Oracle tnsname.ora 파일 설정
위치할 곳 : C:\oracle\ora92\network\ADMIN\tnsname.ora
구분명 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 아이피)(PORT = 포트))
)
(CONNECT_DATA =
(SID = "sid")
)
)
ex)
DevOra =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 215.121.141.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORA07)
)
)