ORA-00119,ORA-00130问题处理

最新推荐文章于 2022-02-16 10:47:41 发布

转载最新推荐文章于 2022-02-16 10:47:41 发布 · 399 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/543207

文章标签：

#数据库 #运维

解决vbox虚拟机迁移后Oracle数据库启动时报ora-00119, ora-00130错误的问题。通过调整/etc/hosts文件及/etc/sysconfig/network配置，确保hostname正确解析，成功启动Oracle实例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

vbox虚拟机迁移后，启动数据库报错：

显示ora-00119,ora-00130

经过查询资料检查

检查 /etc/hosts /etc/sysconfig/network hostname

[root@athena ~]# hostname
athena

[root@athena ~]# vi /etc/sysconfig/network

NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=athena

[root@athena ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6-----------------------------添加192.168.56.101 athena即可

[root@athena ~]# vi /etc/hosts
[root@athena ~]# vi /etc/hosts
[root@athena ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.56.101 athena

保存后数据库可以正常启动：

[oracle@athena ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 20 20:58:21 2014

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 835104768 bytes
Fixed Size      2232960 bytes
Variable Size    633343360 bytes
Database Buffers   197132288 bytes
Redo Buffers      2396160 bytes
Database mounted.
Database opened.

本文转自 abc3486389 51CTO博客，原文链接:http://blog.51cto.com/1336014/1427914