How To Extend Oracle Database User Expiry Without Changing Existing Password

Step 1) Check the user status

select USERNAME,ACCOUNT_STATUS,LOCK_DATE,EXPIRY_DATE,PROFILE from dba_users where USERNAME='SYSMAN';





Step 2) Fetch the encrypted password for the corresponding user 

select name, password from user$ where name='SYSMAN';






Step 3) Alter the user sysman and set the above encrypted password

alter user SYSMAN identified by values '447B729161192C24' account unlock;






Step 4) Check the user status and try to login using clear text password that your using previously.

select USERNAME,ACCOUNT_STATUS,LOCK_DATE,EXPIRY_DATE,PROFILE from dba_users where USERNAME='SYSMAN';








Comments

Post a Comment

Popular posts from this blog

How To Recover Custom Identity And Custom Trust Keystore Password

Image
==> Password information are stored in security data file  SerializedSystemIni.dat which cannot be readable like text files. ==> Encrypted passwords are stored in config.xml, boot.properties And DataSource-jdbc.xml file can be visible to user. ==> Using Encrypted password and SerializedSystemIni.dat file we can recover passwords ==> Using this method one can recover password for  weblogic Admin Console KeyStore password Data source Password  1) Create a file DecryptTest.py  with below content in $DOMAIN_HOME/security directory from weblogic.security.internal import * from weblogic.security.internal.encryption import * #This will prompt you to make sure you have SerializedSystemIni.dat file under #current directory from where you are running command raw_input("Please make sure you have SerializedSystemIni.dat inside the current directory, if yes press ENTER to continue.") # Encryption service encryptionService = Seri...
Read more

How To Install Oracle WebLogic Server 12.2.1.1.0 Using Silent Mode ?

Image
Summary       1) Create OS User and Group      2) Create Required Directories      3) Assign The Ownership and Permission To Directories      4) Install the JDK and Export The JAVA_HOME in .bash_profile      5) Prepare The Response file.      6) Create The File oraInst.loc And add inventory_loc and inst_group      7) Start The WebLogic Server Binaries Installation Using Silent Mode      8) Create WebLogic Domain Using WLST. 1. Create OS User and Group        groupadd -g 54321 oinstall        useradd -u 54322 -g oinstall oracle        passwd oracle 2. Create Required Directories         mkdir -p /oracle/Middleware        mkdir -p /jdk/jvm 3. Assign The Ownership and Permission To Directories...
Read more

Cannot load /etc/httpd/modules/mod_wl_24.so into server: libopmnsecure.so: cannot open shared object file: No such file or directory

Image
Issue Definition:-    ==> All plugin files are copied to the apache module folder /etc/httpd/modules   ==> In httpd.conf below line is added     LoadModule weblogic_module  /etc/httpd/modules/mod_wl_24.so   ==> Below issue occurs while loading WebLogic Pxoy Plugin 12.2.1.2.0             While executing " httpd -t "  OR ". /apachectl -t " [root@test2 conf]# httpd -t httpd: Syntax error on line 60 of /etc/httpd/conf/httpd.conf: Cannot load /etc/httpd/modules/mod_wl_24.so into server: libopmnsecure.so: cannot open shared object file: No such file or directory [root@test2 conf]# Cause:-  This issue occurs because link to shared library are not present Solution :-   a) Edit the file  ld.so.conf by adding plugin module path /etc/httpd/modules    vi /etc/ld.so.conf    /etc/httpd/modules   b) Execute below command    ldco...
Read more