OraFAQ Forum: SQL & PL/SQL » ORA-02019: connection description for remote database not found

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02019: connection description for remote database not found (10.2.0.3.0)

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

ORA-02019: connection description for remote database not found [message #391499]

Thu, 12 March 2009 06:56

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Hi all,

I have created ".sql" script in Unix and I amtrying to execute the script at SQL prompt. But I am getting the folowing error message after getting the output. Please look into this and let me know the soltion.

ORA-02019: connection description for remote database not found

Disconnected from Oracle Database 10g Enterprise Edition 
Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

Thank you

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #391516 is a reply to message #391499]

Thu, 12 March 2009 07:36

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

It absolutely beggars belief that you still 'don't get it'. I am genuinely starting to believe that you are just posting random drivel to see how much you can wind up other posters here.

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #391523 is a reply to message #391516]

Thu, 12 March 2009 07:45

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Hopw this is not the right way to answer without knowing any thing.Am I right?

I have answered for one forum earlier days as follows he query which i had received from one resource and I answered as follows. But this time am nlt able to find the slution.

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #391531 is a reply to message #391523]

Thu, 12 March 2009 07:59

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This is what Oracle says:

Oracle

ORA-02019 connection description for remote database not found

Cause: An attempt was made to connect or log in to a remote database using a connection description that could not be found.

Action: Specify an existing database link. Query the data dictionary to see all existing database links. See your operating system-specific Net8 documentation for valid connection descriptors.

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #391662 is a reply to message #391531]

Thu, 12 March 2009 22:19

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Database link got created. But still getting the same error message.

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #391663 is a reply to message #391499]

Thu, 12 March 2009 22:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Search words: ORA-02019 Total hits: 37
Search time: 0.000 seconds Run time: 0.012 seconds

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #391677 is a reply to message #391663]

Fri, 13 March 2009 00:45

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>Database link got created. But still getting the same error message.

Ok

1/ Connect your user.

2/ select * from dual@Your database link name

Post the output.

Babu

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #391716 is a reply to message #391531]

Fri, 13 March 2009 03:19

user71408
Messages: 585
Registered: November 2007
Location: NE

Senior Member

Hi database link got created. But I am getting the following error message.

ERROR at line 5:
ORA-01031: insufficient privileges

Please let me know how to write GRANT statement in UNIX box in the coding.

Thank you

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #391781 is a reply to message #391716]

Fri, 13 March 2009 07:46

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

The same way you do in Windows.

/forum/fa/917/0/

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #391876 is a reply to message #391499]

Sat, 14 March 2009 03:00

vaibhavk
Messages: 7
Registered: March 2009

Junior Member

you don't have privilege on the database link. You create public or private db_links. The point of grants is not the db_link itself, but the object you are trying to access at the remote database. Permissions must be granted on the remote objects to the user that is trying to connect to the remote DB.

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #463720 is a reply to message #391876]

Fri, 02 July 2010 14:25

suckedinthevortex
Messages: 1
Registered: July 2010
Location: Philly

Junior Member

Just to keep this like real simple. When getting this error be sure there are PUBLIC links that work first. Example setting up Adv. replication. Be sure the system passwords match on both nodes, test the PUBLIC link and that its active. Once you're good there then go and create your schema DB link logged in as the schema owner with the proper privs so you can create the private DB link and all other required privs needed to query the remote object. I always keep the passwords the same for the schema DB link on both nodes and public DB links in this example, system user. So key thing, be sure PUBLIC links are active, if they're not first verify passwords match for system schema first. Start there first you will save mucho time. Then create your private schema DB links. Oh and of course one last thing that gets missed mucho times. Be sure you create a connect descriptor in the TNSNAMES.ora file for all DB links being created from the source node to the target node. I've seen peeps miss that one alot.

[Updated on: Fri, 02 July 2010 14:28]

Report message to a moderator

Previous Topic:	PL/SQL: ORA-19102: XQuery string literal expected
Next Topic:	Outer Join

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:14:29 CDT 2024