How to uninstall HDR (if required)

• "Uninstall database objects"
• "Uninstall the HDR middle tier"

Uninstall database objects

To uninstall the database objects (HDR, ETS and HDR_CONFIG user schemas), execute the following SQL scripts from sqlplus/sqldeveloper as the sys user:

Note:

If the tablespace names used during HDR install were different from the standard names then adjust the scripts accordingly.

alter session set "_oracle_script"=true; set serveroutput on; declare
     type tbs_name_type is table of varchar2(100);
     tbs_names tbs_name_type;
begin
     begin
         dbms_scheduler.drop_job('HDR_ETS_MAINTENANCE', TRUE);
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         dbms_scheduler.drop_job('HDR_ETS_LOADER', TRUE);
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         dbms_scheduler.drop_job('HDR_ETS_IMPORTER', TRUE);
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
dbms_scheduler.drop_program('hdr_ets_maintenance_program');
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         dbms_scheduler.drop_program('hdr_ets_loader_program');
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         dbms_scheduler.drop_program('hdr_ets_importer_program');
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     select tablespace_name bulk collect into tbs_names from DBA_TS_QUOTAS where username in ('HDR', 'ETS', 'HDR_CONFIG');
 
     begin
         execute immediate 'drop user HDR cascade';
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         execute immediate 'drop user ETS cascade';
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     begin
         execute immediate 'drop user HDR_CONFIG cascade';
     exception when others then
         dbms_output.put_line(SQLERRM);
     end;
 
     for i in 1..tbs_names.count loop
         begin
             execute immediate 'drop tablespace '||tbs_names(i)||' 
including contents and datafiles';
         exception when others then
             dbms_output.put_line(SQLERRM);
         end;
     end loop;
end;
/

Uninstall the HDR middle tier

To uninstall the HDR middle tier:

1. Stop the hdr_domain and hdr_server node mangers.
2. Delete the hdr_domain folder completely.
3. Edit WebLogic Oracle_Home/domain-registry.xml and remove the entry for hdr_domain.
4. Delete the HDR home directory (that you provided during installation) completely.