mercredi 18 juillet 2012

Résoudre : ORA-12520: TNS:listener could not find available handler for requested type of server

En faisant mon backup oracle j'ai l'erreur : 
Export: Release 11.2.0.2.0 - Production on Thu Mar 22 11:49:56 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. 
EXP-00056: ORACLE error 12520 encountered 
ORA-12520: TNS:listener could not find available handler for requested type of server 
EXP-00000: Export terminated unsuccessfully


Pour rechercher l'erreur, je regarde le statut de mon listener : 
-bash-4.2$ lsnrctl services 
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 22-MAR-2012 11:50:54 Copyright (c) 1991, 2011, Oracle.  All rights reserved. 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Service "XE" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:13414 refused:0 state:blocked LOCAL SERVER Service "XEXDB" has 1 instance(s). Instance "XE", status READY, has 1 handler(s) for this service... Handler(s): "D000" established:100 refused:0 current:0 max:1022 state:ready DISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxxxxxt.local)(PORT=54291)) 
The command completed successfully 
-bash-4.2$


On voit le statut blocked. 
La première chose à faire est de verifier qu'on arrive à se connecter en SQL Plus. 
Pour ma part, j'ai eu un problème de nombre max de connexion sur la base de données. 


Visiblement une autre possibilité est developpé dans cet article : http://blog.abigold.fr/joomla/index.php?option=com_content&view=article&id=285:ora-12520shutdownmtsmultithread&catid=66:oracle-securite&Itemid=53