Hit ORA-06550 PLS-00201: identifier 'DBMS_LOGSTDBY.BUILD' must be declared when build logical DR

Mar 26, 2021 12:03PM

Hi,

I've got the below error when build logical DR with version 19.10(SunOS 5.11 sparc)

=======================

ORA-06550: line 1, column 7:

PLS-00201: identifier 'DBMS_LOGSTDBY.BUILD' must be declared

=======================

The physical DR has been build successfully, and the latest log is same as PROD.

Thread Last Sequence Received Last Sequence Applied

---------- ---------------------- ---------------------

1 401 401

I am not sure why cause this error? The below are the steps I am following, can you please help to check and advise me how to fix it?

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> EXECUTE DBMS_LOGSTDBY.BUILD;

BEGIN DBMS_LOGSTDBY.BUILD; END;

*

ERROR at line 1:

Database Administration (MOSC)