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>

keithjgordon@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@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.com

keithjgordon@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.

On Apr 17, 3:40 pm, Brian Peasland <d...@nospam.peasland.net> wrote:
> keithjgor...@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
> d...@nospam.peasland.nethttp://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 fromhttp://www.teranews.com

Thank you Brian and Abhinandan for helping me. I have used "col" to
strip out control characters from the file and I still get the
problem. Here is my pfile and it is surprisingly small. I cannot see
anything obviously wrong ?
Thank you
John

XE.__db_cache_size=436207616
XE.__java_pool_size=4194304
XE.__large_pool_size=4194304
XE.__shared_pool_size=159383552
XE.__streams_pool_size=0
*.audit_file_dest='/usr/lib/oracle/xe/app/oracle/admin/XE/adump'
*.background_dump_dest='/usr/lib/oracle/xe/app/oracle/admin/XE/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/usr/lib/oracle/xe/oradata/XE/control.dbf'
*.core_dump_dest='/usr/lib/oracle/xe/app/oracle/admin/XE/cdump'
*.db_name='XE'
*.DB_RECOVERY_FILE_DEST_SIZE=10G
*.DB_RECOVERY_FILE_DEST='/usr/lib/oracle/xe/app/oracle/
flash_recovery_area'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=XEXDB)'
*.hash_area_size=1750000
*.job_queue_processes=4
*.open_cursors=300
*.os_authent_prefix=''
*.pga_aggregate_target=11534336
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=20
*.sga_target=605552640
*.shared_servers=4
*.undo_management='AUTO'
*.undo_tablespace='UNDO'
*.user_dump_dest='/usr/lib/oracle/xe/app/oracle/admin/XE/udump'
*.workarea_size_policy='AUTO'
~