Today at noon will be nearly a few points when suddenly received SMS warning prompt, the company's software for a long time without a single production. The first reaction was that the company's software was hung up, so it was immediately viewed. After restarting all the software found that actually did not return to normal, has been prompted:
com.gs.db.DBException:java.sql.SQLException:Io Exception : the Network Adapt
ER could not establish the connection.
Thought it was the database stopped, died plsql logged in, and found that Plsql entered the user name password is not responding.
Is the monitor dead? To the database server native login try, holding this idea went to the database server, using sqlplus to log in, found that sqlplus actually also log on.
Oh, I went to the evil. Will it be too much to connect the software to the dead, try to stop listening has disconnected all connections, the result is a long time no response. To see the memory usage and CPU usage finally found the problem.
Memory fortunately did not see anything special place, but the CPU is not normal, occupancy rate incredibly is 100%.
because the database could not be logged on, it was not possible to restart the database software in the usual way, so we had to choose to restart the database server. Restart after the normal use, but heart still brooding want to find non-responsive and CPU occupancy rate 100% reason, through the Internet to find information, finally found that this is an Oracle Bug . The Oracle version is 10.2.0.1. As long as the Linux x86 host running days is a multiple of 24.8 it is possible to raise the bug (just a good system is running for 198 days), because the time () function value is null, causing an infinite loop, thus exhausting the CPU, my server just has this problem.
The solution to this Oracle bug is as follows:
Three types of solutions:
1) Restart the host;
2) hit patch set, such as upgrade to 10.2.0.4;
3) make temporary patch 4612267 for the bug alone.
The first kind of palliative, temporary use can, but not fundamentally solve the problem, the second fundamentally solve the problem, but need to reinstall the database, time-consuming and laborious, the third is the most convenient, but need to stop the business installation patches, and there is no kind of free to give you the patch or the matter. I was lucky to find the Oracle corresponding patch, fortunately the cost of downloading is not very high, or to cry to death.
After getting the patch, follow the instructions in the manual and the online tutorial to summarize the following installation steps:
Stop all database services, typically these three kinds of
1. Stop listening:lsnrctl stop
2. Stop dbconsole:emctl stop Dbconsole(if you install it, stop it, do not install it)
3. Stop database:shutdown immediate
Log in to the Linux system using the root user, create a folder to store the patch files, such as patches. After the setup is complete, upload the patches.
Then unzip:
You will see a 4612267 directory after decompression and do not install it directly at this time.
After switching to the Oracle user and entering this directory, you will see a file of two folders.
Where the folder is the specific upgrade file, the txt is a description file, you can not control it. Under this directory, execute the patch apply command to begin installing patches:
After successful execution, the following information is prompted:
At this point he will ask whether or not ready to patch, here we choose y, enter after the return to see the installation process.
By the time the patch is installed, we need to verify that the patch was installed successfully. Use the opatch lsinventory command to see if the patch was successfully installed:
Seeing the patch number indicates that we have successfully installed it.
If one day we don't need this for some reason, we can unload it.
Enter the directory where the patch is located and execute the following command:
$ORACLE _home/opatch/opatch Rollback-id 461226
And then all the way to y on the line.
The environment covered in this article is as follows:
Linux
Linux hljtnitsdb 2.6.18-128.el5pae #1 SMP Wed Dec 12:02:33 EST. i686 Athlon i386 Gnu/linux
Oracle
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Oracle Patches:
http://download.csdn.net/detail/wxlbrxhb/8567587
Oracle Login unresponsive Problem resolution (oracle4612267 patch installation tutorial)