RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
Yes, I'm sure. If in the services control panel you change OracleService starup properties, it does not affect "ORA__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 value of "Start" key in "HKEY_LOCAL_MACHINE\CurrentControlSet\Services\OracleService" (and the way service is started when the machine is rebooted - Automatic/Manual). So, if you have "Start" key in "HKEY_LOCAL_MACHINE\CurrentControlSet\Services\OracleService" set to "2" (which means "automatic") and you have "ORA__AUTOSTART" key in "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0" set to "FALSE", then on reboot OracleService will start automatically, but the database will not startup. So, then (whenever you ready) you can do: set oracle_sid=instance_name sqlplus /nolog connect sys/password as sysdba startup which will startup the database. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jacques Kilchoer Sent: Friday, January 30, 2004 4:04 PM To: Multiple recipients of list ORACLE-L star > -Original Message- > Igor Neyman > > OracleServiceSID starts the database automatically, because by default > the registry key "ORA__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 service will be still running, but you should be able to > startup the database from OEM. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] Are you sure about that? This is the way I thought it worked with Oracle 8.1 and 9.2 (I just tried it again today using Oracle 8.1.7 on Windows 2000) If in the services control panel the database service has Startup Type Automatic, then the registry entry you mention will have ORA_sid_AUTOSTART TRUE, and when the machine is rebooted, the service will start up AND the instance will be started up. If you want to startup the instance manually on system reboot, you should set the Startup Type for the service to Manual (either in the Services control panel or the registry). Then once the machine is rebooted, you can 1) go to the Services control panel and start the Service, which will start the service and the instance OR 2) At a command prompt type in set ORACLE_SID=instance_name oradim -startup -sid %ORACLE_SID% which will start the service and the instance OR 3) At a command prompt type in set ORACLE_SID=instance_name oradim -startup -sid %ORACLE_SID% -starttype srvc which will start the service, then oradim -startup -sid %ORACLE_SID% -starttype inst which will start the instance OR 4) At a command prompt type in set ORACLE_SID=instance_name oradim -startup -sid %ORACLE_SID% -starttype srvc which will start the service, then sqlplus /nolog connect sys/password as sysdba startup which will start the instance I personally use method 4. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
Igor, What you have mentioned is right i.e. if I set "ORA__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 need to study about this more), but not the database. And then from OEM now I can startup the database. My impression was that OEM should be able to do all these tasks itself. Thanks to all others who have replied as well. -Original Message- Igor Neyman Sent: Friday, January 30, 2004 3:04 PM To: Multiple recipients of list ORACLE-L star Dharminder, OracleServiceSID starts the database automatically, because by default the registry key "ORA__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 service will be still running, but you should be able to startup the database from OEM. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Dharminder Softhome Sent: Friday, January 30, 2004 2:20 PM To: Multiple recipients of list ORACLE-L star 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 boot the machine. Thanks. -Original Message- Mercadante, Thomas F Sent: Friday, January 30, 2004 10:44 AM To: Multiple recipients of list ORACLE-L star 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. It needs to be running for the database to run, but you can still shut the database down as normal and keep the background service running. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 30, 2004 10:34 AM To: Multiple recipients of list ORACLE-L start a Thomas, That is the real problem. I can start the database using Windows 2000 OracleServiceSID. But I want to start up the database using OEM only. Thanks. -Original Message- Thomas Day Sent: Friday, January 30, 2004 9:19 AM To: Multiple recipients of list ORACLE-L start a Go to the SERVICES and start the service. "Dharminder Softhome"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated Sent by: ml-errors 01/29/2004 06:14 PM Please respond to ORACLE-L Hey all, Following is the environment. Windows 2000 Oracle Enterprise 9.2, OEM 9.2 I have two 9.2 database installed on my system. OEM is configured properly. One of the database is in automatic startmode and this DB contains OEM repository. I start the machine, open OEM, login to OEM and then try to start the other database, but it does not start the DB, instead I get ORA-12500 Failed to start a dedicated OEM doc says that with OEM, you can start/shutdown the database using OEM. Can someone point to me what I am doing wrong. I am using sys username/password for the startup of the second database. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
> -Original Message- > Igor Neyman > > OracleServiceSID starts the database automatically, because by default > the registry key "ORA__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 service will be still running, but you should be able to > startup the database from OEM. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] Are you sure about that? This is the way I thought it worked with Oracle 8.1 and 9.2 (I just tried it again today using Oracle 8.1.7 on Windows 2000) If in the services control panel the database service has Startup Type Automatic, then the registry entry you mention will have ORA_sid_AUTOSTART TRUE, and when the machine is rebooted, the service will start up AND the instance will be started up. If you want to startup the instance manually on system reboot, you should set the Startup Type for the service to Manual (either in the Services control panel or the registry). Then once the machine is rebooted, you can 1) go to the Services control panel and start the Service, which will start the service and the instance OR 2) At a command prompt type in set ORACLE_SID=instance_name oradim -startup -sid %ORACLE_SID% which will start the service and the instance OR 3) At a command prompt type in set ORACLE_SID=instance_name oradim -startup -sid %ORACLE_SID% -starttype srvc which will start the service, then oradim -startup -sid %ORACLE_SID% -starttype inst which will start the instance OR 4) At a command prompt type in set ORACLE_SID=instance_name oradim -startup -sid %ORACLE_SID% -starttype srvc which will start the service, then sqlplus /nolog connect sys/password as sysdba startup which will start the instance I personally use method 4. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
Dharminder, OracleServiceSID starts the database automatically, because by default the registry key "ORA__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 service will be still running, but you should be able to startup the database from OEM. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Dharminder Softhome Sent: Friday, January 30, 2004 2:20 PM To: Multiple recipients of list ORACLE-L star 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 boot the machine. Thanks. -Original Message- Mercadante, Thomas F Sent: Friday, January 30, 2004 10:44 AM To: Multiple recipients of list ORACLE-L star 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. It needs to be running for the database to run, but you can still shut the database down as normal and keep the background service running. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 30, 2004 10:34 AM To: Multiple recipients of list ORACLE-L start a Thomas, That is the real problem. I can start the database using Windows 2000 OracleServiceSID. But I want to start up the database using OEM only. Thanks. -Original Message- Thomas Day Sent: Friday, January 30, 2004 9:19 AM To: Multiple recipients of list ORACLE-L start a Go to the SERVICES and start the service. "Dharminder Softhome"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated Sent by: ml-errors 01/29/2004 06:14 PM Please respond to ORACLE-L Hey all, Following is the environment. Windows 2000 Oracle Enterprise 9.2, OEM 9.2 I have two 9.2 database installed on my system. OEM is configured properly. One of the database is in automatic startmode and this DB contains OEM repository. I start the machine, open OEM, login to OEM and then try to start the other database, but it does not start the DB, instead I get ORA-12500 Failed to start a dedicated OEM doc says that with OEM, you can start/shutdown the database using OEM. Can someone point to me what I am doing wrong. I am using sys username/password for the startup of the second database. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
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? Maybe you can create an OEM job to start the service. The DOS command is: NET START OracleServiceSID and NET STOP OracleServiceSID Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 30, 2004 2:20 PM To: Multiple recipients of list ORACLE-L star 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 boot the machine. Thanks. -Original Message- Mercadante, Thomas F Sent: Friday, January 30, 2004 10:44 AM To: Multiple recipients of list ORACLE-L star 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. It needs to be running for the database to run, but you can still shut the database down as normal and keep the background service running. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 30, 2004 10:34 AM To: Multiple recipients of list ORACLE-L start a Thomas, That is the real problem. I can start the database using Windows 2000 OracleServiceSID. But I want to start up the database using OEM only. Thanks. -Original Message- Thomas Day Sent: Friday, January 30, 2004 9:19 AM To: Multiple recipients of list ORACLE-L start a Go to the SERVICES and start the service. "Dharminder Softhome"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated Sent by: ml-errors 01/29/2004 06:14 PM Please respond to ORACLE-L Hey all, Following is the environment. Windows 2000 Oracle Enterprise 9.2, OEM 9.2 I have two 9.2 database installed on my system. OEM is configured properly. One of the database is in automatic startmode and this DB contains OEM repository. I start the machine, open OEM, login to OEM and then try to start the other database, but it does not start the DB, instead I get ORA-12500 Failed to start a dedicated OEM doc says that with OEM, you can start/shutdown the database using OEM. Can someone point to me what I am doing wrong. I am using sys username/password for the startup of the second database. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
That's true.
"Dharminder
Softhome"To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Starting Database from OEM
9.2 gives ORA-12500 Failed to star
Sent by:
ml-errors
01/30/2004 02:19
PM
Please respond
to ORACLE-L
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 boot
the machine.
Thanks.
-Original Message-
Mercadante, Thomas F
Sent: Friday, January 30, 2004 10:44 AM
To: Multiple recipients of list ORACLE-L
star
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. It needs to be
running for the database to run, but you can still shut the database down
as
normal and keep the background service running.
hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 30, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L
start a
Thomas,
That is the real problem. I can start the database using Windows 2000
OracleServiceSID.
But I want to start up the database using OEM only.
Thanks.
-Original Message-
Thomas Day
Sent: Friday, January 30, 2004 9:19 AM
To: Multiple recipients of list ORACLE-L
start a
Go to the SERVICES and start the service.
"Dharminder
Softhome"To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Starting Database
from OEM 9.2 gives ORA-12500 Failed to start a dedicated
Sent by:
ml-errors
01/29/2004 06:14
PM
Please respond
to ORACLE-L
Hey all,
Following is the environment.
Windows 2000
Oracle Enterprise 9.2,
OEM 9.2
I have two 9.2 database installed on my system. OEM is configured properly.
One of the database is in automatic startmode and this DB contains OEM
repository.
I start the machine, open OEM, login to OEM and then try to start the other
database, but it does not start the DB, instead I get
ORA-12500 Failed to start a dedicated
OEM doc says that with OEM, you can start/shutdown the database using OEM.
Can someone point to me what I am doing wrong. I am using sys
username/password for the startup of the second database.
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dharminder Softhome
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line con
RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
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 boot the machine. Thanks. -Original Message- Mercadante, Thomas F Sent: Friday, January 30, 2004 10:44 AM To: Multiple recipients of list ORACLE-L star 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. It needs to be running for the database to run, but you can still shut the database down as normal and keep the background service running. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 30, 2004 10:34 AM To: Multiple recipients of list ORACLE-L start a Thomas, That is the real problem. I can start the database using Windows 2000 OracleServiceSID. But I want to start up the database using OEM only. Thanks. -Original Message- Thomas Day Sent: Friday, January 30, 2004 9:19 AM To: Multiple recipients of list ORACLE-L start a Go to the SERVICES and start the service. "Dharminder Softhome"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated Sent by: ml-errors 01/29/2004 06:14 PM Please respond to ORACLE-L Hey all, Following is the environment. Windows 2000 Oracle Enterprise 9.2, OEM 9.2 I have two 9.2 database installed on my system. OEM is configured properly. One of the database is in automatic startmode and this DB contains OEM repository. I start the machine, open OEM, login to OEM and then try to start the other database, but it does not start the DB, instead I get ORA-12500 Failed to start a dedicated OEM doc says that with OEM, you can start/shutdown the database using OEM. Can someone point to me what I am doing wrong. I am using sys username/password for the startup of the second database. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containi
RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star
The Windows service implements Oracle's VOS ( virtual OS ) This is not noticed on *versions, as there is no separate step. See James Morle's book 'Scaling Oracle 8i'. Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/30/2004 07:44 AM Please respond to ORACLE-L 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 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. It needs to be running for the database to run, but you can still shut the database down as normal and keep the background service running. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 30, 2004 10:34 AM To: Multiple recipients of list ORACLE-L start a Thomas, That is the real problem. I can start the database using Windows 2000 OracleServiceSID. But I want to start up the database using OEM only. Thanks. -Original Message- Thomas Day Sent: Friday, January 30, 2004 9:19 AM To: Multiple recipients of list ORACLE-L start a Go to the SERVICES and start the service. "Dharminder Softhome" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> @softhome.net> Subject: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated Sent by: ml-errors 01/29/2004 06:14 PM Please respond to ORACLE-L Hey all, Following is the environment. Windows 2000 Oracle Enterprise 9.2, OEM 9.2 I have two 9.2 database installed on my system. OEM is configured properly. One of the database is in automatic startmode and this DB contains OEM repository. I start the machine, open OEM, login to OEM and then try to start the other database, but it does not start the DB, instead I get ORA-12500 Failed to start a dedicated OEM doc says that with OEM, you can start/shutdown the database using OEM. Can someone point to me what I am doing wrong. I am using sys username/password for the startup of the second database. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services -
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 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. It needs to be running for the database to run, but you can still shut the database down as normal and keep the background service running. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 30, 2004 10:34 AM To: Multiple recipients of list ORACLE-L start a Thomas, That is the real problem. I can start the database using Windows 2000 OracleServiceSID. But I want to start up the database using OEM only. Thanks. -Original Message- Thomas Day Sent: Friday, January 30, 2004 9:19 AM To: Multiple recipients of list ORACLE-L start a Go to the SERVICES and start the service. "Dharminder Softhome"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated Sent by: ml-errors 01/29/2004 06:14 PM Please respond to ORACLE-L Hey all, Following is the environment. Windows 2000 Oracle Enterprise 9.2, OEM 9.2 I have two 9.2 database installed on my system. OEM is configured properly. One of the database is in automatic startmode and this DB contains OEM repository. I start the machine, open OEM, login to OEM and then try to start the other database, but it does not start the DB, instead I get ORA-12500 Failed to start a dedicated OEM doc says that with OEM, you can start/shutdown the database using OEM. Can someone point to me what I am doing wrong. I am using sys username/password for the startup of the second database. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dharminder Softhome INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
