ORA-12528: TNS:listener: all appropriate instances are blocking new connections

今天在测试中碰到这个错误

数据库版本是10.2.0.1，平台是rhel5

sid为xe

xe库是从其他数据库上通过rman迁移过来的。

配置了监听，启动监听

Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status BLOCKED, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

竟然出现的是blocked??

通过客户端去连接，爆出的是ORA-12528: TNS:listener: all appropriate instances are blocking new connections

从整体上来看我的数据库监听，服务都已经启动，并且在数据库的启动中也没有报错。

查看bdump下的alert_xe.log发现

Tue Jun  7 16:54:10 2011
starting up 1 shared server(s) ...
Tue Jun  7 16:54:13 2011
ALTER DATABASE   MOUNT
Tue Jun  7 16:54:13 2011
ORA-00202: control file: '/u02/xe/control01.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Tue Jun  7 16:54:16 2011
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Tue Jun  7 17:13:15 2011

没有这些文件

突然想起原来当时因为做测试的时候磁盘不够，又添加了一块磁盘，但是没有在启动的时候就mount上，

mount上之后，数据库就启动正常了。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24212278/viewspace-697255/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24212278/viewspace-697255/