Well, I finally got past this issue. The problem was in dbora:
touch /var/lock/subsys/oracle9i
Upon startup this was fine, Oracle would start and create
/var/lock/subsys/oracle9i, and everything was cool. At shutdown,
however, INIT expected a lock file called 'dbora' since that was the
name of script that it would've tried to execute from /etc/rc0.d and
/etc/rc6.d: K10dbora. I changed dbora to touch /var/lock/subsys/dbora
at dbstart, and rm -f /var/lock/subsys/dbora at dbshut. And that did
the trick. Thanks to all who offered suggestions.
Mark
Mark wrote:
> 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 Tue Oct 22 2002 - 20:50:39 CDT
