ORA-01078, LRM-00110

ORA-01078: failure in processing system parameters Cause: Failure during processing of INIT.ORA parameters during system startup. Action: Further diagnostic information should be in the error stack.

LRM-00110: syntax error at "string" Cause: A syntax error was detected. Action: Change the input so that the correct syntax is used. Note: LRM errors are parameter messages.

Example: SQL> startup nomount pfile=/fs/u02/oracle/admin/mydb/pfile/initmydb.ora create database …… LRM-00110: syntax error at 'ache' ORA-01078: failure in processing system parameters create database mydb * ERROR at line 1: ORA-01034: ORACLE not available Reason: The script failed with an Oracle parameter error LRM-00110. Check the init.ora file and it looks like this: $ more /fs/u02/oracle/admin/mydb/pfile/initmydb.ora ache and I/O ########################################### db_block_size=8192 db_file_multiblock_read_count=8 Solution: fix the syntax error, the init.ora file looks like: $ more /fs/u02/oracle/admin/mydb/pfile/initmydb.ora ########################################### # Cache and I/O ########################################### db_block_size=8192 db_file_multiblock_read_count=8

Last updated: August 25, 2009

All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors