Hi I am new to Oracle 11g, I have a physical standby database and a primary database of Oracle 11g on two different servers.
I have changed the passwords of users(schemas)like sys, sysman, system, users,etc. in primary database by using command :
SQL>alter user username identified by password"
and the passwords have been successfully changed, but when I am trying the same thing with physical standby database , its creating oracle error
ORA-16000: database open for read-only access
And I don't want to change the physical standby database to primary i.e. cannot change it to open read - write mode .
Kindly provide some solution. Thanks in advance