Listener fail

[Vogra]

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.

[Joseph C. Denman · Accepted solution]

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

...jcd...

[James R. Ferguson]

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

[Alessandro Bocchino]

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

[Sridhar Bhaskarla]

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

[ajax13]

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

[Vogra]

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.

[Vogra]

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