ORA-00119: invalid specification for system parameter LOCAL_LISTENER

简介: 数据库遇到如下错误:SQL> startup mountORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name 'HRES' //来源:http://www.

数据库遇到如下错误:
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 =
(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)
)
)

 

目录
相关文章
|
7月前
|
SQL Oracle 关系型数据库
Oracle数据库启动时:ORA-00119: invalid specification for system parameter LOCAL_LISTENER;
Oracle数据库启动时:ORA-00119: invalid specification for system parameter LOCAL_LISTENER;
|
7月前
|
SQL Oracle 关系型数据库
【已解决】ORA-01722: invalid number
【已解决】ORA-01722: invalid number
243 0
|
SQL Oracle 关系型数据库
ORA-01722:invalid number
Oracle表字段为`VARCHAR2`时,where条件出现`NUMBER`的匹配,`可能`会出现该错误。
342 0
ORA-01722:invalid number
|
关系型数据库 Oracle
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
5158 0
|
应用服务中间件 数据格式 JSON
Tomcat 8 Invalid character found in the request target. The valid characters are defined in RFC 3986
终极解决方案: Invalid character found in the request target. The valid characters are defined in RFC 3986 25-Aug-2018 11:27:27.
21197 0