Pavan DBA's Blog

The DBA Knowledge Store

Posts Tagged ‘database status script’

script to check db status in a server

Posted by Pavan DBA on May 24, 2012

script to check db status in a server


setenv ORATAB /var/opt/oracle/oratab
foreach x (`cat ${ORATAB} | grep -v “^#”| grep “^[a-z]” | grep -v “demo” | grep -v “test”| grep -v “*” | awk -F:

‘{print $1}’`)
        setenv ORAENV_ASK 1
        setenv ORACLE_SID “$x”
        source /usr/local/default/oracle_sid.csh
            sqlplus -s <<EOF
        / as sysdba
        set lines 132 pages 200 hea off feedback off trims on
        col host_name for a20
                spool chk_dbstatus.log
        select instance_name, host_name, logins, version, status from v\$instance;
                spool off

Note: The above script is written using “C” shell, so if you are using any other shell, make necessary changes. Also as always first test it in lower environments

Posted in Administration, Scripts | Tagged: , , | Leave a Comment »

%d bloggers like this: