How can the problem be resolved if a SYSDBA, forgets his password for logging into enterprise manager?

supremo
Profile Answers by supremo Questions by supremo
Jul 28th, 2007
2
2190

Showing Answers 1 - 2 of 2 Answers

senthilora

Sep 24th, 2007

I think there are 2 ways to do that.
1. Login as SYSTEM and change the SYS password by using ALTER USER.
2. Recreate the password file using orapwd and set remote_password_file=exclusive and then restart the instance.

mhans
Profile Answers by mhans

Feb 25th, 2008

1. Always you should have one more user activated as SYSDBA and this is achieved by using orapw utility
2. If there is just one SYS user then on unix platform, login as ORACLE user (DBA group)
3.

sqlplus '/ as sysdba'
alter user sys identified by 'xyz' ;

This would change SYS pwd