Printable View
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!!!!!!!!!!!
Go to Control Panel-->Services and change the service startup type from manual to automatic.
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.
You said you made a lot of changes. What changes did you make??
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;