02020: too many database links in use

From: guy1 <aone1504_at_yahoo.com>
Date: Fri, 21 Dec 2007 22:06:04 -0800 (PST)
Message-ID: <eb4b060b-18c2-442a-8a1f-750036a42c17@s19g2000prg.googlegroups.com>

We are using Oracle 9i on Solaris server 480R. This is accessed by Oracle 9i on Windows 2003 machine at a remote site.

We are getting the above mentioned error. This seems to be happening whenever there is a some temporary problem in the network, whereby some packets get lost.

Some one suggested that we increase the following parameters in the target database:-

mts_sessions,
sessions,
license_max_sessions

Their current values are :-

mts_sessions=550
sessions = 555
license_max_sessions = 0

Will increasing these values help and when we do this should we increase any other Oracle configuration parameter also.?

Thanks.
AVM Received on Sat Dec 22 2007 - 00:06:04 CST