oracle的tnsname.ora（网络服务名配置文件）

# tnsnames.ora Network Configuration File: E:\oracle\oracleBaseMenu\oracleMainMenu\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

# sqlplus username/password@service_name 普通用户登录
# sqlplus username/password@service_name as sysdba 管理员用户登录
# eg: 在CMD命令窗口可以通过 sqlplus scott/tiger@hmy 登录
# HMY网络服务名
HMY = # HMY为网络服务名 
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
 #     (SERVER = DEDICATED)
 #     (SERVICE_NAME = hmy.cn) # 服务名方式配置
      (SID = hmy) # sid名方式配置
      (PRESENTATION = RO)
    )
  )
# 另一个网络服务名
ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = hmy)
      (PRESENTATION = RO)
    )
  )