Post date: May 31, 2016 8:44:30 AM
Upgradation of Triniti Product's database from Oracle 11g to 12C can be done in two ways:
1. Triniti Products Upgradation to Latest
We can upgrade the deployment with latest Triniti Products patch (which supports Oracle 12C). And JDBC URL signature should be changed to support 12C database. Here is the signatures for both 11g and 12C database URLs:
11g: <url>jdbc:oracle:thin:@<host>:<port>:<SID></url>
12C: <url>jdbc:oracle:thin:@//<host>:<port>/<SID></url>
2. Oracle configuration setting without Triniti Products Upgradation:
We may face "ORA-28040: No matching authentication protocol" Exception, while trying to connect to 12c database, with old patch level, because oracle thin driver was used in the code. Below database configuration change has to be done in "oracle/network/admin/sqlnet.ora" file which allows old (thin driver) code to work.
Set SQLNET.ALLOWED_LOGON_VERSION=8