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

From: iggy_fernandez_at_hotmail.com
To: jcdrpllist_at_gmail.com
Subject: RE: Can't connect oracle 12c to 9i through dblink neither sqlplus but yes 10g and 11g Date: Tue, 14 Oct 2014 09:55:59 -0700

Juan,
It appears that the Net Services documentation is terrifically misleading. A well-written document would have warned that the 12c client cannot cannot to a 9.2 database, nor can a 9.2 client connect to a 12c database. I checked the MOS document that was mentioned; it states that an attempt to do so will result in ORA errors. Iggy

Date: Tue, 14 Oct 2014 11:45:33 -0400
Subject: Re: Can't connect oracle 12c to 9i through dblink neither sqlplus but yes 10g and 11g From: jcdrpllist_at_gmail.com
To: giantpanda_at_gmx.net
CC: oracle-l_at_freelists.org

Thank you Ingrid,basically the source is documentation, unless I misunderstand somethingif you set 8, that includes 9 too, in theory, because there is no comment saying it is not possible to be cliente of oracle 9, and this parameters set the lower limit.I you have some text saying oracle can't connect to 9 as client, I'll appreciate if you share.Thank you :) http://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016

SQLNET.ALLOWED_LOGON_VERSION_CLIENT Purpose To set the minimum authentication protocol allowed for clients, and when a server is acting as a client, such as connecting over a database link, when connecting to Oracle Database instances. Usage Notes
The term VERSION in the parameter name refers to the version of the authentication protocol, not the Oracle Database release. If the release does not meet or exceed the value defined by this parameter, then authentication fails with an ORA-28040: No matching authentication protocol error. See Also:
Oracle Database Security Guide Values
12a for Oracle Database 12c Release 1 (12.1) release 12.1.0.2 or later 12 for the critical patch updates CPUOct2012 and later Oracle Database 11g authentication protocols (recommended) 11 for Oracle Database 11g authentication protocols (default) 10 for Oracle Database 10g authentication protocols 8 for Oracle8i authentication protocol Default
11

2014-10-14 11:30 GMT-04:00 Ingrid Voigt <giantpanda_at_gmx.net>: Where did you get the information that connecting from 12 to 9 is possible? According to MOS 207303.1 direct connection is not supported and gives ora-03134, db links follow the same rules. Best regards Ingrid Gesendet: Dienstag, 14. Oktober 2014 um 16:31 Uhr Von: "Juan Carlos Reyes Pacheco" <jcdrpllist_at_gmail.com> An: ORACLE-L <oracle-l_at_freelists.org> Betreff: Can't connect oracle 12c to 9i through dblink neither sqlplus but yes 10g and 11g 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                                                                                               

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