Re: Help: How can I get the spfile out of ASM disk

On Feb 9, 8:36 pm, "joe bayer" <joebay..._at_hotmail.com> wrote:
> See what I got:
>
> [oracle_at_learning dbs]$ cat inittest1.ora
> SPFILE='+DISKTEST/test/spfiletest.ora'
>
> [oracle_at_learning~]$ export ORACLE_SID=test1
> [oracle_at_learning~]$ sqlplus /nolog
>
> SQL*Plus: Release 10.2.0.3.0 - Production on Sat Feb 9 20:31:30 2008
>
> Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
>
> SQL> connect / as sysdba
> Connected to an idle instance.
> SQL> create pfile from spfile;
> create pfile from spfile
> *
> ERROR at line 1:
> ORA-27037: unable to obtain file status
> Linux-x86 Error: 2: No such file or directory
> Additional information: 3
>
> Thanks
>
> "Ana C. Dent" <anaced..._at_hotmail.com> wrote in messagenews:Ntqrj.359$n42.215_at_newsfe08.phx...
>
>
>
> > "joe bayer" <joebay..._at_hotmail.com> wrote in
> >news:Dnorj.130$eU3.92_at_trndny04:
>
> >> How can I create spfile if I can not even start the instance with the
> >> spfile?
>
> > What makes you think the DB needs to be up to create the pfile???????
>
> > sqlplus
>
> > SQL*Plus: Release 11.1.0.6.0 - Production on Sat Feb 9 15:02:46 2008
>
> > Copyright (c) 1982, 2007, Oracle.  All rights reserved.
>
> > Enter user-name: / as sysdba
>
> > Connected to:
> > Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
> > With the Partitioning, OLAP, Data Mining and Real Application Testing
> > options
>
> > SQL> shutdown immediate
> > Database closed.
> > Database dismounted.
> > ORACLE instance shut down.
> > SQL> create pfile from spfile;
>
> > File created.
>
> > SQL> startup
> > ORACLE instance started.
>
> > Total System Global Area  401743872 bytes
> > Fixed Size                  1300212 bytes
> > Variable Size             356518156 bytes
> > Database Buffers           37748736 bytes
> > Redo Buffers                6176768 bytes
> > Database mounted.
> > Database opened.- Hide quoted text -
>
> - Show quoted text -

Joe your spfile does not appear to be in the default location. If that is true then you must specify the explicit spfile name in the create pfile command.

>> SQL manual entry on CREATE PFILE >>

If you specify spfile_name, then the file must exist on the server. If the file does not reside in the default directory for server parameter files on your operating system, then you must specify the full path. <<

We run RAC on a server that did not have a clustered file system (at the time of initial install) so our init,ora has one line referencing the spfile location, which must be on shared disk, that is, a raw partition in our case. Based on your post it looks like the same requirement may be true if the spfile is placed in ASM.

HTH -- Mark D Powell -- Received on Sun Feb 10 2008 - 12:21:08 CST