orapwd file out of sync now because I changed the sys password!
653230Apr 20 2009 — edited Apr 20 2009I just got these two databases on line and working (primary and standby), and really don't want to have to request an outtage from the customer...
HPUX 11.23
Oracle 10.2.0.2
For some reason, I couldn't get my toad session to log in with sys credentials, so I figured I locked the account.
I used a sqlplus session to change the sys password....
As SOON as I hit enter on the commit command, I knew I messed up. I remember reading that the sys passwords must be the same.
I found my notes on what I had the sys set to on the standby last, and that would match what it was supposed to be on the primary.
I changed it back, but still the standby has lost the heartbeat connection and is throwing failures in the primary alert log.
Is there anyway to sync this all back up without having to bring down both databases and recreate the password file?
My searches have all returned nothing but how to create the file it's self.
Thanks.