OraFAQ Forum: Networking and Gateways » ora_sid

Home » RDBMS Server » Networking and Gateways » ora_sid_autostart

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora_sid_autostart [message #67340]

Mon, 17 May 2004 04:50

JOHN
Messages: 182
Registered: April 1998

Senior Member

I am running Oracle 8.1.6.0.0 and have a problem with the OracleServiceSID not starting following a reboot. I have checked the registry settings and ora_sid_autostart is set to true.

As a workaround, I intend to set the service to manual and then write a small batch file and place it in the startup folder so that this service is automatically started.

Any ideas on what else I would need to add to the batch file? Does anyone have any samples?

Many thanks

Report message to a moderator

Re: ora_sid_autostart [message #67344 is a reply to message #67340]

Mon, 24 May 2004 04:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

oracle service is not doin its job.you can create a new service and make it autostart using ORADIM
--------------------------------------------------------------------------------
rem Delete the old serviceORADIM -DELETE -SID test -SRVC servicenamerem Create a new services with the STARTMODE AUTO propertyoradim -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile C:orantadminTESTpfileinitTEST.ora
[i]
iF YOU Intend to write a batch file,
have the following scripted into a .bat file and throw the script in your startup.

invoke svrmgrl (only in 8i)
login as sys or internal
startup
exit

Report message to a moderator

Previous Topic:	dynamic service registration
Next Topic:	TNS-12542 TNS:Address already in use Urgent please help!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 19:49:23 CDT 2025