Oracle监听不定期出现异常故障处理(二)

2014-11-24 17:19:05 · 作者: · 浏览: 1
16:02:26 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=racdb)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))(CID=(PROGRAM=sqlplus@racdb1)(HOST=racdb1)(USER=tmn))) * (ADDRESS=(PROTOCOL=tcp)(HOST=11.111.11.89)(PORT=41669)) * establish * racdb * 0
17-FEB-2014 16:02:26 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=racdb)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))(CID=(PROGRAM=sqlplus@racdb1)(HOST=racdb1)(USER=tmn))) * (ADDRESS=(PROTOCOL=tcp)(HOST=11.111.11.89)(PORT=41682)) * establish * racdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Solaris Error: 24: Too many open files <<<<<<<<<<


Too many open files意味着Maximum Number Of Open Files Per Process 达到了上限。因此listener hang住的原因可能是该limit设置过小,进一步查看硬件限制如下:



$ ulimit -Ha
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 65536
memory(kbytes) unlimited


查看软件限制如下:



$ ulimit -Sa
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 256
memory(kbytes) unlimited


查看/etc/system如下:



*ident "@(#)system 1.18 97/06/27 SMI" /* SVR4 1.5 */


*


* SYSTEM SPECIFICATION FILE


*




* moddir:


*


* Set the search path for modules. This has a format similar to the


* csh path variable. If the module isn't found in the first directory


* it tries the second and so on. The default is /kernel /usr/kernel


*


* Example:


* moddir: /kernel /usr/kernel /other/modules







* root device and root filesystem configuration:


*


* The following may be used to override the defaults provided by


* the boot program:


*


* rootfs: Set the filesystem type of the root.


*


* rootdev: Set the root device. This should be a fully


* expanded physical pathname. The default is the


* physical pathname of the device where the boot


* program resides. The physical pathname is


* highly platform and configuration dependent.


*


* Example:


* rootfs:ufs


* rootdev:/sbus@1,f8000000/esp@0,800000/sd@3,0:a


*


* (Swap device configuration should be specified in /etc/vfstab.)







* exclude:


*


* Modules appearing in the moddir path which are NOT to be loaded,


* even if referenced. Note that `exclude' accepts either a module name,


* or a filename which includes the directory.


*


* Examples:


* exclude: win


* exclude: sys/shmsys







* forceload:


*


* Cause these modules to be loaded at boot time, (just before mounting


* the root filesystem) rather than at first reference. Note that


* forceload expects a filename which includes the directory. Also


* note that loading a module does not necessarily imply that it will


* be installed.


*


* Example:


* forceload: drv/foo







* set:


*


* Set an integer variable in the kernel or a module to a new value.


* This facility should be used with caution. See system(4).


*


* Examples:


*


* To set variables in 'unix':


*


* set nautopush=32


* set maxusers=40


*


* To set a variable named 'debug' in the module named 'test_module'


*


* set test_module:debug = 0x13




* Begin FJSVssf (do not edit)


set ftrace_atboot = 1


set kmem_flags = 0x100


set kmem_lite_maxalign = 8192


* End FJSVssf (do not edit)


force