Tuesday, December 31, 2013

The Oracle base has been set to Parse failed, error 229

Error:
In line 0 of oraclehomeproperties.xml:
LPX-00229: input source is empty
The Oracle base has been set to Parse failed, error 229

Cause: oraclehomeproperties.xml file got corrupt

Solution:
  1. cd $ORACEL_HOME/inventory/ContentsXML
  2. use ls -ltr to get the following:
    drwx—— 2 oracle oinstall 4096 Dec 29 2010 ConfigXML
    -rw-r—– 1 oracle oinstall 7770 Feb 21 2011 libs.xml
    -rw-r—– 1 oracle oinstall 1978 Feb 21 2011 config.xml
    -rw-r—– 1 oracle oinstall 656001 Feb 21 2011 comps.xml
    -rw-r–r– 1 oracle oinstall 0 May 19 2013 oraclehomeproperties.xml

    Notice that oraclehomeproperties.xml is of size 0 bytes.
  3. To fix the issue either restore oraclehomeproperties.xml from backup or copy it from another ORACLE_HOME of a different database

No comments:

Post a Comment