System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

/var 100% ,Oracle LISTENER went Down ?

redhat7012
Advisor

/var 100% ,Oracle LISTENER went Down ?

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.

 

 

7 REPLIES
Patrick Wallek
Honored Contributor

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

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.

redhat7012
Advisor

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

error the DBA team faced :

 

TNS-12502 TNS:listener received no CONNECT_DATA from client 

 

redhat7012
Advisor

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

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 ?

 

 

Patrick Wallek
Honored Contributor

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

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.

Dave Chamberlin
Trusted Contributor

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

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?

donna hofmeister
Trusted Contributor

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

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

Bill Hassell
Honored Contributor

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

/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.



Bill Hassell, sysadmin