Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help creating SP file
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';
Total System Global Area 608174080 bytes
Fixed Size 1260316 bytes Variable Size 167773412 bytes Database Buffers 436207616 bytes Redo Buffers 2932736 bytesDatabase mounted.
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