Re: listener woes

Will the K01/S99 scenario work with AIX? I thought that was Solaris-specific.

> > > >
> > > > "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.
> >
>
> Not paying enough attention to your inittab entry I just realized that
> you are starting ORACLE at run level 2.  Therefore you should put the
> K01oracle and S99oracle files or links in /etc/rc2.d.
>
> Usually you'll place a copy of your dbora script in /etc/init.d and
> call it 'oracle'.  You would then link this file as both K01oracle and
> S99oracle in /etc/rc2.d.  The rc process will pass the proper parameter
> to the script depending upon whether the system is coming up or coming
> down.
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>