Home » RDBMS Server » Networking and Gateways » dblink between oracle 7.2 and oracle 9i
dblink between oracle 7.2 and oracle 9i [message #66874] Mon, 24 February 2003 06:12 Go to next message
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
Re: dblink between oracle 7.2 and oracle 9i [message #66875 is a reply to message #66874] Mon, 24 February 2003 08:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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)

Re: Tnsnames.ora file to identify the problem [message #66877 is a reply to message #66874] Mon, 24 February 2003 22:53 Go to previous messageGo to next message
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)
)
)
Re: dblink between oracle 7.2 and oracle 9i [message #66880 is a reply to message #66874] Tue, 25 February 2003 06:36 Go to previous message
Mahesh Rajendran
Messages: 10707
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).
Previous Topic: Oracle Instance Crashes Regularly
Next Topic: Re: ORA-12154:TNS:Could not resolve service name.
Goto Forum:
  


Current Time: Fri Mar 29 03:16:28 CDT 2024