DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: How to automate DB startup in windows

  1. #1
    Join Date
    Feb 2002
    Posts
    267

    How to automate DB startup in windows

    Hi folks,
    How can i make the d/b to automatically start when the Windows starts and shutdown when the windows go down.

    I think i need to create a service to do the same. Could somebody help me in this regard.

    I am using windows2000 Professional and Oracle 8.1.7
    sonia
    Last edited by Sonia; 03-10-2003 at 06:14 AM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi,

    Use dbassist to create the database, it will create the service for you and by default it is set to startup automatically when the Machine starts. And will do a shutdown immediate when the machine goes down if you set the value of ORA_SID_SHUTDOWNTYPE to i in the registry.

    HTH
    Last edited by adewri; 03-10-2003 at 06:18 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Just create a new service with the followin command

    ORADIM -NEW -SID TEST1


    now go the services applet and make it auto start..that it

    regards
    Hrishy

  4. #4
    Join Date
    Feb 2002
    Posts
    267
    hi,
    No, already database is running.....and has been created manually.

    now i cannot recreate the db.
    I think there should be a way to do this.

  5. #5
    Join Date
    Feb 2002
    Posts
    267
    ok....hrishy i will try that
    thanx

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Plaese refer to my post

    regards
    Hrishy

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    AFAIK, in windows 2000 if the database is running then the service must be there.

    Go to services>OracleServiceSid.

    double click it and in the startup type drop down menu choose automatic.

    for shutdown immediate while the machine goes down set the value of ORA_SID_SHUTDOWNTYPE to i in the registry.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    Sep 2002
    Posts
    411
    drop the old service and recreate it with the following command:

    DROP THE SERVICE

    ORADIM -DELETE -SID SID_NAME


    RECREATE THE SERVICE:

    ORADIM -NEW -SID SID_NAME -STARTMODE AUTO -INTPWD PASSWORD -PFILE ....\PFILE\.INIT_SIDNAME.ORA

  9. #9
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by mike2000
    ORADIM -NEW -SID SID_NAME -STARTMODE AUTO -INTPWD PASSWORD -PFILE ....\PFILE\.INIT_SIDNAME.ORA
    (I'm prepared to be wrong on this . . .) I think that just makes the OracleServiceSID (i.e. the instance) startup as "Automatic". I've seen something else to startup the database - OracleStartSID I think - oradim does not seem to create this. (We didn't want this - so I deleted it ages ago). Amar usually knows what he is doing, check out dbassist . . .
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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