Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help creating SP file
keithjgordon_at_hotmail.co.uk wrote:
> Hello, I have been changing some parameters on my XE home database and
> I now have problems. I can start my database with a pfile but not with
> an sp file. I have read the Oracle documentation for 10.2/RHEL x86 ---
> this is what I see. What can my Oracle database start with a pfile but
> not with an spfile created from it?
>
> This is a home database and not a company database for learning.
> Thank you
> John
>
> SQL>
> SQL>
> SQL> startup mount pfile='kjxe.ora';
> ORACLE instance started.
>
> Total System Global Area 608174080 bytes
> Fixed Size 1260316 bytes
> Variable Size 167773412 bytes
> Database Buffers 436207616 bytes
> Redo Buffers 2932736 bytes
> Database mounted.
> SQL>
> create spfile='/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/
> initXE.ora' from pfile='kjxe.ora';
> SQL>
> File created.
>
> SQL> shutdown immediate;
> ORA-01109: database not open
>
>
> Database dismounted.
> ORACLE instance shut down.
> SQL> startup;
> ORA-01078: failure in processing system parameters
> LRM-00123: invalid character 0 found in the input file
> SQL>
>
As the LRM-00123 message says, you have an invalid character in the file. This most likely occurred from the conversion of the text PFILE to the binary SPFILE. Double check your PFILE to ensure everything is correct. Then recreate the SPFILE again.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown -- Posted via a free Usenet account from http://www.teranews.comReceived on Tue Apr 17 2007 - 09:40:47 CDT