Hello everybody,

I have a development database TEST which until recently didn't cause me any problem.

But now , here we go:
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
Solaris Error: 12: Not enough space
This is a 8.1.6.3 database in solaris o/s

swap space,CPU, I/O statistics shows that there is no swapping or paging,no load(99% idle).
In the ORAinit file processes=180

LSNRCTL for Solaris: Version 8.1.6.3.0 - Production on 31-JUL-2002 13:49:53

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip_address)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 8.1.6.3.0 - Production
Start Date 31-JUL-2002 12:40:59
Uptime 0 days 1 hr. 8 min. 53 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /var/opt/oracle/listener.ora
Listener Log File /oracle_home/network/log/listener.log
Services Summary...
TEST has 1 service handler(s)
TEST has 2 service handler(s)
The command completed successfully

I've read about some sysconfig parameters:

limits are defined in the /etc/system file with the following lines:

set max_nprocs=xxx
set maxusers=xxx

Could it help ? and how to determine the values for maxusers,max_nprocs.

sar -r 5 5

Average 2519 15818
I need some expertise on this problem(some suggestions for more statistics) , some advices , some hints .

Tia
Peter




---------------------------------
Post your ad for free now! Yahoo! Canada Personals
Oracle LazyDBA home page