6 Removing Oracle Role Manager Software

This chapter describes the process of removing Oracle Role Manager software. It contains the following sections:

Removing Oracle Role Manager Software

This section describes general instructions for UNIX-based systems and Windows systems.
Removing the Oracle Role Manager Database

This section describes specific instructions for dropping the Oracle Role Manager database users/schemas.

6.1 Removing Oracle Role Manager Software

Use the following procedure to uninstall the Oracle Role Manager software:

Run the Oracle Universal Installer as follows:

For UNIX-based systems, run the command from $ORACLE_HOME/oui/bin:

./runInstaller -deinstall -silent REMOVE_HOMES={"$ORACLE_HOME"} from $OH/oui/bin

For example,

$ORACLE_HOME/oui/bin/runInstaller -deinstall -silent REMOVE_HOMES={"/scratch/ORMHome_1"}

For Windows systems, run the following command from $ORACLE_HOME\oui\bin:

setup.exe -deinstall -silent REMOVE_HOMES={"$ORACLE_HOME"} from $OH\oui\bin

For example,

<ORACLE_HOME>\oui\bin\setup.exe -deinstall -silent REMOVE_HOMES={"C:\orm123"}

As an alternative for Windows systems, start Oracle Universal Installer from the Start menu. On the Welcome page, click Deinstall Products to bring up the Oracle Inventory screen.

Select the Oracle home directory and the products that you want to remove by selecting the desired check boxes, then click Remove. The Confirmation window appears. Click Yes to remove the selected components.

After the Oracle Role Manager components are removed from your system, the Oracle Inventory page appears without the removed components. Click Close to close the Oracle Inventory page. Click Cancel to exit Oracle Universal Installer. Click Yes to confirm that you want to exit.
Clean up the old Oracle directories.

On systems where Oracle Role Manager is the only Oracle software installed, navigate to the directory for oracle, then remove the directory.

For UNIX-based systems, use the rm -r command.

Otherwise, delete the Oracle Role Manager home.

For UNIX-based systems, issue the following command to confirm there is no other Oracle home installed.
```
$ grep 'HOME NAME' OraInventory/ContentsXML/Inventory.xml
```
Remove the deployments of the Oracle Role Manager server and Web UI from the application server, as appropriate to the application server.

6.2 Removing the Oracle Role Manager Database

Use the following procedure to remove the Oracle Role Manager database:

As the Oracle SYSTEM user, using sqlplus or similar utility, drop the Oracle Role Manager database owner.

Check if there are active sessions from users using the following commands:

select sid,serial# from v$session where username = 'ORM_DB_OWNER';
select sid,serial# from v$session where username = 'ORM_APP_USER';

Drop the Oracle Role Manager application user using the following commands:
```
drop user ORM_APP_USER cascade;
drop user ORM_DB_OWNER cascade;
```

Drop the Oracle Role Manager tablespaces using the following commands.

DROP TABLESPACE ORM_UNDO INCLUDING CONTENTS AND DATAFILES CASCADE
CONSTRAINTS;
DROP TABLESPACE ORM_TEMP INCLUDING CONTENTS AND DATAFILES CASCADE
CONSTRAINTS;
DROP TABLESPACE ORM_INDEX INCLUDING CONTENTS AND DATAFILES CASCADE
CONSTRAINTS;
DROP TABLESPACE ORM_DATA INCLUDING CONTENTS AND DATAFILES CASCADE
CONSTRAINTS;
commit;