가끔씩 설정할때마다 잊어버리곤해서 정리합니다. Linux- $ORACLE_HOME 과 $TNS_ADMIN 의 위치를 확인합니다.# echo $ORACLE_HOME/home/XXXX/oracle# echo $TNS_ADMIN/home/XXXX/oracle (보통은 $ORACLE_HOME/network/admin)# cd /home/XXXX/oracle# vi tnsnames.oradb200 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORA92) ) ) "db200" : o..