HI,
We are working on a database upgrade from 11g to 12c and have built the Dev, Test and Stage databases. There is an interfacing application whose services used to connect to the application database using ojdbc 14.jar. Post upgradation we have observed that the application is able to connect to Dev database using ojdbc14.jar but not to the stage database despite the credentials being correct. Below entries have been added in both the DB's sqlnet.ora files
- SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
- SQLNET.ALLOWED_LOGON_VERSION=8
The difference being dev and stage being the zone (Dev in Intra and Stage in Inter) and the dev db being standalone whereas stage being in a 2 node cluster.
We did a small POC on one of the tools (Pentaho) by connecting to Dev and Stage database by using the jar files ojdbc6.jar and ojdbc14.jar. The tool connected to dev with Ojdbc14.jar but failed to connect to stage with error – No matching authentication protocol. However when the jar was replaced with ojdbc6.jar the connection was successful.
Why is this different behavior displayed between the 2 12c db's where an app is able to connect to dev (Oracle12c) using ojdbc14.jar which is not recommended under the recommendations to use as a driver for 12c Refer -https://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html
Could anyone let us know the possible fix to db and why the jar is behaving differently.
PS : Replacing the jar is the last option as there would be 150 services impacted due to a common framework.