oracle 9i client connecting to oracle 12c server

oracle12c oracleclient
njihan picture njihan · Mar 10, 2015 · Viewed 11.6k times · Source

Can Oracle 9.2 client connect to Oracle 12c server? We have an old server which is an 11g version, and so far there's no problem connecting from client.

Thank You.

Answer

Alex Poole picture Alex Poole · Mar 10, 2015

That isn't a supported combination, no. As it says in the documentation, you can see the supported client/server combinations at My Oracle Support note 207303.1.

The 9i client used to be supported with an 11g server, but is not with a 12c server. There is a specific note about it:

Attempting to connect from 9.2 to 12.1 will fail with an "ORA-28040: No matching authentication protocol" error.

Related questions

Installing 32 and 64-bit Oracle client but 32-bit installer crashes

I am trying to install Oracle 12c instant 32-bit client alongside my 64-bit installation because I can't connect Visual Studio to the 64-bit version (throws BadImageFormatException). I run the installer and give it another directory for home, so it's like …

Read More
ORA-28040: No matching authentication protocol exception

I am trying to connect my grails project to Oracle databse(Oracle 12c) in windows(8) system. However, whenever I run my application I get following exception : Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-28040: No matching authentication …

Read More
error: ORA-65096: invalid common user or role name in oracle

I just installed Oracle, and it was missing the Scott schema. So i am trying to generate it myself. I got the sql script of Scott schema, but when i try to run the query: create user Scott identified by …

Read More