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>.
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"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":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
17 December 2019
UID
ibm11115037