About database startup

[garry]

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!!!!!!!!!!!

[Halo]

Go to Control Panel-->Services and change the service startup type from manual to automatic.

[garry]

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.

[Halo]

You said you made a lot of changes. What changes did you make??

[sreddy]

[url]http://www.dbasupport.com/forums/showthread.php?threadid=7490[/url]
[url]http://www.dbasupport.com/forums/showthread.php?threadid=7315[/url]

[hnagia]

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;