APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.3 to 12.1.0.1 [Release 10.2 to 12.1] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later SYMPTOMS: When trying to recompile invalid objects by running the utlrp.sql script, the below error is thrown: "XDB now invalid, could not find xdbconfig" Furthermore, Oracle XML Database (XDB) is INVALID, and querying resource view fails with error: SQL> select any_path from resource_view; select any_path from resource_view * ERROR at line 1: ORA-31024: Parser initialization failed with LPX-201 error while parsing a stream to XOB CAUSE: Incorrect setting of enviroment variable, ORA_NLS10. The ORA_NLSxx environment variable is used to indicate where Oracle RDBMS/client software can locate the defintions of Charactersets. For Oracle 10g, 11g, and 12c the variable is called ORA_NLS10 and this must be set to $ORACLE_HOME/nls/data. If left undefined, the variable defaults to $ORACLE_HOME/nls/data. SOLUTION: Unset ORA_NLS10 so it defaults to the correct value of $ORACLE_HOME/nls/data, OR explicitly set it to $ORACLE_HOME/nls/data. Shutdown, restart the database, and run utlrp.sql
Recent Posts
