Oracle® Healthcare Data Model Installation Guide 11g Release 2 (11.2) Part Number E18025-02 |
|
|
View PDF |
This chapter explains how to deinstall Oracle Healthcare Data Model:
Backing up and recovering Oracle Healthcare Data Model involves a two-step process to:
Backup or recover the relational objects
Backup or recover the analytic workspace that is part of Oracle Healthcare Data Model
The following topics outline these steps:
Take the following steps to backup the Oracle Healthcare Data Model:
Backup the OHDM_SYS
schema by executing the expdp
utility.
This utility exports all physical tables containing the data and mining models. For more information, see Oracle Database Utilities.
Backup the analytic workspace that is part of the Oracle Healthcare Data Model. The analytic workspace is backed up as an EIF file, named OHDM_BAK.EIF
, which is generated under the ORACLE_HOME
/ohdm/pdm/olap
directory.
Connect to the Database with ohdm_sys
.
Issue the following SQL statements.
exec dbms_aw.execute('AW ATTACH OHDM'); exec dbms_aw.execute('CDA OHDM_OLAP_DIR'); exec dbms_aw.execute('EXPORT ALL TO EIF FILE ''OHDM_BAK.EIF'' NOTEMPDATA'); exec dbms_aw.execute('AW DETACH OHDM');
Take the following steps to restore Oracle Healthcare Data Model from the backup files:
Restore the OHDM_SYS
schema by executing the impdp
utility.
This utility imports all physical tables containing the data and mining models. For more information, see Oracle Database Utilities.
Connect to the Database with ohdm_sys
, and import the analytic workspace that was saved as an EIF file, named OHDM_BAK.EIF
, under the ORACLE_HOME
/ohdm/pdm/olap
directory.
exec dbms_aw.execute('IMPORT ALL TO EIF FILE ''OHDM_BAK.EIF');
To deinstall Oracle Healthcare Data Model, you do not simply run the Oracle Installer in deinstall mode. Instead, you perform the following tasks:
Backup Oracle Healthcare Data Model, as described in "Exporting Oracle Healthcare Data Model".
Stop any sessions that use the Oracle Healthcare Data Model schemas, as described in "Pre-Deinstallation Tasks".
Execute the deinstallation script, as described in "Deinstallation Script Execution".
If you are deinstalling the sample reports, perform the tasks described in "Post-Deinstallation Tasks".
The deinstallation script removes the ohdm_sys
schema. Consequently, before you run the deinstallation script, ensure that there are no active sessions that connect to the ohdm_sys
schema.
Identifying if the ohdm_sys schema is active
To identify if there are active sessions connecting to the schema take the following steps:
Sign in as DBA.
Execute the following SQL statement:
select SID,SERIAL# from v$session where USERNAME='OHDM_SYS';
If this query returns a session ID, then there is an active session.
Ending an active ohdm_sys schema session
To end an active session, execute the following statements in which you replace sid
and serial
are the session ID and serial number returned by the earlier queries.
alter system kill session 'sid,serial' ;
Set Oracle Home Environment Variable
Set the ORACLE_HOME environment variable to the location of the Database where you want to deinstall Oracle Healthcare Data Model.
For example, suppose that Oracle Home is in the directory /loc/app/oracle/product/11.2.0/
In a Bourne, Bash, or Korn shell, use these commands to set ORACLE_HOME:
$ ORACLE_HOME=/loc/app/oracle/product/11.2.0/ $ export ORACLE_HOME
In a C shell, use this command to set ORACLE_HOME
% setenv ORACLE_HOME /loc/app/oracle/product/11.2.0/
To execute the Oracle Healthcare Data Model deinstallation script:
Execute
$ORACLE_HOME/ohdm/ohdm_deinstall.sh
When prompted, enter the SYSTEM password.
The script de-configures the Oracle Healthcare Data Model and executes the Oracle Installer in deinstall silent mode.
If you are deinstalling the sample reports, once the deinstallation script has executed, perform the tasks described in "Post-Deinstallation Tasks".
If you are deinstalling the Oracle Healthcare Data Model sample reports, follow these steps to perform additional cleanup:
Delete ohdm.rpd
in the directory BIHome
/server/Repository
.
Delete the ohdmwebcat
folder in BIDataHome
/web/catalog
.
Delete the following line from BIHome
/server/Config/NQSConfig.INI
:
Star = ohdm.rpd, DEFAULT