Re: "sgadef" is no longer supported ... anyone know of a similiar method ..

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 <dominic.cribbin_at_cognotecSTOPSPAM.com> wrote in message news:87934j$9j7$1_at_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
>
>
Received on Wed Feb 02 2000 - 05:20:37 CST