Home » RDBMS Server » Networking and Gateways » Db links issues.. (Oracle10g/10.2.0.4)
Db links issues.. [message #447960] Thu, 18 March 2010 13:40 Go to next message
rajabaskar
Messages: 13
Registered: June 2007
Location: chennai
Junior Member
Hi,

We got below error, while connecting a session from one db to another db.

Details:
--------

SQL>Desc tab@<db_link_name>

ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Maximum of 2 active sessions allowed.
ORA-06512: at line 13
ORA-02063: preceding 3 lines from

NAME |TYPE |VALUE
------------------------------------|-----------|----------------
open_links |integer |4
open_links_per_instance |integer |4


Please help me...

Regards
Rajabaskar Thangaraj
Re: Db links issues.. [message #447962 is a reply to message #447960] Thu, 18 March 2010 13:43 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-20000: Maximum of 2 active sessions allowed.
Talk to the DBA who allowed this localized error.
This is an application level error & not native to distributed Oracle RDBMS
Previous Topic: Oracle forms login problem
Next Topic: Problem Connecting Developer 6.0 to 10G Database
Goto Forum:
  


Current Time: Thu Nov 21 12:11:48 CST 2024