How To startup DATABASE automaticly
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How To startup DATABASE automaticly

  1. #1
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145

    Angry



    HAi,

    I create the database on personal oracle version 8.1.6 on win NT .With my own storage specifications.

    After that I shutdown the Windows NT system. With out shutdown the database. After a while I start the windows system. Then I saw that database not in open stage. But I keep the instance in auto and also Lisner in auto.


    Please help me.





  2. #2
    Join Date
    Aug 2001
    Posts
    10
    Go to registry (regedit). Under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMEO you can see an entry ORA_*_AUTOSTART. Set the value to TRUE. If you have installed the sample database, you will see the same kind of entry for that in the registry.

    Regards

  3. #3
    Join Date
    Aug 2001
    Location
    cuddapah
    Posts
    145

    Angry



    BUT STILL I GET SAME PROBLEM .

    plsease help me.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Go to your services and set the appropriate oracle parameters to automatic, inclusing the listeners and etc.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    Also make sure that your pfile is properly specified in the same registry location. Oracle 8.1.6 has a bug where it creates the service for the instance and gets the path to the pfile wrong. Hence Oracle does not automatically start when you boot the system.

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