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 localhost6192.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

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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