oracle11g rac转换单机,11gR2单机转RAC 报ORA-12547

(节点1由于操作系统空间不足，先在节点2测试)本次单机转RAC，将数据库文件从生产端迁移到共享存储ASM的data磁盘组中，实现2节点正常

open，创建节点1的初始化参数文件，启动节点1实例，发现实例起不来，报连不上ASM实例，即无法读取放在ASM磁盘组上的spfile，可参照下面

文档解决

Oracle Database Fails to Start with Error ORA-12547 (文档 ID 1307075.1)

参考笔记：

[oracle@node1 dbs]$ more initnode1.ora

SPFILE='+data/node/parameterfile/spfilenode.ora'

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 3 21:41:24 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+data/node/parameterfile/spfilenode.ora'

ORA-17503: ksfdopn:2 Failed to open file +data/node/parameterfile/spfilenode.ora

ORA-12547: TNS:lost contact

SQL>

[oracle@node1 ~]$ su – grid

Password:

[grid@node1 ~]$ ls -l $ORACLE_HOME/bin/oracle-rwxr-x–x 1 grid oinstall 209914519 Jul 29 21:58 /oracle/grid/crs_1/bin/oracle

[grid@node1 ~]$ cd $ORACLE_HOME/bin/

[grid@node1 bin]$chmod 6751 oracle

[grid@node1 bin]$ ls -l $ORACLE_HOME/bin/oracle

-rwsr-s–x 1 grid oinstall 209914519 Jul 29 21:58 /oracle/grid/crs_1/bin/oracle

[grid@node1 bin]$ su – oracle

Password:

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 3 22:00:29 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  626327552 bytes

Fixed Size                  2255832 bytes

Variable Size             297796648 bytes

Database Buffers          322961408 bytes

Redo Buffers                3313664 bytes

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS

—————- ————

node1            OPEN

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

——— ——————–

NODE      READ WRITE