I have another suggestion to check if a database is up

[Aponte, Tony]

Title: encrption of a column in a table, for V7.3

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).   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/sh set -x # Establish run-time environment. ORACLE_SID=spt_dev; export ORACLE_SID ORAENV_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 $! UnsetTimer echo "All done." exit 0 -----Original Message----- From: Christopher Spence [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: encrption of a column in a table, for V7.3 http://www.cybcon.com/~jkstill/util/util_master.html   There is some explanation of blowfish encryption via PL/SQL.     Also look here as it has some information of password encryption which makes some notes of v7 v8   http://osi.oracle.com/~tkyte/Misc/Passwords.html     "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." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863   -----Original Message----- From: Chen, Bill [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject: encrption of a column in a table, for V7.3     Are anybody aware of any product which will encrypt a column in a table for Oracle V7? Something like the DBMS_OBFUSCATION_TOOLKIT package (available V8.1.6+). Thanks. Bill