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
