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