ORA-12519 错误解决

客户端连接间歇性失败，报错ORA-12519

OERR: ORA-12519 TNS:no appropriate service handler found

[@more@]

Error: ORA-12519 / TNS-12519
Text: TNS:no appropriate service handler found
---------------------------------------------------------------------------
Cause: the listener could not find any available service handlers that are
appropriate for the client connection.
Action: run "lsnrctl services" to ensure that the instance(s) have registered
with the listener, and are accepting connections. 检查lsnrctl service ，instance已经注册，状态显示ready时，可以连接。

When the listener believes the current number of connections has reached maximum load, it may set the state of the service handler for an instance to "blocked" and begin refusing incoming client connections with either of the following errors: ora-12519 or ora-12516

采用服务动态注册的方式，由PMON 通过SERVICE_UPDATE 来得到目前连接情况，但SERVICE_UPDATE 有时间间隔，所以，listener显示的连接数和当前实际的连接数可能不同。

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

转载于:http://blog.itpub.net/87149/viewspace-972507/