Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02019 while accesing DB B from DB A through a dblink.
ORA-02019 while accesing DB B from DB A through a dblink. [message #209138] Wed, 13 December 2006 08:38 Go to next message
sssss
Messages: 9
Registered: November 2006
Junior Member
Hi All,

I am facing problem while genrating a purchase order, or populating any record, from DB A on to DB B through a DBLINK.

As my DB A is on 9.2.0.4.0 and DB B is on 10g.

Please suggest me some workaround for this problem.

DB link works fine when used through SQL EDITOR, but does not work when used in a PL/SQL code.
Re: ORA-02019 while accesing DB B from DB A through a dblink. [message #209141 is a reply to message #209138] Wed, 13 December 2006 08:50 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

"DB link works fine when used through SQL EDITOR"

Duh..
"SQL EDITOR" ?
What does that sql statment look like ?

"but does not work when used in a PL/SQL code"

I cant guess how your code looks like.......................
You might wanna show us the code and the error you are reciving ?

[Updated on: Wed, 13 December 2006 08:51]

Report message to a moderator

Re: ORA-02019 while accesing DB B from DB A through a dblink. [message #209142 is a reply to message #209138] Wed, 13 December 2006 08:53 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
"Does not work" covers a multitude of problems.
When you try it does it:
1) Hang indefinitely
2) Generate a unending sequence of "ORA-00732: Out of Cheese" errors
3) Cause your server to animate and migrate south to warmer climes
4) Some other problem that I haven't got to yet.

Give us a chance - if you want our help fixing your problem, at least tell us what the problem you're getting IS.
Re: ORA-02019 while accesing DB B from DB A through a dblink. [message #209145 is a reply to message #209141] Wed, 13 December 2006 08:59 Go to previous messageGo to next message
sssss
Messages: 9
Registered: November 2006
Junior Member
Thanks for ur reply,

Actually I do not have the code with me right now, as I mean DB link is working fine when you use it through SQL editor, But when suppose you have to do any insert through a PL/SQL it is not able to do so, as the dblink comes in picture.

I will update you further.

Thanks Again for your prompt response.

[Updated on: Wed, 13 December 2006 11:08]

Report message to a moderator

Re: ORA-02019 while accesing DB B from DB A through a dblink. [message #209146 is a reply to message #209142] Wed, 13 December 2006 09:04 Go to previous messageGo to next message
sssss
Messages: 9
Registered: November 2006
Junior Member
no as explained, it give this error intermittently, and this doen not cause any problem to anything else. its just not able to populate in the DB B from DB A through the dblink.
Re: ORA-02019 while accesing DB B from DB A through a dblink. [message #209148 is a reply to message #209138] Wed, 13 December 2006 09:09 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

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.


SQL> conn scott/tiger
Connected.
SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------

ORCL

SQL> desc big
ERROR:
ORA-04043: object big does not exist


SQL> create database link ORACLE
2 connect to scott
3 identified by tiger
4 using 'ORACLE';

Database link created.

SQL> select count(*) from big@oracle;

COUNT(*)
----------
0


regards
Taj
Re: ORA-02019 while accesing DB B from DB A through a dblink. [message #209164 is a reply to message #209148] Wed, 13 December 2006 09:57 Go to previous messageGo to next message
sssss
Messages: 9
Registered: November 2006
Junior Member
Thanks so much for your response, but I think there is no problem in creating the dblink, the thing is DB A is on 9.2.0.4 which has a BUG 3071468-ora 2019 may occur when describing an synonym using a dblink.

so to workaround with this problem both the DB's should have same global_name.

so doc id 262881.1 gives this workaround, but still, if I am wrong you are most welcome to give me any suggestions.

In my issue, only one interface is not working properly, others are working fine inspite of different global_names. so I am guessing those interfaces might be using View instead of synonyms.

i will further update you.

Thanks Again for replying.

[Updated on: Wed, 13 December 2006 11:10]

Report message to a moderator

Re: ORA-02019 while accesing DB B from DB A through a dblink. [message #209188 is a reply to message #209142] Wed, 13 December 2006 12:08 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
JRowbottom wrote on Wed, 13 December 2006 09:53

3) Cause your server to animate and migrate south to warmer climes


But if one is in the southern hemisphere, heading south would get you to the colder climes Wink
Re: ORA-02019 while accesing DB B from DB A through a dblink. [message #209190 is a reply to message #209188] Wed, 13 December 2006 12:17 Go to previous message
sssss
Messages: 9
Registered: November 2006
Junior Member
Hi


I did not get you. Can you please explain.
Previous Topic: Optimizing query with alpanumeric range condition
Next Topic: 2 inner queries in select statement??
Goto Forum:
  


Current Time: Sat Dec 10 06:55:38 CST 2016

Total time taken to generate the page: 0.12454 seconds