When Applying One Off Patch Onto 126.96.36.199 (Like Exadata 188.8.131.52 BP 21) Receiving Error SP2-0310 Unable To Open File "exa/scripts/catmacdd.sql"
Last updated on APRIL 09, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2]
Information in this document applies to any platform.
When applying a patch on 18.104.22.168 (in this example, while applying Exadata 22.214.171.124 BP 21), the following error is seen.
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)
2 IF (dbms_registry.status ('DV') = 'VALID') then
3 :script_name := '@catmacdd.sql';
5 :script_name := dbms_registry.nothing_script;
6 END IF;
PL/SQL procedure successfully completed.
SQL> SELECT :script_name FROM DUAL;
1 row selected.
SP2-0310: unable to open file "exa/scripts/catmacdd.sql"
Oracle Database Vault is listed as installed in the dba_registry using the following query.
SELECT COMP_NAME , VERSION , STATUS FROM DBA_REGISTRY;
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