TNS-12545

• 코드
• TNS-12545
• 원인
• 12c에서 Tnsnames.ora 에도 해당 내용이 서술되어 있고 ping , ssh  등이 모두 작동하지만 tnsping 을 입력하면 접속이 되지 않을때 발생

• 
  
  $ vi /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora
  RCAT6 =
    (DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.6)(PORT = 1521))
  )
  (CONNECT_DATA =
    (SERVICE_NAME = backorcl)
  )
    )
• 해결
• 접속을 원하는 server의 방화벽을 비활성화 시킨다
  
  
  # systemctl stop firewalld
  # systemctl disable firewalld
• 참고 MOS 문서번호 & 기타
• 12545, 00000, "Connect failed because target host or object does not exist"
  // *Cause: The address specified is not valid, or the program being
  // connected to does not exist.
  // *Action: Ensure the ADDRESS parameters have been entered correctly; the
  // most likely incorrect parameter is the node name.  Ensure that the
  // executable for the server exists (perhaps "oracle" is missing.)
  // If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
  // host name to a numeric IP address and try again.

TNS-12543

• 코드
• TNS-12543
• 원인
• // *Cause: Contact can not be made with remote party.

• // *Action: Make sure the network driver is functioning and the network is up.
  PING SSH 모두 동작하고 LISTENR.ORA , tnsnames.ora 에 모두 등록되어있고 Listener  모두 동작중인데 tnsping 명령에서 동작하지않을 때 발생함
• 해결
• 주로 보안이슈와 관련되어있음
  1==/etc/hosts 파일에 ip , hostname으로 모두 등록되어 있는지 확인한다
  2==lsnrctl service 로 현제 Listener 의 상태를 점검한다
  3==/etc/selinux/config 파일에 selinux의 값을 disable로 변경한다
  
  
  # This file controls the state of SELinux on the system.
  # SELINUX= can take one of these three values:
  #     enforcing - SELinux security policy is enforced.
  #     permissive - SELinux prints warnings instead of enforcing.
  #     disabled - No SELinux policy is loaded.
  SELINUX=disabled
  # SELINUXTYPE= can take one of these two values:
  #     targeted - Targeted processes are protected,
  #     minimum - Modification of targeted policy. Only selected processes are protected.
  #     mls - Multi Level Security protection.
  SELINUXTYPE=targeted
  
  
  4==systemctl status firewalld 로 방화벽 상태를 점검하고 active 라면 비활성화 시킨다
  ---systemctl status firewalld -àsystemctl stop firewalld  à systemctl disable firewalld
  
  
  [root@localhost ~]# systemctl status firewalld
  â firewalld.service - firewalld - dynamic firewall daemon
     Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
     Active: active (running) since Mon 2017-05-22 04:23:33 EDT; 1h 1min ago
  [root@localhost ~]# systemctl stop firewalld
  Redirecting to /bin/systemctl stop  firewalld.service
  
  
  [root@localhost ~]# systemctl disable firewalld
  Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
  Removed symlink /etc/systemd/system/basic.target.wants/firewalld.service.
  
  
  [root@localhost ~]# systemctl status firewalld
  â firewalld.service - firewalld - dynamic firewall daemon
     Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
     Active: inactive (dead)
• 참고 MOS 문서번호 & 기타
• // *Cause: Contact can not be made with remote party.
  // *Action: Make sure the network driver is functioning and the network is up.

TNS-03505

• 코드
• TNS-03505
• 원인
• /etc/hosts 파일에 서버의 정보가 없을때 발생
• 해결
• Oerr 정보와 다르게 Listener 도 작동중이고 lsnrctl status 에서 instance 의 상태도 정상,tnsnames.ora 에도 정보가 들어있는 상태에서 tnsping 만 하면 해당 에러가 발생한다

• /etc/hosts 파일에 해당 정보가 들어있는지 꼭 확인한다
• 참고 MOS 문서번호 & 기타
• $ oerr tns 03505
  03505, 00000, "Failed to resolve name"
  // *Cause:  The service name you provided could not be found in TNSNAMES.ORA,
  //          an Oracle Names server, or a native naming service.
  // *Action: Verify that you entered the service name correctly.  You may need
  //          to ensure that the name was entered correctly into the network
  //          configuration.