Oracle11g 单机ASM,虚拟机克隆机器后,IP和主机名发生改变的处理过程

参考:

How to Reconfigure Oracle Restart (文档 ID 986740.1)

1.Remove Oracle Restart configuration

This 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 configuration

This 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 instance

This 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):

这里可以从源来的机器里拷贝一个参数文件过来,或者参考源库的参数,自己写一个

[root@dgasm1 ~]# su - grid
[grid@dgasm1 ~]$ cd $ORACLE_HOME/dbs
[grid@dgasm1 dbs]$ vi init+ASM.ora
## 就用原来的文件就可以了
+ASM.__large_pool_size=16777216
+ASM.__oracle_base='/oracle/app/grid'#ORACLE_BASE set from in memory value
+ASM.asm_diskgroups='DG2_SYSTEM','DG3_ARCH','DG4_DATA01'#Manual Mount
*.asm_diskstring='/dev/asm*'
*.asm_power_limit=1
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

6. Restart HAS stack

crsctl stop has
crsctl start has  

7.Add components back to Oracle Restart Configuration

7.1 Add database component

This step should be performed as RDBMS owner (oracle user).

如果克隆后机器,DBCA删除原来的数据库了,这里就不用添加原来的数据库了

srvctl add database -d -o

7.2. Add listener component

This step should be performed as Grid Infrastructure owner (grid user).

srvctl add listener

7.3. Add other components

For 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

其他

How to change Hostname / IP for a Grid Infrastructure Oracle Restart Standalone Configuration (SIHA) (文档 ID 1552810.1)

posted on   yq1DB  阅读(134)  评论(0编辑  收藏  举报

编辑推荐:
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
阅读排行:
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5

导航

统计

点击右上角即可分享
微信分享提示