Setting “ADMIN_RESTRICTIONS_listener_name=on” disables the runtime
modification of parameters in listener.ora.
Got error message “TNS-12508: TNS:listener could not resolve the COMMAND given” when trying to switch off listener log.
LSNRCTL> set log_status off Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=racnode1)(PORT=1521))) TNS-12508: TNS:listener could not resolve the COMMAND given LSNRCTL>
Read more of this content when you subscribe today.
User password can be restored back to its original one by using password hash value.
The password is unknown, and it is encrypted in application configurations. User doesn’t want to change it at the moment.
$ oerr ora 28002
28002, 00000, "the password will expire within %s days"
// *Cause: The user's account is about to expire and the password
// needs to be changed
// *Action: change the password or contact the DBA
//
SQL> select USERNAME,PASSWORD,ACCOUNT_STATUS,EXPIRY_DATE
from dba_users
where username='TESTUSER';
USERNAME PASSWORD ACCOUNT_STATUS EXPIRY_DATE
---------------- -------------------- ---------------- ---------
TESTUSER EXPIRED(GRACE) 18-MAR-17
Get hash password value from USER$.
SQL> select password from user$ where name='TESTUSER'; PASSWORD -------------------- 512795B1F6AC27B8
Reset the password with the original one:
SQL> alter user testuser identified by values '512795B1F6AC27B8'; User altered.
SQL> select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE
from dba_users
where USERNAME='TESTUSER';
USERNAME ACCOUNT_STATUS EXPIRY_DATE
-------------- --------------- -----------
TESTUSER OPEN 14-MAY-17
Make DBA Life Easy 