topic Listener fail in Operating System - HP-UX

Listener fail

Vogra — Thu, 16 Aug 2001 13:36:13 GMT

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.

Re: Listener fail

Joseph C. Denman — Thu, 16 Aug 2001 13:44:55 GMT

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

...jcd...

Re: Listener fail

James R. Ferguson — Thu, 16 Aug 2001 13:47:49 GMT

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'.

Regards!

...JRF...

Re: Listener fail

Alessandro Bocchino — Fri, 17 Aug 2001 08:30:56 GMT

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

Regards,

...AB...

Re: Listener fail

Sridhar Bhaskarla — Fri, 17 Aug 2001 22:56:34 GMT

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.

-Sri

Re: Listener fail

ajax13 — Mon, 20 Aug 2001 16:41:44 GMT

Hi,
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.

Thanks

Re: Listener fail

Vogra — Thu, 23 Aug 2001 18:21:56 GMT

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.
thanxs.

Re: Listener fail

Vogra — Thu, 23 Aug 2001 18:25:00 GMT

... and number of process that was 800 and I need 3600 (Kernel manuel of Baan)...