Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help creating SP file

Help creating SP file

From: <keithjgordon_at_hotmail.co.uk>
Date: 17 Apr 2007 07:30:35 -0700
Message-ID: <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> Received on Tue Apr 17 2007 - 09:30:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US