Re: listener woes

In article <8t9gro$jr52_at_nntp.cig.mot.com>,   "jawa" <p29682_at_email.mot.com> wrote:
> That is a typo -- it is actually ORACLE_HOME. Good eye, though.
>
> "Dave A" <dave_and_vanna_at_hotmail.com> wrote in message
> news:svfbbnpsk5l409_at_corp.supernews.com...
> > just a guess, but you have the variable ORACLE_HOME for everything
 exept
 the
> > listener start portion where ORA_HOME is used. Are the values
 behind
 these
> > variables correct?
> >
> > --
> > Dave A
> >
> >
> > "jawa" <p29682_at_email.mot.com> wrote in message
> > news:8t73k9$m4q3_at_nntp.cig.mot.com...
> > > Oracle 7.3.4.4 on AIX -- Why doesn't the listener process startup
 on a
> > > system reboot using the following call from /etc/inittab to the
 following
> > > script dbora? The 'stop' stanza works fine. The 'start' stanza
 starts
 the
> > > databases but not the listener. It's as if some oracle process
 needs to
 be
> > > running before the call to lsnrctl happens. Any ideas?
> > >
> > > inittab entry:
> > > oracle:2:wait:/bin/su oracle -c "/.../.../dbora start"
> > >
> > > dbora script:
> > > #!/bin/sh
> > > if [ ! -f ${ORACLE_HOME}/bin/dbstart -o ! -d ${ORACLE_HOME} ]
> > > then
> > > echo "Oracle startup: cannot start"
> > > exit
> > > fi
> > > #
> > > case "$1" in
> > > 'start') #Start the Oracle Databases
> > > ${ORACLE_HOME}/bin/dbstart
> > > wait;sync;sync;sync;sleep 10
> > > ${ORA_HOME}/bin/lsnrctl start
> > > wait;sync;sync;sync;sleep 10
> > > ;;
> > > 'stop')
> > > ${ORACLE_HOME}/bin/lsnrctl stop
> > > wait;sync;sync;sync;sleep 10
> > > ${ORACLE_HOME}/bin/dbshut
> > > wait;sync;sync;sync;sleep 10
> > > ;;
> > > esac
> > > #
> > >
> > >
> >
> >
>
>

This actually should not be executed from /etc/inittab but should be run from rc at boot time. There should be a K01oracle and an S99oracle entry in either the /etc/rc2.d or /etc/rc3.d directory so that when the run level is exited the ORACLE services are stopped and when the run level is entered the ORACLE services are started -- most systems boot to run level 3 so the entries should be placed in the /etc/rc3.d directory. Your difficulties arise from using the wrong process to bring up the ORACLE database and listener.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.