OraFAQ Forum: Networking and Gateways » dblink between oracle 7.2 and oracle 9i

Home » RDBMS Server » Networking and Gateways » dblink between oracle 7.2 and oracle 9i

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

dblink between oracle 7.2 and oracle 9i [message #66874]

Mon, 24 February 2003 06:12

Syed Mansoor Ali
Messages: 2
Registered: February 2003

Junior Member

I have three machines and three version of oracle database, (1) 7.2, (2) 8i, (3) 9i

oracle 7.2 and 8i are working with dblinks
oracle 8i and 9i are also working with dblinks
but..
oracle 7.2 and 9i not working and returning the following errors

select * from emp@usrvr

ERROR at line 1:
ORA-28546: connection initialization failed, probable Net8 admin error
ORA-02068: following severe error from USRVR
ORA-03113: end-of-file on communication channel

any help will be highly appreciated

Report message to a moderator

Re: dblink between oracle 7.2 and oracle 9i [message #66875 is a reply to message #66874]

Mon, 24 February 2003 08:26

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

manually open the listener.ora in USRVR and check whether the correct ORACLE_SID is used.
and check out for any hetergenous services defines (HS)

Report message to a moderator

Re: Tnsnames.ora file to identify the problem [message #66877 is a reply to message #66874]

Mon, 24 February 2003 22:53

Syed Mansoor Ali
Messages: 2
Registered: February 2003

Junior Member

As I told that "dblink and connection between 7.2 and 8i is ok" and also "dblink and connection between 8i and 9i is ok" but not working with "7.2 and 9i dblinks"

please check and confirm me

-- Tnsnames.ora

ORAV920 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gtserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orav920)
)
)

L8I =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.147.160.3)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = v817)
)
)

US =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.147.200.50)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = userver)
)
)

Report message to a moderator

Re: dblink between oracle 7.2 and oracle 9i [message #66880 is a reply to message #66874]

Tue, 25 February 2003 06:36

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i beleive,
ur dblink name is USRVR
ur connect string is US ( as per ur posting).
First make sure whether u can establish a sqlnet connection
from 7.2 server to 9i server using this settup?
convention is to use DBLINK Name same as CONNECSTRING string ( or create dblink with whole tnsentries).

Report message to a moderator

Previous Topic:	Oracle Instance Crashes Regularly
Next Topic:	Re: ORA-12154:TNS:Could not resolve service name.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 02:28:22 CST 2025