FW: Can't connect oracle 12c to 9i through dblink neither sqlplus but yes 10g and 11g
- From: Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 14 Oct 2014 10:35:38 -0700
cc:ing the list
From: iggy_fernandez@xxxxxxxxxxx
To: jcdrpllist@xxxxxxxxx
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@xxxxxxxxx
To: giantpanda@xxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx>:
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@xxxxxxxxx>
An: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
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
Other related posts:
