uninstalling OBIEE

updated: 13 Feb 2014

Includes information about version 11.1.1.7 and Windows registry entries.

Summary of de-installation from Oracle docs.

1. Run the deinstall script and select the Deinstall instances managed by a WebLogic domain option.
2. Stop all Oracle Business Intelligence processes and servers, including all OPMNcontrolled components and JEE components.
3. Drop the Metadata Services (MDS) and Business Intelligence Platform (BIPLATFORM) schemas using RCU.
4. Run the deinstall script and select the Deinstall the Oracle home option.
5. Deinstall the Oracle Common home manually or by running the deinstall script that it contains.
6. Use the Oracle WebLogic Server uninstaller to uninstall WebLogic Server.
7. Remove the Oracle home (if necessary).
8. Remove the Middleware home and any other homes (Domain home, Applications home, and Instance home) that might have been installed outside of the

Deinstall weblogic server managed instances:

Run the deinstall script and select the Deinstall instances managed by a WebLogic domain option. Make sure OBIEE services are running, before you proceed.

Go to $ORACLE_HOME\oui\bin (e.g. D:\OBIEE11g\Oracle_BI1\oui\bin ) and execute this command

D:\OBIEE11g\Oracle_BI1\oui\bin>setup –deinstall

Stop all OBIEE services.

Go to http://localhost:7001/em - > Business Intelligence -> core application and stop all components.

Go to http://localhost:7001/console

Domain structure -> deployments link -> control tab

Select all components and stop them

Customize the table to display all process (all 61 processes) and then select all. It will stop the processes and exclude the libraries. This is ok.

Note: On Windows machine you can stop all services from the services control panel.

Drop the Metadata Services (MDS) and Business Intelligence Platform (BIPLATFORM) schemas using RCU.

Run RCU.bat file from RCU_HOME\bin (e.g. F:\OBIEEInstall\rcuHome\BIN ).

Remove the oracle home (oracle BI HOME).

Run the deinstall script and select the Deinstall the Oracle home option.

Got to D:\OBIEE11g\Oracle_BI1\oui\bin and run setup.exe –deinstall

 

Deinstall the Oracle Common home

Go to MW_HOME\oracle_common\oui\bin   (e.g. D:\OBIEE11g\oracle_common\oui\bin )

Run

setup.exe -deinstall -jreLoc full_path_of_jre_or_jdk

specify the JDK directory that was created by Oracle Business Intelligence 11g Installer in the Middleware home. (in my case D:\OBIEE11g\jdk160_24)

D:\OBIEE11g\oracle_common\oui\bin>setup.exe -deinstall -jreLoc D:\OBIEE11g\jdk16

0_24

note:

1. You can specify any compatible jdk path. But the uninstall utility has a problem with spaces in the file path,  therefore ensure that jdk is installed in a path without spaces.
2. I noticed while uninstalling 11.1.1.7.0 the jdk directory is deleted by the uninstaller. In such cases you can install a compatible jdk into a directory without spaces and specify this new path in the deinstall command above.

uninstall WebLogic Server

if you are uninstalling on Windows,

run uninstallNodeMgrSvc.cmd from the following directory in your WebLogic Home:

WL_HOME\server\bin\uninstallNodeMgrSvc.cmd  (for example : D:\OBIEE11g\wlserver_10.3\server\bin\uninstallNodeMgrSvc.cmd )

Open a command prompt and go to Middleware Home -> utils –> uninstall, and execute “uninstall  -mode=console”

D:\OBIEE11g\wlserver_10.3\server\bin>cd D:\OBIEE11g\utils\uninstall

D:\OBIEE11g\utils\uninstall>uninstall -mode=console

Note: If you get a message like “The system cannot find the path specified.”, it means the uninstaller cannot find the path to the java home that is set in the uninstall.cmd file. you should edit this file to make it point to the new jdk home.

Manually delete the MW_HOME (middleware home) directory. On Windows you may want to use a program like ccleaner to clean up your system and reboot.

Cleaning up the Windows Registry Entries:

• It is advisable to make registry backup before you do this.
• go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI and delete the stale and unnecessary odbc entries (like coreapplication_OH1974671976).
• also delete similar entries in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
• listed below the key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI delete all driver entries that were installed by OBIEE.
• After deleting the entries, you can verify by checking that these entries are no longer listed in the system DSN tab of the ODBC dialog box(which can be opened from the Windows control panel)