RE: db up script

Here is an example of how I use it in a Unix script. V7.3.4, HPUX

$BIN_PATH/oiconnect $GCT_ID_PASSWD

if [ $? -eq 0 ]

  then                                                      
     print   "+ Database $ORACLE_SID is up, continue processing"
     print   "+"
else
     print   "+ Database $ORACLE_SID is down, stop processing"
     print   "+"
     print   "++++++++++++++++++++++++++++++++++++++++++++++++++++++"
     exit

Hope this helps.

John Fedock
jfedock_at_ixl.com

-----Original Message-----
From: Walt Weaver [mailto:wweaver_at_rightnowtech.com] Sent: Friday, May 12, 2000 10:09 AM
To: Multiple recipients of list ORACLE-L Subject: RE: db up script

My experiences with oiconnect weren't all that great -- oiconnect proved to be pretty flaky. It would work correctly about half the time.

I quit using it back in my V.7 days, and I can't find it anywhere in my 8.1.5 distribution. I didn't look very hard, though.

--Walt Weaver
  Bozeman, Montana, USA

-----Original Message-----
Gramolini
Sent: Friday, May 12, 2000 7:22 AM
To: Multiple recipients of list ORACLE-L

When I tried it I got nothing. Is there some trick to it. I tried oiconnect dbname and oiconnect by itself and got zilch. Ruth
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, May 12, 2000 6:57 AM

> You can also use $ORACLE_HOME/bin/oiconnect ( at least up to 8.0.5 ), wich
> will - if I remember correctly - return 0 if is has been able to connect
to
> the db & something else otherwise.
> Just test it ...
>
> > ----------
> > From: Lisa_Koivu_at_gelco.com[SMTP:Lisa_Koivu_at_gelco.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Thursday, May 11, 2000 08:28
> > To: Multiple recipients of list ORACLE-L
> > Subject: db up script
> >
> > Hello -
> >
> > Does anyone have a script that checks if a series of databases are up
and
> > available that they would be willing to share? I set out to write a ksh
> > script
> > to do this and found that I would have to write C to do what I needed to
> > do,
> > since trying to connect to a hung or down instance will result in a hung
> > process. There wasn't an easy way to fire off the connect process,
sleep,
> > and
> > kill it if it hadn't come back yet. I really don't want to spend my day
> > writing
> > C code, it will exacerbate the headache my job gave me today.
> >
> > Any suggestions / script snippets are appreciated
> > Thanks
> > Lisa
> >
> >
> >
> > --
> > Author:
> > INET: Lisa_Koivu_at_gelco.com
> >
> > 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: ListGuru_at_fatcity.com (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).
> >
>
>
> Visit us at http://www.clearstream.com
>
> IMPORTANT MESSAGE
>
> Internet communications are not secure and therefore Clearstream
International does not
> accept legal responsibility for the contents of this message.
>
> The information contained in this e-mail is confidential and may be
legally privileged. It is
> intended solely for the addressee. If you are not the intended recipient,
any disclosure,
> copying, distribution or any action taken or omitted to be taken in
reliance on it, is
> prohibited and may be unlawful. Any views expressed in this e-mail are
those of the
> individual sender, except where the sender specifically states them to be
the views of
> Clearstream International or of any of its affiliates or subsidiaries.
>
> END OF DISCLAIMER
> --
> Author:
> INET: DDORR_at_cedelglobalservices.com
>
> 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: ListGuru_at_fatcity.com (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).
>

--
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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: ListGuru_at_fatcity.com (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).

-- 
Author: Walt Weaver
  INET: wweaver_at_rightnowtech.com

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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L