[04.28] oracle

상태: 실패 -테스트 실패: IO 오류: The Network Adapter could not establish the connection
1. 리스너 문제 
cmd에서 tnspingin [ip]
오류인 경우 TNS-12541: TNS:no listener

이 경우는 listener.ora ,tnsnames.ora 체크
이 파일은 오라클 설치 경로(따로 지정 안해줬으면 c:\user\ 어딘가에 있음)


Used HOSTNAME adapter to resolve the alias
tnsnames.ora 에 없을 경우, host 를 참조해서 lookup

내 ip==ipv4


sid 는 instance 의 유일한 이름
server name  은 데이터베이스에 원격으로 접속할때 사용되는 tns alias 

****
방화벽 체크 안해줘서 생긴 문제였음

---

http://itpsolver.com/%EC%98%A4%EB%9D%BC%ED%81%B4-%EB%A6%AC%EC%8A%A4%EB%84%88%EC%9D%98-%EC%97%AD%ED%95%A0-%EB%B0%8F-%EA%B5%AC%EB%8F%99-listenerora-tnsnamesora-%ED%8C%8C%EC%9D%BC%EC%9D%98-%EC%97%AD%ED%95%A0/

https://gamjatada.tistory.com/238

https://hunit.tistory.com/211
https://jhnyang.tistory.com/272 

https://bae9086.tistory.com/289http://itpsolver.com/%EC%98%A4%EB%9D%BC%ED%81%B4-%EB%A6%AC%EC%8A%A4%EB%84%88%EC%9D%98-%EC%97%AD%ED%95%A0-%EB%B0%8F-%EA%B5%AC%EB%8F%99-listenerora-tnsnamesora-%ED%8C%8C%EC%9D%BC%EC%9D%98-%EC%97%AD%ED%95%A0/

https://m.blog.naver.com/PostView.naver?isHttpsRedirect=true&blogId=darkturtle&logNo=50116724993