Re: Oracle 8i Startup Script

OK

On the other hand, I never saw a need to use a password to su to oracle when connected as root.
Granted you will need it when you are connected as root, su to oracle, then su to root, and then su to oracle again, but who does that? So that's why (no obvious error in the script) I made this suggestion

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

"Martin Haltmayer" <Martin.Haltmayer_at_d2mail.de> wrote in message
news:3C2B1F84.586264F5_at_d2mail.de...


> Hello Sybrand,

>

> a password in the listener.ora would not prevent starting the listener but

it


> would only prevent stopping the listener.

>

> Regards,

>

> Martin

>

>

>

> Sybrand Bakker wrote:

> >

> > On Thu, 27 Dec 2001 02:16:28 -0500, "Stuart Shay" <sshay_at_j51.com>

> > wrote:

> >

> > >Hello All:

> > >

> > >Below I have a startup script that does not startup the Oracle Listner.

It


> > >starts up the database correctly.

> > >

> > >When I run the script from the command line it prompts me for the

oracle


> > >account password. Is there anything that I may have left out.

> > >

> > >O/S: SOL 8/Sparc

> > >Oracle: Oracle 8i

> > >

> > >Thanks

> > >Stuart

> > >

> > >Sym Links

> > > ln -s ../init.d/oracle /etc/rc3.d/S95oracle

> > > ln -s ../init.d/oracle /etc/rc0.d/K15oracle

> > >chmod 0755 /etc/init.d/oracle

> > >

> > >Startup Script : /etc/init.d/oracle

> > >

> > >#!/sbin/sh

> > >

> > >case $1 in

> > >        start)

> > >

> > >                echo "Starting Oracle Databae"

> > >                su - oracle  -c "$ORACLE_HOME/bin/dbstart"

> > >

> > >                echo "Starting TNS Listener"

> > >                su - oracle -c "$ORACLE_HOME/bin/lsnrctl START"

> > >

> > >                exit 0

> > >        ;;

> > >

> > >        stop)

> > >                su - oracle -c  "$ORACLE_HOME/bin/lsnrctl STOP"

> > >                su - oracle -c  "$ORACLE_HOME/bin/dbshut"

> > >        ;;

> > >        status)

> > >        ps -ef | grep oracle

> > >        ;;

> > >

> >

> > Most likely you have a password in your listener.ora, so a line

> > reading

> > password_listener =

> > The easiest would be to delete that line.

> > Other than that you can use the set password command in lsnrctl

> >

> > Hth

> >

> > Sybrand Bakker, Senior Oracle DBA

> >

> > To reply remove -verwijderdit from my e-mail address