Home » RDBMS Server » Server Administration » creating a database link between 12c and 8i (Oracle 12.2.0.1.0 database link to 8.1.7.4.0 database)
  creating a database link between 12c and 8i [message #663657] |
Tue, 13 June 2017 12:15  |
Bill B
Messages: 1971
Registered: December 2004
|
Senior Member |
|
|
While unsupported a number of articles say that it is possible to downgrade the sqlnet protocols used in oracle 12c by using the following two commands in the sqlnet.ora on the database server
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
After making the changes I did a reload on the listener and shutdown/startup on the 12c database. When I make the database link to the 8i server I am getting error
ORA-03134: Connections to this server version are no longer supported.
While I know that I am 4 major revisions higher on the 12c server a number of articles said it should work. Am I doing something wrong? Any pointers would be much appreciated.
For this test the database is on my workstation and it is running client 10.2.0.5.0
Both the 12c server and the client are using the same sqlnet.ora I set the environmental variable TNS_ADMIN=c:\sqlnet
[Updated on: Tue, 13 June 2017 12:17] Report message to a moderator |
|
|
|
| Re: creating a database link between 12c and 8i [message #663658 is a reply to message #663657] |
Tue, 13 June 2017 12:38  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
Did you make the change in the sqlnet.ora for both the client and the server?
Is the 12c database on the same server as 8i database?
I believe before version 12c (or maybe it was 11g), there was just a single line in sqlnet.ora, something like:
SQLNET.ALLOWED_LOGON_VERSION=8
You would of course have to put that line instead of the 12c parameter as it would know nothing about the new parameters.
Also, what is your exact 12c version? I seem to recall something "different" about 12.2.0.1 vs. earlier versions. At one time, I had 6i forms running against 12c, but it is was 12.1.0.2, but when I tried it against 12.2.something, I got a message similar to yours.
[Updated on: Tue, 13 June 2017 12:44] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: creating a database link between 12c and 8i [message #663698 is a reply to message #663662] |
Wed, 14 June 2017 12:55 |
Bill B
Messages: 1971
Registered: December 2004
|
Senior Member |
|
|
I did not work. The following is in my common sqlnet.ora file
# sqlnet.ora Network Configuration File: c:\sqlnet\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
The following is in the listener.ora
# listener.ora Network Configuration File: c:\sqlnet\listener.ora
# Generated by Oracle configuration tools.
LISTENER_2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ITW7029.xxxxxxxx.local)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Oracle12c\product\12.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Oracle12c\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)
)
SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
I did a reload on the listener and then a status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_2
Version TNSLSNR for 64-bit Windows: Version 12.2.0.1.0 - Produ
ction
Start Date 13-JUN-2017 17:17:01
Uptime 0 days 20 hr. 30 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File c:\sqlnet\listener.ora
Listener Log File C:\app\Oracle12c\diag\tnslsnr\ITW7029\listener_2\alert
\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ITW7029.raymourflanigan.local)(PORT=
1521)))
Services Summary...
Service "988359b1d71b4e35919ee01aa2eb494e" has 1 instance(s).
Instance "whb", status READY, has 1 handler(s) for this service...
Service "plb_orcl" has 1 instance(s).
Instance "whb", status READY, has 1 handler(s) for this service...
Service "whb" has 1 instance(s).
Instance "whb", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
When I try to test the database link I get the following
Link Name : "gerstest"
Error: ORA-03134: Connections to this server version are no longer supported.
The tnsnames.ora entry for the two database are
WHB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ITW7029.xxxxxxxx.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = whb)
)
)
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gerstest.xxxxxxxx.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)
The create database string in the 12c database is
CREATE PUBLIC DATABASE LINK GERSTEST
CONNECT TO CUSTOM
IDENTIFIED BY *****
USING 'TEST';
any ideas if this is at all possible?
[Updated on: Wed, 14 June 2017 12:56] Report message to a moderator |
|
|
|
|
|
| Re: creating a database link between 12c and 8i [message #663701 is a reply to message #663700] |
Wed, 14 June 2017 14:38 |
Bill B
Messages: 1971
Registered: December 2004
|
Senior Member |
|
|
No. ITW7029.raymourflanigan.local is my workstation where I have the 12C database running. gerstest.raymourflanigan.com is the test 8i server. My machine is windows 7 professional and the gerstest machine is running Solaris
The 8i database is running the terminal patches and my workstations has ALL current patches applied and the 12c database also has all available patches applied.
SunOS gerstest 5.10 Generic_150400-16 sun4v sparc sun4v
[Updated on: Wed, 14 June 2017 14:42] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun May 04 01:07:19 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
