13 Data Management Assembly for Oracle Data Integrator Uninstall

Note:

This section is applicable only to uninstall Data Management Assembly only from the development environment.
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_721> cascade;
drop user <HCD_MASTER_REP_721> cascade;
drop user <WIL_WORK_REP_721> cascade;
drop user <TL_MASTER_REP_721> cascade;
drop user <CDM_WORK_REP_721> cascade;
drop user <TL_WORK_REP_721> cascade;
drop user <WIL_MASTER_REP_721> cascade;
drop user <CDM_MASTER_REP_721> cascade;
drop user <WIL_HMC721> cascade;
drop user <HCD_HMC721> cascade;
drop tablespace <hmc_temp721> INCLUDING CONTENTS and datafiles;
drop tablespace <odirep_temp721> INCLUDING CONTENTS and datafiles;
drop tablespace <odirep_ts721> INCLUDING CONTENTS and datafiles;
drop tablespace <hmc_ts721> 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;
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: Database service listener port

    • Service Name: 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 ODI Data Assembly Installation to drop and select all the components in the bottom table and click Next.

  6. Click Drop to drop all the schemas with the selected prefix.

  7. After the drop is completed, click Finish.
Navigate to the ODI domains directory and drop all the OHF domain folders created during the OHF 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