Find the date and patch number applied in Oracle Database. List the patches applied in Oracle Database Go to directory CD %ORACLE_HOME%\OPatch opatch lspatches List the patches with lsinventory — …

Check SGA total size and free space usage in Oracle Check the Usage of SGA select round(used.bytes /1024/1024 ,2) used_mb , round(free.bytes /1024/1024 ,2) free_mb , round(tot.bytes /1024/1024 ,2) total_mb …

Check and Change Default Tablespace for User in Oracle Check the User default tablespace select username,default_tablespace from dba_users where username = ‘MDSYS’; USERNAME DEFAULT_TABLESPACE ——– —————— MDSYS SYSAUX In this …

Monitor the gap between data guard physical Standby with email alert Create a database link between the primary and standby link: — Create a database line on primary server linking …

Assign Sudo privileges to the user in Oracle Linux Login with the root user and open the sudoers file $ vi /etc/sudoers OR $ visudo Then go to the session …

ORA-1653: unable to extend table HR.TEST by 8192 in tablespace DATA_1 An error occurs during the insertion operation: ORA-1653: unable to extend table HR.TEST by 8192 in tablespace DATA_1 Error: …

Useful SQL script for Data guard environment Check the data guard information on primary and Standby SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE Check the error or …

Check the archive log status in Oracle Data guard Check the received and applied archive log on the Oracle Dataguard environment select ‘Last Log applied : ‘ Logs, to_char(next_time,’DD-MON-YY:HH24:MI:SS’) Time …