 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 #663661 is a reply to message #663659] |
Tue, 13 June 2017 13:51 |
Frank Naude
Messages: 4581
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 #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 |
|
|
|
| Re: creating a database link between 12c and 8i [message #663702 is a reply to message #663657] |
Wed, 14 June 2017 15:43 |
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 |
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 #663729 is a reply to message #663710] |
Thu, 15 June 2017 07:20 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
