Showing results for 
Search instead for 
Did you mean: 

Listener fail

Go to solution
Regular Advisor

Listener fail

Hi All!

Oracle8i - 8.1.6 - O.S=: HP-UX11.0
Error Number: TNS-12223 - 12540 - 12560 - 00510
Server Net Version: 8.1.6
Client O.S: WIN95/98Lisate

We use an ERP and our clients get the error below. We see the Oracle note 1060517.6 and would like if we can create de file sqlnet.ora on $ORACLE_HOME/network/admin/ directory on the server. Although we not running batch process. Also, if you can help us with other solution. thanx in advance.

Error messages:
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
HPUX Error: 12: Not enough space

see file attach with swapinfo.

We are spirits in the material world
Joseph C. Denman
Honored Contributor

Re: Listener fail

Looks like your server has run out of swap. Add additional swap. I would look into adding more memory.

If I had only read the instructions first??
James R. Ferguson
Acclaimed Contributor

Re: Listener fail

Hi Claudio:

Error-12 is a not enough memory error. To rectify this one needs to configure more swapspace, set 'swapmem_on=1' and/or increase the kernel 'maxdsiz' ('maxdsiz_64bit' on 64-bit processors).

In your case, it appears that you may need to increase 'maxdsiz'.



Re: Listener fail

On an ERP system usually you need at least
twice the RAM in swap space.
SAP says 3.5 times RAM or 20GB for 64bit systems
If you run both the RDBMS and the ERP instance
on the same box consider adding more RAM,
1.5GB is not much.
Be sure you have your HPUX kernel setup for a
database server.
As far as I know you need sqlnet.ora in network/admin


We work in the dark, we do what we can, we give what we have, our doubt is our passion, and our passion is our task - the rest, is the madness of art - Henry James
Sridhar Bhaskarla
Honored Contributor

Re: Listener fail

You are obviously running out of swap space. I am more concerned if I see something in the column "kb used". This indicates that the system is running low on memory. As the swap utilization is nearing 100%, your system may get locked up anytime!!

Add another raw logical volume with the same priority immediately.

swapon -p 1/dev/vg01/lvol5

You obviously have to consider increasing RAM on this box as the processes are swapping out.
After that you may want to fix your maxdsiz parameter.


You may be disappointed if you fail, but you are doomed if you don't try
Frequent Advisor

Re: Listener fail

Other things you may wanna check is the the number of process in the init.ora file, the kernel parameters such as nproc, maxusers, maxuprc.

Regular Advisor

Re: Listener fail

Hi All! Thanx a lot.
really my problem was a swap. I added more 1Gbytes (total of 2G) after read the ERP (Baan IV C4) kernel manual and your answers. I have been monitoring the system and I think it's ok.
We are spirits in the material world
Regular Advisor

Re: Listener fail

... and number of process that was 800 and I need 3600 (Kernel manuel of Baan)...
We are spirits in the material world