dev, dev2 2개의 Database가 있다. 기존 dev라는 DB가 있는 상황에서 dev2를 생성했다. 이는 ORACLE_SID만 주의해서 생성하면 되므로 이에 대한 설명은 생략 리스너설정 [oracle@dev2 admin]$ cat listener.ora

LISTENER.ORA Configuration File:/u01/app/oracle/product/8.1.5/network/admin/listener.ora

Generated by Oracle Net8 Assistant

LISTENER =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = dev2.dbakorea.pe.kr)(PORT = 1521))     (PROTOCOL_STACK =       (PRESENTATION = TTC)       (SESSION = NS)     )   )

sid_list_listener= (sid_list=         (sid_desc=                 (global_dbname=dev.dbakorea.pe.kr)                 (sid_name=dev)                 (oracle_home=/u01/app/oracle/product/8.1.5)         )         (sid_desc=                 (global_dbname=dev2.dbakorea.pe.kr)                 (sid_name=dev2)                 (oracle_home=/u01/app/oracle/product/8.1.5)         ) )

클라이언트측 설정(동일 호스트라 크게 의미는 없다) [oracle@dev2 admin]$ cat tnsnames.ora

TNSNAMES.ORA Configuration File:/u01/app/oracle/product/8.1.5/network/admin/tnsnames.ora

Generated by Oracle Net8 Assistant

DEV =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = dev.dbakorea.pe.kr)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = dev.dbakorea.pe.kr)     )   )

DEV2 =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = dev2.dbakorea.pe.kr)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = dev2.dbakorea.pe.kr)     )   )

DEV2_MTS =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = dev2.dbakorea.pe.kr)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = dev2.dbakorea.pe.kr)       (SERVER=SHARED)     )   )