Installation and Upgrade > Upgrade Guide > The Windchill Upgrade Procedure > Using the Upgrade Manager > Specifying Oracle Source Database Connection Properties
Specifying Oracle Source Database Connection Properties
In Windchill 11.0, the default Oracle database connection string uses the database service name, not the SID. For environments using an Oracle database, if the source and target database instances are on separate hosts and the source database instance is only configured to use SID, before executing the Upgrade Manager, use a windchill shell to specify the following database properties:
xconfmanager -s wt.pom.oracle.jdbcConnectionUseService=false -t
db/db.properties -p
xconfmanager -s wt.pom.jdbc.host=<Source_DBHost.Domain> -t
db/db.properties -p
xconfmanager -s wt.pom.jdbc.port=<Source_Oracle_Listener_port_number> -t
db/db.properties -p
xconfmanager -s wt.pom.jdbc.service=<Source_Oracle_SID> -t
db/db.properties -p
xconfmanager -s wt.pom.dbUser=<Source_Windchill_schema_user> -t
db/db.properties -p
xconfmanager -s wt.pom.dbPassword=<Source_Windchill_schema_user_password> -t
db/db.properties -p
Was this helpful?