Create a database and a windchill user using the PSI

Question

Hello Gurus,I was trying to create a new database and a user (only these two) using the PSI.Has any one done this if yes can they share there experiences.The scenerio here is :-Fire a PSI --> Chose Standalone Components option --> Check create a database and new user (give the database details and other details that PSI needs).ThanksMayur

ptc-4496767 · Answer

Mayur,Creating the database and installation user is fairly easy. Along with the PSI, you will need the PDMLink Third Party Software. The information you need to input is:Base Installation Directory - Path for Windchill directoryInstallation Directory for Oracle Configuration Utility - This is defaulted to {Base Installation Directory}\ocu. I would suggest putting it in {Drive}:\ptc. The reason I suggest this is after upgrades (i.e. 9.1 -> 10.1) the ocu folder stays in the old directory (ptc\Windchill_9.1).Oracle Server Installation Directory - Usually something like D:\oracle\product\11.2.0\db_1Oracle Database DNS Registered Host Name - Host Name for the database serverOracle Database Listener Port Number - Default is 1521Oracle Database System Identifier (SID) - The SID you want to name your Windchill database.Oracle 'SYSTEM' Account Password - Password set for the SYSTEM account when you installed OracleOracle User Name for Windchill Installation - User Name for your Windchill Database user.If you are installing on Linux, the PSI has to be run as your Linux Oracle user.Hope this helps,Todd BurkhartProductSpace Solutions, Inc.

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.