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

MOSC Banner

ORA-01017: invalid username/password; logon denied. During DGMGRL> convert to physical standby

Hi,

I need to convert the snapshot standby back to physical standby on DGMGRL. I get the following error.

I connect as local on Primary.

DGMGRL> connect /;

Connected as SYSDG.

DGMGRL> show configuration;

Configuration - dg_prd1203

  Protection Mode: MaxPerformance

  Members:

  prd1203  - Primary database

    p1203fs  - Far sync instance

    p1203s1  - Physical standby database

    p1203s2  - Snapshot standby database

    p1203fs2 - Far sync instance

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS   (status updated 13 seconds ago)

DGMGRL> convert database p1203s2 to physical standby;

Converting database "p1203s2" to a Physical Standby database, please wait...

Oracle Clusterware is restarting database "p1203s2" ...

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