Article - CS266319
How to find the staging database SID for Windchill Bulk Migrator
Modified: 06-Dec-2024
Applies To
- Windchill Bulk Migrator 1.0 to 12.1
Description
- How to find the Oracle staging database SID?
- How to find the SQL Server staging database SID?
- Which SID to use in db connection url Host:Port:SID?
- sqlplus test fails with ORA-12170 error
- wbmldr hangs at Registering class com.ptc.wbm.wbmldr.core.WbmldrStatus against com.ptc.wbm.wbmldr
- Occurs when wbmldr tries to connect to the staging
- Errors during normalization
INFO db.DSHandler - Connecting to DB :[host]:[port]:[service name] AS staging
INFO core.WbmldrContext - Context compacted by 21%
Registering class com.ptc.wbm.wbmldr.core.WbmldrStatus against com.ptc.wbm.wbmldr .....
core.WbmldrStatus - Cannot initailize com.ptc.wbm.wbmldr.core.WbmldrStatus
com.ptc.wbm.wbmldr.util.WbmldrException: An Exception occurred
at com.ptc.wbm.wbmldr.core.WbmldrStatus.validate(WbmldrStatus.java:124)
at com.ptc.wbm.wbmldr.core.WbmldrStatus.initialize(WbmldrStatus.java:83)
at com.ptc.wbm.wbmldr.core.WbmldrStatus.getInstance(WbmldrStatus.java:62)
at com.ptc.wbm.wbmldr.WbmldrImpl.implement(WbmldrImpl.java:107)
at com.ptc.wbm.wbmldr.WbmldrImpl.main(WbmldrImpl.java:80)
Caused by: com.ptc.wbm.wbmldr.util.WbmldrException: A SQLException occurred when creating DS connection.
at com.ptc.wbm.wbmldr.core.db.DSHandler.getConnection(DSHandler.java:464)
at com.ptc.wbm.wbmldr.util.WbmldrUtils.tableExists(WbmldrUtils.java:81)
at com.ptc.wbm.wbmldr.core.WbmldrStatus.validate(WbmldrStatus.java:93)
... 4 more
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
This is a printer-friendly version of Article 266319 and may be out of date. For the latest version click CS266319