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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem with DBMS_LOGSTDBY.INSTANTIATE_TABLE

AigarsPJan 4 2010 — edited Sep 12 2011

Hello!
I am trying to execute this procedure on logical standby, however without success.
Same DB versions on the same server (11.1)

I am calling EXECUTE DBMS_LOGSTDBY.INSTANTIATE_TABLE (SCHEMA_NAME => 'TEST', TABLE_NAME => 'TAB1', DBLINK => 'TO_PRIM');

Created DB Link on standby:

CREATE DATABASE LINK TO_PRIM
CONNECT TO <USER>
IDENTIFIED BY <PWD>
USING 'orcl';

When executing instantiate_table, I am getting error:

ORA-16276: specified database link does not correspond to primary database
ORA-06512: at "SYS.DBMS_INTERNAL_LOGSTDBY", line 5933
ORA-02019: connection description for remote database not found
ORA-06512: at "SYS.DBMS_LOGSTDBY", line 650
ORA-06512: at line 1

simple select * from tab1@to_prim works.

What am I missing?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2011

Added on Jan 4 2010

#general-database-discussions

3 comments

1,158 views