新安装的sunha4数据库遭遇 这俩错误,系统不停的core dump 分区都被沾满了
Mon Dec 20 10:03:26 2010
dispatcher 'D000' encountered error getting listening address
Mon Dec 20 10:03:26 2010
Errors in file /oracle/product/10.2.0/admin/sunha4/bdump/sunha4_ora_3650.trc:
ORA-07445: exception encountered: core dump [kslgetl()+148] [SIGSEGV] [Address not mapped to object] [0x000000208] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
dispatcher 的状态。
SYS AS SYSDBA at sunha4 > select * from v$dispatcher ;
NAME
----
NETWORK
--------------------------------------------------------------------------------
PADDR STATUS ACC MESSAGES BYTES BREAKS
---------------- ---------------- --- ---------- ---------- ----------
OWNED CREATED IDLE BUSY LISTENER CONF_INDX
---------- ---------- ---------- ---------- ---------- ----------
D000
(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))
000000040E002800 REFUSE NO 0 0 0
0 0 0 0 0 0
状态有问题哦,
我们看看正常库的是什么样子的
SYS AS SYSDBA at sunha4 > select * from v$dispatcher ;
NAME
----
NETWORK
--------------------------------------------------------------------------------
PADDR STATUS ACC MESSAGES BYTES BREAKS
---------------- ---------------- --- ---------- ---------- ----------
OWNED CREATED IDLE BUSY LISTENER CONF_INDX
---------- ---------- ---------- ---------- ---------- ----------
D000
(ADDRESS=(PROTOCOL=tcp)(HOST=sunha4.pconline.ctc)(PORT=45632))
00000003CF002FE8 WAIT YES 0 0 0
0 0 4845 0 0 0
SYS AS SYSDBA at sunha4 >
明显的问题库的主机名出故障了
经过检查,发现 /etc/hosts 里主机名与 hostname 输出的主机名不一致。
etc/hosts 配置为sunha4.pconline.ctc
hostname 输出为 sunha4.pconline.com.ctc
修改/etc/hosts后要重启,或者 用hostname命令设定主机名
然后重新开个窗口,oracle 用户从新登陆主机,重新启动oracle 问题解决。