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.
Local database: oracle 126.96.36.199
Remote database: oracle 10.2
Thanks In Advance.