Specifying Oracle 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, the database must be configured so the Windchill persistence layer connects to the Oracle database using database service name, rather than SID. This means the URL format for establishing database connections uses service name string format: Host:Port/ServiceName. Using a windchill shell, modify the following properties:
xconfmanager -s wt.pom.oracle.jdbcConnectionUseService=true -t db/db.properties -p
xconfmanager -s wt.pom.jdbc.service=<Target_Oracle_ServiceName> -t db/db.properties -p
xconfmanager -s wt.pom.jdbc.service=<Target_Oracle_ServiceName> -t db/db.properties -p
In Windchill 11.0, database connections using SID are supported. If a database connection with SID is needed (i.e. URL format of Host:Port:SID), the following properties must be set:
xconfmanager -s wt.pom.oracle.jdbcConnectionUseService=false -t db/db.properties -p
xconfmanager -s wt.pom.jdbc.service=<Target_Oracle_SID> -t db/db.properties -p
xconfmanager -s wt.pom.jdbc.service=<Target_Oracle_SID> -t db/db.properties -p
 |
Service Name is the default connection mechanism for Oracle 19c and has been supported since 8i releases. In most cases, there should be no issues connecting to Oracle using Service Name instead of SID.
|
For more information about using SID for database connections, see https://support. ptc.com/appserver/cs/view/case_solution.jsp?n=222980.
For more information about Oracle service names, see https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/SERVICE_NAMES.html#GUID-AC956707-D568-4F8A-BF2E-99BA41E0A64F.