Manually start DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Manually start DB

  1. #1
    Join Date
    Aug 2002
    Posts
    15

    Manually start DB

    Hi,

    Sorry, I have a simple question. Apprecaite if you can help me.

    Now my database is startup automatically, How can I change it to manually startup mode.

    Thanks much

  2. #2
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145
    If u are using winNT or 2000 server u

    Go to services in control Panel and change u oracleservice<< sid >> to manual.

  3. #3
    Join Date
    Jan 2001
    Location
    San Diego, CA
    Posts
    81
    well you didn't say which OS you are running on.

    For windows go to "services" menu in administrative tools folder find oracle and set it to manual, for unix, sorry but you gonna figure it out on your own because it is specific to your machine and brand of unix. You will have to change your start up scripts somewhere......

    Eugene, "the jobless DBA"
    San Diego

  4. #4
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    if it is a win2k server then u go to
    control panel
    administrative options
    services
    Oracle_sid - set it to manual.

    NT control panel services same thing.

    In unix - u may have to write a shell which says Oracle_sid , and db start parameters.
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    And if you are on UNIX, you can edit the /var/opt/oracle/oratab file and set the Y setting to N. You can also disable the startup by removing the S## startup script related to init.d.

Posting Permissions

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


Click Here to Expand Forum to Full Width