ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-12526, TNS:listener: all appropriate instances are in restricted mode

ORA-12526, TNS:listener: all appropriate instances are in restricted mode

原创 Linux操作系统 作者:frog-qs 时间:2012-03-01 10:47:21 0 删除 编辑
在启动应用程序的时候提示ora-12526错误
 
2012-02-29 04:37:25,366 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Listener refused the connection with the following error:
ORA-12526, TNS:listener: all appropriate instances are in restricted mode
The Connection descriptor used by the client was:
192.168.12.229:1521:orcl
2012-02-29 04:37:25,369 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Listener refused the connection with the following error:
ORA-12526, TNS:listener: all appropriate instances are in restricted mode
The Connection descriptor used by the client was:
192.168.12.229:1521:orcl
2012-02-29 04:37:25,369 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Listener refused the connection with the following error:
ORA-12526, TNS:listener: all appropriate instances are in restricted mode
The Connection descriptor used by the client was:
192.168.12.229:1521:orcl
oracle@linux-y2ty:~> oerr ora 12526
12526, 00000, "TNS:listener: all appropriate instances are in restricted mode"
// *Cause:  Database instances supporting the service requested by the client
// were in restricted mode. The Listener does not allow connections to
// instances in restricted mode. This condition may be temporary, such as
// during periods when database administration is performed.
// *Action: Attempt the connection again. If error persists, then contact
// the database administrator to change the mode of the instance,
// if appropriate.
数据库处于受限模式,禁止了先。(属于测试部门的数据库,不知道是谁改为该模式)
SQL> alter system disable restricted session;
System altered.
重新启动应用,正常连接。

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

下一篇: substr,instr使用
请登录后发表评论 登录
全部评论

注册时间:2009-10-27

  • 博文量
    132
  • 访问量
    241238