change password sysman - oms 1

[Yarka]

Hi,

I've configurated oracle management server (Oracle 9i). I need to change the password sysman. Nowadays, it don't have the default password, because I change it (if you have the default password then you can change it easily). But now, by security I need to change it again, but I don't know as I can do this.

Thanks.

 

[Thargy]

Yarka,

if ever you can't get in to a database, have yourself added to the oracle dba group by the system administrator. This allows you to log in to any database on the server in question as sys, without a valid password.

Once in as sys, set any passwords you need to whatever you want them to be, and then log out.

Regards

Tharg

Grinding away at things Oracular

 

[karluk]

Resetting the sysman password is more complicated than just going into the database and executing an "alter user identified by xxx" command. You normally would use the OEM 9i console and go into the Configuration -> Manage Administrators panel. You can then highlight the SYSMAN id and click edit to modify the password. In fact, this is exactly what you should do if you have created another OEM administrator account which has the authority to modify passwords.

Assuming you don't have access to an OEM administrator account which can do the password reset, you will have to log into the OEM repository database as the repository owner and execute the following command, which will reset the sysman password to the default.

execute smp_maintenance.reset_sysman();

Please read Metalink note 236121.1 for more details, especially if you don't know the id or password of the OEM repository owner.