Troubleshooting
Problem
After data migration from Oracle 11g to Oracle 12c Revision 2 (SCC was stopped, data was exported from Oracle 11g and imported to Oracle 12c) , an error occurred while configuring the connection to new DB through <installdir>/bin/configCC.sh.
The connection to database works fine from clients like "sqlplus" and required permissions were granted on new database.
The provided conenction details, host, port, user credential etc. are all correct.
For Oracle 12c the driver ojdbc8.jar was used.
After the failed configCC.sh attempt, trying to revert back to using the old Oracle 11g database with the ojdbc7.jr driver also fails with the same error (see below)
Symptom
*********************** E R R O R ***************************
Error while configuring DB connection ....
Error : com.sterlingcommerce.scc.common.SCCException: CJDB014ECannot create a new connection for URL jdbc:oracle:thin:@<DB hostname>:<DB port>.
Causing error: CJDB014E Cannot create a new connection for URL jdbc:oracle:thin:@<DB hostname>:<DB port>.
Cause
An issue was discovered with the use of ojdbc8.jar during the development cycle. This has now been addressed in version 6.1.2.1 iFIx01
Resolving The Problem
Upgrade your Control Center to 6121 iFIx01 or newer.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
17 December 2019
UID
ibm11115037