Uninstall OBIEE 11g

How to uninstall OBIEE 11g, once it has installed incorrectly.

Refer the procedure section for step by step uninstallation of OBIEE 11g.

1.  Stop all running processes for Admin and Managed servers including BI components services. Stop all the processes, if any, created during service process creation for e.g. Windows Process.

2.  Remove the Weblogic Server using the Un-installation wizard under Control Panel.

3. Perform De-install from Oracle Business Intelligence -> De-install option of Program menu.

4. Drop the RCU schemas using the RCU batch file -> Drop option.

5. Manually remove the RCU Tablespace DBF file (to have a clean new RCU schema) . In this case I didn’t remove the DBF file as the Database server is under DBA’s control .Hence, to be safer side I re-create the RCU during the fresh installation process under different tablespace. This will make sure nothing is going to messed up with your previous installation …

6. De-install Middleware Oracle home (traverse to ..\[MIDDLEWARE_HOME]\Oracle_BI\oui\bin\ and execute below from command line: setup.exe -deinstall).

7. De-install the Middleware common Oracle Home  (traverse to ..\[MIDDLEWARE_HOME]\oracle_common\oui\bin\ and execute below from command line: setup.exe -deinstall –jreLoc  ..\[MIDDLEWARE_HOME]\Oracle_BI1\jdk)

8. Remove the Middleware Home directory with all contents forcefully, if required

9. Remove the environment variable pointing to earlier locations and the relevant paths if any. This is very important step.

10. Re-boot the entire server.

11. Delete the Oracle common keys , if any, from registry. This is Important ! Most of the common problem lies here . So in this case I follow the process of finding my Middleware Home path from Registry and delete all relevant Keys and values . Be careful while playing with registry :)

12. Remove the windows service process key from registry , if any

13. As in my case I don’t need to De-install my Oracle Client/DB Home hence I skip the process as I going to re-use the same Oracle Home in the next installation time.So if you are going to do the same probably you can skip De-installing your Oracle Client/DB home.

Oracle 11g DATABASE INSTALLATION

Download the Oracle 11g Database software from oracle website- http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Step 1: Deselect the option “I wish to receive security updates via My Oracle Support” and click next.

Click Yes

Step 2: Select “Create and configure a database” and then click next

Step 3: Select “Server Class” and then click next

Step 4: Select “Single instance database installation” and click next

Step 5: Select “Advance Install” and click next

Step 6: Select the language you prefer and click next

Step 7: Specify the type of database that yo want to install. I have chosen "Enterprise Edition"

Step 8: Specify the installation location. I kept is as default and click next.

Step 9: Select the type of database that you want to create. I clicked on General purpose and click on next.

Step 10: Specify the Global Database name.

Step 11: Configure Character sets and sample schemas

Click on "Character sets" Tab and select "Use unicode"

Then click on "Sample Schemas" Tab and select "Create database with Sample Schemas"

Step 12: Specify management options.

Step 13: Specify Data storage options.

Step 14: Select to enable or disable automated backups for your database

Step 15: Select "Use the same password for all accounts" and Enter Password. Click next

Repository Creation Utility (RCU) installation

Download the software- http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html
Pre-requisite-
Database should be installed. http://obi4easy.blogspot.com/2013/04/oracle-11g-database-installation.html

Step 1: Run the rcu.bat (Batch file)

Step 2: On create Repository dialog box, select the 'Create' option

Step 3: Specify the connection details

Step 3: Select the components (Oracle Business Intelligence)

Step 4: Type the Schema Password

Step 5: On Map tablespaces dialog box click next

You get the confirmation message. Click ok

Table spaces are created. Click ok

Step 6: You get the summary window. Click on create.

OBIEE 11g (11.1.1.6) Installation

Download the software- http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html
Pre-requisite-
1. Database should be installed. (http://obi4easy.blogspot.com/2013/04/oracle-11g-database-installation.html)
2. Repository creation Utility (RCU) should be installed. (http://obi4easy.blogspot.com/2013/04/repository-creation-utility-rcu.html)

Step 1: In the Install software Updates screen select the option skip software updates

Step 2: Select the Installation type.

Step 3: A pre-requisite check will take place.

Step 4: Click on create a new BI system. Enter the Username, Password and click next. 

Step 5: Specify the Installation Location. Create a folder for OBIEE11g and specify the path and automatically the boxes will be filled. Click next. 

Step 6: In the Configure Components window select the components to be installed

Step 7: Select the Database Type. Enter the connection string. Enter the BIPLATFORM schema username and password. Then click next.

Step 8: Enter the MDS Schema username and Password. Then click next.

Step 9: In the Configure Ports dialog box, select Auto Port Configuration

Step 10: Deselect "I wish to receive security updates via My oracle support" and then click next

Step 11: In the Summary window, click next

Step 12: Check the installation progress.

Step 13: Check the summary.