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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30310891/viewspace-1760427/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30310891/viewspace-1760427/