High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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;

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