OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Sun OS (Oracle 10.2.0.3.0)

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

Sun OS [message #513467]

Mon, 27 June 2011 11:52

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?

Report message to a moderator

Re: Sun OS [message #513468 is a reply to message #513467]

Mon, 27 June 2011 12:01

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

Report message to a moderator

Re: Sun OS [message #513469 is a reply to message #513467]

Mon, 27 June 2011 12:06

Michel Cadot
Messages: 68745
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Sun OS [message #513470 is a reply to message #513467]

Mon, 27 June 2011 12:14

John Watson
Messages: 8966
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

)

Report message to a moderator

Previous Topic:	ORA-28500
Next Topic:	unable to connect to a database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 06:49:08 CDT 2025