OraFAQ Forum: Networking and Gateways » Database Link not working between Oralce 9i and Oracle 11g

Home » RDBMS Server » Networking and Gateways » Database Link not working between Oralce 9i and Oracle 11g (Oracle 9i (9.2.0.1.0), RHEL 2.1 AS, Oralce 11g(11.2.0.1.0) RHEL 5.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Link not working between Oralce 9i and Oracle 11g [message #508285]

Fri, 20 May 2011 02:55

jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad

Senior Member

Dear Friends,

I'm trying to connect Oracle 11g database from Oracle 9i database, by creating dblink on Oracle 9i database. But my session got hang while i perform this. Here i'm giving the steps i followed on my both the database. Here Oracle 9i database is my source db and Oracle 11g is my target db. Please help me while i'm missing some parameter or setttings.

Following steps/setting on Oralce 11g Database

SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE

SQL> alter user SSA identified by SSA;

User altered.

Password File recreted on Oracle 11g Database Server 

[oracle1@dev11g dbs]$ orapwd file=/backup/ora11gsoft/odb/OH1/dbs/orapwwbdata 
ignorecase=n password=dev entries=5

Following steps performed on Oralce 9i Database

DROP DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM";

CREATE DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM"
 CONNECT TO SSA
 IDENTIFIED BY SSA
 USING 'DEVDATA.DEV11G';

Database link created.

SELECT * FROM SSA.SSMASTER@SSA11G;

And the hangs for ever.

Please suggest some way.

Regards

Jimit

[Updated on: Fri, 20 May 2011 03:26] by Moderator

Report message to a moderator

Re: Database Link not working between Oralce 9i and Oracle 11g [message #508301 is a reply to message #508285]

Fri, 20 May 2011 04:10

jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad

Senior Member

Dear Friends

One more input that forget was, My Oracle 9i is on Standard Edition. Is it limitation of it.

Regards

Jimit

Report message to a moderator

Re: Database Link not working between Oralce 9i and Oracle 11g [message #508384 is a reply to message #508285]

Fri, 20 May 2011 14:57

knight
Messages: 111
Registered: January 2009

Senior Member

i guess you have to set that parameter to false or add password in " "

please post o/p of

tnsping DEVDATA.DEV11G

Report message to a moderator

Re: Database Link not working between Oralce 9i and Oracle 11g [message #508409 is a reply to message #508384]

Fri, 20 May 2011 23:57

jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad

Senior Member

Dear Knight

Here is the output of tnsping (From my 9i database)

[oracledev@ssa_db1 odb]$ tnsping DEVDATA.DEV11G

TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 21-MAY-2011 10:24:
29

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
/ora9isoft/odb/OH1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.150.1.59)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SER
VICE_NAME = devdata.dev11g.wbtea.com)))
OK (30 msec)
[oracledev@ssa_db1 odb]$

Regards

Jimit

Report message to a moderator

Re: Database Link not working between Oralce 9i and Oracle 11g [message #508441 is a reply to message #508285]

Sat, 21 May 2011 03:49

knight
Messages: 111
Registered: January 2009

Senior Member

please post o/p of foll. from your 9i database

sqlplus ssa/ssa@DEVDATA.DEV11G

SELECT * FROM dual@SSA11G;

Report message to a moderator

Previous Topic:	TNS:listener does not currently know of SID given in connect descriptor
Next Topic:	ORA-12154

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 03:05:56 CST 2024