Trying to execute sqlplus in a Windchill Shell so I can create a custom sequence using the string bellow.
Getting error: sqlplus is not reconized as an internal or external command.
Solved! Go to Solution.
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.
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.
I get the same error when I run sqlplus from the command line. So I never get to login to the DB. I can login and conencto the DB using SQL Server Manager.
It looks like you are using SQL Server and the steps you were trying was for Oracle. Please follow the CS https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS42301 for SQL Server
Thank you for your help so far. I think I am almost there. When I run the db command from the Windchill Shell I get
I guess I'm not sure on the last part of the command line <schema_user> <password>. Is this the sql admin UN/PW or the PDMLink credentials or the Cognos credentials?
Well I got that figured out. I works with no username and password.
New problem is it starts everything with 730000. I replaced 730000 with 01 in my sequence file. So I don't know why it starts at 730000.