Oracle单机迁移-hostname问题

2220阅读 0评论2018-01-26 zhangshengdong
分类:Oracle

问题描述:如果启动数据库,出现如下问题。
[root@localhost ~]# su - oraarp
[oraarp@localhost ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 26 15:18:18 2018
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected.
SQL> select * from v$instance
  2  ;
select * from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

没有出现:
[oraarp@arpdb ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 26 15:20:59 2018
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.

一般来说,除了修改/etc/hostname文件之外。
还需要修改 /etc/sysconfig/network
[root@localhost ~]# vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=arpdb

临时生效的命令:
hostname arpdb
上一篇: Oracle中filesystemio_options and disk_asynch_io两个参数的思考
下一篇:Mongodb副本集--Out of memory: Kill process 37325 (mongod)