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

From: Dominic Cribbin <dominic.cribbin_at_cognotecSTOPSPAM.com>
Date: Mon, 31 Jan 2000 14:29:56 -0000
Message-ID: <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 Received on Mon Jan 31 2000 - 08:29:56 CST