Xref: alice comp.databases.oracle.server:83171
Path: alice!news-feed.fnsi.net!news.idt.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!intgwpad.nntp.telstra.net!nsw.nnrp.telstra.net!not-for-mail
From: steve.adams@ixora.com.au (Steve Adams)
Newsgroups: comp.databases.oracle.server
Subject: Re: SGADEF no longer supported in Oracle 8.1.5  .. need to find how to detect a db is open from a script !
Organization: Ixora Pty Ltd
Message-ID: <38990637.206360991@news.eagles.bbs.net.au>
References: <879452$a2b$1@kermit.esat.net>
X-Newsreader: Forte Free Agent 1.11/32.235
Cache-Post-Path: news.eagles.bbs.net.au!unknown@s33.eagles.bbs.net.au
X-Cache: nntpcache 2.3.2 (see http://www.nntpcache.org/)
Lines: 26
Date: Thu, 03 Feb 2000 04:40:26 GMT
X-Complaints-To: abuse@telstra.net
X-Trace: nsw.nnrp.telstra.net 949552631 203.35.234.163 (Thu, 03 Feb 2000 15:37:11 EST)
NNTP-Posting-Date: Thu, 03 Feb 2000 15:37:11 EST

Hi Dominic,

Have a look at the oiconnect executable in $ORACLE_HOME/bin. It may do
what you want.

Regards,
Steve Adams
http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


On Wed, 2 Feb 2000 11:22:00 -0000, "Dominic Cribbin"
<dominic.cribbin@cognotecSTOPSPAM.com> wrote:

>Hi,
>
>I am currently migrating a script that we used to take cold backups of an
>Oracle DB on a Unix Sun Solaris machine. We are currently using Oracle8i
>8.1.5, my problem is that "sgadef" is no longer supported in the version of
>Oracle. Can anyone advise my on what the equivalent or similar variable is
>in Oracle 8.1.5 .... or what setting tells the script that the database is
>currently open.
>
>Any advice would be great. Thanks.