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

If you will ask a question, please don't comment here..

For your questions, please create an issue into my forum.

Forum Link: http://ermanarslan.blogspot.com.tr/p/forum.html

Register and create an issue in the related category.
I will support you from there.