Db links issues.. [message #447960] |
Thu, 18 March 2010 13:40 |
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 |
|
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
|
|
|