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