iSimplyShare.com

Sharing is caring :)

By

OBIEE 11g simple installation on Windows

OBIEE 11g installation on windows machine is done in 2 parts :
  1. Creating the repository using RCU (Repository Creation utility)
  2. Installing OBIEE 11G
Pre-requisites :
  1. Availability of Oracle database
  2. Setup files for OBIEE 11g
Installation Process:
  • Unzip the RCU zip file into some directory and run the rcu.bat under BIN directory. Start the database before running the RCU; this will install the BI and Metadata schema.
Welcome Screen

Welcome Screen

  • Click Next.
Create Repository Screen

Create Repository Screen

  • Create to create component schemas in the database.
  • Drop to remove component schemas from the database.
  • Select Create and click next.
Database Connection Details Screen

Database Connection Details Screen

Specify the connection details for your Oracle database.

  1. a.      Host Name

Enter the name of the server where your database is running.

  1. b.      Port

Enter the port number for your database. The default port number for Oracle databases is 1521.

 

  1. c.       Database Name

Specify the service name for the database. Typically, the service name is the same as the global database name.

  1. d.      Username

          Enter the user name for your database. The default user name is SYS.

  1. e.       Password

         Enter the password for your database user.

  1. f.       Role

         Select the database user’s role from the drop-down list:

  • Normal
  • SYSDBA

The SYS user requires the SYSDBA role. All other users would use the Normal role.

  • Click next to continue.

OBIEE

  • Oops! Warning!! . My Oracle database version is 10.2.0.2.0, while it is required minimum 10.2.0.4. Any way I clicked the ignore, so you can do the same or get the right version.

OBIEE

  •  Click ok to continue to next page.
Select Components Screen (for Create Operation)

Select Components Screen (for Create Operation)

  • You can select an existing prefix or select the next prefix.
  • Check the Oracle Business Intelligence. Please note down the schema name. You will need it during OBIEE installation. It is DEV1_BIPLATFORM in this case. Metadata Services is already checked for you
  • Click Next.
Check Schema Prerequisites

Check Schema Prerequisites

  • Click ok to continue to next page.
  • If an error occurs during the prerequisite checking, the error message(s) appear in the Messages field on the Select Components screen.
  • Click OK to dismiss this screen.
Schema Passwords Screen

Schema Passwords Screen

  • There are three ways to specify schema passwords on this screen:
    • Use same password for all schemas
    • Use main schema passwords for auxiliary schemas
    • Specify different passwords for all schemas
    • Click next when you are finished.
Map Table spaces Screen

Map Table spaces Screen

  • This screen only appears if you selected the Create option on the Create Repository Screen
  • Click next when you are finished with your table space information. The following screen appears, asking you to confirm the creation of table spaces for any new schemas.

OBIEE

  • Click OK to continue. The following screen appears, indicating the programs of the table space creation.

OBIEE

  • Click Stop to cancel table space creation. When the table spaces are created,
  • Click OK to dismiss this window.
Summary Screen (for Create Operation)

Summary Screen (for Create Operation)

  • Review the information on this screen, and click Create to begin schema creation. The operations summarized on this page will be performed when you click Create.
Completion Summary Screen (for Create Operation)

Completion Summary Screen (for Create Operation)

  • Review the information on this screen, and then click Close to dismiss this screen.

OBIEE Installation

The second part is OBIEE installation

  • Unzip all 4 zip files in one folder and open the Disk1 folder and run the setup.exe

OBIEE

Welcome Screen

Welcome Screen

  • Click next.
  • There are two types for software updates:

i.            Skip Software Updates

ii.            Search for the existing software

  • Skip Software Updates

              It allows you to skip for the software updates.

  • Search for the existing software

             It allows you to search for the existing Oracle Software.

  • Click appropriate option and click next.
Software Update Screen

Software Update Screen

Types Of Installation Screen

Types Of Installation Screen

  • Select the simple installation and Click next.
Prerequisite Checks Screen

Prerequisite Checks Screen

  • Click next.
Location Screen

Location Screen

  • Specify the location, where you want to install the software.
  • Make sure it has around 11 GB free disk space.
Administrator Details Screen

Administrator Details Screen

  • Select the username, password for web logic server, the same user id and password will be use to access the OBIEE.
  • Click Next.
Configuration Screen

Configuration Screen

  • Select the component.
  • Click next.
BIPlatform screen

BIPlatform screen

  • Enter the Database details where we have installed the BI schema through RCU.
  • Enter a user name and password.
  • Connection String :
    • Enter the connection String in the Format of
Hostname: port:servicename
  •  Click next.
Security Update Screen

Security Update Screen

  • Enter the required details and Click next.

Summary Screen

  • Review the installation summary and click install.
  • After clicking the Install button, Installation process will start.
Installation Screen

Installation Screen

  • The process will take some time.
  • The installation will take around 20 minutes. It could be more or less depending on the available resources.
  • In the middle of the process you may see a blank command window.
Configuration Progress

Configuration Progress

The next step is Configuration Progress; this will automatically start after completion of installation.

  •  Click the next button.
  • Finally the configuration 100% completed.
ORACLE  Business Intelligence Login Page

ORACLE Business Intelligence Login Page

Enter User Id: weblogic

Password: Password you have set

Faisal Memon

Hey, Thanks for reading !!
I am Faisal Memon, creator of FreeITProjects.org and iSimplyShare.com

Read more about me over here – http://faisalmemon.com/

Facebook Twitter 

  • WelcomeScreenOBIEE
  • Create Repository Screen
  • Database Connection Details Screen
  • OBIEE1
  • OBIEE1
  • Select Components Screen (for Create Operation)
  • Check Schema Prerequisites
  • Schema Passwords Screen
  • Map Table spaces Screen
  • OBIEE
  • OBIEE
  • Summary Screen (for Create Operation)
  • Completion Summary Screen (for Create Operation)
  • OBIEE
  • Welcome Screen
  • Software Update Screen
  • Types Of Installation Screen
  • Prerequisite Checks Screen
  • Location Screen
  • Administrator Details Screen
  • Configuration Screen
  • BIPlatform screen
  • Security Update Screen
  • Summary Screen
  • Installation Screen
  • Configuration Progress
  • ORACLE  Business Intelligence Login Page
  • sunil

    thanks

    • Faisal Memon

      Welcome :) !!