各位大神,我的oracle为oracle92,服务器每个三五天就会出现这个问题,每次出现必须重启服务器才行,服务器为windows server 2003,装了个虚拟机,web程序部署在tomcat上,现在程序还没正式上线没几个人用,为什么会出现这个问题,贴出日志来04-12月-2011 05:02:29 * service_update * oradb * 0
04-12月-2011 05:02:42 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3360)) * establish * oradb * 0
04-12月-2011 05:02:57 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3373)) * establish * oradb * 0
04-12月-2011 05:02:57 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3374)) * establish * oradb * 0
04-12月-2011 05:03:05 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3385)) * establish * oradb * 0
04-12月-2011 05:03:05 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3386)) * establish * oradb * 0
04-12月-2011 05:03:20 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3402)) * establish * oradb * 0
04-12月-2011 05:03:27 * http * handoff * 0
不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dzy-900df5284d1)(PORT=2100))(Presentation=FTP)(Session=RAW))
不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dzy-900df5284d1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
04-12月-2011 05:03:27 * service_died * oradb * 12547
TNS-12547: TNS:丢失连接
04-12月-2011 05:03:35 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3415)) * establish * oradb * 12500
TNS-12500: TNS:监听器未能启动专用的服务器进程
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
32-bit Windows Error: 2: No such file or directory
04-12月-2011 05:03:35 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3416)) * establish * oradb * 12500
TNS-12500: TNS:监听器未能启动专用的服务器进程
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
32-bit Windows Error: 2: No such file or directory
04-12月-2011 05:03:36 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3417)) * establish * oradb * 12500
TNS-12500: TNS:监听器未能启动专用的服务器进程
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
04-12月-2011 05:02:42 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3360)) * establish * oradb * 0
04-12月-2011 05:02:57 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3373)) * establish * oradb * 0
04-12月-2011 05:02:57 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3374)) * establish * oradb * 0
04-12月-2011 05:03:05 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3385)) * establish * oradb * 0
04-12月-2011 05:03:05 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3386)) * establish * oradb * 0
04-12月-2011 05:03:20 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3402)) * establish * oradb * 0
04-12月-2011 05:03:27 * http * handoff * 0
不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dzy-900df5284d1)(PORT=2100))(Presentation=FTP)(Session=RAW))
不再监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dzy-900df5284d1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
04-12月-2011 05:03:27 * service_died * oradb * 12547
TNS-12547: TNS:丢失连接
04-12月-2011 05:03:35 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3415)) * establish * oradb * 12500
TNS-12500: TNS:监听器未能启动专用的服务器进程
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
32-bit Windows Error: 2: No such file or directory
04-12月-2011 05:03:35 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3416)) * establish * oradb * 12500
TNS-12500: TNS:监听器未能启动专用的服务器进程
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
32-bit Windows Error: 2: No such file or directory
04-12月-2011 05:03:36 * (CONNECT_DATA=(SID=oradb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.67.40.235)(PORT=3417)) * establish * oradb * 12500
TNS-12500: TNS:监听器未能启动专用的服务器进程
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
解决方案 »
- oracle 10g 批量解锁用户求指点
- 类似与WMSYS.WM_CONCAT函数的方法
- RMAN的configure问题
- windows2003双机热备切换后数据库无法OPEN
- 大家帮我看看自符长度的问题! 谢谢! 只剩10分了, 下次一定补上
- 一个workspace 能有多少个pc文件?
- 求子结点的相关信息
- 菜鸟一个存储过程。要METHOD_ID字段每插入一条记录便加1。大家帮忙修改
- 只用一条Sql语句能完成这样的功能吗?
- 继续问:oracle安装,烦死人了
- ORA-03113: 通信通道的文件结束
- oracle.oc4j.rmi.OracleRemoteException 这个异常是怎么回事,如何解决?
listener挂掉了?