topic Re: Oracle DB hang up in Operating System - Linux

Oracle DB hang up

Patrick Chim — Thu, 26 Sep 2002 07:00:01 GMT

Hi,

Last night we perform some test on our Oracle DB 8.1.7 on RedHat linux 7.0 throught some application running on Windows 2000 with oracle client.

This morning we discover that the database is hangup and the following error is shown in /var/log/messages

Sep 26 07:30:00 oradb1 kernel: Unable to load interpreter /lib/ld-linux.so.2

Does anyone know about this ?

Regards,
Patrick

Re: Oracle DB hang up

U.SivaKumar_2 — Thu, 26 Sep 2002 07:31:29 GMT

Hi,
Do this.

echo 36000 > /proc/sys/fs/file-max

regards,
U.SivaKumar

Re: Oracle DB hang up

Michael Kelly_5 — Thu, 26 Sep 2002 13:13:07 GMT

This error means that there is not enough free memory (physical RAM + swap) to load another program.
You need to find out which process has taken all the available memory.
If you can get ps or top to run you should be able to pinpoint the process using the most memory. If not, try getting users to log off (one at a time if possible) until you can.

Hope this helps.
Michael.

Re: Oracle DB hang up

Christyna Caroline — Wed, 02 Oct 2002 08:24:16 GMT

I will add question regarding ORACLE. I'm sorry I put my question here cause I can't start new messege I don't know why..I should try it again next time.
Here is my problem.
I have 2 Gigs tablespace. When I want to make 6 Gigs tablespace, it was said that the OS have maz filesize of 2 gigs.
How to make the OS filesize to 6 gigs ?
I use RedHat62.

rgrds,
Chris

Re: Oracle DB hang up

U.SivaKumar_2 — Thu, 03 Oct 2002 02:52:04 GMT

Hi,
Christyna , please see my previous post , DO the same to increase the OS file size.

regards,
U.SivaKumar