Solved

ORA-12500: TNS:listener failed to start a dedicated server process

Posted on 2008-06-15
3
2,379 Views
Last Modified: 2013-12-20
Hay Experts,
         I am working on a distributed environment. This is a web application where the UI is designed using Cold Fusion 5.0. ColdFusion interacts with a local oracle 9i database. All major tables are in a remote db which is in  
Oracle 10g. We are using private dblink to connect from 9i to 10g.
        This works fine, but sometimes this gives us ORA-12500: TNS:listener failed to start a dedicated server process. We are not able to figure out the reason.
        Initially we thought may be the fetching is starting a lot of process. SO started monitoring, but the count is very less.

       NOTE: To fetch data ColdFusion calls a stored procedure in 9i, which in turn calls the views present in 10g.  
The process is initiated by ColdFusion.

Details:
Local database: oracle 9.2.0.6
Remote database: oracle 10.2
 Coldfusion version:5.0
 Thanks In Advance.
Ragards,
Plaban Patra
0
Comment
Question by:Plaban_Patra
  • 2
3 Comments
 
LVL 23

Expert Comment

by:David
ID: 21789685
The most common cause of a ORA-12500 is a busy system whereby PGA RAM is exhausted.  The solutions are:

Reduce sort_area_size (pga_aggregate_target) and hash_area_size to make each default PGA size smaller.

Add additional server RAM
0
 
LVL 23

Expert Comment

by:David
ID: 21797329
May I be of further assistance?
0
 
LVL 1

Accepted Solution

by:
Plaban_Patra earned 0 total points
ID: 21812431
Hi DVZ,
We have found the solution after a hard day. This is because some of the tables in remote db being defined with 'parallel (degree default instances default)', which forces parallel query. By executing the queries, what we see is sessions generated by parallel query in this database. We removed the parallel option, and now the system is running fine.
Thanks for your assistance.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
whm high memory usage in processes 7 69
Insert and update a row at the same time 4 49
Oracle Public Synonyms and Privileges 2 50
Help with a redirect in web.config file 8 20
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now