Re: Help needed in Unix Shell Scripts

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 10 Dec 1998 20:53:02 +0100
Message-ID: <3670269D.7F8FFD7A@sybrandb.demon.nl>

Oracle provides standard scripts to do this. They will shutdown every database listed in /etc/oratab (on some platforms /var/opt/oracle/oratab) the dbshut(down?) and dbstart(up?) scripts are located in $ORACLE_HOME/bin. These are for Bourne Shell/Korn shell, c shell scripts are also available. If you don't want to use these here is a script skeleten

svrmgrl <<EOD
connect internal
shutdown immediate
exit
EOID
(assuming your are on 7.3)

Hth,

Sybrand Bakker, Oracle DBA

Kenny Leow wrote:

> Hi,
>
> I need to write a shell script to login into my oracle from root, and do a
> shutdown. Can someone help me please?
>
> login for oracle=ora734
> password=oracle734
>
> Thanks a lot.
>
> Kenny

Received on Thu Dec 10 1998 - 13:53:02 CST