# tnsnames.ora Network Configuration File: E:appJackieKimproduct11.2.0dbhome_1NETWORKADMIN nsnames.ora
# Generated by Oracle configuration tools.

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

INNO =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVICE_NAME = inno)
)
  )

DINGQF =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVICE_NAME = dingqf.ora11)
)
  )

JINSF =
  (DESCRIPTION =
(ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.206)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVICE_NAME = jinsf.ora11)
)
  无法修改jinsf，192.168.1.206的IP地址。
修改后提示拒绝访问。
解决方式很简单，剪切tnsnames.ora 到桌面，修改为192.168.1.106完成后保存，再拷贝回原来的文件夹。大功告成。

ITPub博客

解决 Oracle 修改tnsnames.ora显示无法修改