» about » content » twitter » github »

Oracle Enterprise Manager

If Agent won't allow connections (ORA-28001)

If you get a ORA-28001 or "Enterprise Manager is not able to connect to the database instance" or "ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)" error, the most probable reason is that the SYSMAN user password has expired. You need to do more than just change this password however, here's what you'll need to do (note that I've also included how to change the DBSNMP password for database monitoring)...

Make sure that ORACLE_HOME, ORACLE_SID environment variables are set.

Stop the dbconsole: emctl stop dbconsole.

Connect to the database as a user with DBA privilege using SQL*Plus:

sqlplus /nolog
conn / as sysdba
    

Then run: alter user sysman identified by YourNewPassword;

Make sure that your password works: conn sysman/YourNewPassword

cd to $ORACLE_HOME/YourInstanceSID/sysman/config backup the emoms.properties file.

Edit the emoms.properties file and change oracle.sysman.eml.mntr.emdRepPwd=ABunchOfEncryptedValues to oracle.sysman.eml.mntr.emdRepPwd=YourNewPassword

Then modify oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE to oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

You could restart at this stage, but if your DBSNMP password has also expired, here's how to change it too:

Connect to the database as a user with DBA privilege using SQL*Plus:

sqlplus /nolog
conn / as sysdba
    

Then run: alter user dbsnmp identified by YourNewPassword;

Make sure that your password works: conn dbsnmp/YourNewPassword

cd to $ORACLE_HOME/YourInstanceSID/sysman/emd backup the targets.xml file.

Edit the targets.xml file and change the VALUE after Property NAME="password" to YourNewPassword (set above) and on the same line set ENCRYPTED="FALSE", then save your changes.

Restart the dbconsole: emctl start dbconsole

Refresh your Oracle Enterprise Manager in your browser.

© Roqet 2018 :: 2018-05-11 17:07:10