1. Installation Guide
  2. Uninstall
  3. Data Management Assembly for Oracle Data Integrator Uninstall

17 Data Management Assembly for Oracle Data Integrator Uninstall

Note:

This section is applicable only to uninstall the Data Management Assembly only from the development environment.
- Steps

Checkbox

Execute the following commands to drop user schemas by connecting to the system user. If you have installed the Data Model Assembly, replace the user schema name and tablespace names with the values provided during the installation.

drop user <HCD_WORK_REP_80> cascade;
drop user <HCD_MASTER_REP_80> cascade;
drop user <WIL_WORK_REP_80> cascade;
drop user <TL_MASTER_REP_80> cascade;
drop user <CDM_WORK_REP_80 cascade;
drop user <TL_WORK_REP_80> cascade;
drop user <WIL_MASTER_REP_80> cascade;
drop user <CDM_MASTER_REP_80> cascade;
drop user <WIL_HMC80> cascade;
drop user <HCD_HMC80> cascade;
drop tablespace <hmc_temp80> INCLUDING CONTENTS and datafiles;
drop tablespace <odirep_temp80> INCLUDING CONTENTS and datafiles;
drop tablespace <odirep_ts80> INCLUDING CONTENTS and datafiles;
drop tablespace <hmc_ts80> INCLUDING CONTENTS and datafiles;
drop tablespace <wil_odi_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <hcd_odi_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <cdm_odi_ts> INCLUDING CONTENTS and datafiles;
drop tablespace <tl_odi_ts> INCLUDING CONTENTS and datafiles;
commit;

Checkbox

Drop the RCU repository:

  1. Start the RCU from the terminal: 
    cd WLS_HOME/oracle_common/bin/
 ./rcu
  2. In the Welcome screen, click Next.
  3. Select Drop Repository and click Next.
  4. Fill in the following values:
    • Database Type: eg. Oracle Database
    • Host Name: Host where the database is running
    • Port: Oracle Database service listener port
    • Service Name: Oracle Database service name
    • User Name: User name with SYSDBA privilege
    • Password: Password for the above sysdba user
    • Role: SYSDBA

    Click Next.

  5. Choose the existing RCU prefix created during the Oracle Data Integrator Data Assembly Installation to drop and select all the components in the bottom table and click Next.
  6. Click Drop to drop all of the schemas with the selected prefix.
  7. After the drop is completed, click Finish.

Checkbox

Navigate to the Oracle Data Integrator domains directory and drop all the Oracle Healthcare Foundation domain folders created during the Oracle Healthcare Foundation installation. For example: 

cd $ODI_HOME/user_projects/domains
 rm -rf ${RCU_PREFIX}_WIL_domain_01
 rm -rf ${RCU_PREFIX}_AT_domain_01
 rm -rf ${RCU_PREFIX}_CDM_domain_01
 rm -rf ${RCU_PREFIX}_TL_domain_01

Parent topic: Uninstall