RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated ....

[Dharminder Softhome]

Mauricio

I do not think it is a memory issue because I can startup the database using Windows 2000 OracleServiceSID service and it does not fail.

Thanks.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Mauricio Vilez
Sent: Friday, January 30, 2004 12:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated ....

There is not enough memory to start a dedicated connection. so change the server mode from dedicated to shared, (you can do it change some parameters in init_sid.ora file see oracle documentation).

 

If you are going to change the server mode to shared and you have two database on the same machine, then you have to assign one listener port for each database.

 

hope this helps

 

Mauricio Vilez

Oracle DBA

 

 

Dharminder Softhome <[EMAIL PROTECTED]> wrote:

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).

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!