Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02019: connection description for remote database not found (10.2.0.3.0)
ORA-02019: connection description for remote database not found [message #391499] Thu, 12 March 2009 06:56 Go to next message
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
Re: ORA-02019: connection description for remote database not found [message #391516 is a reply to message #391499] Thu, 12 March 2009 07:36 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
./fa/449/0/
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.
icon10.gif  Re: ORA-02019: connection description for remote database not found [message #391523 is a reply to message #391516] Thu, 12 March 2009 07:45 Go to previous messageGo to next message
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.
Re: ORA-02019: connection description for remote database not found [message #391531 is a reply to message #391523] Thu, 12 March 2009 07:59 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: ORA-02019: connection description for remote database not found [message #391662 is a reply to message #391531] Thu, 12 March 2009 22:19 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Database link got created. But still getting the same error message.
Re: ORA-02019: connection description for remote database not found [message #391663 is a reply to message #391499] Thu, 12 March 2009 22:27 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Search words: ORA-02019 Total hits: 37
Search time: 0.000 seconds Run time: 0.012 seconds
Re: ORA-02019: connection description for remote database not found [message #391677 is a reply to message #391663] Fri, 13 March 2009 00:45 Go to previous messageGo to next message
babuknb
Messages: 1734
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


Re: ORA-02019: connection description for remote database not found [message #391716 is a reply to message #391531] Fri, 13 March 2009 03:19 Go to previous messageGo to next message
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
Re: ORA-02019: connection description for remote database not found [message #391781 is a reply to message #391716] Fri, 13 March 2009 07:46 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The same way you do in Windows.

./fa/917/0/
Re: ORA-02019: connection description for remote database not found [message #391876 is a reply to message #391499] Sat, 14 March 2009 03:00 Go to previous messageGo to next message
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.
Re: ORA-02019: connection description for remote database not found [message #463720 is a reply to message #391876] Fri, 02 July 2010 14:25 Go to previous message
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:
  


Current Time: Sat Dec 03 04:15:51 CST 2016

Total time taken to generate the page: 0.11020 seconds