Results 1 to 6 of 6

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

  1. #1

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

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

  2. #2
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    4,654

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

    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...b_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. #3

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

    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. #4
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    4,654

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

    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. #5
    Join Date
    Jan 2010
    Location
    Canada
    Posts
    33

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

    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.

    Code:
    #!/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. #6

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

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •