I am trying to move pfile from file system to spfile in ASM
Below are the details.
I have created an ASM instance using user ORACRS having primary group as oinstall and secondary group as dba.
Version of ASM+CRS is 11.2.0.2
I am creating a RAC instance and to do so i have created a Normal DB in the owner of user ORACLE having
primary group as oinstall and secondary group as dba.
Version of DB is 11.1.0.7
When i try to create spfile using the below command in the ownership of user ORACLE it errors out:-
[oracle@rac1 11.1.0]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Feb 22 09:36:19 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile='+DATA' from pfile;
create spfile='+DATA' from pfile
*
ERROR at line 1:
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
I tried using the cp command of asmcmd but it got hang for a quite long and i had to cancel it.
now if i try to copy the file or dismount the DISK , it again errors out:-
Copy(as user oracrs since it is the owner of ASM):-
===============================
ASMCMD [+] > cp /u001/db/tech_st/11.1.0/dbs/spfileCABLE.ora +DATA
copying /u001/db/tech_st/11.1.0/dbs/spfileCABLE.ora -> +DATA/spfileCABLE.ora
ASMCMD-08016: copy source->'/u001/db/tech_st/11.1.0/dbs/spfileCABLE.ora' and target->'+DATA/spfileCABLE.ora' failed
ORA-19505: failed to identify file "+DATA/spfileCABLE.ora"
ORA-17502: ksfdcre:4 Failed to create file +DATA/spfileCABLE.ora
ORA-15268: internal Oracle file +DATA.253.1 already exists.
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 410
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)
I could not find this file anywhere in +DATA
Basically this is empty, but might have created some internal file as i cancled one of the command.
Dismount (as user oracrs since it is the owner of ASM):-
==================================
ASMCMD [+] > umount DATA
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "DATA" precludes its dismount (DBD ERROR: OCIStmtExecute)
any idea where i am doing wrong!!!
Edited by: NeerajKataria on Feb 22, 2011 10:10 AM