Can't connect oracle 12c to 9i through dblink neither sqlplus but yes 10g and 11g
Date: Tue, 14 Oct 2014 10:31:53 -0400
Message-ID: <CAGYrQyt3i7F1OWFaWrcvcqpObVX7ULRD_tiSg20K5UnMuFTfSQ_at_mail.gmail.com>
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 - 16:31:53 CEST