Hi,
I prepared a Data Guard scenario for a primary database "E11primary" to a physical standby database "E11standby". All worked fine so far. Tried several Protection Modes at primary, checked behaviour etc. Ended up with "Maximum Protection" mode.
Until I performed a manual role switchover.
Now surprisingly my sys connect to the other database service for both sides(!) does not work anymore. It actually should have nothing to do with the Data Guard scenario, but accordingly my new primary cannot to the standby db when opening.
In detail: When both databases are in MOUNT I´m not able to "connect /@<theotherservice>" without using "as sysdba". This worked all the time before.....I know it´s only needed for the primary, but nevertheless it should work.
Error in general : "ORA-01033: ORACLE initialization or shutdown in progress"
Error when opening primary
Odd : Even the a "connect /@<localservice>" on the same server doesn´t work. Shouldn´t this be possible by using the password file....?
Already checked:
- connect /@E11primary as sysdba -> so service is reachable, also tried tnsping
- parameter remote_login_password_file = exclusive -> had no change there, but nevertheless rechecked it
- renewed the password file at new primary, copied it to new standby -> inserted another user HUGO and checked entries on both sides in V$pwfile_users
- restarted both Listener and instance windows service -> just in case....
DB Version : 11.2.0.4
OS : Windows 2k8
Thanks in advance.
Dominik