oracleserviceSID [message #63406] |
Sun, 03 October 2004 00:42 |
mb
Messages: 51 Registered: March 2001
|
Member |
|
|
hi,
when I want to connect to database I get this error:
Ora-01034:oracle not available.
when I start DB with svrmgrl , my problem solved,
but when I restart windows I have problem,yet.
note: I can't stop and start the oracleserviceSID in services in control panel(it shows that service in start mode), I must use svrmgrl manually.
|
|
|
Re: oracleserviceSID [message #63407 is a reply to message #63406] |
Sun, 03 October 2004 03:20 |
dilip kumar
Messages: 111 Registered: December 2003
|
Senior Member |
|
|
Hi
your database has to be started when ever you restart your system and regarding the service it will always display Started mode when ever u restart the system.
if you want your database should start automatically whenever you restart the system the let me know on which O/S your database is running Because you need to change some system parameters
Regards
D.Dilip
|
|
|
Re: oracleserviceSID [message #63409 is a reply to message #63407] |
Sun, 03 October 2004 04:22 |
mb
Messages: 51 Registered: March 2001
|
Member |
|
|
hi,
my OS is windows2000 and I set the ora_SID_autostart='TRUE' but the oracleserviceSID shows start , but dosn't work correct.
thanks + regards
|
|
|
Re: oracleserviceSID [message #63411 is a reply to message #63409] |
Sun, 03 October 2004 21:21 |
dilip kumar
Messages: 111 Registered: December 2003
|
Senior Member |
|
|
Hi
where you have set that parameter..?
if you want to start DB at booting time then that parameter should be specify in windows registry then only it will start the instance as well database,otherwise it will start only instance.
set the parameters in registry
Thanks and Regards
D.Dilip
|
|
|
|