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)
icon5.gif  creating a database link between 12c and 8i [message #663657] Tue, 13 June 2017 12:15 Go to next message
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 Go to previous messageGo to next message
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 #663659 is a reply to message #663657] Tue, 13 June 2017 13:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The documentation is there.

Now you have to show us the sqlnet.ora and tnsnames.ora files and the DOS session:
set
sqlplus .../...@...

[Updated on: Tue, 13 June 2017 13:27]

Report message to a moderator

Re: creating a database link between 12c and 8i [message #663661 is a reply to message #663659] Tue, 13 June 2017 13:51 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
I've managed to connect Oracle 8 clients to an 12R2 DB with these parameters.

Just for testing, set all 3 parameters on the target & destination (the incorrect ones will be ignored):
SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

If you use RAC, you need to set them on all nodes, in both the GRID & ORACLE_HOME directories.
Re: creating a database link between 12c and 8i [message #663662 is a reply to message #663661] Tue, 13 June 2017 15:01 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
I just saw your responses. Thank you. I am loading some software on my machine and as soon as it is working I will try the 3 parameters. Thanks for the quick response.
Re: creating a database link between 12c and 8i [message #663698 is a reply to message #663662] Wed, 14 June 2017 12:55 Go to previous messageGo to next message
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 #663700 is a reply to message #663698] Wed, 14 June 2017 14:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Are "ITW7029.raymourflanigan.local" (listening endpoint) and "gerstest.xxxxxxxx.com" (in TEST entry) the same thing?

Also TEST points to service TEST and listener is not listening for this service.

Re: creating a database link between 12c and 8i [message #663701 is a reply to message #663700] Wed, 14 June 2017 14:38 Go to previous messageGo to next message
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

Re: creating a database link between 12c and 8i [message #663702 is a reply to message #663657] Wed, 14 June 2017 15:43 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Bill B wrote on Tue, 13 June 2017 13:15

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.
Bill, did the articles mention 12.2.0.1 or just 12c, because I mentioned earlier I was able to get 6i to connect to 12.1.something, but not 12.2.0.1.

One thing that may work that you want to try if your 12c database is only for testing and you can easily create a new database, is to set your character set in 12c to WE8MSWIN1252. I would not recommend that and I think Oracle will not support it.
Re: creating a database link between 12c and 8i [message #663703 is a reply to message #663702] Wed, 14 June 2017 16:28 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Since I am on 12.2.0.1 , I will rebuild the database as a 12.1 and see what happens. This is just research now. but due to application limitations we are running 8i, 9i, 10g, 11g, and 12c. and it would be nice to have everything talking to each other. We will be able to get rid of the 8i - 11g in about a year. In the meantime they are looking at goldengate (VERY EXPENSIVE) but that will talk to everything.
Re: creating a database link between 12c and 8i [message #663710 is a reply to message #663703] Thu, 15 June 2017 01:11 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Oracle 12.2.0.1 is not the problem here. I think you may be trying to go into the wrong direction. The connection must be from OLD to NEW (I think). Try to establish connectivity with remote sqlplus connection & DB Link.
Re: creating a database link between 12c and 8i [message #663729 is a reply to message #663710] Thu, 15 June 2017 07:20 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
I am dropping this. From the 12C database I can make a database link to any other database 10g and above. However it will not connect to my 8i database. Since I would need to have a database link from 12c to 8i and another database link from 8i to 12C this method will not work for me.

I can connect the two databases by linking from 12c to 10g then using a synonym on the 10g database access the tables on the 8i database but that's a little non standard for a production database.

Thanks
Re: creating a database link between 12c and 8i [message #663759 is a reply to message #663729] Fri, 16 June 2017 06:55 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Bill B wrote on Thu, 15 June 2017 07:20
I am dropping this. From the 12C database I can make a database link to any other database 10g and above. However it will not connect to my 8i database. Since I would need to have a database link from 12c to 8i and another database link from 8i to 12C this method will not work for me.

I can connect the two databases by linking from 12c to 10g then using a synonym on the 10g database access the tables on the 8i database but that's a little non standard for a production database.

Thanks
I don't know what "standard" vs "non-standard" is, but I've seen several occasions (and participated in one) where that is exactly what was done to bridge the gap between versions that were too far apart for direct connection. The 'bridging' datbase had no application object other than db links and synonyms.
Re: creating a database link between 12c and 8i [message #663790 is a reply to message #663759] Mon, 19 June 2017 07:14 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Thanks Ed. I pitch the idea. Thanks
Previous Topic: How identify Schedule Object triggered in job with 2 associated schedules
Next Topic: Cleaning Database after development and tests
Goto Forum:
  


Current Time: Thu Mar 28 06:39:01 CDT 2024