Re: Help creating SP file

keithjgordon_at_hotmail.co.uk wrote in news:1176820235.345750.156770 @o5g2000hsb.googlegroups.com:

>
> 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>
>
>

Please note that you never really opened the database/instance. IMO, I'd say an error exists in your pfile. You should find a clue or 2 in the alert_SID.log file. Received on Tue Apr 17 2007 - 09:45:18 CDT