On Apr 17, 3:40 pm, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> keithjgor..._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
> 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'
~
Received on Tue Apr 17 2007 - 10:17:13 CDT
