Oracle ORA-12541,ORA-12514错误

5：第三个文件：

# tnsnames.ora Network Configuration File: E:\app\username\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

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

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


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

6.这样改完仍没用，报ora-12514

后来又百度发现重启oracle服务器，无奈，重启了一下电脑，恢复正常了。

7.小结：后来回想，主要是局域网内IP地址动态分配的，虽然我给了服务器固定ip，但昨天由于回来迟了，室友先开了机，恰巧又分配了服务器的ip地址

导致我的配置失效。记得以前也出现过一次，可惜没长记性，所以还是写点简单的记录吧。

Oracle ORA-12541,ORA-12514错误

标签：固定   重启   rod   效果   安装   clr   global   user   file