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

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
LVL 1
Plaban_PatraAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Plaban_PatraConnect With a Mentor Author Commented:
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
 
DavidSenior Oracle Database AdministratorCommented:
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
 
DavidSenior Oracle Database AdministratorCommented:
May I be of further assistance?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.