Database Security Products (MOSC)

MOSC Banner

PLS-00201: identifier 'DBMS_ROLLING.INIT_PLAN' must be declared (TDE implementation)

edited Aug 16, 2017 5:00AM in Database Security Products (MOSC) 5 commentsAnswered

Hi all,

I'm in the process to implement the Oracle Advanced Security (TDE) . as per pre-requisite ADG is already configured.

now i'm at step "Convert Physical Standby to Logical Standby" . i execute below procedure to convert but encountered error. pls help.

SQL> EXECUTE DBMS_ROLLING.INIT_PLAN ( future_primary => 'orcldr');

BEGIN DBMS_ROLLING.INIT_PLAN ( future_primary => 'orcldr'); END;

      *

ERROR at line 1:

ORA-06550: line 1, column 7:

PLS-00201: identifier 'DBMS_ROLLING.INIT_PLAN' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL> select db_unique_name,name,database_role,open_mode,cdb from v$database;

DB_UNIQUE_NAME                 NAME      DATABASE_ROLE    OPEN_MODE            CDB

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center