- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: /var 100% ,Oracle LISTENER went Down ?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2012 11:53 AM
10-23-2012 11:53 AM
/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.
- Tags:
- Oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2012 12:01 PM
10-23-2012 12:01 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2012 12:14 PM
10-23-2012 12:14 PM
Re: /var 100% ,Oracle LISTENER went Down ?
error the DBA team faced :
TNS-12502 TNS:listener received no CONNECT_DATA from client
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2012 12:18 PM
10-23-2012 12:18 PM
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2012 12:53 PM
10-23-2012 12:53 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2012 03:15 PM
10-23-2012 03:15 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2012 03:23 PM
10-23-2012 03:23 PM
Re: /var 100% ,Oracle LISTENER went Down ?
the even bigger question is -- why does it appear that nothing is monitoring your file system fullness?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2012 06:21 PM
10-23-2012 06:21 PM
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