인프런 커뮤니티 질문&답변
작성한 질문수
tnsnames.ora 접속관련
작성
·
739
0
아래와 같이 easy connect 방식으로 접속시 접속이 잘됩니다.
sqlplus system/welcome1@146.56.146.88:1521/ORCL
근데 강의 시 알려주셨던것 처럼 tnsnames.ora파일 내용 작성 후 아래와 같이 접속하려고하면 패스워드 입력하라고 나오고,
welcome1로 동일하게 패스워드 입력하면 접속이 안됩니다.
sqlplus system@ORCL
맥북 환경으로 oracle client 구성 하였습니다. 문제가 뭐일까요?
[tnsnames.ora 설정내용]
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 146.56.146.88) (PORT = 1521))
)
(CONNECT_DATE =
(SERVICE_NAME = ORCL)
)
)
dwkim@Donguks-MacBook-Pro ~/Desktop/study/oracle/oracle_client/instantclient_19_8 cat network/admin/tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 146.56.146.88) (PORT = 1521))
)
(CONNECT_DATE =
(SERVICE_NAME = ORCL)
)
)
dwkim@Donguks-MacBook-Pro ~/Desktop/study/oracle/oracle_client/instantclient_19_8 sqlplus system@ORCL
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 3 21:16:47 2022
Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Enter user-name: system
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name: system
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
✘ dwkim@Donguks-MacBook-Pro ~/Desktop/study/oracle/oracle_client/instantclient_19_8