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

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Tue, 14 Oct 2014 09:34:47 -0700
Message-ID: <1413304487.99232.YahooMailNeo_at_web124704.mail.ne1.yahoo.com>



"The term VERSION in the parameter name refers to the version of the authentication protocol, not the Oracle Database release."

There is nothing in that documentation quote that indicates that either Oracle 8 or Oracle 9 are supported releases for client connections from 12c.  

David Fitzjarrell

Principal author, "Oracle Exadata Survival Guide"

On Tuesday, October 14, 2014 9:47 AM, Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com> wrote:  

Thank you Ingrid,
basically the source is documentation, unless I misunderstand something if 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
Received on Tue Oct 14 2014 - 18:34:47 CEST

Original text of this message