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 ?

Re: remote database link [message #66440 is a reply to message #66437] Tue, 11 June 2002 11:26 Go to previous message
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?
Previous Topic: Re: net8config
Next Topic: ORACLE Listener configuration???? Help please
Goto Forum:

Current Time: Sun Feb 25 06:16:19 CST 2024