8 Removing the Local Database

This chapter contains the following topics:

8.1 Deinstalling the OEE 11gR2 Local Database

When OEE was installed, it was installed into a subdirectory called "E1Local" under a base directory. By default, this base directory is C:\Oracle. This means that the database was installed into c:\Oracle\E1Local by default.This path is used in the deinstall steps listed below.

Follow these steps to deinstall the OEE 11gR2 local database.

  1. Stop the database services from Control Panel:

    • OracleE1LocalTNSListener

    • OracleServiceE1LOCAL

  2. Be sure no Oracle processes from the c:\Oracle\E1Local directory are running.

  3. Open a command prompt window with "Run as administrator."

  4. Run this program:

    c:\Oracle\E1Local\deinstall\deinstall.bat

    Note:

    It is important that you do not "cd" to any directory below c:\Oracle to run this command. If you do make one of these directories the current directory, the OUI deinstaller will not be able to delete that directory.
  5. During installation, the OEESetup.exe program should have created several files in the c:\Oracle\E1Local\deinstall directory. If the files were successfully created, the deinstall.bat program will not prompt for any input from the user. If for some reason the files were not created, the deinstall.bat program will prompt the user for information needed to deinstall the database. You can take the default values (shown in square brackets) for most of the prompts. These are the prompts:

    1. Specify all Single Instance listeners that are to be de-configured [LISTENER]:

    2. Specify the list of database names that are configured in this Oracle home [E1LOCAL]:

    3. Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database) [1]:

    4. Specify the diagnostic destination location of the database [c:\Oracle\diag\rdbms\e1local]:

    5. Specify the storage type used by the Database ASM|FS []:

      This prompt requires a response. Enter FS.

    6. Specify the list of directories if any database files exist on a shared file system. If 'E1LOCAL' subdirectory is found, then it will be deleted. Otherwise, the specified directory will be deleted. Alternatively, you can specify list of database files with full path [ ]:

    7. Specify the flash recovery area location, if it is configured on the file system. If "E1LOCAL" subdirectory is found, then it will be deleted. []:

    8. Specify the database spfile location [ ]:

    9. Do you want to continue (y - yes, n - no)? [n]:

      This requires a response. Enter "y".

      Important: If you go through the above prompts, you also need to delete the registry key \HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_E1Local.

  6. When the deinstall finishes, be sure that the c:\Oracle\E1Local directory no longer exists. If it does, you will need to manually delete it.

    Caution:

    It is very important that no files exist in the E1Local subdirectory when you next attempt to install the OEE database. If any files do exist, the OEE installation will probably fail.

    If the database does not deinstall cleanly for some reason, you will need to manually remove it. Follow the instructions in the Appendix of this guide entitled: Appendix C, "Manual Cleanup of a Deinstalled Oracle Database".

8.2 Deinstalling the OEE 10g Local Database

When OEE was installed, it was installed into a subdirectory called "E1Local" under a base directory. By default, this base directory is C:\Oracle. This means that the database was installed into c:\Oracle\E1Local by default. This path is used in the deinstall steps listed below.

Follow these steps to deinstall the OEE 10g local database.

  1. Stop the database services from Control Panel:

    • OracleE1LocalTNSListener

    • OracleServiceE1LOCAL

  2. Be sure no Oracle processes from the c:\Oracle\E1Local directory are running.

  3. From the Start button, navigate to Programs > Oracle - E1Local > Oracle Installation Products > Universal Installer

  4. Click the Deinstall Products… button.

  5. Turn on the check box next to the E1Local database's Oracle Home.

  6. Click the Remove… button.

  7. When prompted for confirmation, click the Yes button.

When the deinstall finishes, be sure that the c:\Oracle\E1Local directory no longer exists. If it does, you will need to manually delete it.

Caution:

It is very important that no files exist in the E1Local subdirectory when you next attempt to install the OEE database. If any files do exist, the OEE installation will probably fail.

If the database does not deinstall cleanly for some reason, you will need to manually remove it. Follow the instructions in the appendix of this guide entitled: Appendix C, "Manual Cleanup of a Deinstalled Oracle Database".

8.3 Uninstalling the SSE Local Database

To uninstall the SSE local database:

  1. From the Start button, navigate to Control Panel / Programs and Features.

  2. Right-click on Microsoft SQL Server 2005 and select Uninstall.

  3. Follow the prompts to remove all components.

  4. At the Programs and Features screen, likewise uninstall any other products and features that contain the string "SQL Server 2005."