RSS

Category Archives: OBIEE

Installing OBIEE 11.1.1.7.0 on MS windows 7

1         Main steps:

  • Install database “or connect exist certified database”.
  • Install “Create” Oracle Fusion Middleware Repertory.
  • Install OBIEE 11.1.1.7.0

 

2         Listed steps

2.1        Install loopback adaptor, to overcome any connectivity issue.

  1. Open Device Manager from Control Panel.
  2.  From Action menu choose “Add legacy hardware”
  3.  From “Add Hardware” wizard choose “Install the hardware that I manually select from a list”
  4. A list of common hardware choose ”Network adaptors”
  5.  Select “Microsoft” from Manufacturer list then choose “Microsoft Loopback Adaptor”
  6. Press Next to start driver installation, then press Finish to complete the installation.
  7.  Now, give an IP to the net adapter connection, from Control Panel > Network and Sharing Center, click on “Change adapter setting” link from the top left window side.
  8. Right-click on the  “Local Area Connection 2”, Choose “Prosperities” from the menu
  9.  Double-click on “Internet Protocol Version 4 (TCP/IPv4), supply the shown IP (10.10.10.10) and subnet mask (255.255.255.0) in proper fields, Then press “OK”, then “OK”
  10. To edit “hosts” file, Open “Notepad” program as administrator
  11. Locate “hosts” file in directory (C:\Windows\System32\drivers\etc)
  12. Uncomment localhost line, Add the highlighted line

“Assigned IP to loopback adapter <tab> computer name”

 

2.2        Intall Oracle Database 11.2.0.1 to be oracle fusion middleware repository database.

  1. Start the installation from “Setup.exe” file, in “Configure Security Updates”uncheck “I wish to receive…..”, Press Next.
  2. In “Select Installation Option”, choose “ create and configure a database”, press Next
  3.  In “System Class” choose “Server Class” and press Next.
  4.  In “Grid Installation Option” choose “Single instance database installation”, press Next
  5.  In “Select Installation Type” choose “Advanced Install”, Press Next.
  6.  Add “Arabic” language from “Available Languages” in “Select Product Languages” then press Next
  7.  In “Select Database edition” choose “Enterprise Edition”, Press Next.
  8.  In “Specify Installation Location” choose an empty directory e.g. (C:\oracle\db) to be the base directory where all related installation files will be under it.
  9.  In “Select Configuration Type” choose “General Purpose” <as we will use this database to be the fusion middleware repository so general purpose database will be sufficient>, Press Next.
  10. In “Specify Database Identifier” give a name for the database obtain “obidb” for Global database name and  SID, then Press Next
  11.  In “Specify Configuration options” specify the following;
  12.                   i.   In “Memory” tab check “Enable Automatic Memory Management” and reduce the amount to 2048 MB
  13.                 ii.   In “Character Sets” Tab,  Choose “Use Unicode (AL32UTF8)” option
  14.                iii.   In “Security” tab, uncheck “Assert all new security Settings”
  15.               iv.   In “Sample Schemas”, Check “Create database with sample schemas”
  16. In “Specify Management Options”, just press Next.
  17. In “Specify Database Storage Options”, just Press Next.
  18. In “Specify Recovery Options”, just Press Next.
  19. In “Specify Schema Password”, choose “Use the same password for all accounts, supply an alphabetic password of 8 character length: welcome1
  20. A warning message appears if you inter a weak password, press “Yes” to continue with your password anyway.
  21.  A prerequisite check will run, after pass it “Summary”  window will appear, Press “Finish” to start installation
  22. Before finishing the installation a “database Configuration Assistant” window appears to change schema passwords <if you want> just press OK. In ”Finish” window press Close.

2.3        Install RCU

  1. Start Repository Creation Utility from command line, start from directory <rcuHome>\BINà rcu.bat
  2. In “Welcome” window, press Next to start the installation
  3. In “Create Repository”, Choose “Create” then press Next.
  4. In “Database Connection Details”, first choose database type as (Oracle database), supply database hostname, port, service name and username and password of sys, Press Next.
  5. A checking prerequisites window appears, When finish press OK
  6. In “Select Component”, supply a prefix name for all component you will choose (DEV), Then choose the following component:Oracle AS Repository Componentsà AS Common SchemasàMetadata Services; the schema owner will be (DEV_MDS)
  7. Oracle AS Repository ComponentsàOracle Business Intelligenceà Business Intelligence Platform; the schema owner will be (DEV_BIPLATFORM)
  8. A checking prerequisites window appears, When finish press OK
  9. In “Schema Password”, Supply a password (welcome1) in “Use same password for all schemas” option, Then press Next
  10. In “Map Tablespaces” accept all given values and press Next
  11. In “Summary” window review all values and press Create.
  12. After creation completion press Close

2.4        Install OBIEE

  1. Start the installation wizard from setup.exe under bishiphome\Disk1 directory, A welcome screen appears, Press Next to start installation
  2. In “Install Software Updataes”, Choose “Skip Software Update” and press Next
  3. In “Select Installation Type”, select “Enterprise Install” option with install ORACLE_HOME and configure INSTANCE_HOME
  4. In “Create Or Scale Out”, Choose “Create New BI System”, Supply a password(welcome1) for weblogic user, accept other values
  5. In “Specify Installation Location”, Supply “Oracle Middleware Installation Location” which is equivalent to ORACLE_BASE as C:\oracle\MW, Then press Next
  6. If you use a FAT partition a warning message will appears, Press Yes to continue with installation
  7.  In “Configure Component” Choose all available component, then press Next
  8. In “BIPLATFORM Schema” give connection information to repository database, choose (Oracle Database) in Database type, write the connection string as hostname:prot:service_name, supply BIPLATFORM Schema username and password.
  9. In “MDS Schema” as pervious window choose (Oracle Database) in Database type, write the connection string as hostname:prot:service_name, supply MDS Schema username and password
  10. In “Configure Ports”, Choose “Auto Port Configuration” option then press Next
  11. In “Specify Security Update” uncheck “I wish to receive……” then press next.
  12. A confirmation message appears press Yes to continue.
  13. A summary window appears, review it and press Install
  14. While installation “Installation Progress” and “Configuration Progress” windows appears, which takes 20~30 minutes
  15. “Complete” window shows status.
 

Tags: , ,