通过文件配置Oracle网络服务，提示无法修改tnsname.ora文件解决办法

问题：在文件中配置网络服务 提示 “文件在别的地方打开”或者“没有权限修改”

解决办法：可以将该文件复制到桌面 用notepad++打开进行修改 切记备份

F:\app\haitao\product\11.2.0\dbhome_1\NETWORK\ADMIN \tnsname.ora这是我文件的路径

装在c盘路径有可能是：c:\app\administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN \tnsname.ora

文件分析：

若要在文件中配置网络服务只需复制一份修改红色部分

 THT =     /*THT自己去的本机服务名*/
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = haitao-pc)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tht)
    )
  )

HOST = haitao-pc  /*是主机名 若连接自己电脑，可以写自己的计算机名或者 localhost 或者127.0.0.1；连接的服务器：就写服务器的ip地址*/

SERVICE_NAME = tht /*是数据可得实例名字，必须启动对应的实例（OracleserverOrcl  这是安装数据库默认的）才能连接*/

ps:以下是文件的内容：

# tnsnames.ora Network Configuration File: f:\app\haitao\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

THT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = haitao-pc)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tht)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL_111 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.111)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )

113 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = haitao-pc)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )