Hi UNIX guru's,

Have recently upgraded Oracle from 8i to 10g on an HP-UX (RISC) 11.11 box.

At least twice a day the database stops accepting incoming connections and the following errors are observed in the various logs.

The box needs to be rebooted to get everything going again.

The box has 6GB of physical ram and I belive 2 x 2GB swap files.

Does anyone one know what the HPUX Error: 12: Not enough space
error is referring to.

The kernel parameters have been configured according to the Oracle upgrade guide.

Also referring to the last error log which was observed when rebooting, what is aux swap space, is it a problem that we havn't got any?

Any help would be appreciated.

Cheers Mat

after upgrade from 816 to 10G:
the database stops accepting new connections.
Network log
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12549: TNS:operating system resource quota exceeded
TNS-12560: TNS:proto adapter error
TNS-00519: Operating system resource quota exceeded
HPUX Error: 12: Not enough space

Error log :- from alert log :-
skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3
skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3
skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3.


Enable auxiliary swap space
Output from "/sbin/rc1.d/S500swap_start start":
----------------------------
Enabling device paging on /dev/vg00/lvolswap.
/usr/sbin/swapon: /dev/vg00/lvolswap: No such file or directory
Enabling device paging on /dev/vg00/lvol1swap.
/usr/sbin/swapon: /dev/vg00/lvol1swap: No such file or directory
Enabling device paging on /dev/vg00/lvol2swap.
/usr/sbin/swapon: /dev/vg00/lvol2swap: No such file or directory
Enabling device paging on /dev/vg00/lvol9.
Warning: swapon returned exit code: 3
"/sbin/rc1.d/S500swap_start start" FAILED

Do a "swapinfo -t" to see how much swap you really have. It looks like you have typos in /etc/fstab. Review which logical volumes you really have and which lv's you actually want to use as swap areas.

Hi,
Thanks for your reply.

I am unable to to do a swapinfo -t as I'm not in front of the machine.
But a previous swapinfo -a returned

         Kb         Kb         Kb        PCT   START/ Kb
TYPE AVAIL      USED     FREE     USED  LIMIT  RESERVE PRI    NAME
dev   2146304    0       2146304  0%    0        -           1    /dev/vg00/1vol2
dev   2048000    0       2048004  0%    0        -           1    /dev/vg00/1vol9
reserve        -   4192820  -4192820
memory 4786844 3352124 1434720 70%

We need the "swapinfo -t" output. The -a output is worse than useless, it's misleading. "Used" means paging has occurred...something was written to the swap area. "Reserved" means needed for stuff in core now in case of paging. If you cannot reserve, you are out of vm.

Hi,

Here is the output from swapinfo -t

Sorry for taking so long to get back to you.

Thanks

Mat

# swapinfo -t

TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME

dev 2146304 226704 1919600 11% 0 - 1 /dev/vg00/lvol2

dev 2048000 227704 1820296 11% 0 - 1 /dev/vg00/lvol9

localfs 1024000 0 1024000 0% 1024000 0 1 /u06/paging

reserve - 4395952 -4395952

memory 4786844 4584352 202492 96%

total 10005148 9434712 570436 94% - 0 -