tnsnames.ora 없이 접속하는법

 

 

sqlplus gctrade/1234@//127.0.0.1:1521/XE

 

tnsnames.ora 를 활용하는 방법

sqlplus gctrade/1234@TRADINGDB

 

 

샘플 tnsnames.ora

TRADINGDB =
  (DESCRIPTION =
    (ADDRESS =
      (PROTOCOL = TCP)
      (HOST = 127.0.0.1)
      (PORT = 1521)
    )
    (CONNECT_DATA =
      (SERVER = dedicated)
      (SERVICE_NAME = XE)
    )
  )