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

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


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

open_links |integer |4
open_links_per_instance |integer |4

Please help me...

Rajabaskar Thangaraj
Re: Db links issues.. [message #447962 is a reply to message #447960] Thu, 18 March 2010 13:43 Go to previous message
Messages: 24174
Registered: January 2009
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: Sun Oct 04 21:21:01 CDT 2015

Total time taken to generate the page: 0.06717 seconds