SQL> shutdow immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-12528: TNS:listener: all appropriate instances are blocking new connections重启这个Oracle数据库的服务可以解决这个问题。
应程序原因 ,不想用这种方法。到网上也查了资料。自己也还是没有弄出来。在线等哦。请教高手虽然分不多
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-12528: TNS:listener: all appropriate instances are blocking new connections重启这个Oracle数据库的服务可以解决这个问题。
应程序原因 ,不想用这种方法。到网上也查了资料。自己也还是没有弄出来。在线等哦。请教高手虽然分不多
lsnrctl stop
lsnrctl start
分步启动
SQL>startup nomount
SQL>alter database mount;
SQL>alter database open;
[oracle@racnode1 ~]$ oerr ora 12528
12528, 00000, "TNS:listener: all appropriate instances are blocking new connections"
// *Cause: All instances supporting the service requested by the client
// reported that they were blocking the new connections. This condition may be
// temporary, such as at instance startup.
// *Action: Attempt the connection again. If error persists, then contact the
// administrator to check the status of the instances.看下log有具体的说发没, 这个情况是偶尔还是经常出现?
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977(满)
DBA3 群:62697850 DBA 超级群:63306533;
聊天 群:40132017
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
2.查看数据库状态
3.查找引起这些状态的原因
net start oracleserviceorcl