Re: Cronjob misbehaving

2002-03-22 Thread hemantchitale 

Your CRON script should also define the ORACLE_HOME, ORACLE_SID and PATH.

Why do you need a CRON job to recompile database objects every day ?  Why
are the being invalidated
every day ?

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


Simon Waibale [EMAIL PROTECTED]  22/03/2002 04:18 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]   

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 

 Subject: Cronjob misbehaving  

   

   

   






Hi all,
Thanx for all the good work U R doing for Oracle.
I have a misbehaving cronjob

-Cron Entry
0 5 * * * /usr/scripts/recompile.sh  /ops/scripts/recompile.log 21


-recompile.sh
#!/bin/ksh

## Program name : recompile.sh
## Purpose  : Recompile Invalid Database Objects for specified Shema in
FLAG
## Author   : C.S Waibale Simon
## Date written : 2002-03-19

#for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do
#j:=1
#$i=${i:-$(crypt flag  passwds |awk '{print $j}')
#done

SQLPLUS=/ops/product/817/bin/sqlplus
#Do not export the password variables !
FLAGPASS=${FLAGPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print
$1}')}
CALLS_PASS=${CALLS_PASS:-$(crypt flag  /usr/scripts/passwds |awk '{print
$2}')}
WHPASS=${WHPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print $3}')}
echo Recompiling Invalid Database Objects in the FLAG instance
#This can be sustitued with generic code
$SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
$SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
$SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql

-recompile.log
Recompiling Invalid Database Objects in the FLAG instance
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus


What could be broken ??
The script runs correctly from comand prompt.

---

+---+
C.S Waibale Simon
MTN-Uganda, 8th Floor UDB Building
Cell: +256 77-212655,http://mtn.co.ug
+---+

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Simon Waibale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cronjob misbehaving

2002-03-22 Thread Hallas John 
Title: RE: Cronjob misbehaving





It looks as if your ORACLE_HOME is not being set up.
Try either or both of the following


1) Amend your cron job to look like the following (I assume you are running this as user oracle)


0 5 * * * su - oracle 'usr/scripts/recompile.sh'  /ops/scripts/recompile.log 21


Otherwise set the environment up in the script


#!/bin/ksh 
export ORACLE_SID=your sid
export ORACLE_BASE=your base
export ORACLE_TERM=vt100
export ORACLE_HOME=your home
export PATH=$PATH:$ORACLE_HOME/bin


Then the script


HTH



John


-Original Message-
From: Simon Waibale [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2002 08:18
To: Multiple recipients of list ORACLE-L
Subject: Cronjob misbehaving



Hi all,
Thanx for all the good work U R doing for Oracle.
I have a misbehaving cronjob


-Cron Entry
0 5 * * * /usr/scripts/recompile.sh  /ops/scripts/recompile.log 21



-recompile.sh
#!/bin/ksh


## Program name : recompile.sh
## Purpose : Recompile Invalid Database Objects for specified Shema in
FLAG
## Author : C.S Waibale Simon
## Date written : 2002-03-19


#for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do
#j:=1
#$i=${i:-$(crypt flag  passwds |awk '{print $j}')
#done


SQLPLUS=/ops/product/817/bin/sqlplus
#Do not export the password variables !
FLAGPASS=${FLAGPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print $1}')}
CALLS_PASS=${CALLS_PASS:-$(crypt flag  /usr/scripts/passwds |awk '{print
$2}')}
WHPASS=${WHPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print $3}')}
echo Recompiling Invalid Database Objects in the FLAG instance
#This can be sustitued with generic code
$SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
$SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
$SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql


-recompile.log 
Recompiling Invalid Database Objects in the FLAG instance
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus



What could be broken ??
The script runs correctly from comand prompt.


---


+---+
C.S Waibale Simon
MTN-Uganda, 8th Floor UDB Building
Cell: +256 77-212655,http://mtn.co.ug
+---+ 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Simon Waibale
 INET: [EMAIL PROTECTED]


Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).




=
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=

Re: Cronjob misbehaving

2002-03-22 Thread Connor McDonald 

Set your Oracle environment as the first thing in the
cron job (typically by setting ORACLE_SID and calling
oraenv)

hth
connor

 --- Simon Waibale [EMAIL PROTECTED] wrote:  Hi
all,
 Thanx for all the good work U R doing for Oracle.
 I have a misbehaving cronjob
 
 -Cron Entry
 0 5 * * * /usr/scripts/recompile.sh 
 /ops/scripts/recompile.log 21
 
 
 -recompile.sh
 #!/bin/ksh
 
 ## Program name : recompile.sh
 ## Purpose  : Recompile Invalid Database Objects
 for specified Shema in
 FLAG
 ## Author   : C.S Waibale Simon
 ## Date written : 2002-03-19
 
 #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS
 CH2PASS CH3PASS ; do
 #j:=1
 #$i=${i:-$(crypt flag  passwds |awk '{print $j}')
 #done
 
 SQLPLUS=/ops/product/817/bin/sqlplus
 #Do not export the password variables !
 FLAGPASS=${FLAGPASS:-$(crypt flag 
 /usr/scripts/passwds |awk '{print $1}')}
 CALLS_PASS=${CALLS_PASS:-$(crypt flag 
 /usr/scripts/passwds |awk '{print
 $2}')}
 WHPASS=${WHPASS:-$(crypt flag  /usr/scripts/passwds
 |awk '{print $3}')}
 echo Recompiling Invalid Database Objects in the
 FLAG instance
 #This can be sustitued with generic code
 $SQLPLUS flag_calls/$[EMAIL PROTECTED]
 @/ops/rom/recompile.sql
 $SQLPLUS flag/$[EMAIL PROTECTED]
 @/ops/rom/recompile.sql
 $SQLPLUS flag_wh/$[EMAIL PROTECTED]
 @/ops/rom/recompile.sql
 
 -recompile.log 
 Recompiling Invalid Database Objects in the FLAG
 instance
 Message file sp1lang.msb not found
 Error 6 initializing SQL*Plus
 Message file sp1lang.msb not found
 Error 6 initializing SQL*Plus
 Message file sp1lang.msb not found
 Error 6 initializing SQL*Plus
 
 
 What could be broken ??
 The script runs correctly from comand prompt.
 
 ---
 

+---+
 C.S Waibale Simon
 MTN-Uganda, 8th Floor UDB Building
 Cell: +256 77-212655,http://mtn.co.ug

+---+
 
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 --
 Author: Simon Waibale
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX:
 (858) 538-5051
 San Diego, California-- Public Internet
 access / Mailing Lists


 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cronjob misbehaving

2002-03-22 Thread Simon Waibale 

Thanx.
A lot of development work is going on and I need a daily report on the
changes made in the packages. Recompiled Invalid objects suppliment my
report.
Ciao,
CSW

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L


Your CRON script should also define the ORACLE_HOME, ORACLE_SID and PATH.

Why do you need a CRON job to recompile database objects every day ?  Why
are the being invalidated
every day ?

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


Simon Waibale [EMAIL PROTECTED]  22/03/2002 04:18 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
 

 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)

 Subject: Cronjob misbehaving

 

 

 






Hi all,
Thanx for all the good work U R doing for Oracle.
I have a misbehaving cronjob

-Cron Entry
0 5 * * * /usr/scripts/recompile.sh  /ops/scripts/recompile.log 21


-recompile.sh
#!/bin/ksh

## Program name : recompile.sh
## Purpose  : Recompile Invalid Database Objects for specified Shema in
FLAG
## Author   : C.S Waibale Simon
## Date written : 2002-03-19

#for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do
#j:=1
#$i=${i:-$(crypt flag  passwds |awk '{print $j}')
#done

SQLPLUS=/ops/product/817/bin/sqlplus
#Do not export the password variables !
FLAGPASS=${FLAGPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print
$1}')}
CALLS_PASS=${CALLS_PASS:-$(crypt flag  /usr/scripts/passwds |awk '{print
$2}')}
WHPASS=${WHPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print $3}')}
echo Recompiling Invalid Database Objects in the FLAG instance
#This can be sustitued with generic code
$SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
$SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
$SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql

-recompile.log
Recompiling Invalid Database Objects in the FLAG instance
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus


What could be broken ??
The script runs correctly from comand prompt.

---

+---+
C.S Waibale Simon
MTN-Uganda, 8th Floor UDB Building
Cell: +256 77-212655,http://mtn.co.ug
+---+

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Simon Waibale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Simon Waibale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Cronjob misbehaving

2002-03-22 Thread James J. Morrow 

Simon --

One of the things that many people (even some of the more experienced unix
types) tend to forget is that cron doesn't source the user's profile.  This is
why a script might work just fine from the prompt, but fail when submitted
through cron.

So, the solution would be either:
a)  Make sure your script sources the user's .profile
or, better yet:
b)  Adopt a standard by which any script you may want to
possibly submit through cron defines the important environment
settings ($ORACLE_SID, $ORACLE_HOME, $PATH, etc.)

-- James

Simon Waibale wrote:
 
 Hi all,
 Thanx for all the good work U R doing for Oracle.
 I have a misbehaving cronjob
 
 -Cron Entry
 0 5 * * * /usr/scripts/recompile.sh  /ops/scripts/recompile.log 21
 
 -recompile.sh
 #!/bin/ksh
 
 ## Program name : recompile.sh
 ## Purpose  : Recompile Invalid Database Objects for specified Shema in
 FLAG
 ## Author   : C.S Waibale Simon
 ## Date written : 2002-03-19
 
 #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do
 #j:=1
 #$i=${i:-$(crypt flag  passwds |awk '{print $j}')
 #done
 
 SQLPLUS=/ops/product/817/bin/sqlplus
 #Do not export the password variables !
 FLAGPASS=${FLAGPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print $1}')}
 CALLS_PASS=${CALLS_PASS:-$(crypt flag  /usr/scripts/passwds |awk '{print
 $2}')}
 WHPASS=${WHPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print $3}')}
 echo Recompiling Invalid Database Objects in the FLAG instance
 #This can be sustitued with generic code
 $SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
 $SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
 $SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
 
 -recompile.log
 Recompiling Invalid Database Objects in the FLAG instance
 Message file sp1lang.msb not found
 Error 6 initializing SQL*Plus
 Message file sp1lang.msb not found
 Error 6 initializing SQL*Plus
 Message file sp1lang.msb not found
 Error 6 initializing SQL*Plus
 
 What could be broken ??
 The script runs correctly from comand prompt.
 
 ---
 
 +---+
 C.S Waibale Simon
 MTN-Uganda, 8th Floor UDB Building
 Cell: +256 77-212655,http://mtn.co.ug
 +---+
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Simon Waibale
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 

James J. Morrow E-Mail:  [EMAIL PROTECTED]
Senior Principal Consultant
Tenure Systems, Inc.
Arlington, TX, USA

The reasonable man adapts himself to the world:  the unreasonable man
  persists in trying to adapt the world to himself.  Therefore all progress
   depends on the unreasonable man.  -- George Bernard Shaw
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James J. Morrow
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Cronjob misbehaving

2002-03-22 Thread Simon Waibale 

Hi James,Connor, Hallas, Hemant
Receive my heartfelt and sincere vote of thanx to you all for the brotherly
guidance - I solved this and promise to pay back by helping someone else out
there in turn.

Simon

-Original Message-
Sent: Saturday, March 23, 2002 7:33 AM
To: Multiple recipients of list ORACLE-L


Simon --

One of the things that many people (even some of the more experienced unix
types) tend to forget is that cron doesn't source the user's profile.  This
is
why a script might work just fine from the prompt, but fail when submitted
through cron.

So, the solution would be either:
a)  Make sure your script sources the user's .profile
or, better yet:
b)  Adopt a standard by which any script you may want to
possibly submit through cron defines the important
environment
settings ($ORACLE_SID, $ORACLE_HOME, $PATH, etc.)

-- James

Simon Waibale wrote:
 
 Hi all,
 Thanx for all the good work U R doing for Oracle.
 I have a misbehaving cronjob
 
 -Cron Entry
 0 5 * * * /usr/scripts/recompile.sh  /ops/scripts/recompile.log 21
 
 -recompile.sh
 #!/bin/ksh
 
 ## Program name : recompile.sh
 ## Purpose  : Recompile Invalid Database Objects for specified Shema in
 FLAG
 ## Author   : C.S Waibale Simon
 ## Date written : 2002-03-19
 
 #for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do
 #j:=1
 #$i=${i:-$(crypt flag  passwds |awk '{print $j}')
 #done
 
 SQLPLUS=/ops/product/817/bin/sqlplus
 #Do not export the password variables !
 FLAGPASS=${FLAGPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print
$1}')}
 CALLS_PASS=${CALLS_PASS:-$(crypt flag  /usr/scripts/passwds |awk '{print
 $2}')}
 WHPASS=${WHPASS:-$(crypt flag  /usr/scripts/passwds |awk '{print $3}')}
 echo Recompiling Invalid Database Objects in the FLAG instance
 #This can be sustitued with generic code
 $SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
 $SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
 $SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
 
 -recompile.log
 Recompiling Invalid Database Objects in the FLAG instance
 Message file sp1lang.msb not found
 Error 6 initializing SQL*Plus
 Message file sp1lang.msb not found
 Error 6 initializing SQL*Plus
 Message file sp1lang.msb not found
 Error 6 initializing SQL*Plus
 
 What could be broken ??
 The script runs correctly from comand prompt.
 
 ---
 
 +---+
 C.S Waibale Simon
 MTN-Uganda, 8th Floor UDB Building
 Cell: +256 77-212655,http://mtn.co.ug
 +---+
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Simon Waibale
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 

James J. Morrow E-Mail:  [EMAIL PROTECTED]
Senior Principal Consultant
Tenure Systems, Inc.
Arlington, TX, USA

The reasonable man adapts himself to the world:  the unreasonable man
  persists in trying to adapt the world to himself.  Therefore all progress
   depends on the unreasonable man.  -- George Bernard Shaw
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James J. Morrow
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Simon Waibale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also