Thursday, September 2, 2010

Oracle BI Publisher 11G Installation

Have you already installed BI Publisher 11G and started playing around ? Well, as much as I was excited about the release news when I came back from my big vacation, I had a bit of bumps on the road of installing until logging into the initial home page. First, I couldn’t proceed on the installer wizard steps more than step 4, then after having fixed the problem I still couldn’t start some BI services and then couldn’t open BI Publisher login window.

Well, finally figured out the root cause of the issue and its solution. Basically, that my PC environment was Windows XP on a VM (Parallel/Mac) and it’s running on DHCP. And the installer and some components (it’s BI Cluster Controller Server) don’t like it. So I needed to install a Loopback Adaptor and setup a static IP address, and then register that with machine name in Window’s etc/host file properly.

After that is done and cleared up the failed installation completely, the installation worked like a charm. It took about one hour or so and was so smooth that I don’t even remember what I was frustrated about! Anyway, hope your installation went smooth without hassle like the ones I had. But if it didn’t you might want to proceed reading and hope this helps you to get going.

Installation

In order to install BI Publisher 11G you need to get the BIEE 11G installation  package either from OTN or eDelivery. Then you create a repository in your database by using RCU (Repository Configuration Utility) before you start installing the BIEE 11G.  I’m not going to talk about the detail steps of the installation here, you can find many posts on other blogs out there or the installation guide about such detail steps with screenshots. The installation steps itself is pretty simple. However, if your network is not configured well then you will get in trouble big time. So make sure your network configuration before you start installing BI 11g.

Network Configuration

This is mandatory and really critical thing to do especially when you are trying to install onto your laptop or PC desktop with DHCP setting.

Basically there are three things to do before the installation in terms of the network setting.

  1. Make sure if you have installed MSFT loopback adapter.
  2. Set a static IP address to the loopback adapter network.
  3. Set the C:\WINDOWS\system32\drivers\etc\host file with a computer name and the static address you set to the loopback adapter.

All the detail can be found in this Oracle Database 11GR2 Installation guide. Click the link, it gets you directly to the network configuration section.

But one tricky thing is a domain name for your machine name such as ‘us.oracle.com’. If you are not sure about the domain name then don’t include it in the etc/host file. My example is below.

# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host

127.0.0.1       localhost

127.0.0.1       .psf

10.10.10.10   knishida-vm1 

Make sure you reboot your machine once you have set the network configuration, then start the BI11g installation. Without this proper setting you will hit the following issues:

1. You can't proceed the installation steps after where you type username/password for weblogic user.
2. Your ClusteringControler or PSServer doesn't start
3. You can't login to Answers or any other BI apps
4. You can't even open BI Publisher login window
5. You can't open RPD online

I’ve already installed, Any workaround to fix it manually ?

If you have already installed BI11g and having the above issues you can workaround by setting up the etc/host file properly. If there is still a problem starting up the BI Clustering Controller Server then remove a domain name, which is 'us.oracle.com' in my case, from NQClusterConfig.INI located under C:\biee11\instances\instance1\config\OracleBIApplication\coreapplication (I installed the BI11g under C:\biee11.) if any. After removing all the domain name restart only the cluster control server manually from the Fusion Control (EM) then you should be able to start the cluster control server, and then you will be able to open BI Publisher page and login, or login to BI first then access to BI Publisher page. However, this workaround might be wiped out the next time you stop and start all the BI services. As you have realized by this time, regardless of whether you select ‘Simple Install’ or ‘Enterprise Install’ at the installation the BI Clustering Control Server gets installed. And you need that to access to the BI Server even if there is only one, and hence you need that to login to BI Publisher.

Need to Reinstall or Cleanup ?

So, while you can workaround the network issue as mentioned above I still strongly recommend that you review the network configuration and do a fresh install again. The issue like above can be work around temporally, but the workaround will be needed to perform every time you start the BI servers, which is not going to make you a happy camper.

When you do try another fresh installation then make sure you completely delete the original one by following the sequence mentioned in the installation guide. If you have something still left over from the previous installation you will get an error message during the installation. Here is a brief highlight of the steps in the order.

  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 OPMN-controlled 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 Middleware home.

After following the steps documented in the installation guide to delete everything, make sure you don’t have any entry in the registry if you are installing onto Windows system. Especially the following stuff.

1. Remove all the registry entries that contains the Oracle - OHxxxxx. (e.g. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\coreapplicatin_OH868503665)
2. If you have followed the steps mentioned above you shouldn’t see this. But if you still see this Oracle Common Home menu (‘Oracle – OHxxxxx’) from the Start –> Program File menu then remove it by going to ‘C:\Documents and Settings\All Users\Start Menu\Programs’ in the registry then delete such.
3. Even If you have followed the steps above you might still see the OPMN and Node manager windows services, you can do this by deleting these entries from registry, HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services

Share Your Experience!

Well, hope you have installed BI Publisher 11G successfully and start playing around and getting excited about the new features and products as I do now. But if you have found any issue and workaround during the installation and configuration please share!

18 comments:

  1. Very helpful, thanks.
    But for me there is still a problem. When I use Cisco VPN AnyConnect the loopback adapter will automatically put from the frist position in the sequence of network adapters to the second one. When I run my laptop in the VPN I cannot connect anymore using loopback adapter (General network failure). Our IT guys confirmed that this is expected behaviour. Now I try to use localhost as a way to locally connect to the server. Don't know which sideeffects it does have.
    Juergen Menge

    ReplyDelete
  2. Very helpful, thanks. But I have still a problem when using Cisco VPN AnyConnect. When running in VPN I cannot connect using the loopback adapter (General network failure). Our IT guys said that this is expected behaviour. Now I have tried to use localhost as the way to connect to the server. Don't know if that works and which sideeffects it does have.
    Juergen Menge

    ReplyDelete
  3. Hi Kanichiro San,

    thanks for the amazing posts. Wanted to know if BIP11g is certified for Siebel 8.1.1.3. is there a twitter Id we can follow you on :)

    Thanks
    Yuvaraj Narayanan

    ReplyDelete
  4. As to the 11g certification, it won't come soon due to a change in the web service and the certification process. Will update once I get more detail. If you don't hear from me please ping me again!

    ReplyDelete
  5. With OBIEE 11g, I'm getting this error when accessing bipublisher home page.
    "Error
    Server not initialized. Please make sure the repository is ready."
    Does it look familier?
    I tried redeploying the xmlpserverXX.ear in EM with correct MDS repository. But no luck.

    ReplyDelete
  6. We have JD Edwards EnterpriseOne 8.12 implimented in our organization and we are planning have Oracle BIP for reporting needs.

    Does BIP 11G require additional database other than the JDE database(DB2400 database)?

    Database is optional and only required for BIP schedular for BIP 10G, am I correct? If so, is it the same with 11G also?

    I am confused with the version to go for.. any suggestions?

    ReplyDelete
  7. Hi Kanichiro,
    Is this one of the errors you received before you had to do the workaround for the DHCP issue?

    "trying to connect to W0114265 7001
    [SRC_CLASS: oracle.as.install.bi.biconfig.BIConfigMain] [SRC_METHOD: doExecute] [[
    oracle.as.provisioning.exception.ASProvisioningException
    at oracle.as.provisioning.engine.Config.executeConfigWorkflow_WLS(Config.java:872)
    at oracle.as.install.bi.biconfig.standard.StandardWorkFlowExecutor.executeHelper(StandardWorkFlowExecutor.java:31)
    at oracle.as.install.bi.biconfig.standard.ConfigTemplateTask.doExecute(ConfigTemplateTask.java:32)
    at oracle.as.install.bi.biconfig.standard.AbstractProvisioningTask.execute(AbstractProvisioningTask.java:79)
    at oracle.as.install.bi.biconfig.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:61)
    at oracle.as.install.bi.biconfig.BIConfigMain.doExecute(BIConfigMain.java:110)
    at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:335)
    at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:87)
    at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:104)
    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:63)
    at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:158)
    at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81)
    at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:83)
    at java.lang.Thread.run(Thread.java:619)
    Caused by: oracle.as.provisioning.engine.CfgWorkflowException
    at oracle.as.provisioning.engine.Engine.processEventResponse(Engine.java:596)
    at oracle.as.provisioning.weblogic.ASDomain.connectToAdminServer(ASDomain.java:370)
    at oracle.as.provisioning.engine.WorkFlowExecutor.executeWLSWorkFlow(WorkFlowExecutor.java:412)
    at oracle.as.provisioning.engine.Config.executeConfigWorkflow_WLS(Config.java:866)
    ... 14 more
    Caused by: oracle.as.provisioning.util.ConfigException:
    Unable to connect to the AdminServer.

    ReplyDelete
  8. that doesn't look like the one i had before, but still make sure your network configuration done properly.

    ReplyDelete
  9. Hi Kanichiro,
    When I try to open BIP from analytics, I am getting an tab called "Untitled" and message "NOT FOUND" "Sorry!The page requested was not found."
    Following is what URL looks like: http://hostname/analytics/saw.dll?bipublisherEntry&Action=new&itemType=.xdo

    I get the same message when try http://hostname/xmlpserver

    All the services are up and running. I am confused as to where to look to resolve this issue. Any help will be appreciated.
    Thanks!

    ReplyDelete
  10. First, you need to make sure you can access with '/xmlpserver'. What the log says ? and what is the version ?

    ReplyDelete
  11. Hello,
    I hope that you help me. I am pretty new to BI Publisher. I installed the latest version of BI publisher, but the configuration failed.
    I access http://server:7001/console, and went to deployments table. I saw the state of the BI publisher is "fail", then I tried to START it, but it gave me this MSG: weblogic.management.DeploymentException: [J2EE:160149]Error while processing library references. Unresolved application library references, defined in weblogic-application.xml: [Extension-Name: bijdbc, exact-match: false].

    ReplyDelete
  12. What is the version ? Did you install only BIP or BIEE/BIP together?

    ReplyDelete
  13. Hi Kanichiro,
    i am facing the issue with bi publisher 11g that when i click the link manage bi publisher link it will showing the blue screen can u give the solution for this. i am stuck with this and not moving further pls help me in this. we have urgent requirement on that.

    ReplyDelete
  14. Hi Kanichiro,

    Do you know if BIP 11G is certified for any versions higher than siebel 8.1.1.5?

    Thanks,
    Vasu

    ReplyDelete
  15. BIP 11g is not certified by Siebel yet.

    ReplyDelete
  16. Hi Kanichiro,

    I have 2 fresh installs of OBIEE 11.1.1.6, analytics works fine however when I go to publisher I get the following:

    Error Server not initialized. Please make sure the repository is ready.

    I tried applying the 11.1.1.6.2 patch with the new xmlpserver.ear but that did not fix the issue. I've also been working with Oracle support but they have not be able to resolve either. Do you have any pointers?

    Thank you,

    Doug
    dfiedler@ranzal.com

    ReplyDelete
  17. Hi, I know that we can install BIP 10g on Tomcat/Glassfish app. servers.
    http://docs.oracle.com/cd/E10383_01/doc/bip.1013/e11867/T434820T487783.htm

    But, can you also install BIP 11g on Tomcat and Glassfish or is it the case where you have to have Weblogic server?

    ReplyDelete
  18. With 11g, WebLogic is the only platform supported. We have a plan to support WebSphere in the next release.

    ReplyDelete