Home » SQL & PL/SQL » SQL & PL/SQL » Database Link: ORA-00604, ORA-20099, ORA-06512, ORA-02063 (10g Windows)
Database Link: ORA-00604, ORA-20099, ORA-06512, ORA-02063 [message #408836] Thu, 18 June 2009 00:38 Go to next message
sroyc
Messages: 2
Registered: June 2009
Junior Member
Hi All

I ran the following commands from my development database in SQL*Plus session.

create database link lnk_name connect to username
identified by password using 'tns_entry';
select sysdate from dual@lnk_name;

Database link was created successfully. But I am getting the following error.

select sysdate from dual@lnk_name
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20099: ORA-20099: Access not permitted, logon denied.
ORA-06512: at line 8
ORA-02063: preceding 3 lines from lnk_name

Any help or clue that can allow me to proceed? I can create SQL session based on the given credential and access data but not using database link from another SQL session connected to another database where I create the database link.

Thanks in advance.
Roy
Re: Database Link: ORA-00604, ORA-20099, ORA-06512, ORA-02063 [message #408838 is a reply to message #408836] Thu, 18 June 2009 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-20099: Access not permitted, logon denied.

This is a custom message raised by raise_application_error most likely from a logon trigger.
Ask your DBA.

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

[Updated on: Thu, 18 June 2009 00:43]

Report message to a moderator

Re: Database Link: ORA-00604, ORA-20099, ORA-06512, ORA-02063 [message #409473 is a reply to message #408836] Mon, 22 June 2009 19:37 Go to previous messageGo to next message
sroyc
Messages: 2
Registered: June 2009
Junior Member
Thanks Michael.
However DBA can not solve the issue. Will there be any reference to the string in all_source or any other place to verify? It is baffling that data can be fetched through SQL query from a SQL*Plus session using the same connect strict but not via database link. Could it be some privilege restricting SQL access through database link?

Thanks again for your valuable contribution.
Roy
Re: Database Link: ORA-00604, ORA-20099, ORA-06512, ORA-02063 [message #409475 is a reply to message #408836] Mon, 22 June 2009 19:52 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>Will there be any reference to the string in all_source or any other place to verify?
Since we do not have YOUR database, you are wasting your time (& ours) by asking a question ONLY you can answer.

Post your search SQL & results back here.
Re: Database Link: ORA-00604, ORA-20099, ORA-06512, ORA-02063 [message #409543 is a reply to message #409473] Tue, 23 June 2009 01:34 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The answer I can give is to repeat:
Quote:
This is a custom message raised by raise_application_error most likely from a logon trigger.

If you DBA is unable to find it, then maybe it is time to change DBA.

Regards
Michel
Previous Topic: missing expression error with update subquery
Next Topic: Function
Goto Forum:
  


Current Time: Wed Dec 07 03:05:15 CST 2016

Total time taken to generate the page: 0.10603 seconds