oracle启动出现了ORA-00119,ORA-00130
来源:互联网 发布:linux db2 创建实例 编辑:程序博客网 时间:2024/05/21 01:45
启动虚拟机的oracle,执行startup,出现了下面故障码,
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-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>
- oracle启动出现了ORA-00119,ORA-00130
- Oracle启动出现了ORA-00119,ORA-00130
- Oracle启动出现了ORA-00119,ORA-00130
- Oracle启动报错ORA-00119,ORA-00130
- Oracle启动出现ORA-01034和ORA-27101的解决方案
- oracle启动错误ORA-00119和ORA-00132解决办法
- ORACLE启动ORA-01034,ORA-00119错误解决办法
- 启动oracle出现ORA-27102: out of memory错误
- 安装Oracle后数据库不能启动,出现ORA-27125错误
- ORA-00119、ORA-00130
- 出现了ORA-01033:ORACLE initialization or shutdown in progress
- oracle 启动时出现ORA-01157: cannot identify/lock data和ORA-01110: data file 错误
- 启动oracl 出现 ORA-01078
- Oracle归档日志满了导致无法启动ora-03113
- Oracle归档日志满了导致无法启动ora-03113
- 关机再重启出现:ORA-00119 ORA-00130 bogon
- oracle启动错误ORA-00845
- Oracle启动失败:ORA-03113
- [原创] 客户端同学正在辛苦做战斗,加油加油!show下其他界面
- android_图像识别库
- 第二讲.Linear Regression with multiple variable (多变量线性回归)
- Documentation/power/notifers.txt
- JAVA优质代码编写的30条可行建议
- oracle启动出现了ORA-00119,ORA-00130
- 数据结构之(图)之深度遍历及广度遍历
- MTK 报错集锦
- JS window.open()属性
- cdev_alloc
- 原码 反码 补码 移码
- Extjs4.2 Radial图表刻度不随store数据刷新而更新的解决方法
- 数据库测试一(V2.0)
- 【C++进阶】从内存管理、内存泄漏、内存回收探讨C++内存管理