Home » RDBMS Server » Networking and Gateways » remote database link
remote database link [message #66437] Tue, 11 June 2002 07:02 Go to next message
Femi Adigun
Messages: 6
Registered: June 2002
Junior Member
To whom it may concern,

In order to create a database link, I issued the following command :

create public database link rms
connect to fbs identified by fbs using 'rms'

The link was created successfully, but when I issued the statement :

select * from loan@rms, I got the following error message :

error at line 1:
ORA-06401: NETCMN: invalid driver designator.

How do I get out of this ?

Femi.

Report message to a moderator

Re: remote database link [message #66440 is a reply to message #66437] Tue, 11 June 2002 11:26 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Is "rms" a valid entry in the tnsnames.ora file on the server you have created the link with? Can you tnsping rms?

Report message to a moderator

Previous Topic: Re: net8config
Next Topic: ORACLE Listener configuration???? Help please
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 04:50:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.