1. 当前位置:网站首页 > Oracle相关

Oracle启动出现了ORA-00119,ORA-00130


启动虚拟机的Oracle,执行startup,出现了下面故障码,

SQL> startup

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=orapy)(PORT=1521))'

SQL>

根据ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=orapy)(PORT=1521))' 初步判断是IP设置问题

查看主机ip

[root@orapy ~]# ifconfig
eth1 Link encap:Ethernet HWaddr 00:0C:29:A7:7A:5D 
inet addr:192.168.216.129 Bcast:192.168.216.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fea7:7a5d/64 Scope:Link

查看监听文件listener.ora

[oracle@orapy admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.1/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.216.128)(PORT = 1521)) 发现配置文件的ip和主机ip不一致
)

修改好ip好,启动oracle,问题还是出现

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=orapy)(PORT=1521))'
SQL>

再查看一下linux的配置问题hosts,发现ip配置错误,

[root@orapy ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.216.128 st ------------修改为对应的ip和主机名(我这里是192.168.216.129 orapy)
[root@orapy ~]#

然后启动数据库,问题解决

SQL> startup
ORACLE instance started.

Total System Global Area 368263168 bytes
Fixed Size 1336596 bytes
Variable Size 272632556 bytes
Database Buffers 88080384 bytes
Redo Buffers 6213632 bytes
Database mounted.
Database opened.
SQL>


本文最后更新于2015-7-30,已超过 3个月没有更新,如果文章内容或图片资源失效,请留言反馈,我们会及时处理,谢谢!
版权说明

本文地址:https://www.chensj.net/?post=38
未标注转载均为本站远程,转载请注明文章出处:

联系我们

在线咨询:点击这里给我发消息

微信号:chensj923

工作日:9:00-23:00,节假日休息

扫码关注