When Applying One Off Patch Onto 11.2.0.3 (Like Exadata 11.2.0.3 BP 21) Receiving Error SP2-0310 Unable To Open File "exa/scripts/catmacdd.sql" (Doc ID 1645556.1)

Last updated on MAY 21, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When applying a patch on 11.2.0.3 (in this example, while applying Exadata 11.2.0.3 BP 21), the following error is seen.

ERROR

------------

SQL> -- For one-off patches, if DATA VAULT is installed we need to run the DV
SQL> -- script for re-loading their metadata views.
SQL> COLUMN :script_name NEW_VALUE comp_file NOPRINT;
SQL> VARIABLE script_name VARCHAR2(50)
SQL> begin
 2    IF (dbms_registry.status ('DV') = 'VALID') then
 3       :script_name := '@catmacdd.sql';
 4     ELSE
 5         :script_name := dbms_registry.nothing_script;
 6    END IF;
 7  end;
 8  /

PL/SQL procedure successfully completed.

SQL> SELECT :script_name FROM DUAL;

1 row selected.

SQL> @&comp_file
SP2-0310: unable to open file "exa/scripts/catmacdd.sql"

AND

Oracle Database Vault is listed as installed in the dba_registry using the following query.

SELECT COMP_NAME , VERSION , STATUS FROM DBA_REGISTRY;

 

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms