1838606 Members
2731 Online
110128 Solutions
New Discussion

Re: Oracle DB hang up

 
Patrick Chim
Trusted Contributor

Oracle DB hang up

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
4 REPLIES 4
U.SivaKumar_2
Honored Contributor

Re: Oracle DB hang up

Hi,
Do this.

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

regards,
U.SivaKumar



Innovations are made when conventions are broken
Michael Kelly_5
Valued Contributor

Re: Oracle DB hang up

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.
The nice thing about computers is that they do exactly what you tell them. The problem with computers is that they do EXACTLY what you tell them.
Christyna Caroline
New Member

Re: Oracle DB hang up

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
U.SivaKumar_2
Honored Contributor

Re: Oracle DB hang up

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

regards,
U.SivaKumar
Innovations are made when conventions are broken