Advanced Search Country / Region United States Products Pro/ENGINEER Windchill Arbortext All Products Solutions Product Development Solutions Industry Solutions Education Small & Medium Business Global Product Development Services & Training Implementation Services Consulting Services Training Services Product Development System Adoption Services Customer Resources ptc.com Accounts E-mail Newsletters Free Downloads Product Promotions Tools & Tutorials PTC PLM On Demand Partners Resellers Find A Partner For Our Partners Partner Portals About PTC Careers Customer Successes Contact Us Education Program Events Executive Management Investor Relations News Support Technical Support Order and License Support Platform Support Customer Care Global Maintenance Support Business Asset Summary Tool
# Support E-mail this page Print version
### Solution Details - TPI
Number | 130511
Type | TPI
Created Date | 23-Aug-2005
Last Updated | 18-Nov-2005
Title | Oracle Configuration Utility [OCU] Fails to Create Database User and Database Objects.
Details | Description Oracle Configuration Utility [OCU] fails to create database user and database objects. Resolution 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
### Affected Products
Product | Pro/INTRALINK 8.x +
Module | Installation
Reported Release | 8.0
Reported Datecode | Not Available
Resolved Release | Not Available
Resolved Datecode | Not Available
Affected Client | All
Affected Server | Not Available
### Related Documents
Type | Number | Status | Description
--- | --- | --- | ---
None Available