最近数据库监听服务经常自动停止,重启服务后又好了。
查看数据库的alert文件发现发生了好多如下错误:
Tue Jan 29 15:43:02 2013
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
Tue Jan 29 15:44:42 2013
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn
查看监听日志文件出现如下错误:
TNS-12500: TNS:监听器未能启动专用的服务器进程
TNS-12560: TNS: 协议适配器错误
TNS-00530: 协议适配器错误
32-bit Windows Error: 233: Unknown error
操作系统是32位WINDOWS2003,内存4G 数据库是: 9.2.0.6.0
请教高手:分析一下问题出现那里?如何修复