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)
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?