Home » RDBMS Server » Server Administration » Oracle 9i needs startup each time
Oracle 9i needs startup each time [message #58783] Tue, 30 September 2003 09:04 Go to next message
Vivek nath
Messages: 9
Registered: August 2002
Junior Member
Hi

I have been encountering this strange problem on my Windows 2000 Professional Laptop,that everytime i restart my machine i need to restart my oracle/oracle services (9.2.X version) too though its part of the NT services and is in automatic startup mode.Many of my other colleagues are facing the same problem too.

Thanks
Vivek
Re: Oracle 9i needs startup each time [message #58785 is a reply to message #58783] Tue, 30 September 2003 10:29 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the oracle service would have gone crazy.
so, just create a new service using ORADIM
-- Delete the old service
ORADIM -DELETE -SID test -SRVC servicename

--Create a new services with the STARTMODE AUTO property
oradim -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile C:orantadminTESTpfileinitTEST.ora

----------------------------------------------------------------------

then check the servicces in control panel ...
else
just write a batchscript with netstart!
if you use connect strings, make sure u start the listener too

Previous Topic: ORA-12547:TNS lost contact error while installing Oracle9i on AIX
Next Topic: How to automate the export in OEM??
Goto Forum:
  


Current Time: Fri Sep 20 08:41:13 CDT 2024