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.