[오라클, SQL Developer] ORA-12516 Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack

아무리 접속해도 

상태: 실패 -테스트 실패: Listener refused the connection with the following error:

ORA-12516, TNS:listener could not find available handler with matching protocol stack

 

라고만 메세지 나올 경우에는

tnsnames.ora 에서

[SID] =

  (DESCRIPTION_LIST =

    (DESCRIPTION = 

      (ADDRESS = (PROTOCOL= TCP)(Host= 10.136.141.70)(Port= 1521))

      (CONNECT_DATA =(SERVICE_NAME = [SID]) (INSTANCE_NAME = [SID]) 

        (FAILOVER_MODE = 

         (BACKUP = [SID])(TYPE=SELECT)(METHOD=BASIC)))

    ) 

   )

HOST 영역의 도메인명을 IP로 바꿔주니 잘 접속된다!