Archive for August 1st, 2008

What’s up doc? Databases up at a glance

Posted by Jay Caviness in general on August 1st, 2008

If you are like me, you are more often logged into a host working on a database than on an OEM or Grid Control page. One of the most useful scripts I have is called sids.sh which at a glance shows ASM, instances and listeners up on the current host. I like to add the script to the end of .profile, .bashrc, etc., to run when I first log in to a host.

        ################# ASM Instances #####***##############
        ###                +ASM1 came up     Jun20         ###
        ###             There are  1 instances up          ###
        ######################################################
 
        ################# Oracle Instances ###################
        ###             dgc101t1 came up     Jun20         ###
        ###             dgr101t1 came up     Jun20         ###
        ###               ct10d2 came up     Jun20         ###
        ###              dgc1011 came up     Jun20         ###
        ###              fdb32r2 came up     Jun20         ###
        ###              dgr1011 came up     Jun23         ###
        ###              dgr1012 came up     Jul07         ###
        ###              dgc1012 came up     Jul07         ###
        ###               mmlive came up     Jul31         ###
        ###               mmtest came up     Jul31         ###
        ###               mmhist came up     Jul31         ###
        ###              mmtrain came up     Jul31         ###
        ###             There are 12 instances up          ###
        ######################################################
 
        #################### LISTENERS #######################
        ###       LISTENER_ALERO started     Jun20         ###
        ###        There are  1 listeners up               ###
        ######################################################

If you would like a copy of this script click sids.sh to bring up the source.

, ,

No Comments