Installed Oracle 10g R2 on openSuse 11.2 - OK, but...

English Applications
1

…not sure how to stop the instance before shutting down. I tried dbstop and oracle stop, but neither work. Thanks

2

4436time wrote:

>
> …not sure how to stop the instance before shutting down. I tried
> dbstop and oracle stop, but neither work. Thanks
>
>
Did you look at this?

http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html

at the end the section “Starting and Stopping the Database:”

But maybe I misunderstood what you really want and you mean something else
(just out of curiousity which method did you chose to install it - with the
orarun from SLES?)

3

I’m new to Oracle on Linux (new to Linux) and am not sure if it’s necessary to stop any services beyond simply shutting down the database from sqlplus in order to be able to logoff and restart the system?

Until now, I’ve not seen the link you posted, but from what I have read, shutting down the db requires doing a dbshut or oracle stop and that isn’t working. If it’s as simple as shutting down in sqlplus, then no problem.

Which method did I use to install Oracle?
Oracle on openSUSE - openSUSE (11.1 Section)

4

If your only concern is that the database is stopped before the system is
shutdown and everything in your oracle installation went well - then you
simply do not need to care at all to stop it manually.

The databases are automatically stopped during the shutdown process when the
system stops all the services in the different runlevels.

You should see some messages on that during the shutdown process when you
press - huh - i do not remember - I think it is simply pressing [esc].

I am not in front of one of our testing machines where oracle 9 and 10 runs
on opensuse (I set it up long ago for testing purposes) so I can give you
more feedback after work tomorrow evening.

5

Although this is for 11g it might be useful for 10g. You might have to create the runtime service if you did a complete manual install. (I had to)

I did it following this article:
SDB:How to Create Your Own Init Script - openSUSE

The start/stop script I’m using is below. It seems to work okay. The Enterprise manager is not being started on boot up as I don’t use it.


#!/bin/sh
#modify for your environment
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=oraclesystemid
export ORACLE_USER=usernamehere

scriptname='basename $0'

case $1 in
    start)
    su - "$ORACLE_USER"<<EOO
    lsnrctl start
    sqlplus /nolog
    connect / as sysdba
    startup

EOO
touch /var/lock/subsys/$scriptname
    ;;

    stop)
    su - "$ORACLE_USER"<<EOO
    lsnrctl stop
    sqlplus /nolog
    connect / as sysdba
    shutdown immediate

EOO
rm -f /var/lock/subsys/$scriptname
    ;;

    *)
    echo "Usage: $0 {start|stop}"
    ;;
esac
6

M_H, thanks. That may explain why I haven’t found much. Guess I expected more given my experience thus far. Not sure why I’m worried about shutting the db down gracefully since it’s on my home machine.

jyas80, thanks as well. I plan to keep it simple until I’ve had more time to spend with it. Seems to be a lot more work to achieve the same results in Linux as compared with Windows. It’s a matter getting used to, I guess.