[Translated from mos] how to change the password of Database User sysman (this user is the schema of DB Control Repository) mossysman

[Translated from mos] how to change the password of Database User sysman (this user is the schema of DB Control Repository) mossysman

Change the password of the Database User sysman (this user is the schema of DB Control Repository)

Reference Original:
How To Change the Password of the Database User Sysman (DB Control Repository Schema) (Doc ID 259379.1)

Applicable:
Enterprise Manager for Oracle Database-Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Enterprise Manager for Oracle Database-Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Purpose:
The sysman password is encrypted and stored in multiple locations. Therefore, the Database Control (OMS and Agent) can access the database without the sysman password.
Therefore, when you modify the sysman password, the new password must be provided to the Database Control OMS and Agent.

If the new password is not updated to the Database Control OMS and Agent, oms will not be able to access the Database, and in the trace file, you will notice the following error:
13:50:13, 513 [PAFStartupThread] ERROR conn. ConnectionService verifyRepositoryEx.891-Invalid Connection Pool. ERROR = ORA-01017: invalid username/password;
Logon denied2012-05-31 13:50:20, 717 [HTTPThreadGroup-4] ERROR conn. ConnectionService verifyRepositoryEx.891-Invalid Connection Pool. ERROR = ORA-28000: the account is locked
13:50:20, 764 [HTTPThreadGroup-2] ERROR eml. OMSHandshake processFailure.806-OMSHandshake failed.
(Agent url = https://uk-sno1-m018.uk-paper.group.wan: 3938/emd/main) (ERROR = INTERNAL_ERROR) (CAUSE = java. SQL. SQLException: ORA-01017: invalid username/password; logon denied

This article explains how to change the Database user's sysman password when Database Control is continuously enabled.

Note: Enterprise Manager 10 Gb is now available for expansion. Oracle strongly recommends upgrading your environment to Enterprise Manager 11g or 12c.
Enterprise Manager 11g or 12c is currently in premier Support ?)

Range:
All Database administrators who use Enterprise Manager DB Control 10g or 11g.

Details:
Note: For DB Control Release 10.2.0.3 and later installed on Windows 2008/Vista, The emctl command may fail with the error "Permission Denied ". for the solution to this error, see the following article:
Document 1164293.1-Executing Any EMCTL Command on Windows 2008/Vista Returns "Permission denied" Error

First case: Database Release prior 10.2.0.4

Sysman is the schema of the standalone repository of the Enterprise Manager DB Control.
 
To ensure that you have modified the sysman password in the correct database, check whether the environment variable ORACLE_SID is set, the environment variable ORACLE_HOME is set, and whether the PATH includes the correct $ ORACLE_HOME/bin
 
Follow these steps to modify the sysman password. Otherwise, your DB Control runs abnormally.
1. Stop DB Control
On Unix
$ Emctl stop dbconsole

On Windows
Stop the Windows Service OracleDBConsole
Or
Open a Command Window and type
C> emctl stop dbconsole

2. confirm that the DB Control has been stopped:
On Unix
$ Emctl status dbconsole

On Windows
Check the status of the Windows Service OracleDBConsole
Or
Open a DOS Command Window and type
C> emctl status dbconsole

3. log on to sqlplus with the dba permission and execute the following statement:
SQL> alter user sysman identified by <password>;
Example:
SQL> alter user sysman identified by rainbow;

4. Check whether the new password can be logged into the database.
SQL> connect sysman/[@ database_alias]
Example:
SQL> connect sysman/rainbow @ DBRH

5. to $ ORACLE_HOME/host_sid/sysman/config
5.1 back up the emoms. properties file. emoms. properties. orig
5.2 edit the emoms. properties file:
5.2.1 search for rows starting with the following content:
Oracle. sysman. eml. mntr. emdRepPwd =
Replace the encrypted value with the new password (additional note: No plaintext; No.
Example: oracle. sysman. eml. mntr. emdRepPwd = rainbow
5.2.2 find the following line:
Oracle. sysman. eml. mntr. emdRepPwdEncrypted = TRUE
Use FALSE to replace TRUE
6. Restart DB Control
On Unix
$ Emctl start dbconsole

On Windows
Start the Windows Service OracleDBConsole
Or
Open a DOS Command Window and type
C> emctl start dbconsole

7. Check that the password has been encrypted:
View the $ ORACLE_HOME/host_sid/sysman/config/emoms. properties file.
7.1 search for rows starting with the following:
Oracle. sysman. eml. mntr. emdRepPwd =
Confirm that the password has been encrypted
7.2 search for rows starting with the following:
Oracle. sysman. eml. mntr. emdRepPwdEncrypted =
Confirm that this value is TRUE

Case 2: Database Release beginning 10.2.0.4
Sysman is the schema of the standalone repository of the Enterprise Manager DB Control.
 
To ensure that you have modified the sysman password in the correct database, check whether the environment variable ORACLE_SID is set,
 
For DB Control Release 11.2 and later versions, you need to set the environment variable ORACLE_UNQNAME to the value of DB_UNIQUE_NAME.
You must check whether the environment variable ORACLE_HOME is set and whether the PATH includes the correct $ ORACLE_HOME/bin
 
Follow these steps to modify the sysman password. Otherwise, your DB Control runs abnormally.
 
1.1.Stop the DB Control
On Unix
$ Emctl stop dbconsole

On Windows
Stop the Windows Service OracleDBConsole
Or
Open a Command Window and type
C> emctl stop dbconsole

2. confirm that the DB Control has been stopped.
On Unix
$ Emctl status dbconsole

On Windows
Check the status of the Windows Service OracleDBConsole
Or
Open a DOS Command Window and type
C> emctl status dbconsole

3. log on to sqlplus with the dba permission and execute the following statement:
SQL> alter user sysman identified by <password>;
4. Confirm the new password:
SQL> connect sysman/[@ database_alias]
5. In the database directory $ ORACLE_HOME/bin directory, run:
On Unix
$ Emctl setpasswd dbconsole
Provide the new SYSMAN password

On Windows
C>: emctl setpasswd dbconsole
Provide the new SYSMAN password

6. Restart DB Control
On Unix
$ Emctl start dbconsole

On Windows
Start the Windows Service OracleDBConsole
Or
Open a DOS Command Window and type
C>: emctl start dbconsole