About database startup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: About database startup

  1. #1
    Join Date
    Mar 2001
    Posts
    16
    Hello guys !!!!!!!
    I got a problem over here.help me out.my db is on NT .It use to start by itself. I made lots changes.Now whenever i have to reboot the commp i have to startup the database again by myself.Any sussetions so it can start from services.now it's giving me error oracle not available on my logon.
    Thanks in advance!!!!!!!!!!!

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Go to Control Panel-->Services and change the service startup type from manual to automatic.

  3. #3
    Join Date
    Mar 2001
    Posts
    16
    Thanks Halo
    but that's the problem.service for that data database is automatic and started, but still the problem exits after every i reboot.

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    You said you made a lot of changes. What changes did you make??

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    [url]http://www.dbasupport.com/forums/showthread.php?threadid=7490[/url]
    [url]http://www.dbasupport.com/forums/showthread.php?threadid=7315[/url]
    Reddy,Sam

  6. #6
    Join Date
    Jun 2000
    Posts
    179

    Talking

    It is likely to happen that if you have created new services to start your DB , these new services will only make an instance and not open your database so it is very ordinary to make a script as CMD file ( like the incoming ) and put it on the NT desktop and just click at it to start the database :

    ** Assuming that the SID is PROD

    net start oracleserviceprod
    set Oracle_sid=prod
    svrmgr30 @c:\start.sql


    start.sql => is a text file contains :

    connect internal/manager;
    startup open;
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

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