7 Uninstalling the Cartridge Pack

This chapter contains information on the requirements for uninstalling Oracle Communications Offline Mediation Controller Nortel DMS SMDR cartridge pack.

Uninstalling the Cartridge Pack from a Solaris or Linux Workstation

To uninstall the Real-Time ASCII File Collection CDK cartridge pack from a Solaris or Linux Workstation:

1. Go to the OMC_Home/cartridges directory, where OMC_Home is the directory in which Offline Mediation Controller is installed.

2. Run the following command, which removes the cartridge pack:

   rm smdr_r6_0_0.jar
   

Removing Scripts From the Database

To remove the scripts from the database:

1. Execute Oracle_Home/bin/oemapp dbastudio&

   The Oracle Enterprise Console appears.

2. Log on using the following information:

   • User = system

   • Password = oracle

   • Service = NMCDRS

3. In the left-hand frame, expand the schema directory, then expand the NMUSER1 directory, which lists the subdirectories.

4. Expand the sub-directories one by one as follows:

   • Tables

   • Source Types

   • Packages

   • Procedures

   • Functions

   • Java Sources

   • Java Classes

5. For each of the sub-directories, there are files related to the schema. Right-click on each file and select Remove.

6. Expand the Storage directory and then expand the TableSpace directory. It lists the following:

   • SMDR_MAIN

   • MSLV_<YYYYMMDD> (if partition table got created)

7. Right-click on each item and select Remove.

8. Execute the following command as the system user:

   drop user nmuser1 cascade