OBIEE Online Training

OBIEE Online training by ex-Rittman Mead and Oracle trainer.
Contact : naveen@bipracticals.com
Watsapp : +65-82830121
Training will be real time and more hands on.
Number of slots available : 2/5

Tuesday, June 26, 2012

OBIEE 11.1.1.5 installation


Hi guys...I am back with an interesting post on installing OBIEE 11G on your laptop...


My laptop configuration:
OS: Windows7 64-bit
RAM : 4GB
CPU : Intel Core i3,  2.20Ghz


Minimum configuration needed for installing OBIEE 11G:

  • Disk Space(HARD DISK): 20GB or more
  • Available Memory(RAM): 4GB or more
  • Temp Space: 950MB or more
  • Swap Space: 3GB or more
  • CPU: dual-core Pentium, 1.5GHz or greater

Scenario:

I have Oracle 10g Database R2 32-bit and OBIEE 10g(10.1.3.4.2) 32-bit already installed on my laptop.I have to install Oracle Database R2 64-bit and OBIEE 11g(11.1.1.5) 64-bit on my system.

 Only difference while installing OBIEE 11g on a machine already having previous versions of OBIEE installed is that we need to mention the port names during installation by choosing Enterprise installation.Rest everything is same as fresh install.

I upgraded my RAM to 4GB for installing OBIEE11g. Now i am ready to install OBIEE11g on my system.I am planning to install OBIEE 11.1.1.5 on my system.For this i downloaded the following from Oracle website.These are free versions as oracle license is needed only for test and production environments.


INSTALLABLES TO BE DOWNLOADED

1.Java (jdk-6u29-windows-x64 OR higher) 64-bit



2.Oracle Database (Oracle 11g R2) 11.2.0.1.0 64-bit





3.RCU (Repository Creation Utility) 11.1.1.5.0 32-bit.

Note: Run the 32 bit RCU and do 64 bit OBIEE installation . RCU and 11g Installation are independent tasks. RCU Creates a Database and Installation uses it. the common env between these two are only database.
Note: All others except RCU must be 64-bit.If you are planning to use 32-bit Database then OBIEE also must be 32-bit.




4.OBIEE 11G (11.1.1.5.0) 64 bit







Now we are ready to install OBIEE

JAVA


1.Install Java jdk-6u29-windows-x64 .

 

ORACLE DATABASE

 
2.Extract the 2 zip files of Oracle Database (Oracle 11g R2) 11.2.0.1.0 64-bit to a common folder win64_11gR2_database. Note:Extract it to the same folder.Else while installing the database it will error out because some files will be missing. It comes around 2.12GB after unzipping.

 reference links:

3.Delete all the oracle homes created previously to avoid confusion. Don't forget to stop all the Oracle and OBIEE related services before deleting the previously created oracle homes.



 4.Start installing Oracle database by clicking on the setup


5.Select the options as shown below





Give the Global database name.I gave database name as orcl5 and password Admin123.This name will be later used by OBIEE and RCU to connect to this database.So remember this.
All the remaining fields can be kept as default.If you want to change the Software location you can change it.Here i have changed the default software location of dbhome_1 to dbhome_5 because i already used the other home when i tried to install the same database previously.


  Click Next



Oops...I got an error in the above case : oracle MTS recovery service not found
Ignore this error.It is not relevant in this case.




Click on Password Management to unlock the schemas and change the password of the schemas.
I unlocked all the schemas and gave the password as sys for all schemas. This is not recommended in real practice ,but since i am installing it for personal use it is ok.


Oops..error..Ignore the below error.It is because the password sys which i gave is weak. 



 Installation of Oracle 11g R2 database is over.

Check the TNS file for information about the installed database.
TNS Path: C:\app\user\product\11.2.0\dbhome_5\NETWORK\ADMIN
 Note:dbhome_5 is the home directory name given by us during database installation.

 


Now we will run the RCU.

 

RCU


6.The RCU is simply the "Repository Creation Utility". Simply put, the RCU lets you install certain schemas in a database that are required by Fusion Middleware products like Oracle BI EE. These schemas can be installed onto any certified version of database like Oracle Database, IBM DB2, or Microsoft SQL Server. There are schemas that are required by the core components of Oracle Fusion Middleware, while there are schemas that Oracle BI EE requires, like for the Scheduler, for BI Publisher, for the new Scorecard product.
Unzip the downloaded RCU to a folder.

Navigate to the rcuHome\BIN folder and run the rcu.bat file .

The rcu.bat file to be run on a Windows machine

Select "Create" from the option radio-button, and click "Next".
Here you can select an Oracle Database, or click the dropdown to select another database. I will use Oracle Database, obviously.

RCU Welcome Screen

Select the "Create" option

Enter the details where your Oracle Database is running

Host Name: Name or ip of database server
Port: It is by default 1521 provided by oracle for oracle database.
Services Name: Check the service name of your database in tnsname file and give it to service name field.
User name & Password: provide the User name & Password which has dba privileges.
Role: select Role depends upon the user you have given.

Error i encountered here :

Incorrect service name.
Reason: I gave the port number incorrectly.
Correction: Give the details as mentioned in the TNS entries

TNS:

Note : I have used the port number as 1522 here because i already have a Oracle 10g Database installed in my system which has port number 1521.Hence the new Oracle 11g Database which i created will have the port number 1522.You can verify this from the TNS entries.


The below error can be ignored.



 Two metadata repositories are required:
  •    the Metadata Services (MDS)
  •     And Business Intelligence Platform (BIPLATFORM)
Select Metadata Services and Business Intelligence Platform only.

Component Detail ->Select the Oracle Business Intelligence Component. This action automatically selects the Metadata Services (MDS) schema (under the AS Common Schemas group), which is also required by Oracle Business Intelligence. 
8. Schema Passwords -> Use Same Password for all schemas.I used sys as the password for both the schemas.
  
  9.Map Table space


After the schemas are created with no errors, the Completion Summary screen opens. In the Completion Summary screen, click Close.
Congratulations!!! Now you have metadata schema required fro OBIEE installation.

Sort of a post-wrap exercise may be, for those so interested, to launch Oracle SQL Developer, and peek a look at what sort of tables are created by the RCU. If you choose to do so, this is what you would see.
Schemas created by RCU for OBIEE
 The "ANNOT*" tables are used by the Scorecard product.
"QRTZ*" tables are used by BI Publisher, "CALC*", "HSS*" by Essbase and Oracle Hyperion products.
Tables in the RCUOBIEE_BIPLATFORM schema


10. Now that we have created RCU we will go forward with installing OBIEE 11G.

OBIEE

I have OBIEE 10G already installed on my system.I would like to install OBIEE 11G without uninstalling OBIEE 10G. I found the below posts useful for this:


Below are the steps i followed for installing OBIEE 11G.

1.Extract the obiee11g setup.Run the installation setup from Disk 1. 

The below screen appears.Follow the screen-shots given below.



 Select Enterprise install because in this install type there is a option to mention new ports.If we don't do this way the installation will over-write the previously created ports for OBIEE 10g.
Note: I am installing OBIEE 10g and OBIEE 11g on the same machine.Hence i will have to give new port names for OBIEE 11g because the default ports have been used already by OBIEE 10g.
Note: If i am doing a fresh OBIEE 11g installation i will go for Simple Install.
 

 Follow the screen-shots given below.


Here we can specify a user name and password.Unlike OBIEE 10g where the user Administrator used to have all the administrative privileges , in OBIEE 11g we can specify the name of the user who will have Administrative rights.The user name will be weblogic by default.We can change it to any desired name.

The option Scale Out BI System will be used for vertical clustering which is not required here.


Next step would be to give Oracle Middleware Home Location. Click Browse and select any location.
OBIEE11g will be installed into this location.The remaining fields will be populated automatically once you select the Middleware Home path.


Ooops..i got the below error..no problem..click Yes if you get the same error...



 Just click Next and keep going...



Wow...now is the time you have to enter the name of the 2 RCU schemas DEV_BIPLATFORM and DEV_MDU we created earlier.
Also mention the connection string in this format
hostname:portname:servicename

Note here i have used the port 1522 instead of 1521.This is because i have already installed Oracle 10G Database in my system.Hence when i installed Oracle 11G Database it has a new port associated with it ie,1522. We can get these information from the TNS file.
Path: C:\app\user\product\11.2.0\dbhome_5\NETWORK\ADMIN



 

 Now time has come to mention the port name. The default ports have been used by OBIEE10G which we installed previously.We need new port names for OBIEE 11G. For this we need to upload a .ini file containing these port names.
Download the file from the below location:

  
Just click Next and keep going...



Click on Install and it will start installing OBIEE.

 Wait almost 2 hours...don't put your laptop in sleep mode...


Oops...got an error...error is starting opmnctl coreapplication_obips1 failed...ignore this error...click next..



Wakeup guys...hope u didn't sleep..it took around 3 hours for the OBIEE installation to complete.

Now we will try starting OBIEE and playing around with it.

Step1: Click Start BI Services

 Oops i got an error in command line...unable to get file lock..
Note: I ran into this error the first time I restarted Weblogic on one of my installs…

Note: We got the above error because the file is locked.So we will have to go to the path and delete the lock file so that we can start the presentation services.
Navigate to the path : <OBIEE HOME>/C:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp
and delete the “AdminServer.lok” file .


Reference:




Wow..its done...now we can start enjoying OBIEE...
Type the following paths:

Component
Web link
Presentation
http://machine_name:7001/analytics
Enterprise Manger
http://Machine_name:7001/em
Weblogic(Console)
http://Machine_Name:7001/console

In my case paths were different as my ports were different. I have to give the port names i gave during installation.

Component
Web link
Presentation
http://user-VAIO:8704/analytics
Enterprise Manger
http://user-VAIO:6001/em
Weblogic(Console)
http://user-VAIO:6001/console

Enterprise Manager:



Presentation:


Weblogic Console:



Till next time...bye.. :)
Don't forget to put comments below.Your feedback and doubts are valuable.


20 comments:

  1. Hey Naveen ,

    regarding the FAT file system error during the installation is Oracle identified "Bug 13801681: WARNING: FAT FILE SYSTEM WHEN INSTALLING OBIEE 11.1.1.6.0 " and this is nothing to do with your one or multiple partition and Partition type . As you are installing 64 bit version by default this will be think of as NTFS partition as FAT is become obsolete nowadays .

    So just thought to correct you :)
    Thanks,
    DxP

    ReplyDelete
    Replies
    1. Hi Debashis,

      Thanks for correcting me.I have deleted the old statement.Hope to get your support in the future as well.

      Thanks,
      Naveen

      Delete
  2. Hello friends.

    I am unable to delete AdminServer.lok file . When i am trying to delete it shows the message that the action cant be completed because the file is open in java.exe. can you please help me to delete this file and this file is secured..

    ReplyDelete
  3. Hi Sunil,

    Stop BI Services first and then try deleting this file. If still you are not able to delete it then stop java.exe from task manager and then delete the file.Now restart it.

    For information regarding stopping bi services see stop bi services in the page:

    http://pagelock.blogspot.in/2012/07/starting-opmn.html

    Best Regards,
    Naveen

    ReplyDelete
  4. Hi Naveen,

    I an unable to use drag and drop option in presentation ie analystic..

    First time I was able use drag and drop option, but once I had stopped and started OBIEE services.. it is not working..

    Please help me

    ReplyDelete
  5. Try to include the column in the criteria by double clicking(or single clicking) on it.

    ReplyDelete
  6. Hi Naveen,
    I am installing obiee 11g on windows 7 bit system.
    While insatlling obiee ASInstance step failed. opmnctl start: failed.
    Can not resolve xxxxx (machine name ) for interface any. How to resolve this error

    -YSM

    ReplyDelete
    Replies
    1. You can ignore this error while installing and continue with the rest of installation.After completing the installation do the following:

      Stop the bi services.After stopping ensure that the status of all components are "Down". Now start the bi services.Ensure that the status of all components are "Alive". Now you will be able to open the analytics page.

      For starting and stopping bi services refer this link:

      http://pagelock.blogspot.in/2012/07/starting-opmn.html

      Delete
  7. I am installing obiee11g and getting following error : Creating ASInstance failed :

    Executing Task: Creating ASInstance
    Trying to assign 3 consecutive ports where the starting port range is: 9500 - 10000
    AdminServer port is 7001
    trying to connect to DELMW58220 7001
    Successful
    getDomainRuntimeMBeanServerConnection ...
    Connecting to Domain runtime ...
    trying to connect to DELMW58220 7001
    Successfully connected to the Domain Runtime ...
    trying to connect to DELMW58220 7001
    Successful
    MBean Server Connection is :javax.management.remote.rmi.RMIConnector$RemoteMBeanServerConnection@1e5503d
    DELMW58220 7001
    weblogic.Deployer invoked with options: -adminurl DELMW58220:7001 -username weblogic -name NonJ2EEManagement -source C:\OBIEE\Oracle_BI1\opmn\applications\NonJ2EEManagement.ear -nostage -deploy -upload -noexit
    <12-Dec-2012 12:29:05 o'clock IST>
    oracle.as.provisioning.exception.ASProvisioningException
    Caused by: oracle.as.provisioning.engine.CfgWorkflowException
    Caused by: oracle.as.provisioning.util.ConfigException:
    Error creating ASInstance instance1.
    Cause:
    An internal operation has failed: Unable to validate NonJ2EEManagement Application deployment on admin server.
    Action:
    See logs for more details.
    Caused by: oracle.as.config.ProvisionException: Unable to validate NonJ2EEManagement Application deployment on admin server.
    Caused by: oracle.as.config.utl.DeployerException: NonJ2EEManagement Applicationdeployment failed.
    Caused by: java.lang.reflect.InvocationTargetException
    Caused by: weblogic.Deployer$DeployerException: weblogic.deploy.api.tools.deployer.DeployerException: PermGen space
    Caused by: weblogic.deploy.api.tools.deployer.DeployerException: PermGen space
    Caused by: java.lang.OutOfMemoryError: PermGen space

    Please suggest how should i proceed.

    ReplyDelete
  8. I followed your steps... but at last i faced this issue. help me out.

    11g 11.1.1.5.0 step 14 configuration progress
    following failed
    creating ASihnstance
    opmnctl start
    opmnctl start coreapplication_obiccs1
    opmnctl start coreapplication_obis1
    opmnctl start coreapplication_obips1
    opmnctl start coreapplication_obijh1
    opmnctl start coreapplication_obisch1
    plese help me. em and console is opening .if i try to start all the services in coreapplication following error occurs
    error log
    failed to get Messages for target /farm_bifoundation_domain/instance1/coreapplication_obis1,/farm_bifoundation_domain/instance1/coreapplication_obiccs1,
    /farm_bifoundation_domain/instance1/coreapplication_obisch1,/farm_bifoundation_domain/instance1/coreapplication_obips1,/farm_bifoundation_domain/instance1/coreapplication_obijh1

    ReplyDelete
  9. Hi thnks for your wonderful post it helped me a lot in installing 11g on my lappy.
    I encountered an issue, am unable to logic in wl,em,presentaion services plz help in resolveing this and let me know the urls for the same.

    NQS Error[73001]:Cannot connect to primary Cluster Controller (01w441425:8706) or the secondary cluster controller (:9706) specified for the clustered DSN..

    ReplyDelete
  10. hi,

    I have been struggling to install OBIEE, getting the following error in BI Configuration in Create Domain step. Would appreciate help.

    [2013-06-02T09:52:35.162-04:00] [as] [ERROR] [] [oracle.as.provisioning] [tid: 24] [ecid: 0000Jw5A9tg7i4WFLzyGOA1Heo1T00000F,0] [[
    oracle.as.provisioning.exception.ASProvWorkflowException: Error Executing workflow.
    at oracle.as.provisioning.engine.WorkFlowExecutor._createDomain(WorkFlowExecutor.java:686)
    at oracle.as.provisioning.engine.WorkFlowExecutor.executeWLSWorkFlow(WorkFlowExecutor.java:391)
    at oracle.as.provisioning.engine.Config.executeConfigWorkflow_WLS(Config.java:866)
    at oracle.as.install.bi.biconfig.standard.StandardWorkFlowExecutor.executeHelper(StandardWorkFlowExecutor.java:31)
    at oracle.as.install.bi.biconfig.standard.DomainProvisioningTask.doExecute(DomainProvisioningTask.java:49)
    at oracle.as.install.bi.biconfig.standard.AbstractProvisioningTask.execute(AbstractProvisioningTask.java:70)
    at oracle.as.install.bi.biconfig.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:66)
    at oracle.as.install.bi.biconfig.BIConfigMain.doExecute(BIConfigMain.java:113)
    at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:375)
    at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)
    at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:105)
    at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
    at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:96)
    at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:186)
    at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81)
    at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:86)
    at java.lang.Thread.run(Thread.java:662)

    Vinod

    ReplyDelete
  11. Hi Naveen,

    IS it possible to install oracle database + obiee 11g on 2GB RAM system

    ReplyDelete
  12. really good piece of information, I had come to know about your site from my friend shubodh, kolkatta,i have read atleast nine posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again, Regards, obiee training in hyderebad

    ReplyDelete
  13. I am facing a problem in installation of Oracle BI Enterprise Suite 11.1.1.6
    When i click button "Install", after 13% completion, a prompt pop-up having title "Disk Change dialog":
    "Enter the disk with label Oracle Fusion Middleware Business Intelligence 11g and disk number 3&4 or browse to the location containing files for the disk, then press OK"

    When i ignore it:

    Error Message comes:

    Installation Failed. OUI Session failed OUI-10208:Unable to find the product files specified by the disk labelled 'Oracle Fusion Middleware Business Intelligence 11g'. Unable to continue installation, please check the value specified in variable FROM_CD_LABEL matches with the value in file 'disk.label', or please check if the disk is accessible.

    From Download link, whether 32 bit or 64 bit, has only Disk1 and Disk2

    From where i bring up Disk3 Or how i fix that problem?

    ReplyDelete
  14. Copy all the disks under one directory

    ReplyDelete
  15. This webpage dates back to Tuesday, June 26, 2012 (OBIEE 11.1.1.5 installation).
    Does it apply to latest version ( Oracle Business Intelligence 12c (12.2.1.3.0) ).
    http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/index.html

    ReplyDelete
  16. Oracle Business Intelligence 12c (12.2.1.3.0) Downloads
    http://www.oracle.com/technetwork/middleware/bi/downloads/default-3852322.html

    ReplyDelete
  17. Installing Oracle Database 12c on Windows:
    http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/Windows_DB_Install_OBE/Installing_Oracle_Db12c_Windows.html

    ReplyDelete

Thank you

- Naveen