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”資料庫服務。

再次啟動資料庫則可正常。