Solved

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

Posted on 2008-06-15
3
2,390 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

752 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