Re: Help: How can I get the spfile out of ASM disk
Date: Sun, 10 Feb 2008 02:55:49 -0800 (PST)
On Feb 10, 4:36 am, "joe bayer" <joebay..._at_hotmail.com> wrote:
> See what I got:
> [oracle_at_learning dbs]$ cat inittest1.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
See what's in $ORACLE_HOME/dbs/init<SID>.ora where <SID> is your Oracle database SID, verify that SPFILE=... in that file points to an accessible location and if it's on ASM then make sure ASM instance is up. You can also try to
create pfile='file-spec' from spfile;
where file-spec is full path to the pfile you want to be created.
And please, do not top-post.
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Sun Feb 10 2008 - 04:55:49 CST