ORA-28009: connection as SYS should be as SYSDBA or SYSOPERORA-02063: preceding line from DPLINK

Cause:

This error is caused due to lack of proper privilege for the database link to work.

SQL>  select * from dual@dplink;
 select * from dual@dplink
                    *
ERROR at line 1:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
ORA-02063: preceding line from DPLINK

Workaround:

If the database link with sys user is not working , reproduce the error with another user. Check the username and password of source database not remote database. Specify the same username in remote database while creation of database link

--SOURCE database
SQL> create user test identified by password;

User created.

SQL> grant dba,sysdba,connect,resource,create session,unlimited tablespace to test;

Grant succeeded.

SQL> alter user sys identified by password;

User altered.

After specification of the correct username and password of source database in remote database link creation, the error got vanished

--REMOTE database
SQL> create public database link dpl connect to test identified by "password" using 'DPPROD';

Database link created.

SQL> select * from dual@dpl;

D
-
X

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s