Database Startup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Database Startup

  1. #1
    Join Date
    Aug 2002
    Posts
    176

    Database Startup

    hi all

    How do you start the database automatically when the system starts?
    Instead of logining as sysdba and giving startup command. Now when i Login as sysdba it shows connected to as idle instance, then i issue startup but i want to automatically start the database. I have aslo set the registry variable Ora_sid_autostart to true in
    hkey_local_machine\software\oracle\home.
    I am using oracle 8.1.6 in windows 2000.

    Thanks
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Did you check your windows services? Are they running?
    -- Dilip

  3. #3
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Set the windows service startup automatically on boot.
    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

  4. #4
    Join Date
    Aug 2002
    Posts
    176
    Thanks for the Response
    But the Service is Automatic and also the tnslistener service is automatic

    I get the message "Connected to an Idle Instance " when i Log in to start up for the first time after i boot the system.

    I want the database to start immediately when the system boots.

    Thank you
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  5. #5
    Join Date
    May 2001
    Posts
    736
    This is known problem associated with version 8.1.6. with some installations the database will be UP along with OS with some installation it will not.Even this is explained by the Oracle.This can be overcome by upgrading it to 8.1.7.If u search in Metalink u will get some more information on this.
    Last edited by akhadar; 10-28-2002 at 05:26 AM.

  6. #6
    Join Date
    Aug 2002
    Posts
    176
    Thank you for your valuable time .
    Thank you So much.
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  7. #7
    Join Date
    Dec 2001
    Posts
    320
    hi Rohit,
    Just make sure that the ORACLE_SID key in registery is set to your SID.

    Cheers.

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