Windows系统的数据库不能启动ORA-00119 ORA-00130

Windows系统的数据库不能启动ORA-00119 ORA-00130

启动数据库报错：
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address
'(ADDRESS=(PROTOCOL=TCP)(HOST=oms.ccrr.com)(PORT=1521))'

修改数据库的$ORACLE_HOME/network/admin/listener.ora文件。
把
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
      )
     (SID_DESC =
    (GLOBAL_DBNAME = ORCL)
    (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) 
    (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oms.ccrr.com)(PORT = 1521))
    )
  )

把上面的主机名（oms.ccrr.com）改成ip地址。

同时修改$ORACLE_HOME/network/admin/tnanames.ora文件
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oms.ccrr.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = oms.ccrr.com)(PORT = 1521))

把上面的2个主机名（oms.ccrr.com）改成ip地址。

在Windows的“管理工具”中的“服务”中重新启动“OracleServiceLiterner”监听器服务和“OracleServiceORCL”数据库服务。

再次启动数据库则可正常。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12778571/viewspace-688780/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12778571/viewspace-688780/