I use a general rule of thumb is that Oracle provides backward compatibility between the current version and other versions under full support at the time the current version is released, unless explicitly stated in the "What's New" section of the doc.. Sometimes, if we are lucky, we can go back beyond the supported versions. Expecting compatibility back to an unsupported version is highly unrealistic.
In the SQL*Net (Oracle Networking) world, the definitive check is The Oracle Database client / server version compatibility matrix, aka Client / Server Interoperability Support, Note ID 207303.1
From Support Lifetime doc, you can see the expiry dates in "Lifetime Support Policy: Oracle Technology Products" doc from page http://www.oracle.com/us/support/lifetime-support/index.html (for DB, see P 6 of http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf)
For your problem, you will likely need to create a bridge using an Oracle 10g R2 database.
/Hans On 14/10/2014 8:31 AM, Juan Carlos Reyes Pacheco wrote:
Hello If you can help me please ORA-03134: Connections to this server version are no longer supported I'm trying to connect Oracle Database 12c Release 12.1.0.1.0 - 64bit Production (patch 13) with Oracle9i Release 9.2.0.1.0 - Production through a dblink SELECT * FROM DUAL@xxx.WORLD; ORA-03134: Connections to this server version are no longer supported I configured in sqlnet.ora (the folder of the 12c listener where the 12c is trying to connect to 9i) SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 I restarted the computer. -- sqlplus 12c to 9i don't work, but documentation says it is possible C:\Users\jreyes>sqlplus /nolog SQL*Plus: Release 12.1.0.1.0 Production on Mar Oct Copyright (c) 1982, 2013, Oracle. All rights reser SQL> CONN SYS@SBBV_58 AS SYSDBA Introduzca la contrase±a: ERROR: ORA-01075: you are currently logged on SQL> SELECT * FROM DUAL; SP2-0640: No conectado SQL> select * from v$instance; SP2-0640: No conectado -- sqplus 12c to 11.2 OK sqplus 12c to 10.2 OK -- from 11g sqlplus I can of course connect to 9.2C:\Users\jreyes>C:\app\11.2.0.3.20\product\11.2.0\dbhome_1\BIN\sqlplus.exe /NOLOGSQL*Plus: Release 11.2.0.3.0 Production on Mar Oct 14 09:44:10 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. SQL> CONN SYS@SBBV_58 AS SYSDBA Introduzca la contrase±a: Conectado. SQL> SELECT STATUS FROM V$INSTANCE; STATUS ------------ OPEN SQL> -- confirmed is using the correct sqlnet.ora C:\Users\jreyes>tnsping sbbv_58TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 - Production on 14-OCT-2014c:\app\12.1.0\product\12.1.0\dbhome_1\network\admin\sqlnet.ora sqlnet.ora --- SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 SQLNET.AUTHENTICATION_SERVICES=(NONE) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME, EZCONNECT) NAMES.DEFAULT_DOMAIN=WORLD --- The listener services don't show any error when restarting Thank you :)
-- //www.freelists.org/webpage/oracle-l
