Re: Oracle 8i Startup Script

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
Received on Thu Dec 27 2001 - 07:17:56 CST