Home » RDBMS Server » Networking and Gateways » Sun OS (Oracle 10.2.0.3.0)
Sun OS [message #513467] Mon, 27 June 2011 11:52 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I am trying to create a database link and work with it.

I have database A and database B. Both the databases are under different servers.

In database A, I issues the command

create public database link ts25ke connect to SCOTT IDENTIFIED BY
TIGER USING 'UATTNS';

where
ts25ke is the new db link name
SCOTT is the existing username in database A
TIGER is the password for the username SCOTT in database A
UATTNS is the TNS alias existing in database B

If I give this command in both database A and database B,
select name from v$database@UATTNS;

I get the error "ORA-02019: connection description for remote database not found"

What is the mistake I have done and how can I make the
database link work?
Re: Sun OS [message #513468 is a reply to message #513467] Mon, 27 June 2011 12:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

when all else fails, Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5005.htm#i2061505
Re: Sun OS [message #513469 is a reply to message #513467] Mon, 27 June 2011 12:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
icon12.gif  Re: Sun OS [message #513470 is a reply to message #513467] Mon, 27 June 2011 12:14 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You have given the wrong credentials. The database link needs to know the logon for the remote database, not the local database.

But you aren't getting that far. An ORA-2019 usually means that you have the wrong database link name, perhaps because you have a db_domain that has been appended to it. Check the name in dba_db_links (and follow BS's sdvice Smile)
Previous Topic: ORA-28500
Next Topic: unable to connect to a database
Goto Forum:
  


Current Time: Thu Mar 28 13:40:03 CDT 2024