风哥教程

培训 . 交流 . 分享
Make progress together!

oracle 11gR2 oracle restart单机使用asm存储时主机名发生更改处理过程

[复制链接]
内容发布:paulyi| 发布时间:2014-2-23 16:50:53

oracle 11gR2 oracle restart 单机使用asm存储 主机名发生更改并且主机重启后处理过程:以下为解决方案:1. Remove Oracle Restart configurationThis step should be performed as privileged (root) user.

# $GRID_HOME/crs/install/roothas.pl -deconfig -force

The expected result is "Successfully deconfigured Oracle Restart stack".

2. Reconfigure Oracle Restart
This step should also be performed as privileged (root) user.

# $GRID_HOME/crs/install/roothas.pl

The expected result is  "Successfully configured Oracle Grid Infrastructure for a Standalone Server"
3. Add ASM back to Oracle Restart  configurationThis step should be performed as Grid Infrastructure owner (grid user).

$ srvctl add asm

The expected result is no output, just a return to the operating system prompt.
4. Start up ASM instanceThis step should be performed as Grid Infrastructure owner (grid user).

$ srvctl start asm

That should start ASM. Note that at this time there will be no ASM initialization or server  parameter file.

5. Recreate ASM server parameter file (SPFILE)
This step should be performed as Grid Infrastructure owner (grid user).

Create a temporary initialization parameter file (e.g. /tmp/init+ASM.ora) with the following content (specify your own disk group names):
asm_diskgroups='DATA','RECO'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile='EXCLUSIVE'

Mount the disk group where the new server parameter file (SPFILE) will reside (e.g. DATA) and create SPFILE:
$ sqlplus / as sysasm

SQL> alter diskgroup DATA mount;
Diskgroup altered.

SQL> create spfile='+DATA' from pfile='/tmp/init+ASM.ora';
File created.

SQL> show parameter spfile
NAME TYPE VALUE
------- ------- -------------------------------------------------
spfile string +DATA/asm/asmparameterfile/registry.253.707737977

6. Restart HAS stack
crsctl stop has
crsctl start has

7. Add components back to Oracle Restart ConfigurationIf you had the database, listener and other components, add them back to the Oracle Restart Configuration.

7.1. Add database componentThis step should be performed as RDBMS owner (oracle user).
srvctl add database -d <db_unique_name> -o <oracle_home>

7.2. Add listener componentThis step should be performed as Grid Infrastructure owner (grid user).
srvctl add listener

7.3. Add other componentsFor information on how to add back additional components, please review:
Oracle Database Administrator's Guide 11g Release 2 (11.2)
Chapter 4 Configuring Automatic Restart of an Oracle Database
Section Configuring Oracle Restart




上一篇:oracle 11.2.0.2 安装grid集群软件报[INS-30060]问题处理
下一篇:oracle V$ASM_DISK视图含义
回复

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

热门文章教程

  • 风哥Oracle数据库巡检工具V1.0(附2.6网页
  • Oracle 12cR2 九大新功能全面曝光_详解云数
  • 实战PHP与MySQL权威指南PDF电子书下载
  • 大数据技术与应用入门培训教程(电子版下载
  • Oracle OCP认证考试IZ0-053题库共712题数据
  • MySQL5权威指南(第3版)PDF电子版下载
快速回复 返回顶部 返回列表