Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

orapwd file out of sync now because I changed the sys password!

653230Apr 20 2009 — edited Apr 20 2009
I 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.
This post has been answered by 677340 on Apr 20 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2009
Added on Apr 20 2009
4 comments
1,501 views