Re: Still experiencing Auto-shtudown problem on RedHat 8.0
From: Nelson Baumgarten <nelson7_at_optonline.net>
Date: Wed, 23 Oct 2002 00:47:19 GMT
Message-ID: <rkmt9.6798$Z9.780_at_news4.srv.hcvlny.cv.net>
> Thanks again Nelson. When I run the script manually I run it as root.
> The oracle user's environment is not getting set in root's profile.
> When I su - oracle I get the correct environment without --login. Bash
> is the oracle user's shell. Also, I should mention again that the
> database does startup automatically, and properly from this link in
> /etc/rc5.d:
>
> lrwxrwxrwx 1 root root 22 Oct 16 19:26 S29dbora -> ../init.d/dbora
>
> You'll notice in my dbora script, the oracle user gets su'd to in the
> same way in the 'start' section as it does in the 'stop' section.
>
>
> Nelson Baumgarten wrote:
> > Mark;
> > One question you say that when you manually run the script it
> > works.. What account are you running it from. Is it root. Assuming that
it
> > is are you setting the oracle environment in roots profile. If you are
that
> > could be why when you run the script it will work. roots login exports
out
> > the environment settings. I am no expert but I saw that if you do an su
> > without the --login my Oracle environ would not get set. I experimented
in
> > the oracle account by typing bash and then checking the environment.
Thats
> > were I noticed that my Oracle settings were not being setup again. I
then
> > typed bash --login I believe and saw that they did reset. If you have
the
> > Oracle settings in /etc/profile this could be your problem. I believe
when
> > you su or bash you start up a completely new shell and if you don't
> > type --login the login profile will not execute. There are times where
you
> > will want to change your environment and not run the login. When a file
in
> > any rc begins with a Captal S the system sees that as a start command
and
> > sends the command with the argument of Start to the file you run. When
the
> > system sees a K is sends the word stop..
> > I also tried writing my own script as well and it would not work because
of
> > shelling I mentioned above.
> > "Mark Nunes" <markn_at_san.rr.com> wrote in message
> > news:3DB4BBF2.1020004_at_san.rr.com...
> >
> >>Thanks Nelson. I do realize that su - gets a user's environment. In
> >>fact, in my script I set ORA_OWNER=oracle and then su - $ORA_OWNER.
> >>Oracle's .bash_profile is properly configured to set the ORACLE_SID,
> >>ORACLE_BASE and ORACLE_HOME. $ORACLE_HOME/bin is in my PATH.
> >>$ORACLE_HOME/bin is where dbshut resides. dbshut is called by the stop
> >>section of dbora. I should mention again that when I manually run dbora
> >>stop, the database does shutdown. So I know that the oracle user's
> >>environment is being used, or else it wouldn't know where to look for
> >>dbshut, and the db wouldn't shutdown. You mention that you stop Oracle
> >>from rc5.d as well. I'm a little shaky on the sysVinit stuff. Do links
> >>beginning with S get 'start' issued to their corresponding scipts when
> >>you switch to a particular run level(in your case, run level 5), and
> >>links beginning with a K get issued a 'stop' to their corresponding
> >>scripts when you exit that run level? I have pasted in my dbora script.
> >> Perhaps you might see something that I'm missing.
> >>
> >>
> >>/etc/init.d/dbora
> >>
> >>#!/bin/sh
> >>#
> >># description: starts the oracle dabase deamons
> >>#
> >>echo "Oracle 9i auto start/stop"
> >>
> >>ORA_OWNER=oracle
> >>ORA_HOME=/u01/app/oracle/product/9.2.0.1.0
> >>
> >>case "$1" in
> >>'start')
> >>
> >>echo -n "Starting Oracle9i: "
> >>su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
> >>
> >>echo -n "Starting the Listener for 9i: "
> >>su - $ORA_OWNER -c "${ORA_HOME}/bin/lsnrctl start"
> >>
> >>touch /var/lock/subsys/oracle9i
> >>echo
> >>;;
> >>
> >>'stop')
> >>echo -n "Shutting Oracle9i: "
> >>su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
> >>
> >>echo -n "Shutting down Listener for 9i: "
> >>su - $ORA_OWNER -c "${ORA_HOME}/bin/lsnrctl stop"
> >>
> >>rm -f /var/lock/subsys/oracle9i
> >>echo
> >>;;
> >>
> >>'restart')
> >>
> >>echo -n "Restarting Oracle9i: "
> >>$0 stop
> >>$0 start
> >>echo
> >>;;
> >>
> >>*)
> >>echo "Usage: oracle9i {start | stop | restart }"
> >>exit 1
> >>
> >>esac
> >>exit 0
> >>
> >>
> >>
> >>
> >>Nelson Baumgarten wrote:
> >> > Mark ;
> >> > I have Redhat 8.0 with Oracle and I believe my startup
and
> >> > shutdown work. You have to su to Oracle since the root runs all
startups. I
> >> > am using rc5.d to start and stop. What you have to is make sure that
> >
> > the
> >
> >> > Oracle environment is set when oracle logs in. This is done
.bash_profile.
> >> > If you just to SU oracle the .Bash_profile won't run. It only is run
> >
> > once
> >
> >> > when you login. I have a file in init.d called startoracle and it is
linked
> >> > to S50 oracle in rc5.d. The file startoracle has the command;
> >> > su oracle --login --command=/opt/oracle/product/9.0.1/bin/dbstart.
This
> >> > starts up oracle. I do a similar thing to shutdown oracle I use the
command
> >> > su oracle --login --command=/opt/oracle/product/9.0.1/bin/dbshut to
stop my
> >> > database. If you just do an su oracle as I said you do not execute
the
> >> > .bash_profile to reset your environment. The .bash_profile should be
in the
> >> > oracle account home and set up your environment ORACLE_HOME,
ORACLE_SID etc.
> >> > I hope this helps you. su --help explains the bash shell..
> >> > "Mark" <mark_at_somewhere.com> wrote in message
> >> > news:3db4362a$1_2_at_corp.newsgroups.com...
> >> >
> >> >>Hi,
> >> >>
> >> >>I still can't figure out why Oracle won't shutdown at reboot or
system
> >> >>shutdown. My dbora script is attached. I have created K10dbora
links
> >> >
> >> > from
> >> >
> >> >>/etc/rc0.d and /etc/rc6.d that look like this:
> >> >>lrwxrwxrwx 1 root root 15 Oct 14 K10dbora ->
> >> >
> >> > ../init.d/dbora
> >> >
> >> >>/etc/init.d/dbora looks like this:
> >> >>-rwxr-xr-x 1 root root 819 Oct 14 dbora
> >> >>
> >> >>I tried making the 'K' number unique - changed it to K01dbora, but no
> >> >
> >> > change
> >> >
> >> >>in behavior. As I mentioned before, Oracle will start automatically
using
> >> >>S99dbora links in /etc/rc3.d and /etc/rc5.d. And if I manually run
> >> >>/etc/init.d/dbora stop, the database shuts down. If I run
shutdown -h
> >> >
> >> > now,
> >> >
> >> >>shutdown -r now, init 6 or init 0 the db won't shutdown. Again, any
> >
> > help
> >
> >> >>would be appreciated. Thanks.
> >> >>
> >> >>Mark
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>"Mark" <mark_at_somewhere.com> wrote in message
> >> >>news:3daf37b1_4_at_corp.newsgroups.com...
> >> >>
> >> >>>Hi,
> >> >>>
> >> >>>I am having a problem getting Oracle to shutdown automatically on my
> >> >>
> >> >>RedHat
> >> >>
> >> >>>8.0 installation. I have dbora in /etc/init.d. This script calls
> >> >>
> >> > dbstart
> >> >
> >> >>>and dbshut depending on start or stop usage. If I manually run
dbora
> >> >>
> >> >>stop,
> >> >>
> >> >>>the database shuts down. So, I know that the script works. I
created
> >
> > a
> >
> >> >>>link in /etc/rc0.d, K10dbora, which points to /etc/init.d/dbora.
My
> >> >>>understanding is that this should cause the db to shutdown when the
> >> >>
> >> >>computer
> >> >>
> >> >>>is shut down. Unfortunately it doesn't work. BTW - the db starts
> >> >>>automatically(as it should)on boot up. Now, K10 is not unique.
Does
> >
> > it
> >
> >> >>>need to be? I didn't think that it had to be, but I could be wrong.
> >> >>
> >> > Any
> >> >
> >> >>>insight on this would be much appreciated. Thanks.
> >> >>>
> >> >>>Mark
> >> >>>
> >> >>>
> >> >>>
> >> >>>
> >> >>>
> >> >>>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> >> >>>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> >> >>>-----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >> >
Date: Wed, 23 Oct 2002 00:47:19 GMT
Message-ID: <rkmt9.6798$Z9.780_at_news4.srv.hcvlny.cv.net>
Mark;
I experimented a little more and looked at outputs on my system. I also am having problems with oracle shutting down. I tried various different run levels for shutdown and they don't work. Startup does ok at rc5. I also noticed the same problem with the listener shutting down as well. I must tell you where I used to work I was running Oracle under the HPUX operating system and had similar problems there as well. What I did there because we kicked off backups at specific times and never shutdown our
systems. I ran the shutdown thru a CRON that I set up under the oracle account. I only recently installed Linux and Oracle 9i as I told you earlier. I ran version 8.06 on HPUX. I suspect that the problem might bethat oracle when it gets a terminate from the system can't handle hit and the various processes just terminate when the system kills them without any error handling to shutdown the instance. When Oracle starts up it will repair itself during startup and be ok after. "Mark" <mark_at_nospam.com> wrote in message news:3DB55ADD.5010104_at_nospam.com...
> Thanks again Nelson. When I run the script manually I run it as root.
> The oracle user's environment is not getting set in root's profile.
> When I su - oracle I get the correct environment without --login. Bash
> is the oracle user's shell. Also, I should mention again that the
> database does startup automatically, and properly from this link in
> /etc/rc5.d:
>
> lrwxrwxrwx 1 root root 22 Oct 16 19:26 S29dbora -> ../init.d/dbora
>
> You'll notice in my dbora script, the oracle user gets su'd to in the
> same way in the 'start' section as it does in the 'stop' section.
>
>
> Nelson Baumgarten wrote:
> > Mark;
> > One question you say that when you manually run the script it
> > works.. What account are you running it from. Is it root. Assuming that
it
> > is are you setting the oracle environment in roots profile. If you are
that
> > could be why when you run the script it will work. roots login exports
out
> > the environment settings. I am no expert but I saw that if you do an su
> > without the --login my Oracle environ would not get set. I experimented
in
> > the oracle account by typing bash and then checking the environment.
Thats
> > were I noticed that my Oracle settings were not being setup again. I
then
> > typed bash --login I believe and saw that they did reset. If you have
the
> > Oracle settings in /etc/profile this could be your problem. I believe
when
> > you su or bash you start up a completely new shell and if you don't
> > type --login the login profile will not execute. There are times where
you
> > will want to change your environment and not run the login. When a file
in
> > any rc begins with a Captal S the system sees that as a start command
and
> > sends the command with the argument of Start to the file you run. When
the
> > system sees a K is sends the word stop..
> > I also tried writing my own script as well and it would not work because
of
> > shelling I mentioned above.
> > "Mark Nunes" <markn_at_san.rr.com> wrote in message
> > news:3DB4BBF2.1020004_at_san.rr.com...
> >
> >>Thanks Nelson. I do realize that su - gets a user's environment. In
> >>fact, in my script I set ORA_OWNER=oracle and then su - $ORA_OWNER.
> >>Oracle's .bash_profile is properly configured to set the ORACLE_SID,
> >>ORACLE_BASE and ORACLE_HOME. $ORACLE_HOME/bin is in my PATH.
> >>$ORACLE_HOME/bin is where dbshut resides. dbshut is called by the stop
> >>section of dbora. I should mention again that when I manually run dbora
> >>stop, the database does shutdown. So I know that the oracle user's
> >>environment is being used, or else it wouldn't know where to look for
> >>dbshut, and the db wouldn't shutdown. You mention that you stop Oracle
> >>from rc5.d as well. I'm a little shaky on the sysVinit stuff. Do links
> >>beginning with S get 'start' issued to their corresponding scipts when
> >>you switch to a particular run level(in your case, run level 5), and
> >>links beginning with a K get issued a 'stop' to their corresponding
> >>scripts when you exit that run level? I have pasted in my dbora script.
> >> Perhaps you might see something that I'm missing.
> >>
> >>
> >>/etc/init.d/dbora
> >>
> >>#!/bin/sh
> >>#
> >># description: starts the oracle dabase deamons
> >>#
> >>echo "Oracle 9i auto start/stop"
> >>
> >>ORA_OWNER=oracle
> >>ORA_HOME=/u01/app/oracle/product/9.2.0.1.0
> >>
> >>case "$1" in
> >>'start')
> >>
> >>echo -n "Starting Oracle9i: "
> >>su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
> >>
> >>echo -n "Starting the Listener for 9i: "
> >>su - $ORA_OWNER -c "${ORA_HOME}/bin/lsnrctl start"
> >>
> >>touch /var/lock/subsys/oracle9i
> >>echo
> >>;;
> >>
> >>'stop')
> >>echo -n "Shutting Oracle9i: "
> >>su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
> >>
> >>echo -n "Shutting down Listener for 9i: "
> >>su - $ORA_OWNER -c "${ORA_HOME}/bin/lsnrctl stop"
> >>
> >>rm -f /var/lock/subsys/oracle9i
> >>echo
> >>;;
> >>
> >>'restart')
> >>
> >>echo -n "Restarting Oracle9i: "
> >>$0 stop
> >>$0 start
> >>echo
> >>;;
> >>
> >>*)
> >>echo "Usage: oracle9i {start | stop | restart }"
> >>exit 1
> >>
> >>esac
> >>exit 0
> >>
> >>
> >>
> >>
> >>Nelson Baumgarten wrote:
> >> > Mark ;
> >> > I have Redhat 8.0 with Oracle and I believe my startup
and
> >> > shutdown work. You have to su to Oracle since the root runs all
startups. I
> >> > am using rc5.d to start and stop. What you have to is make sure that
> >
> > the
> >
> >> > Oracle environment is set when oracle logs in. This is done
.bash_profile.
> >> > If you just to SU oracle the .Bash_profile won't run. It only is run
> >
> > once
> >
> >> > when you login. I have a file in init.d called startoracle and it is
linked
> >> > to S50 oracle in rc5.d. The file startoracle has the command;
> >> > su oracle --login --command=/opt/oracle/product/9.0.1/bin/dbstart.
This
> >> > starts up oracle. I do a similar thing to shutdown oracle I use the
command
> >> > su oracle --login --command=/opt/oracle/product/9.0.1/bin/dbshut to
stop my
> >> > database. If you just do an su oracle as I said you do not execute
the
> >> > .bash_profile to reset your environment. The .bash_profile should be
in the
> >> > oracle account home and set up your environment ORACLE_HOME,
ORACLE_SID etc.
> >> > I hope this helps you. su --help explains the bash shell..
> >> > "Mark" <mark_at_somewhere.com> wrote in message
> >> > news:3db4362a$1_2_at_corp.newsgroups.com...
> >> >
> >> >>Hi,
> >> >>
> >> >>I still can't figure out why Oracle won't shutdown at reboot or
system
> >> >>shutdown. My dbora script is attached. I have created K10dbora
links
> >> >
> >> > from
> >> >
> >> >>/etc/rc0.d and /etc/rc6.d that look like this:
> >> >>lrwxrwxrwx 1 root root 15 Oct 14 K10dbora ->
> >> >
> >> > ../init.d/dbora
> >> >
> >> >>/etc/init.d/dbora looks like this:
> >> >>-rwxr-xr-x 1 root root 819 Oct 14 dbora
> >> >>
> >> >>I tried making the 'K' number unique - changed it to K01dbora, but no
> >> >
> >> > change
> >> >
> >> >>in behavior. As I mentioned before, Oracle will start automatically
using
> >> >>S99dbora links in /etc/rc3.d and /etc/rc5.d. And if I manually run
> >> >>/etc/init.d/dbora stop, the database shuts down. If I run
shutdown -h
> >> >
> >> > now,
> >> >
> >> >>shutdown -r now, init 6 or init 0 the db won't shutdown. Again, any
> >
> > help
> >
> >> >>would be appreciated. Thanks.
> >> >>
> >> >>Mark
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>"Mark" <mark_at_somewhere.com> wrote in message
> >> >>news:3daf37b1_4_at_corp.newsgroups.com...
> >> >>
> >> >>>Hi,
> >> >>>
> >> >>>I am having a problem getting Oracle to shutdown automatically on my
> >> >>
> >> >>RedHat
> >> >>
> >> >>>8.0 installation. I have dbora in /etc/init.d. This script calls
> >> >>
> >> > dbstart
> >> >
> >> >>>and dbshut depending on start or stop usage. If I manually run
dbora
> >> >>
> >> >>stop,
> >> >>
> >> >>>the database shuts down. So, I know that the script works. I
created
> >
> > a
> >
> >> >>>link in /etc/rc0.d, K10dbora, which points to /etc/init.d/dbora.
My
> >> >>>understanding is that this should cause the db to shutdown when the
> >> >>
> >> >>computer
> >> >>
> >> >>>is shut down. Unfortunately it doesn't work. BTW - the db starts
> >> >>>automatically(as it should)on boot up. Now, K10 is not unique.
Does
> >
> > it
> >
> >> >>>need to be? I didn't think that it had to be, but I could be wrong.
> >> >>
> >> > Any
> >> >
> >> >>>insight on this would be much appreciated. Thanks.
> >> >>>
> >> >>>Mark
> >> >>>
> >> >>>
> >> >>>
> >> >>>
> >> >>>
> >> >>>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> >> >>>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> >> >>>-----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >> >
>>--------------------------------------------------------------------------
> >
> > --
> >
> >> > ----
> >> >
> >> >
> >> >
> >> >>
> >> >>
> >> >>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> >> >>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> >> >>-----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >
> >
>
>
Received on Wed Oct 23 2002 - 02:47:19 CEST