数据库遇到如下错误：SQL> startup mountORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-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 = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = HRES) ) )
LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
转载于:https://www.cnblogs.com/zhaocundang/p/7777837.html
