From AponteT@hsn.net Thu, 20 Sep 2001 08:22:40 -0700 From: "Aponte, Tony" Date: Thu, 20 Sep 2001 08:22:40 -0700 Subject: I have another suggestion to check if a database is up Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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/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/ <-----Original Message-----From: Christopher Spence [mailto:cspence@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 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:BChen@us.britannica.com] Sent: Friday, September 14, 2001 2:56 PMTo: Multiple recipients of list ORACLE-LSubject: 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