tnsnames.ora

C:\ > sqlplus [username]/[passowrd]@[IP Addr]:[Port Number]/[Service Name]

tnsnames.ora利用の場合

C:\ > sqlplus [username]/[passowrd]@[net_service_name]

C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
net_service_name = 

(DESCRIPTION =  

      (ADDRESS_LIST = 

        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.xx.xxx )(PORT = 1521))

     ) 

  (CONNECT_DATA = (SERVICE_NAME = service_name.world ) )

 )

net_service_name =

(DESCRIPTION =
(ADDRESS_LIST =
(FAILOVER = ON
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sevice_name.world)
)
)