The best solution to startup/shutdown the database in NT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: The best solution to startup/shutdown the database in NT

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    The best solution to startup/shutdown the database in NT

    There are basically 3 ways to do the startup and shutdown job

    A. Connect to Server Manager to do the job
    B. Use Oradim Utility
    C. Use Windows NT Net Stop /Start Command.

    The answer might be C .

    It is because
    A .in NT , if we choose A/B , even we shutdown the database , but some services still lock the datafile.
    It is not a 'thorough' way to shutdown the database .

    B . C is much faster

    C. Listener can be stoped either .

    D. It's easy to log the information by using C


    So I made a script like :
    Shutdown.bat:
    net stop OracleStart
    net stop OracleService
    net stop OracleTNSListener

    Startup.bat:
    net start OracleService
    net start OracleStart
    net start OracleTNSListener

    Above is just my study , I would like to hear from your idea .
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Mar 2002
    Posts
    200
    I am not somehow convinced about "A" being a bad choice. Looking behind generations of Oracle's growth, there has never been a better way to Shutdown the database other than from the Server Manager. Could you be more specific about what doesn't get stopped in the option from Server Manager?

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    In NT , shutdown command will actually bring the database down . But
    the files related with database are still locked by some process thus you can not delete those files .
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    stopping the service just shutdown the database in normal way .

    i think following following
    shutdown immediate, shutdown transactional, shutdown abort
    is not possible .

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Check Doc ID 74981.1 on Metalink.

    Sanjay

  6. #6
    Join Date
    Mar 2002
    Posts
    200
    Originally posted by ligang
    In NT , shutdown command will actually bring the database down . But
    the files related with database are still locked by some process thus you can not delete those files .
    I could Shutdown the test database on my NT server and could delete all the physical files.

  7. #7
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    I suppose that stopping OS service just do a operation of "shutdown abort". Is it right? Please correct me if I am on the wrong way.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  8. #8
    Join Date
    Oct 2001
    Posts
    11
    Yes stopping OS services amounts to Shutdown abort, something eqivalent to killing all Oracle background processes in Unix.

    - Niranjan

  9. #9
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    In that sense , It looks option3 is not that nice ! As shutdown abort
    is not good anyway
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

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