SP2-0310: Unable To Open File "CATMDLOC.SQL" When Installing Oracle interMedia (Doc ID 465052.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Multimedia - Version: 10.2.0.3 to 10.2.0.3 - Release: 10.2 to 10.2
HP-UX PA-RISC (64-bit)
Linux Itanium

Symptoms

During installing Oracle interMedia on Oracle Database 10.2.0.3 on HP-UX PA-RISC(64-bit) or Linux Itanium the following errors can be seen:

when running ordinst.sql to create the users

...
SP2-0310: unable to open file "%ORACLE_HOME%/md/admin/mdprivs.sql" 
SP2-0310: unable to open file "%ORACLE_HOME%/rdbms/admin/utlraw.sql" 
SP2-0310: unable to open file "%ORACLE_HOME%/rdbms/admin/prvtrawb.plb"
...


when running iminst.sql to install the Oracle interMedia types and packages

...
SP2-0310: unable to open file %ORACLE_HOME%/md/admin/catmdloc.sql"
...


Selecting from DBA_LIBRARIES after finishing the installation will show a wrong value for FILE_SPEC:

SQL> select owner, library_name, file_spec
from dba_libraries
where owner='ORDSYS'
and library_name = 'ORDIMLIBS';

OWNER  LIBRARY_NAME  FILE_SPEC
------ ------------- ---------------
ORDSYS ORDIMLIBS     %IM_SHLIB%

Opening $ORACLE_HOME/ord/admin/imimdloc.sql shows a substitution variable %ORACLE_HOME% as follows :

%ORACLE_HOME%/md/admin/mdprivs.sql  

REM Install UTL_RAW  

%ORACLE_HOME%/rdbms/admin/utlraw.sql  
%ORACLE_HOME%/rdbms/admin/prvtrawb.plb   
 

Opening $ORACLE_HOME/ord/im/admin/imimdloc.sql will shows the a substitution variable %ORACLE_HOME%:

@%ORACLE_HOME%/md/admin/catmdloc.sql    


Opening $ORACLE_HOME/ord/im/admin/ordlib.sql shows a substitution variable %IM_SHLIB%:

create or replace library ORDIMLIBS as '%IM_SHLIB%'; 
/

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