DBMS_ROLLING.BUILD_PLAN returns ORA-45414
Hi,
I'm trying to implement rolling upgrade using DBMS_ROLLING on a two-member Data Guard environment consists of one primary database (oradb) and one physical standby database.
I ran through the procedure successfully till I reached to the point to run the BUILD_PLAN procedure. It returns the following error:
SQL> exec DBMS_ROLLING.BUILD_PLAN;
BEGIN DBMS_ROLLING.BUILD_PLAN; END;
ERROR at line 1:
ORA-45414: could not connect to a remote database
ORA-06512: at "SYS.DBMS_ROLLING", line 16
ORA-06512: at line 1
To dig into the error, I ran the following query:
SQL>select type, MESSAGE from dba_rolling_events order by event_time;