Why and How to Monitoring user DBSNMP will expire in xx hours

 

 Why ?

Each user in oracle is assigned with a password and password has a lot of details, these details may be configured in profile, this profile can be link with function if needed to fulfill all complexity required. One of these is lifetime limit, if you have a limit in profile assigned to your user then you will be prompted in OEM that user xxx will be expired in xxx hour, this is based on your OEM configuration. To renew this time limit you can just re-enter the password or you may create new profile to unlimited or new time period as needed.

How ?

Below are commands in sqlplus to check and update the password for dbsnmp user for example  :

1- to check the user expiration date use:

SQL> set linesize 200

SQL> col username format a30

SQL> select USERNAME,EXPIRY_DATE from dba_users where username="DBSNMP" ;

2- you can renew the password age by re-enter a same or new password as below :

alter user dbsnmp identified by ‘password’ ;