ORA-12537: TNS:connection closed 에러관련 문의 0 1 10,790

by 이런잭쓴 [DB 기타] [2014.12.01 15:29:04]


안녕하세요 다름이 아니라 ~ Virtual box를 이용하여 인터넷메뉴얼보고 RAC를 설치하여보았는데요 .

위와같은 에러가 발생이 되는데 원인이 뭔지 아시는분 있으신가요 ?

tnsping으로는 정상적으로 접속이 되는것 같으나.

oracle@rac1.localdomain:/ssw/oracle/product/11.2.0.1/network/admin> tnsping RAC1

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 01-DEC-2014 15:25:39

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/ssw/oracle/product/11.2.0.1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.51)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC)))
OK (0 msec)
oracle@rac1.localdomain:/ssw/oracle/product/11.2.0.1/network/admin>

 

아래와 같이 접속을 TNS식별자를 통해 할려고 하면 에러가 발생하네요 ..

oracle@rac1.localdomain:/ssw/oracle/product/11.2.0.1/network/admin> sqlplus TEST/TEST@RAC1

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 1 15:26:31 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:
ORA-12537: TNS:connection closed

원인이 무엇일까요 ...

# tnsnames.ora Network Configuration File: /ssw/oracle/product/11.2.0.1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

RAC =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RAC)
    )
  )

RAC1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.51)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RAC)
    )
  )

by DJ [2014.12.01 16:24:22]

$ ls -l $RDBMS_HOME/bin/oracle 

결과 확인해 보시고 permission deined 가 나오며 아래와 관련된 내용으로 판단되네요.

ORA-12537 / ORA-12547 or TNS-12518 if Listener (including SCAN Listener) and Database are Owned by Different OS User (Doc ID 1069517.1)

1. In environments where the listener is not run in the same ORACLE_HOME where the database resides, the listener owner (including SCAN listener) may not be able to access the oracle binary in the database home.  This is common in RAC or whenever a GRID_HOME and a database ORACLE_HOME are installed.

As listener owner:

$ ls -l $RDBMS_HOME/bin/oracle
ls: /home/oracle/app/oracle/product/11.2/db/bin/oracle: Permission denied

2. Oracle binary in database home has wrong permission:

ls -l $RDBMS_HOME/bin/oracle
-rwxr-x--x 1 oracle asmadmin 184286251 Aug  9 16:25 /home/oracle/app/oracle/product/11.2/db/bin/oracle


The permission "-rwxr-x--x" is wrong as it's missing suid bit, oracle binary should have permission of 6751:

-rwsr-s--x 1 oracle asmadmin 184286251 Aug  9 16:25 /home/oracle/app/oracle/product/11.2/db/bin/oracle


Note: If Job Role Separation is in place, the group will be <asmadmin>, otherwise it will be <oinstall>

3. File System for database home does not support setuid/suid or has nosetuid/nosuid set:
 

mount| grep <mount_point_of_ORACLE_HOME>
/home/oracle on /dev/dsk/diskoracle read/write/nosuid..

 

4. Another cause may be permissions on the RDBMS Directory structure or Home directory which needs to be accessed by the CRS user.
Check that the RDBMS $ORACLE_HOME is set to 755.
This can be seen from an OS trace such as strace or truss when using it to trace the CRS user running the "oracle" executable which fails with the "Permission denied" error.

 

댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입