OraFAQ Forum: SQL & PL/SQL » Database Link: ORA-00604, ORA-20099, ORA-06512, ORA-02063

Home » SQL & PL/SQL » SQL & PL/SQL » Database Link: ORA-00604, ORA-20099, ORA-06512, ORA-02063 (10g Windows)

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

Database Link: ORA-00604, ORA-20099, ORA-06512, ORA-02063 [message #408836]

Thu, 18 June 2009 00:38

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

Report message to a moderator

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

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

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

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

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

Report message to a moderator

Previous Topic:	missing expression error with update subquery
Next Topic:	Function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 01:39:12 CST 2024