Re: listener woes

In article <8tae1f$hof4_at_nntp.cig.mot.com>,   "jawa" <p29682_at_email.mot.com> wrote:
> 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
> >
>
>

Yes, it is UNIX specific, not Solaris specific. Any System V variant of UNIX will support the rc?.d mechanism.

--
David Fitzjarrell
Oracle Certified DBA


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