Description: This Shell script is very useful to calculate and review total no of database shutdown in the year or month. We can schedule the script to crontab for every…
Read MoreHow to Identify If a Disk/Partition Is Still Used by ASM Introduction: To find whether an ASM disk is still used by ASM, or has Been used by ASM or…
Read MoreOracle Clusterware (CRS/GI) – ASM – Database Version Compatibility Introduction: You can have different release combinations of Oracle Clusterware, ASM and database software running on your cluster. However all cluster…
Read MoreWhat is ocssd.bin ? How To Stop/Start This Process To Apply A Patch in non-RAC Introduction: You have installed Oracle Database 10g Products into the Oracle Home. Now you’re trying…
Read MoreTroubleshooting ASMLIB on Linux ASMLIB Disk Discovery troubleshooting checklist ———————————————— In Oracle10g, storage management and provisioning for Oracle databases is more simplified with a new feature called Automatic…
Read MoreASM is Unable to Detect ASMLIB Disks/Devices Introduction: We can detect ASMLIB devices/disks thru the ASM instance using the below steps. How to detect ASM devices/disks: 1) First of…
Read MoreDescription: We are restricting the logon time for a particular database user so the user can only access the database within defined periods. If the user attempts to logon during…
Read Moreset pages 5000 SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON – HEAD “<TITLE>EMPLOYEE REPORT</TITLE> – <STYLE type=’text/css’> – <!– BODY {background: #FFFFC6} –> – </STYLE>” – BODY…
Read Moreselect ‘alter database datafile’||’ ”’||file_name||””||’ resize ‘||round(highwater+2)||’ ‘||’m’||’;’ from ( select /*+ rule */ a.tablespace_name, a.file_name, a.bytes/1024/1024 file_size_MB, (b.maximum+c.blocks-1)*d.db_block_size/1024/1024 highwater from dba_data_files a , (select file_id,max(block_id) maximum from dba_extents group…
Read MoreSet lines 2000 col NAME for a45 col DESCRIPTION for a100 SELECT name,description from SYS.V$PARAMETER WHERE name LIKE ‘\_%’ ESCAPE ‘\’;
Read More