DISQUS

chandrapabba · 3 months ago

Actually, you just need step 3 (which is copying over the file from primary to standby)...that should do it...even valid for 11g irrespective of SEC_CASE_SENSITIVE_LOGON setting.

fuadar · 3 months ago

Thanks .
I was referring to 1,2 and 3 as independent options not linked to each other

chandrapabba · 3 months ago

Ok, then check this out as regards your option 1:

sys@DOE01:11g> Select open_mode, database_role from v$database;

OPEN_MODE DATABASE_ROLE
---------- ----------------
READ ONLY PHYSICAL STANDBY

1 row selected.

sys@DOE01:11g> alter user sys identified by temppass;
alter user sys identified by temppass
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access


sys@DOE01:11g>

fuadar · 2 months ago

Agreed.
The behaviour of a read only database does not allow for passwords to be changedin physical standby;
Option #1 thus can only be used if the database is open for read write .
i will update the post . Thanks

Fahd Mirza · 2 months ago

Thanks for the info, and for time being I will stick to the Option 3.