topic Re: /var 100% ,Oracle LISTENER went Down ? in Operating System - HP-UX

/var 100% ,Oracle LISTENER went Down ?

redhat7012 — Tue, 23 Oct 2012 18:53:27 GMT

Hi ,

Today one of our HP-UX Box /var filesystem got 100 % Full and it made Oracle LISTENER go down.

Due to this database went down..

What could be the reason ?

How this /var filesystem made ORACLE LISTENER Go Down ?

After we have Housekeeping done on /var filesystem and made the space come down to 75%, then the ORACLE LISTENER came UP.

So, I want to know, why this /var has caused LISTENER Go Down ?

How this is related to each other /var and LISTENER ?

Can anybody help me in knowing this ?

Regards,

Appu.

Re: /var 100% ,Oracle LISTENER went Down ?

Patrick Wallek — Tue, 23 Oct 2012 19:01:34 GMT

Do you have any Oracle related files in /var? Perhaps the listener log file? If the file system fills up and the listener could not write to its log file then that may force the listener to crash.

The listener going should not have effected the rest of the DB. The listener being would prevent remote connections to the database but it should not cause the database itself to go down.

Re: /var 100% ,Oracle LISTENER went Down ?

redhat7012 — Tue, 23 Oct 2012 19:14:44 GMT

error the DBA team faced :

TNS-12502 TNS:listener received no CONNECT_DATA from client

Re: /var 100% ,Oracle LISTENER went Down ?

redhat7012 — Tue, 23 Oct 2012 19:18:25 GMT

Can anybody tell me, where are the PID files are stored ?

we can see PID using ps -ef command.

Which process are running ? we can find using ps -ef command.

So, each process has Process ID (PID).

Where these PID Files get stored ?

Please give me the path to find why LISTENER Process got terminated ?

Re: /var 100% ,Oracle LISTENER went Down ?

Patrick Wallek — Tue, 23 Oct 2012 19:53:16 GMT

HP-UX has not PID files like Linux.

The best place to find errors for the listener would be in the listener.log file. Your DBAs should be able to find that.

Re: /var 100% ,Oracle LISTENER went Down ?

Dave Chamberlin — Tue, 23 Oct 2012 22:15:23 GMT

there is an oracle parameter setting called utl_file_dir that by default is /usr/tmp. This directory is often pointed to /var/tmp as a symbolic link. There are a number of possible oracle processes that may require space on on /var to function. The bigger question is why did /var become full? Are you running the oracle E-Business suite on this box?

Re: /var 100% ,Oracle LISTENER went Down ?

donna hofmeister — Tue, 23 Oct 2012 22:23:44 GMT

the even bigger question is -- why does it appear that nothing is monitoring your file system fullness?

Re: /var 100% ,Oracle LISTENER went Down ?

Bill Hassell — Wed, 24 Oct 2012 01:21:39 GMT

/var (and the root filesystem /) are the two most critical filesystems in HP-UX. A *LOT* of processes went down when /var filled up, not just Oracle. The system administrator cannot allow /var to fill up and as mentioned, it sounds like you have nothing to monitor critical filesystem space. If you look at the syslog.log file, you'll probably see a lot of other errors caused by /var filling up.