ORA-12526错误码

ORA-12526: TNS: 监听程序: 所有适用例程都处于受限模式

 

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.

 

解决方法：

ALTER SYSTEM DISABLE RESTRICTED SESSION;