RE: ORA-12500

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Thu, 26 Apr 2001 01:35:23 -0700
Message-ID: <F001.002F29D3.20010425235020@fatcity.com>

Thanks Vijay,

        It'll take some time to really test and implement the solutions. I have also checked Metalink, they too suggests mainly processes and removing ORACLE_HOME from listener.ora. Actually I wanted to know that whether these solutions have worked in real life problem or not ;-))

        And yes, I can't find any related error message in oracle trace file...

Thanks again,
Rajesh
-----Original Message-----
Patidar
Sent: Thursday, April 26, 2001 10:51 AM
To: Multiple recipients of list ORACLE-L

hi rajesh,
 i also face the same problem on AIX OS based machine, at that time ora-12500 error was b'cze of no. of OS process execeded from users no. of process limit, after increase the limit it's solved.
may be it will be helpful for u.

Vijay

• "Danisment Gazi Unal (Unal Bilisim)" <danisment.unal_at_unal-bilisim.com> wrote:
  > Hi,
  >
  > ora-12500 is not a good error to diagnose. is there
  > any error in alert.log
  > ?
  >
  > Rajesh Dayal wrote:
  >
  > > Hi All,
  > > I have seen the error-manual for above
  > > Error message, but it really doesn't state
  > anything
  > > clearly.....
  > > Env is Oracle 8.0.5 on NT 4.0. This
  > problem
  > > is not persistent and it comes intermittently. And
  > > it has come when I try to shutdown a Production
  > > through an automated script before backup (of
  > course
  > > automated). Due to this, the backup doesn't happen
  > > and also Media recovery is required further to
  > open
  > > the database. I have checked the env. variables,
  > > they look OK to me(most of the times it work).
  > > The similar script works fine with Demo
  > Database.
  > > Any experience on this issue? Please suggest some
  > > solution.....
  > >
  > > TIA,
  > > Rajesh
  > > --
  > > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > > --
  > > Author: Rajesh Dayal
  > > INET: Rajesh_at_ohitelecom.com
  > >
  > > Fat City Network Services -- (858) 538-5051
  > FAX: (858) 538-5051
  > > San Diego, California -- Public Internet
  > access / Mailing Lists
  > >
  >

  ---

  
  > > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > > to: ListGuru_at_fatcity.com (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.com
  > --
  > Author: Danisment Gazi Unal (Unal Bilisim)
  > INET: danisment.unal_at_unal-bilisim.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (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! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vijay Patidar
  INET: patidar_vijay_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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.com
-- 
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Received on Thu Apr 26 2001 - 03:35:23 CDT