监听进程无故终止

显示全部楼层 · 2019-4-13 23:36:38

我这里有一套数据库，操作系统aix 5.2.0.7，数据库版本9.2.0.6
运行几天后，就会报错退出
监听的log
TNS-12560: TNS

rotocol adapter error
TNS-00530: Protocol adapter error
IBM/AIX RISC System/6000 Error: 69: Network is down
但是根据主机和网络的检查，网络和网卡没有任何问题和告警，不知道是什么原因？
监听配置
# LISTENER.ORA.XJYDSC1_HOST1_2 Network Configuration File: /oracle/products/920/network/admin/listener.ora.xjydsc1_host1_2
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 222.248.2.100)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/products/920)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = sc10.gsm.zte.cn)
(SID_NAME = sc10)
(ORACLE_HOME = /oracle/products/920)
)
)
sqlnet的配置
$ more sqlnet.ora
# SQLNET.ORA.XJYDSC1_HOST1_1 Network Configuration File: /oracle/products/920/network/admin/sqlnet.ora.xjydsc1_host1_1
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME=1
请各位帮助

千问 · 2019-4-13 23:36:38

系统日志??

千问 · 2019-4-13 23:36:38

最初由 kso 发布
[B]系统日志?? [/B]
数据库日志正常
操作系统有
errpt |more
B6048838 0119031107 P S SYSPROCSOFTWARE PROGRAM ABNORMALLY TERMINATED
B6048838 0119031107 P S SYSPROCSOFTWARE PROGRAM ABNORMALLY TERMINATED
B6048838 0119030907 P S SYSPROCSOFTWARE PROGRAM ABNORMALLY TERMINATED
B6048838 0119030907 P S SYSPROCSOFTWARE PROGRAM ABNORMALLY TERMINATED
errpt -aj B6048838
errpt -aj B6048838
---------------------------------------------------------------------------
LABEL:
CORE_DUMP
IDENTIFIER: B6048838
Date/Time: Fri Jan 19 03:11:38 BEIS
Sequence Number: 10238
Machine Id:0056ECDD4C00
Node Id: xjydsc1_host1_1
Class: S
Type:
PERM
Resource Name: SYSPROC
Description
SOFTWARE PROGRAM ABNORMALLY TERMINATED
Probable Causes
SOFTWARE PROGRAM
User Causes
USER GENERATED SIGNAL
Recommended Actions
CORRECT THEN RETRY
Failure Causes
SOFTWARE PROGRAM
Recommended Actions
RERUN THE APPLICATION PROGRAM
IF PROBLEM PERSISTS THEN DO THE FOLLOWING
CONTACT APPROPRIATE SERVICE REPRESENTATIVE
Detail Data
SIGNAL NUMBER

11
USER'S PROCESS ID:
41038
FILE SYSTEM SERIAL NUMBER
8
INODE NUMBER
2054
PROCESSOR ID
1
CORE FILE NAME
/home/oracle/core
PROGRAM NAME
sid2.bin
ADDITIONAL INFORMATION
doPreCk CC
doPreCk B8
swecAuthe 58
authentic 84
main 14C

千问 · 2019-4-13 23:36:38

自己顶一下

千问 · 2019-4-13 23:36:38

帮顶！

千问 · 2019-4-13 23:36:38

路过