[lugm.org] Oracle db on debian 6 ia64

[kn at debian.mu]

Hello Systems Admins / Engineers,

I need some advise;

I've migrated from an old hp integrity rx2620 server running hp ux 11b) to an integrity bl870c i2 blade with the following specs:

4x itanium 9340
704gb ram (44x 16gb ram sticks)
4x300 gb @ 15k rpm sas (raid 1 with 2 online spares for os only)
OS: debian 6.0.2

Oracle 11g r2 is being run on the server and databases stored on an hp eva 4400.

The problem started when the blade celebrated its first day in production! The shell prompt appears 15mins after hitting the password! Tried to log in via ssh, it took approx one hour for the prompt to display! 

Oracle advised to dismount all databases and increase file descriptors, I adjusted the oracle user a soft & hard limit of 100000 / 9999999 in /etc/security/limits.conf. Appended fs.file-max = 9999999 in /etc/sysctl.conf , did a sysctl -p & rebooted.

Prompts now appears after approx 8 mins on console, 35 mins via ssh..

To which extent can I increase the wide limits?

Any help would be greatly appreciated.

kn
Sent from my BlackBerry® wireless device