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