Zero Downtime Installation Guide for Oracle

10.3 HotFix 1

Back Next

Install Informatica MDM Zero Downtime

Use Oracle SQL*Plus (

sqlplus

) to run the SQL scripts and the wrapped source code files. Perform these steps on the source system and the target system.

Navigate to the following directory:

<MDM installation directory>/hub/server/resources/database/oracle/en_US

Open the

update_javasp.sql

file and verify the following lines of code:

HOST loadjava -verbose -force -resolve -oracleresolver -thin -user &ors_name/&ors_passwd@&tns_name ../siperian-cleansecaller.jar
HOST loadjava -verbose -force -resolve -oracleresolver -thin -user &ors_name/&ors_passwd@&tns_name ../siperian-dbutil.jar
HOST loadjava -verbose -force -resolve -oracleresolver -thin -user &ors_name/&ors_passwd@&tns_name ../siperian-zdt.jar
HOST loadjava -verbose -force -resolve -oracleresolver -thin -user &ors_name/&ors_passwd@&tns_name ../informatica-locale-util.jar

If necessary, update the lines of code in the file to match the preceding code.

In MDM 9.7.1 versions, the JAR file

../informatica-locale-util.jar

was named

../informatica

-db

-locale-util.jar

Navigate to the following directory:

<MDM installation directory>/hub/server/resources/database/oracle/en_US

As the schema user, run the following command on the source database:

SQL> @compile_types.sql

Navigate to the following directory:

<MDM installation directory>/resources/database/oracle/

Run the files on the source database in the following order:

SQL> @cmx_zdt_objects_support.sql
SQL> @cmxlb_pack.plb
SQL> @cmx_debug_print_proc.plb
SQL> @cmxlog_pack.plb
SQL> @cmxlog_body.plb
SQL> @cmxzdt_pack.plb
SQL> @cmxzdt_body.plb

Rename Saved Search

Table of Contents

Zero Downtime Installation Guide for Oracle

Zero Downtime Installation Guide for Oracle

Install Informatica MDM Zero Downtime

Install Informatica MDM Zero Downtime