Databases Reference
In-Depth Information
Changing SYSMAN password
The procedure to change the password starts with properly setting the environment
variables:
ORACLE_HOME
,
ORACLE_SID
, and
PATH.
1. Shut down Enterprise Manager Console and make sure it is completely off.
emctl stop dbconsole
emctl status dbconsole
2. From a SQL*Plus prompt connected with a privileged account (SYS, SYSTEM
or SYSMAN) modify the
SYSMAN
's password with a regular
ALTER
USER
command
SQL> alter user SYSMAN identified by <SysmanNewPassword> ;
3. Verify you can open a SQL*Plus session using the
SYSMAN
user identified
with the recently set password.
sqlplus SYSMAN/<SysmanNewPassword>
4. The next phase has to do with replicating the change on the EM configuration
files.
5.
From an OS prompt change the current directory to
<Oracle Home>/
<Hostname>_<Oracle SID>/sysman/config
directory.
6. Backup the
emoms.properties
configuration file.
7. Edit the
emoms.properties
file with a text editor, look for the
oracle.
sysman.eml.mntr.emdRepPwd
entry and replace the text string with the new
SYSMAN
password written in clear text, then look for the
oracle.sysman.
eml.mntr.emdRepPwdEncrypted
entry and change the value to
FALSE
.
Enterprise Manager will automatically change the value to
TRUE
and it will
rewrite the password with the encrypted version.
8. Once you are ready, start the console using the regular
emctl
start
dbconsole
command and when this step is finished verify the password
written in the previously modified configuration file has changed to the
encrypted version.
Your Enterprise Manager console should be up and running now with the new
password. You can verify the access of the
SYSMAN
user sessions in the database
with a simple query to the
V$SESSION
dynamic view.
Search WWH ::
Custom Search