Re: listener woes

From: <oratune_at_aol.com>
Date: Thu, 26 Oct 2000 22:41:23 GMT
Message-ID: <8tabui$9ie$1@nnrp1.deja.com>

In article <8tabfp$955$1_at_nnrp1.deja.com>,   oratune_at_aol.com wrote:
> 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.

>

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


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

Received on Thu Oct 26 2000 - 17:41:23 CDT