IT/DATABASE
oracle 설치 후 리스너가 안뜰때
김보야
2020. 6. 19. 10:28
cmd> lsnrctl status
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=User)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
64-bit Windows Error: 1004: Unknown error
HOST의 localhost를 127.0.0.1로 변경
%ORACLE_HOME%\NETWORK\ADMIN\listener.ora
%ORACLE_HOME%\NETWORK\ADMIN\tnsnames.ora
관리자권한으로 cmd 실행 > lsnrctl start
또는
실행(windows key + R) > services.msc > Oracle * Listener 시작
cmd> lsnrctl status > 정상 확인