Re: Can't connect oracle 12c to 9i through dblink neither sqlplus but yes 10g and 11g

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Tue, 14 Oct 2014 15:35:43 -0600
Message-ID: <543D972F.4090304_at_gmail.com>

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_at_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_at_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.2
> C:\Users\jreyes>C:\app\11.2.0.3.20\product\11.2.0\dbhome_1\BIN\sqlplus.exe
> /NOLOG
> SQL*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_at_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_58
> TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 - Production
> on 14-OCT-2014
> c:\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 :)

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 14 2014 - 23:35:43 CEST