OraFAQ Forum: Networking and Gateways » Database Link Oracle 9i to Oracle 8i

Home » RDBMS Server » Networking and Gateways » Database Link Oracle 9i to Oracle 8i

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

Database Link Oracle 9i to Oracle 8i [message #67417]

Mon, 12 July 2004 22:48

Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta

Member

Hi all

I need small help.

I am having two databases on is Oracle 8i and the other is Oracle 9i Release-2.

Now from Oracle 9i Database I wish to connect to Oracle 8i for some data.

I am trying to create a Database link for the same.I give the following command :

"create public database link 9ito8i connect to scott identified by tiger using 'ora8i';"

Also I have given the rights to create database link on 9i�� and create session on 8i for respective users.

Howevere when i try to access data from 9i to 8i it gives me follwing error :

Command : Select * from scott.emp@9ito8i�

ERROR at line 1:
ORA-12154: TNS:could not resolve service name

Can anyone tell me what to do in this case.

On both Net8 is configured. Please as this is urgent. Thanks to all in advance

Regards

Atul P

�

�

Report message to a moderator

Re: Database Link Oracle 9i to Oracle 8i [message #67418 is a reply to message #67417]

Tue, 13 July 2004 00:34

Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas

Senior Member

Hi,

It seems that you are creating this link on a machine which is not the server means you are connected through a client machine with the server and trying to create the dblink. And that 'ora8i' net string is available at ur client machine basically it should be in your 9i server's TNS file.

To check this try to make a SQL connection from 9i server to ur 8i server using ur ora8i net string. If u get the same error then add this tns entry in 9i server TNS file OR while creating dblink instead of specifying the net service variable just paste the connect string.

Best Regards
Daljit Singh.

Report message to a moderator