ORA-12518, TNS : 리스너가 클라이언트 연결 오라클 11g를 전달할 수 없습니다.

다음 오류와 함께 Oracle 11G 데이터베이스에 연결을 시도하는 Eclipse에 JAVA 응용 프로그램이 있습니다.

Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection
The Connection descriptor used by the client was:
127.0.0.1:1521/XE

listener.ora 및 tnsnames.ora의 호스트 이름은 "LP-5CD9296CDZ"로되어 있지만 lsnrctl 상태는 호스트를 LP-5CD9296CDZ.XXX.CORP.XXX.IN으로 표시합니다.

C:\WINDOWS\system32>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 14-DEC-2019 18:20:51

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
Start Date                14-DEC-2019 17:52:45
Uptime                    0 days 0 hr. 28 min. 6 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File         C:\oraclexe\app\oracle\diag\tnslsnr\LP-5CD9296CDZ\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LP-5CD9296CDZ.XXX.CORP.XXX.IN)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LP-5CD9296CDZ.XXX.CORP.XXX.IN)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

내 JDBC 연결 URL은 다음과 같습니다. jdbc:oracle:thin:@LP-5CD9296CDZ:1521/XESQL Plus에서 conn 시스템을 사용하여 데이터베이스에 연결할 수 있지만 JBOSS7.1 서버를 통해 배포 된 응용 프로그램을 통해서는 연결할 수 없습니다.

Listener.ora는 다음과 같습니다.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

DEFAULT_SERVICE_LISTENER = (XE)

tnsnames.ora is as follows:
XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ORACLR_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
    ) 
    (CONNECT_DATA = 
      (SID = CLRExtProc) 
      (PRESENTATION = RO) 
    ) 
  ) 

결과 :

   SQL>select * from v$resource_limit;

    RESOURCE_NAME CURRENT_UTIL MAX_UTIL  INITIAL_ALLOCAT  LIMIT_VALUE
    -----------------------------------------------------------------
    processes         32        100         100                100

    sessions          33        101         176                176

    enqueue_locks     16        90          2180              2180

    enqueue_resources 15        15           992              UNLIMITED

    ges_procs         0         0            0                 0

    ges_ress          0         0            0                 UNLIMITED

    ges_locks         0         0            0                 UNLIMITED

    ges_cache_ress    0         0            0                 UNLIMITED

    ges_reg_msgs      0         0            0                 UNLIMITED

    ges_big_msgs      0         0            0                 UNLIMITED

    ges_rsv_msgs      0         0            0                 0

    gcs_resources     0         0            0                 0

    gcs_shadows       0         0            0                 0

    dml_locks         0         0           772                UNLIMITED

temporary_table_locks 0         0       UNLIMITED              UNLIMITED

    transactions      0         0           193                UNLIMITED

    branches          0         0           193                UNLIMITED

    cmtcallbk         0         1           193                UNLIMITED

max_rollback_segments 11        11          193                65535

    sort_segment_locks 0        4        UNLIMITED             UNLIMITED

    k2q_locks          0        0           352                UNLIMITED

    max_shared_servers 4        4        UNLIMITED             UNLIMITED

    parallel_max_serve 0        0             0                3600


    23 rows selected.