Support

Oracle Configuration Utility [OCU] fails to create database user and database objects.

This technique assumes Oracle is installed and a database has been created along with necessary tablespace like USERS, SYSTEM, TEMP, BLOBS.

If the OCU fails to create the required User Schema and associated data, manually create it using the following procedure.

Step 1:
Start the command prompt

Step 2:
Change the directory to <Windchill>\db\sql: cd <Windchill>\db\sql

Step 3:
Start sqlplus as system user, default password is manager (if you have provided different password during installation, then use that password).

Example: sqlplus system/manager@wind

Note: For this example 'wind' is the oracle instance

Step 4:
Create a new user by typing command:
@create_user
This will prompt you for username, user table space (type USERS) and temp tablespace (type TEMP).

Step 5:
Relogin to sqlplus using new user name you have created in step 4 (Note: password is same as username, for instance if username created was guest then try sqlplus guest/guest@wind)

Step 6:
Create schema using command:
@create_ddl_wt

Step 7:
Set following properties appropriately in db.properties file.
wt.pom.serviceName
wt.pom.dbPassword
wt.pom.dbUser

Use xconfmanager to set these properties. For instance,
xconfmanager -s"wt.pom.serviceName=spradhan03d:1521:wind" -t db/db.properties -p
xconfmanager -s"wt.pom.dbPassword=guest" -t db/db.properties -p
xconfmanager -s"wt.pom.dbUser=guest" -t db/db.properties -p