I have another suggestion to check if a database is up

From: Aponte, Tony <AponteT_at_hsn.net>
Date: Thu, 20 Sep 2001 08:22:40 -0700
Message-ID: <F001.00393B21.20010920082056@fatcity.com>

This
isn't a new post (I lost the original thread asking for help with checking the status of the database via sqlplus, but it was hung). <SPAN
class=344592814-20092001> 
I
developed this script to run sqlplus within a time limit.  The sample below will execute a sqlplus session and will kill it if it's not done in 10 seconds.  It returns zero of it completes OK or a one if the timer expired and the sqlplus session had to be killed. 
 
 

#!/bin/shset -x# Establish
run-time environment.ORACLE_SID=spt_dev; export ORACLE_SIDORAENV_ASK=NO; export ORAENV_ASK. oraenv#-#AlarmHandler() { echo "Got SIGALARM, cmd took too long." KillSubProcs exit 14}#KillSubProcs() { kill ${CHPROCIDS:-$!} if [ $? -eq 0 ] ; then    echo "Sub-processes killed." ;    exit 1 fi}#SetTimer() { 
DEF_TOUT=${1:-10};  if [ $DEF_TOUT -ne 0 ] ;

then     sleep $DEF_TOUT && kill -14 $$ 
&     CHPROCIDS="$CHPROCIDS 
$!"     TIMERPROC=$!  

fi}#UnsetTimer() {  kill $TIMERPROC}##
main()#trap AlarmHandler 14#SetTimer 15#sqlplus internal/ <<EOF &select * from dual;exec DBMS_LOCK.SLEEP(30);exit;EOF#CHPROCIDS="$CHPROCIDS $!"wait $!UnsetTimerecho "All done."exit 0

  <FONT face="Times New Roman"
  size=2>-----Original Message-----From: Christopher Spence   [mailto:cspence_at_FuelSpot.com]Sent: Friday, September 14, 2001 3:45   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   encrption of a column in a table, for V7.3   

  <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt"><A   href="http://www.cybcon.com/~jkstill/util/util_master.html">http://www.cybcon.com/~jkstill/util/util_master.html   <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">    <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">There is some   explanation of blowfish encryption via PL/SQL.   <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">    <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">    <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Also look here as it   has some information of password encryption which makes some notes of v7   v8
  <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">    <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt"><A   href="http://osi.oracle.com/~tkyte/Misc/Passwords.html">http://osi.oracle.com/~tkyte/Misc/Passwords.html   <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">    <SPAN
  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">    

  <SPAN
  style="COLOR: navy; FONT-SIZE: 12pt; mso-no-proof: yes">"Do not criticize   someone until you walked a mile in their shoes, that way when you criticize   them, you are a mile a way and have their shoes."   <SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 18pt; mso-no-proof: yes">Christopher   R. Spence<SPAN
  style="COLOR: navy; mso-no-proof: yes"> <FONT color=navy   face="Comic Sans MS" size=2><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">Oracle   DBA<SPAN
  style="COLOR: navy; mso-no-proof: yes"> <FONT color=navy   face="Comic Sans MS" size=2><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">Phone:   (978) 322-5744<SPAN
  style="COLOR: navy; mso-no-proof: yes"> <FONT color=navy   face="Comic Sans MS" size=2><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">Fax:      (707) 885-2275<SPAN
  style="COLOR: navy; mso-no-proof: yes">   <SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">Fuelspot<FONT   color=navy>
  <FONT color=navy
  face="Comic Sans MS" size=2><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">73   Princeton Street<SPAN
  style="COLOR: navy; mso-no-proof: yes"> <FONT color=navy   face="Comic Sans MS" size=2><SPAN

  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">North<FONT 
  color=navy face="Comic Sans MS" size=2><SPAN 
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">, 

  <SPAN

  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">Chelmsford<FONT 
  color=navy face="Comic Sans MS" size=2><SPAN 
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes"> 

  <FONT color=navy face="Comic Sans MS"   size=2><SPAN
  style="COLOR: navy; FONT-FAMILY: 'Comic Sans MS'; FONT-SIZE: 10pt; mso-no-proof: yes">01863<FONT   color=navy>     

  <SPAN
  style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original   Message-----From: Chen, Bill
  [mailto:BChen_at_us.britannica.com] <SPAN   style="FONT-WEIGHT: bold">Sent<SPAN
  style="FONT-WEIGHT: bold">: <st1:date Year="2001"   Day="14" Month="9"><SPAN
  style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">Friday, September 14,   2001<SPAN
  style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"> <st1:time   Minute="56" Hour="14"><SPAN
  style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">2:56   PM<SPAN
  style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"><SPAN   style="FONT-WEIGHT: bold">To: Multiple recipients of list   <SPAN
  style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">ORACLE-L<FONT   face=Tahoma size=2><SPAN
  style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt"><SPAN   style="FONT-WEIGHT: bold">Subject: encrption of a column in a   table, for V7.3
  <FONT face="Times New Roman"
  size=3> 
  <FONT face="Times New Roman"
  size=3> 
  <SPAN
  style="FONT-SIZE: 10pt">Are anybody aware of any product which will encrypt a   column in a table for Oracle V7? <SPAN   style="FONT-SIZE: 10pt">Something like the DBMS_OBFUSCATION_TOOLKIT package   (available V8.1.6+).
  <SPAN
  style="FONT-SIZE: 10pt">Thanks. <SPAN   style="FONT-SIZE: 10pt">Bill Received on Thu Sep 20 2001 - 10:22:40 CDT