10 Uninstall the Oracle Argus Mart Application

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

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

   <ArgusMart_HOME>\Disk1\install

   The Welcome screen appears.

2. Click Deinstall Products.

   The Inventory screen appears.

3. In Contents tab, expand Independent Products.

   The list of Independent Products appears.

4. Select Oracle Argus Mart <version number> check box.

   Note the installation location displayed under the Product Information frame.

   For example:

   Location C:\ArgusMart822\oracle.hsgbu.am specifies installation path as C:\ArgusMart822
5. Click Remove.

   A confirmation message appears.

6. Click Yes.

   A progress bar appears and subsequently removes Oracle Argus Mart from the list of Independent Products.

7. Click Close to exit from the Inventory screen.
8. Click Cancel in the Oracle Universal Installer screen to exit.
9. Delete the folder, where the Oracle Argus Mart was installed, from the local file system.

   Example: C:\AM

10. Navigate to ...\ArgusMart\Database\DBInstaller.
11. Right-click Oracle Argus Mart, and from the drop-down menu, click Delete.
12. To Remove Database Components for Oracle Argus Mart:
    1. Remove Database Schemas from Oracle Argus MartDatabase.

       Connect to SYSTEM or DBA user of Oracle Argus Mart Database, and execute the following commands to drop Oracle 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;
       

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

       Connect to SYSTEM or DBA user of Argus Safety Database.

       connect SYSTEM/<password>@<ArgusSafetyDB>
       DROP USER "AS_MART_USER" CASCADE;

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

    ..\network\admin\tnsnames.ora

14. Restart the system.

    Note:

    If you are re-installing Oracle 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 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.