Re: Can't connect oracle 12c to 9i through dblink neither sqlplus but yes 10g and 11g
- From: "David Fitzjarrell" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "oratune@xxxxxxxxx" for DMARC)
- To: "jcdrpllist@xxxxxxxxx" <jcdrpllist@xxxxxxxxx>, Ingrid Voigt <giantpanda@xxxxxxx>
- Date: Tue, 14 Oct 2014 09:34:47 -0700
"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@xxxxxxxxx> 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@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:
