Bonjour (UNIX et 9i)
Lors d'une connexion à distance sur une instance, les utilisateurs ont l'erreur suivante...
Pouvez-vous m'aider à comprendre ce message et me dire pourquoi ?TNS-12518 TNS:listener could not hand off client connection
Cause: The process of handing off a client connection to another process failed.
Action: Turn on listener tracing and re-execute the operation. Verify that the listener and database instance are properly configured for direct handoff. If the problem persists, contact Oracle Support Services.
Voici le status de mon listener :
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.4.0 - Production
Start Date 11-JUL-2006 12:40:24
Uptime 0 days 1 hr. 36 min. 31 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/app/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=spaxktp01)(PORT=1521)))
Services Summary...
Service "toto" has 1 instance(s).
Instance "toto", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
et mon listener.ora :
Merci d'avance !# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTOTO =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.001.002.003)(PORT = 4009))
)
)
)
SID_LIST_LISTOTO =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = toto)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = ktp)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = toto)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = toto)
)
)
Partager