问题现象:数据库远程无法连接,本地连接同样报错:ORA-12547: TNS:lost contact
临时解决办法:重启监听,数据库连接恢复正常
查看alert log日志发现如下错误:
Wed May 06 12:27:37 2015
Process W000 died, see its trace file
Wed May 06 12:29:29 2015
Process W000 died, see its trace file
Wed May 06 12:29:29 2015
网上查找,推测是process设置不合理导致,查看process使用情况,发现并未达到上限
SQL> select * from V$RESOURCE_LIMIT;
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- ---------------------------------------- -
processes 222 816 1000 1000
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- ---------------------------------------- -
processes 222 816 1000 1000
查看系统内存使用情况,并无异常
[oracle@db1 trace]$ free -m
total used free shared buffers cached
Mem: 32200 31609 590 0 216 27234
-/+ buffers/cache: 4159 28041
Swap: 15999 149 15850
total used free shared buffers cached
Mem: 32200 31609 590 0 216 27234
-/+ buffers/cache: 4159 28041
Swap: 15999 149 15850
数据库采用自动内存管理,同样未发现异常
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 14592M
memory_target big integer 14592M
shared_memory_address integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 14592M
memory_target big integer 14592M
shared_memory_address integer 0
最后感觉可能还是因为process值设置的过小,调整到1200并继续观察
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28719055/viewspace-1625768/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28719055/viewspace-1625768/