Solved

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

Posted on 2008-06-15
3
2,389 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

740 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