Background:

The database has been running very well, but today there is a fatal blow. When the company’s application program is about 10:30, all the sites can’t be accessed, and the page only prompts that the site can’t be found. At first, I thought there was a problem with the network or VIP. After checking for a long time, I didn’t get any message. Then I went to Weblogic and found that the pool status of the connection with the database is invalid, Check Oracle 10g DB immediately

questions :

First, check whether the monitor program of DB works normally

  
  
  
  
  
  
  
 
  
 
  
 
   
   
lsnrctlstatus
 
 
 
 
 

 

 

  
  

Directly stuck, if the database crash, it is the tragedy of the tragedy! After checking the database, it runs normally. If you check alter.log, you will only be prompted with false_ Client, indecisive, I used kill

  
  
  
  
  
  
  
 
  
 
  
 
   
   
ps-ef|grepLISTENER
  
  
  
  
  
 
  
 
  
 
   
   
oracle254781006:47?00:00:00/home/oracle/OraBase/OraHome1/bin/tnslsnrLISTENER-inherit
  
  
  
  
  
 
  
 
  
 
   
   
root2593225786008:40pts/100:00:00grepLISTENER
  
  
  
  
  
 
  
 
  
 
   
   
kil-925478
 
 
 
 
 

 

 

  
  

Restart monitoring report the following error:

lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 – Production on 06-JUL-2009 14:37:59
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /opt/oracle/product/9ir2/bin/tnslsnr: please wait…
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe

solution:

This is only with the help of Google. After searching on the Internet, we found that the reasons are as follows:

The operating system of the database server is red hat AS4, which is a 32-bit operating system. The maximum text file size cannot exceed 2G. When $Oracle_ When the size of listener.log in home/network/log is 2G, you cannot continue to write to the log. The listening service will stop automatically. When you start or stop the listener, you will report an error:

1. Often manually clear the content of listener.log file, execute the following command in the database server

  
  
  
  
  
  
  
 
  
 
  
 
   
   
cd$ORACLE_HOME/network/log
  
  
  
  
  
 
  
 
  
 
   
   
cat</dev/null>listener.log
 
 
 
 
 

 

 

  
  

2. Let the command lsnrctl not log, and execute the following command on the database server

  
  
  
  
  
  
  
 
  
 
  
 
   
   
lsnrctl
  
  
  
  
  
 
  
 
  
 
   
   
setlog_statusoff
  
  
  
  
  
 
  
 
  
 
   
   
quit
 
 
 
 
 

 

 

  
  

You can also add logging in the listener. Ora file_ Listener = off to close the listening log

When I run lsnrctl status hopefully to start monitoring, an error is reported:

Starting /home/oracle/OraBase/OraHome1/bin/tnslsnr: please wait…
/home/oracle/OraBase/OraHome1/bin/tnslsnr: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Err or: 32: Broken pipe

Can’t find the file, it must be that the path is not set right. At this time, I suddenly thought of the command I used to run with root, switched to Oracle user to run again, this time succeeded! Although the database is OK, the application still can’t work. At this time, restart Weblogic

I find that no experience can scare people to death in this business

This article comes from “take small steps, never stop!” Blog, please keep this source http://badboy6515.blog.51cto.com/1320302/628669