Xref: alice comp.databases.oracle.server:83023 Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newspeer.clara.net!news.clara.net!skynet.be!newsfeed2.news.nl.uu.net!sun4nl!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: "sgadef" is no longer supported ... anyone know of a similiar method .. Date: Wed, 2 Feb 2000 12:20:37 +0100 Message-ID: <949490565.19331.0.pluto.d4ee154e@news.demon.nl> References: <87934j$9j7$1@kermit.esat.net> Reply-To: "Sybrand Bakker" X-Trace: news.demon.nl 949490565 pluto:19331 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@nl.demon.net X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Lines: 38 Oracle used to provide a script to stop and start the database. I know for sure in v7 they were checking the sgadef. They must have addressed the issue too. The scripts are called dbstart and dbstop and are located in $ORACLE_HOME/bin. Hth, -- Sybrand Bakker, Oracle DBA Dominic Cribbin wrote in message news:87934j$9j7$1@kermit.esat.net... > Hi, > > I am trying migrate an exist Unix script that performs an automated backup > to tape. Part of this script is that it must check to see if the database is > current open. We are migrating to Oracle8i 8.1.5 were I am getting an error > with the "sgadef" parameter in the code below ... it is no longer supported. > > Can any one advise me on another method (similiar to the sgadef method) that > I could use to check for the database status is open for a script like the > one below. I would be gratefully for any advice. > > > > if [ -f $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf ] > then > echo "Oracle instance "$ORACLE_SID" is running closing it to perform > coldbackup" >>$LOGFILES/coldbackup.log > >