1.How to check a specific user account details in a database set lines 400 pages 400col USERNAME for a20col ACCOUNT_STATUS for a20col PROFILE for a30select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,LOCK_DATE,PROFILE from dba_users where USERNAME='&username';…
If you want to know how to query the alert log file then you are in the right place. Today we will learn how to check the alert log using…
Step-by-Step Applying PSU Patch : 1.Download the latest Opatch Tool and latest patch from My Oracle Support.p28163133_122010_Linux-x86-64.zip --->PSU patchp6880880_122010_Linux-x86-64.zip --->Opatch Review readme file on Patch 28163133. 2.Copy the patch and…
Step-by-Step Applying PSU Patch : 1.Download the latest Opatch Tool and latest patch from My Oracle Support.p28163133_122010_Linux-x86-64.zip --->PSU patchp6880880_122010_Linux-x86-64.zip --->Opatch Review readme file on Patch 28163133. 2.Copy the patch and…