ORA-00119: invalid specification for system parameter LOCAL_LISTENER

資料庫遇到如下錯誤：

SQL> startup mount

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'HRES'

//來源：http://www.cnblogs.com/xiaobo-Linux/p/7777837.html

檢查C:\app\xiaobo\product\11.2.0\dbhome_1\NETWORK\ADMIN\中的network name，發現沒有HRES的監聽名

修改tnsnames.ora檔案中的監聽名name修改為hres，重新開機解決。

# tnsnames.ora Network Configuration File: C:\app\xiaobo\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_HRES =

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

HRES =

(DESCRIPTION =

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = HRES)

)

LISTENER_ORCL =

ORCL =

(SERVICE_NAME = orcl)