9 Uninstalling the Argus Mart Application

This section of the guide introduces you to the procedure to uninstall the Argus Mart application.

To uninstall the Argus Mart application, execute the following steps:

Double-click Setup.exe to open the Oracle Universal Installer, available at the following location:

<ArgusMart_HOME>\Disk1\install

The Welcome screen appears.
Click Deinstall Products.

The Inventory screen appears.
In Contents tab, expand Independent Products.

The list of Independent Products appears.
Select Oracle Argus Mart <version number> check box.

Note the installation location displayed under the Product Information frame.

For example: Location C:\ArgusMart81\oracle.hsgbu.am specifies installation path as C:\ArgusMart81
Click Remove.

A confirmation message appears.
Click Yes.

A progress bar appears and subsequently removes Argus Mart from the list of Independent Products.
Click Close to exit from the Inventory screen.
Click Cancel in the Oracle Universal Installer screen to exit.
Delete the folder, where the Argus Mart was installed, from the local file system.

Example: C:\AM
Navigate to start > All Programs > Oracle > Oracle Argus Mart.
Right-click Oracle Argus Mart.

A drop-down menu appears.

Figure 9-1 Deleting Oracle Argus Mart through Start Menu
Click Delete.

To Remove Database Components for Argus Mart:

Remove Database Schemas from Argus Mart Database.

Connect to SYSTEM or DBA user of Argus Mart Database, and execute the following commands to drop Argus Mart Users, Tablespaces, and other objects.

connect SYSTEM/<password>@<ArgusMartDB>

DROP USER "AM_APP_USER" CASCADE;
DROP USER "AM_BI_USER" CASCADE;
DROP USER "AM_ETL_USER" CASCADE;
DROP USER "AM_MART_USER" CASCADE;
DROP USER "AM_STAGE_USER" CASCADE;
DROP USER "AM_VPD_USER" CASCADE;

DROP ROLE "AM_VPD_ADMIN_ROLE";

DROP PUBLIC SYNONYM "RM_CMN_PROFILE_GLOBAL";

ALTER TABLESPACE "AM_APP_DATA_01" COALESCE;
ALTER TABLESPACE "AM_APP_INDEX_01" COALESCE;
ALTER TABLESPACE "AM_APP_LOB_01" COALESCE;
ALTER TABLESPACE "AM_MART_DATA_01" COALESCE;
ALTER TABLESPACE "AM_MART_INDEX_01" COALESCE;
ALTER TABLESPACE "AM_MART_LOB_01" COALESCE;
ALTER TABLESPACE "AM_STAGE_DATA_01" COALESCE;
ALTER TABLESPACE "AM_STAGE_INDEX_01" COALESCE;
ALTER TABLESPACE "AM_STAGE_LOB_01" COALESCE;

DROP TABLESPACE AM_APP_DATA_01 INCLUDING CONTENTS;
DROP TABLESPACE AM_APP_INDEX_01 INCLUDING CONTENTS;
DROP TABLESPACE AM_APP_LOB_01 INCLUDING CONTENTS;
DROP TABLESPACE AM_MART_DATA_01 INCLUDING CONTENTS;
DROP TABLESPACE AM_MART_INDEX_01 INCLUDING CONTENTS
DROP TABLESPACE AM_MART_LOB_01 INCLUDING CONTENTS;
DROP TABLESPACE AM_STAGE_DATA_01 INCLUDING CONTENTS
DROP TABLESPACE AM_STAGE_INDEX_01 INCLUDING CONTENT
DROP TABLESPACE AM_STAGE_LOB_01 INCLUDING CONTENTS;

Remove Argus Mart Schema on Argus Safety Database (AS_MART_USER) from Argus Safety Database created for Argus Mart.

Connect to SYSTEM or DBA user of Argus Safety Database.
```
connect SYSTEM/<password>@<ArgusSafetyDB>
DROP USER "AS_MART_USER" CASCADE;
```

Remove the TNS entry of the Argus Mart database from the given Oracle Home path (see Section 2.2 > Step 6) located at

..\network\admin\tnsnames.ora

Restart the system.

Note:

If you are re-installing Argus Mart on the same server, you must provide the same folder path that was specified during the previous installation process.

For example, if you installed Argus Mart at the C:\AM location and uninstall it using the steps mentioned above, you must enter the same folder path (for example, C:\AM) that was entered in the previous installation process.