Hi Techies.,
I have issue in OEM(Enterprise Manager is not able to connect to the database instance), To rectify that I have to update the encrypted password of sysman user in properties file.
But when I issue the below command, getting blank in password;
SQL> select username,lock_date,expiry_date,profile,password from dba_users where username='SYSMAN';
USERNAME LOCK_DATE EXPIRY_DA PROFILE PASSWORD
------------------------------ --------- --------- ------------------------------ ------------------------------
SYSMAN 10-MAY-12 06-NOV-12 DEFAULT
h2.account is getting locked after change the profile.
I have changed the default profile also.what parameter need to change in Profile . i have modified the
ALTER PROFILE default LIMIT password_lock_time 1000;
SQL> select username,account_status,lock_date,expiry_date,profile,password from dba_users where username='SYSMAN';
USERNAME ACCOUNT_STATUS LOCK_DATE EXPIRY_DA PROFILE PASSWORD
------------------------------ -------------------------------- --------- --------- ------------------------------ ------------------------------
SYSMAN LOCKED(TIMED) 10-MAY-12 06-NOV-12 DEFAULT