Dharminder,
Changes the service to AutoStart when the machine reboots. As Thomas said,
the NT service has to be running for you to be able to start the database.
The service will stay running even if you shut the database down. Think of
the service as a backgrouond placeholder for the database.
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
Dharminder,
Changes the service to AutoStart when the machine reboots. As Thomas said,
the NT service has to be running for you
Tom,
As stated earlier, here the intention is to startup the database using OEM
only and without using windows service. As for as I understand if the
OracleServiceSID is properly setup and if startmode for the service is set
to automatic then it will startup the database automatically once you
Subject: RE: Starting Database from OEM
9.2 gives ORA-12500 Failed to star
Sent by:
ml-errors
Well, you can't. Windows is different from other systems in that you have
these services that have to be running in the background. Once the
services are running, you can use OEM to shutdown and startup the database.
But the service has to be running first.
Sorry.
Have you looked at OEM Jobs?
Dharminder,
OracleServiceSID starts the database automatically, because by default
the registry key ORA_SID_AUTOSTART IN
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 is set to TRUE.
If you don't want your OracleServiceSID to start the database
automatically, change the value to FALSE.
This way
-Original Message-
Igor Neyman
OracleServiceSID starts the database automatically, because by default
the registry key ORA_SID_AUTOSTART IN
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 is set to TRUE.
If you don't want your OracleServiceSID to start the database
automatically, change
Igor,
What you have mentioned is right i.e. if I set ORA_SID_AUTOSTART to
FALSE for the database in question and set OraceServiceSID startmode to
Automatic then as windows starts it starts the OracleSID service (or I
should say background services needed for the database to run and I believe
I
Yes, I'm sure.
If in the services control panel you change OracleServiceSID starup
properties, it does not affect ORA_SID_AUTOSTART key in
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 (and does not change the way
the database is started when the service is started).
What it does, it changes the