Package switching problem!!

[chae, jeong-seong]

Hello.

I configured two node cluster with two package.
One of package guard Oracle_9_2 and the other guard own develop application.

On operating, One of the package switch over adaptive node.
I don't know cause why package switch over.
I will attach the file of package cntl.log and the other log.

I doubt, the cause of swiching full hash table.

You tell me..
thankyou

[chae, jeong-seong]

another file attached

[T G Manikandan · Accepted solution]

The error log tells

"no enough space"

The error is due to
1.Amount of memory and swap available.
If you have 80% used.
What is the value of dbc_max_pct on your kernel.
If it is 50% of memory bring it down to somewhere around 8.
The buffer cache half the memory is too high.

check the individual process usage using
UNIX95= ps -e -o ruser,pid,vsz=Kbytes

to check the process usage by each process.
How is the usage of the swap on the machine
Just do a
swapinfo -ta

you can use glance to monitor the process which is throwing out the error.

2.You have to increase your kernel parameters like
These paramters define the upper limit for a process.
They have default values like 8MB.

maxdsiz
maxdiz_64
maxssiz
maxssiz_64
maxtsiz
maxtsiz_64
ALso make sure that you check these values.

Revert with the amount of swap utilization

[chae, jeong-seong]

The System is the rp2405 with two PA8700 and 2GB Memory.
swapsize is 4GB.
I see the memory and swap utility using glance plus.
Memory usage rate is about 65% and Swap utility rate is about 35%.

Kernel parameter was configurated Oracle 9_2_0 recommendation.

thank you

[T G Manikandan]

Also if you have 2Gb RAM then you can bring down the dbc_max_pct (buffer cache) to 250MB(15%).By default it is 50% i.e. 1Gb for buffer cache.

Also check that you are running the 64 bit oracle executables then you need to tune the 64 bit kernel parameter maxdsiz_64(for 64 bit applications) and not maxdsiz(32 bit).check it out.

REview your documentation on the tuning of kernel parameters.

What is the output of swapinfo -ta.What is the swap usage?

Revert

[chae, jeong-seong]

As kernel parameter is..

maxdsiz = 1073741824 byte
maxdsiz_64 = 2147483648 byte
maxssiz = 134217728 byte
maxssiz_64 = 1073741824 byte

nproc = 4096

thank you

[T G Manikandan]

check the other things

1.reduce dbc_max_pct as mentioned above


2.check at swap usage.

Thanks

[chae, jeong-seong]

swapinfo -at
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4194304 1119344 3074960 27% 0 - 1 /dev/vg00/lvol2
reserve - 2069868 -2069868
total 4194304 3189212 1005092 76% - 0 -

root@ktsmp1:/>kmtune -q dbc_max_pct
Parameter Value
===============================================================================
dbc_max_pct 20