Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-20002 : you cannot create database links

Nagaraju POct 25 2013 — edited Oct 26 2013

HI Experts,

While creating database link i am getting below error. Could anybody of you please have some light on this error. I googled regarding this error and did not get any update.

Oracle version : 11.2.0.3

The user with which i am creating this database link has DBA privilege.

SQL> create database link temp_LINK connect to accountin identified by ******************* using '(DESCRIPTION= (ADDRESS= (COMMUNUITY=tcp.world)(PROTOCOL=TCP)(Host=myself.us.lev.com)(Port=1525)) (CONNECT_DATA=(SID=LNDB1DB)))';
create database link temp_LINK connect to accountin identified by ******************* using '(DESCRIPTION= (ADDRESS= (COMMUNUITY=tcp.world)(PROTOCOL=TCP)(Host=myself.us.lev.com)(Port=1525)) (CONNECT_DATA=(SID=LNDB1DB)))';
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20002: You cannot create database links
ORA-06512: at line 4


Thank you..

This post has been answered by Hoek on Oct 25 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2013
Added on Oct 25 2013
10 comments
10,242 views