APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later SYMPTOMS: Oracle XML Database (XDB) is INVALID after applying a PSU. COMP_ID COMP_NAME STATUS VERSION ---------- -------------------------- ------------ ---------- ... XDB Oracle XML Database INVALID 12.1.0.2.0 Reloading XDB's packages and procedures through xdbrelod.sql generates errors: ... 19 dbms_xmlschema.compileschema(schema_url); 20 ELSE 21 exit; 22 END IF; 23 END LOOP; 24 dbms_sql.close_cursor(cur); 25 commit; 26 end; 27 / declare * ERROR at line 1: ORA-09925: Unable to create audit trail file IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 9925 ORA-09925: Unable to create audit trail file IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 9925 ORA-06512: at "SYS.DBMS_SQL", line 1120 ORA-06512: at line 8 CAUSE: File system path to AUDIT_FILE_DEST does not exist SOLUTION: 1. Recreate the default directory for AUDIT_FILE_DEST and make sure the permission is set to 755. mkdir $ORACLE_BASE/admin/$ORACLE_SID/adump chmod 755 $ORACLE_BASE/admin/$ORACLE_SID/adump - or mkdir $ORACLE_HOME/rdbms/audit chmod 755 $ORACLE_HOME/rdbms/audit 2. Run xdbrelod.sql spool xdbreload.log connect / as sysdba set echo on; shutdown immediate; startup upgrade; @?/rdbms/admin/xdbrelod.sql shutdown immediate; startup; @?/rdbms/admin/utlrp.sql spool off
Recent Posts
