not all alterations performed

本文记录了在Oracle RAC环境中安装过程中遇到的问题及解决方案,包括AttachHome失败、dbca错误处理等,并分享了如何通过手动命令解决节点间文件同步不一致等问题。


Remote 'AttachHome' failed on nodes:'rac2'.
Refer to '/homo/oracle/oraInventory/logs/installActions2012-07-14_09-01-51AM.log' for details.
You can manualy re-run the following command on the failed nodes after the installation:
/u01/app/oracle/product/10g/db/oui/bin/runInstaller -attachHome -noClusterEnabled ORACLE_HOME=/u01/app/oracle/product/10g/db ORACLE_HOME_NAME=OraDb10g_home2 CLUSTER_NODES=rac1,rac2 "INVENTORY_LOCATION=/home/oracle/oraInventory" LOCAL_NODE=<node on which command is to be run>


/u01/app/oracle/product/10g/db/oui/bin/runInstaller -attachHome -noClusterEnabled ORACLE_HOME=/u01/app/oracle/product/10g/db ORACLE_HOME_NAME=OraDb10g_home2 CLUSTER_NODES=rac1,rac2 "INVENTORY_LOCATION=/home/oracle/oraInventory" LOCAL_NODE=rac2
以oracle用户执行了上面的命令之后,提示如下:
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
'AttachHome' was successful.



在RAC 上dbca时,报错:
ORA-15032:not all alterations performed
ORA-15017: diskgroup "ASMDATA" can no be mounted
ORA-15030: diskgroup name "ASMDATA" is in use by another diskgroup
检查发现:
[root@rac1 pfile]# ll
total 8
-rw-r-----  1 oracle oinstall 1122 Jul 14 08:51 init.ora
-rw-r-----  1 oracle oinstall 1129 Jul 13 08:34 init.ora.614201285134
[root@rac1 pfile]#

[root@rac2 pfile]# ll
total 8
-rw-r-----  1 oracle oinstall 1122 Jul 14 08:51 init.ora
[root@rac2 pfile]#
在rac2节点上少一个文件,将此文件从节点1拷贝到节点2上相同的目录下后,再mount,mount上了。




更多参考:


the specified nodes are not clusterable

根据rowid删除表中重复的行

Agent process exited abnormally during initialization

一次字符乱码的解决过程

rman实验(一)

rman实验(二)

ORA-00600: internal error code, arguments: [keltnf

ORA-00600: ORA-12012 ORA-08102解决

linux下完全删除oracle

INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory

centos4.8_64上安装oracle10201建库报ORA-12547

EM乱码解决

ORA-31613 Master process DM00 failed during startup

ORA-00600: internal error code, arguments: [4194], [29], [27], [], [], [], [], []

ORA-24324 ORA-01041 ORA-03113

centos5.3升级oracle

pdksh-5.2.14-36.el5.i386.rpm

使用rman进行数据库迁移

oracle10.2.0.1升级到10.2.0.4报错

Upgrade Oracle 10g from 10.2.0.1 to 10.2.0.4 (Single Instance)

改oracle的name和dbid

修改oracle实例名

Solaris8上迁移oracle8i---上

Solaris8上迁移oracle8i---下

未备份归档日志导致数据丢失的实验

使用NBU进行数据库迁移

catalog备份数据库

RMAN FORMAT字符串格式化

Error: can not register my instance state - -1

not all alterations performed

The ASM instance configured on the local node is a single-instance ASM

/u01/crs102/bin/crsctl.bin: error while loading shared libraries: libstdc++.so.5: cannot open shared

Initializing the Oracle ASMLib driver: [FAILED]

ORA-00245: control file backup operation failed

WARNING: failed to read mirror side 1 of virtual extent 229 logical extent

模拟恢复参数文件

Interface eth0 checked failed

import server uses ZHS16GBK character set (possible charset conversion)





评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值