Re: Map database to running instance from oratab?

From: Ethan Post <post.ethan_at_gmail.com>
Date: Tue, 24 Jul 2012 12:14:10 -0500
Message-ID: <CAMNhnU39hWJkdj9h-Sc2UNh+vgQV-pPg6bXTR1+gp8AYSKCA6A_at_mail.gmail.com>

Thanks for all who contributed answers, seems there are no easy answers. Ideally some of these things would be exposed externally without having to look into the database. There are things I might like to know before I even log in with a script. Is it running, is it a standby, is it rac non-rac, what is the instance name...
Anyway here is what I came up with, this is my

.get-active-instance-from-database.sh script. Makes use of a couple other
custom scripts.

. .require.sh DATABASE "${1}"

.list-all-databases.sh | grep "^${1}$" | while read DATABASE; do

   INSTANCE=$(ps -ef | grep "[ora|asm]_smon_${DATABASE}$" | grep -v "grep" | cut -d"_" -f3)

   if [[ -z "${INSTANCE}" ]]; then

      i=0
      while (( ${i} < 5 )); do
         ((i=i+1))
         INSTANCE=$(ps -ef | grep "[ora|asm]_smon_${DATABASE}${i}$" | grep
-v "grep" | cut -d"_" -f3)
         [[ -n "${INSTANCE}" ]] && break
      done

   fi
done

if [[ -z ${INSTANCE} ]]; then

   .warning.sh "$0" "Failed to map instance to database ${1}. Verify database is running and in oratab file." else

   echo ${INSTANCE}
fi

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 24 2012 - 12:14:10 CDT