Skip to main content
P
pstapler1-Visitor
1-Visitor
September 25, 2015
Solved

Addtional Sequences: WC 10.2 M010. SQLPLUS error.

  • September 25, 2015
  • 10 replies
  • 3423 views

Trying to execute sqlplus in a Windchill Shell so I can create a custom sequence using the string bellow.

exec wtpk.createSequence('seq_name',start_num,inc_value).

Getting error: sqlplus  is not reconized as an internal or external command.

Regards

Patrick

Best answer by BineshKumar1

It should be the PDMLink credentials. Refer to wt.pom.dbuser in WT_HOME/db/db.properties

Thank you

Binesh Kumar

Barry Wehmiller

10 replies

B
BineshKumar12-Explorer
2-Explorer
September 25, 2015

It looks like you don't have oracle client is not installed on Windchill server. Download the oracle client, update the tns entries for windchill database and try again.

Thanks you

Binesh Kumar

Barry Wehmiller

P
pstapler1-VisitorAuthor
1-Visitor
September 25, 2015

I don't see that as an option from the PTC website.

B
BineshKumar12-Explorer
2-Explorer
September 25, 2015

You can download the oracle client from Oracle website.

Another option is to run it from the db server directly. From the db server, logon to SQLPLUS and run the command.

Thank you

Binesh Kumar

Barry Wehmiller

Terms & ConditionsAccessibility statement