RE: Help with Windows error - I have this issue as well

From: kathy duret <katpopins21_at_yahoo.com>
Date: Mon, 24 Jul 2006 13:17:08 -0700 (PDT)
Message-ID: <20060724201708.12573.qmail@web38207.mail.mud.yahoo.com>

Riddle me this. Used to get over 500 connections, now only 400 on windows before I hit error

Windows 2003, 32bit 9.2.0.6

Yes I have a sev 1 tar open with Oracle and they haven't been able to solve my issue. No, I can't upgrade from 9.2.0.6 to 10 on 3rd party application and not certified. No new applications deployed, no program changes in.

  I have these errors:
  TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded   TNS-12560: TNS:protocol adapter error
   TNS-00510: Internal limit restriction exceeded

Moved to a new dell 6850 box and clone of 9.2.06 database this weekend. Everything is the same that I can tell except :

The parameters are all the same EXCEPT db_cache size which I DECREASED by almost 1/2 per Oracle instructions.

My shared_pool_size is very small, large pool is 32K which I can't decrease any more, java pool is 0.

since this was a new OS install on windows, the os and patch levels are the SAME.

could there be any register setting that might be different or ?

anyone got a clue, cause Oracle doesn't

Thanks,

Kathy

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 24 2006 - 15:17:08 CDT

RE: Help with Windows error - I have this issue as well - URGENT UPDATE