I am getting error 'ORA-24778: cannot open connections' when a front end screen tries to connect to database B via a shared db link in database A. What are the possible causes?
the DB link is a public shared link. We tried bumping up the db parameter open_link_per_instance to 40 and bouncing the database. The error stopped for a while only to re-appear again.
DB : oracle 11g
J2EE application running on Weblogic 10
Please help!