What's up doc? Databases up at a glance August 1, 2008
Posted by grumpydba in general.Tags: ASM, scripts, sids
add a comment
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.
New – Scripts page July 31, 2008
Posted by grumpydba in general.Tags: ASM, scripts, SQL
add a comment
I have been asked to provide some of the scripts I use as a DBA. So I have created a new page “Scripts” which will start off with a few of the ASM scripts I use. I will continually add to the page with scripts for ASM, sql, PL/SQL and shell scripts. If there is a particular function you would like, let me know, if I don’t have it, I am sure I can find it or come up with one. The format may change here and there to make it more efficient. Cheers!
