Tuesday, March 26, 2013

Standby fail with ORA-16191

Ref: Oracle support

Whenever SYS password is changed in Primary DB, you need to copy password file from primary to Standby databases . Otherwise, the log shipping will fail with ora-16191.

To make log shipping to continue work without copying password file from primary to physical standby when changing sys password on primary -> use "REDO_TRANSPORT_USER" ( new initilization parameter introduced in 11g)

No comments :

Post a Comment