OBIEE 11g Installation : High Level Steps

Hi Atul,

when trying to run the rcu.bat file as part of OBIEE 11g(11.1.1.3) installation on windows 7 64 bit home edition I am getting the following error
“windows cannot find C:\Users\manoj\Desktop\Oracle.Make sure you typed the name correctly, and then try again”.
Please help me how to overcome this error, I am not able to understand why it is looking for C:\Users\manoj\Desktop\Oracle.

Thanks
Manoj

@ Manoj,
RCU is not supported from 64 bit machines

Check this

http://onlineappsdba.com/index.php/2009/07/03/oracle-fusion-middleware-11g-repository-creation-utility-rcu/

Run command prompt as administrator and run rcu.bat from this command prompt

Hi Atul Kumar,

I’d tried to install and configure the Oracle Weblogic but get a timeout error in the step when
the config.cmd is creating the domain.
I’m using Windows Vista Home Premium 64Bits
It is my log.
http://www.4shared.com/file/SOrGe6Mx/install2011-06-11_01-24-57PM.html

http://www.4shared.com/photo/jEHA3Dvu/timeout.html

PD. My English is bad, i speaking Spanish

Hi Atul,

Thanks !!

Now i have installed Weblogic10.3 on linux-64 system and then installed OBIEE 11.1.1.5.0 software only installation in the same middleware(as used by weblogic)on the same linux-64 system.
So far so good.
Now i am able to see wlserver, Oracl_BI1 and /opt/beainstall/Oracle/Middleware/user_projects/domains/Weblogic/ObiEE11g(domain name)…..
But i am not able to see Instance folder ?????

How to get this folder?
Do i need to do any more configuration ?
How to make obiee11g run ??
I dont have any clue for next step..Please guide me here…..:)

hi,

what are the different schemas will be there for OBIEE 11.1.1.5 i know for 10.1.3.4.1 we will have informatica,dac,scheduler,olapdw schemas so for 11g what are all the schemas will be there?

raj

@ Raj,
BIPLATFORM and MDS

Hello Atul,

Thanks for all your online help.

I have a 64 bit server with 8 CPUs and 16 gigs of RAM. I’m looking to learn some more things.
Oracle Apps R12, and OBIEE for sure. Perhaps RAC using VMWare.

What would be the order of operations for installing Apps R12, and OBIEE?

Install Oracle Apps first, then OBIEE?

Would I need to create a second database for OBIEE, or just use a new schema in the existing one?

Any other hints, greatly appreciated!

Best,

Rodger

@Atul

thanks for your response.

can you provide me any screenshot documents for installing 11.1.1.5 on linux along with informatica and dac pieces.

Thanks,
raj

@ Roger,
You can install OBIEE and EBS in same database but this is not recommended. For learning purpose I don’t see any problem installing OBIEE in same DB as EBS.

If you wish to put them in same DB then install R12 first which will install EBS DB and then create OBIEE schema using RCU

Hi Atul,

Thanks for the response.

I started installing R12. As always, the DB was fine, but I have middle tier issues to resolve.

As I think about this now, I have a few concerns.

Both R12 and OBIEE have a middle tier, the Oracle Apps server, correct?

If so, can the apps server for both R12 and OBIEE be the same? Or, when I install OBIEE, do I need to install a second middle tier?

For port conflicts, when I install OBIEE, do I need to have R12 up and running fully for the installer?
Or, just note the list, and manually change the ports?

Thanks a lot!

Q: Both R12 and OBIEE have a middle tier, the Oracle Apps server, correct?

A: Depends which OBIEE version we are talking here , in OBIEE 10g yes it runs on oracle iAS but from OBIEE 11g , it runs on weblogic server

Q: can the apps server for both R12 and OBIEE be the same?
A: No, both OBIEE and EBS must use their own apps server .

Q: when I install OBIEE, do I need to install a second middle tier?
A: Yes , you must

Q: For port conflicts, when I install OBIEE, do I need to have R12 up and running fully for the installer?
Or, just note the list, and manually change the ports?

A: If you leave R12 running, OBIEE installer will not assign used ports. Changing ports later is task in itself and if you are new then I wouldn’t recommend . Leave R12 running and then install OBIEE.

[…] Install OBIEE 11g  – Follow OBIEE installation steps here, here and here. This step will create middleware home (MW_HOME), OBIEE Oracle Home (ORACLE_HOME) […]

Atul,

For Enterprise install what is the sequence we need to follow

1)weblogic 10.3.5
2)RCU
3)OBIEE 11.1.5

correct me if i am wrong?

@ Ravi,
Yes that is correct

check

http://docs.oracle.com/cd/E21764_01/doc.1111/e15722/install.htm#CIHIJIJH

Note: RCU can be run anytime before configuring OBIEE

Atul,

for OBIEE 11g Enterprise install i dont find the Weblogic 10.3.5 file on linux. can you please guide me with the file?

appreciate your help.

@ Ravi,
Download it from http://www.oracle.com/technetwork/middleware/ias/downloads/wls-main-097127.html

For 64 bit machine download jar version of weblogic software

Atul,

Thanks for the repsonse. in OBIEE 11g do we have the scheduler component? do we need to configure the scheduler component too in obiee 11g same as obiee 10g? because we do scheduler configuration in obiee 10g right.

Atul,

can you please provide the sequence for informatica and dac and OBIA components on 2nd server. On 1st server i completed the installation of oracle db,jdk,weblogic,rcu and obiee. Now on 2nd server i need to install informatica,dac,obia(i think might be on windows) please guide me with the steps.

appreciate your help

Thanks

@ Ravi,
Yes, scheduler is part of OBIEE 11g check this http://docs.oracle.com/cd/E21764_01/doc.1111/e18562/schedconcepts.htm#BIESJ1426

i am currently installing OBIEE 11g on linux x86_64.we have got 2 servers say server1.com and server2.com and 1 windows server say win1

on server1.com i have installed oracle db, JDK 1.6.30,weblogic 10.3.5,started with rcu and got struck with sysdba privilages(from my comp) so after i get them i will proceed with installing RCU and OBIEE11g. But i have noticed by going through your blog when are installing obiee11g at the last it also installs weblogic and configure weblogic domain right? but my question when we installed the weblogic already so will that have any problem?please clarify my doubts.

Now coming to 2nd server server2.com. Here i am not sure what to install first? can you please guide me with the sequence of steps here?
now coming to win1 machine here i will install the informatica 9.01 client and what else i need to install?

so meanwhile i get access to sysdba privilages can i start installing obia,informatica and dac pieces?

please guide me with the things. Appreciate your help.

Thanks,
Ravi

@ Ravi,
What components you want to run on server1.com , server2.com and win1 ?

I’ll then update what to install where

@Atul,

on server1 i want to install OBIEE(enterprise install) so for that i have done with oracle db,JDK,weblogic 10.3.5,RCU and now OBIEE11g is in progress. But i can see from your blog that OBIEE11g itself installs weblogic and configuration of weblogic domain along with EM etc. So did i do something wrong? i should not install weblogic in advance for obiee enterprise install?

on server2 i want to install informatica,dac
on win1 i want to install informatica and dac client and OBIA. Do i need to install OBIEE11g again on windows?

can you please clear me with this stuff?

thanks

@ Ravi,
There is nothing wrong with installing weblogic. If weblogic is already available in middleware home then obiee installer will skip this step else it will install weblogic.

For server2, iformatica & dac please ask support or informatica/dac forum as I am not familiar with these products (they are on my to do list for quite sometime)

@Atul

okay thanks you.
i am looking for httpd.conf file after installaing oBIEE with enterprise install where can i find it?

after installation of obiee i have got all the above mentioned 5 URL’s. Do i need to do anything after that like configuring something? or its fine for now with the installation took care of it?

@Ravi,

The find command is your best friend in Linux
find / -type f -iname “httpd.conf”

@Atul

Atul, I’ve installed all the components fine.
But since rebooting the machine, I’m having an awful time trying to
get OBIEE to run again.

Please make a page on how to admin/start/stop weblogic and OBIEE.
Similar to how you did with R12.

Thanks a lot!

@Rodger,

Thanks for your response. yeah i tried finding it using the same find command but in vain.generally it should be somewhere in weblogic folder which we have installed using obiee, but not sure i dont find one.

Has anyone had any success in installing OBIEE (11.1.1.5), DAC (10.1.3.4.1), Informatica (9.0.1 hotfix 2) and Oracle BI Apps (7.9.6.3) on Linux 64 bit?

We have been provided 2 physical Linux servers (say A & B) and 2 virtual server (say C & D) for the same. We were able to install obiee 11g on linux el5 machine (A). We were able to also install the Informatica server (9.0.1 hotfilx 2) and DAC server on the machine (B). As per e-delivery, Bi apps 7.9.6.3 is not available for linux 64 bit platform, hence we have downloaded for windows and planning to install on windows machine(C).

Has anybody have idea, whether how could we install bi apps 7.9.6.3 on Linux as our OBIEE 11g is installed on Linux machine(A).
Any thoughts/suggestions would be greatly appreciated.

????

Run the find command exactly as I gave it.
For the entire server.

Another variation:
find / -type f | grep -i “http”

Rereading, you have three servers there.
I’ve no experience with that.
find on all three.

Why not try installing everything cleanly on a single server first? Then, after you learn what is involved, try it on multiple servers. It’s complex enough on a single server.

@ Ravi,
I don’t think OHS is installed with OBIEE 11g (and for that reason you ca’t find httpd.conf), you will have to configure OHS separately if you want to access OBIEE via OHS.

Has anyone installed RCU 11g on DB2 platform? I am getting an error Unable to connect to database using following schema users DEV_MDS, DEV_BI Please enter valid username/password for schema users Step 4 of 7

This step should take the schem user names and password (I enterd on the screen) and create these objects? I already created the OS users for these schemas

anyone get this error, can you help me?

@Kusak,

so you have the sysdba privilages for that user using which ypu are creating. if not then you will see this error.

thanks,
Ravi

Hi Ravi,

Thanks for responding

Yes the user I am using for the install is a SYSDBA user created for me by my DBA. Do the dev_mds or dev_bi users need SYSDBA privilages? Or does user in step 2 have to be named “sys”? Trying to think out loud here.

Anything will help
Thanks

@Kusak,

the user you enter in step 2 should be sysdba and its password.

Thanks,
Ravi

Hi,

Information about jboss 5.1 certified version with obiee 10g(10.1.3.4.1/2) or not? as per the SRSP i can see its 4.0 http://docs.oracle.com/cd/E10415_01/doc/bi.1013/e10417.pdf any help is highly appreciated.

Thanks,
Kiran

Hi Guys,

I need your help.I have a java code that works on OBIEE10g and it is to download the XML file and then converting to CSV.This Java code uses OBIEE10g webservices.BUt when I try to run the same code for 11g then it is not working.Can you tell me what can be wrong and what changes needs to be done.

Thanks
Jas

Hi Atul,

We have a two node OBIEE production on windows. Following are the installated components on each node:

APPS Tier:
1. Weblogic 10.3.5
2. OBIEE 11.1.1.5
3. Oracle BI Application 7.9.6.3

Databas Tier:
1. Oracle Database EE 11gR2
2. Informatics 9 hotfix 2.
3. Datawarehouse Administration console 10.1.3.4.1

We need to clone the APPS Tier to a different machine. Pl. suggest the clonning steps for our environments.

Regards
Ummar

Hi Atul,

We have OBIEE installed on test servers,the Datawarehouse is on windows 2007 64 bit machine,and the application is on windows 2007 32 bits,to overcome the performance issue we are now moving the Application to New Windows 2007 64 bit server.

On this new server,I Installed weblogic,I have run the BI instalation main program,on the half way BIPLATFORM Schema step(6 of 12) I am giving the existing BIPLATFORM username and password which is erroring out with the message “INST-08020:one or more entries are found in HSS_COMPONENT table ”
then I createded one more user with name “dev_biplatform” in the DB it is also erroring out with the message
INST-08029:Unable to connect to the database with the given credentials”
Attaching the Screen shots for your reference.

Please suggest on this.
Can you please share any Cloning steps for OBIEE.

Regards,
Sayeed

Hi Atul,

I have installed OBIEE 11.1.1.6 on a Linux server.
If Admin Server is shut down, weblogic user can’t login to analysis/presentation server. The analysis page comes up but login fails.

I want to create 1 server as primary node and scale out to secondary node. What i need to test is if Primary machine goes down even then people should be able to use analysis using secondary managed server bi_server2.

Please advice.

Thanks
Nitin Aggarwal

@ Nitin Aggarwal

Q: If Admin Server is shut down, weblogic user can’t login to analysis/presentation server.

A: This means there is some issue with analysis/presentation server.

Check managed server logs and also logs under OBIEE components managed by OPMN ($ORACLE_INSTANC/diagnostics).

Q2: I want to create 1 server as primary node and scale out to secondary node.

A: Use Oracle Enterprise Deployment Guide (EDG) to deploy OBIEE in HA using http://docs.oracle.com/cd/E23943_01/doc.1111/e15722/create_domain.htm#BAJGGFCJ

Thanks Atul,

My requirement is following:-

1- I have 2 Linux Servers
2- Fist server will be made primary, second server will be made secondary by using scale out option.
3- Objective is to provide HA & failover using only 2 servers.
4- Now if primary server goes down, people should be able to use analysis using managed server on secondary machine – bi_server2.

Will this work or how we can make this work?

Thanks & regards
Nitin Aggarwal

Hi Atul,

Any idea regarding this?
I tried this out but users are not able to login to bi_server2 when bi_server1 is down.

Thanks
Nitin Aggarwal

Hi Atul,

I used the following for scale-out:-

http://docs.oracle.com/cd/E21764_01/doc.1111/e15722/bi_clusters.htm

I have 2 instances bi_server1 & bi_server2. How to expand OPMN processes on second node?

I simply did a scale-out and verified that I am able to access analytics using both of the URLs.

Please Advice.

Thanks
Nitin Aggarwal

Hi atul
i am trying to install obiee 11.1.1.6 in my windows7 32 bit machine.i have created BIPLATFORM schemas using RCU. when it comes for the Domain creation step it shows error.
“oracle.as.provisioning.exception.ASProvWorkflowException: Error Executing workflow.
at oracle.as.provisioning.engine.WorkFlowExecutor._createDomain(WorkFlowExecutor.java:686)” (from the log)

please advice on this

regards
senthil

Hi senthil,

check your domain name also,it should not contain any underscores(_) in it.It should be be single word.

Regards,
Sayeed

Hi Atul,
First of all thanks for your help in online.
As I am new to OBIEE,I have installed OBIEE 11.1.1.6 in linux x86_64 single server.All the components and url’s are working fine.Now I need to configure single-sign-on for this.
For that do I need to install OHS..?

Please let me know the detailed steps to configure single-sign-on.
Thanks in advance…:)

Thanks Atul for fast reply.
I will go through the above link .

As I told you,installed OBIEE 11.1.1.6 in linux x86_64.while login to Bipublisher It’s giving error as below:

Error 500- Internal server error
From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1:
10.5.1 500 Internal Server Error

The server encountered an unexpected condition which prevented it from fulfilling the request.

Please advice..
Thanks in advance.

[…] http://onlineappsdba.com/index.php/2011/05/01/obiee-11g-installation-high-level-steps/ […]

Hi,

I wanted to do the Migration of OBIEE Servers into Exalytics Machine. So please let me know what are the steps i need to follow.

whether i have to install fresh OBIEE installation if it so do i need to install BI APPS as well? . Please provide me the detailed steps of components to be installed and the migration into Exalytics.

Thanks
Kumar

Any reply on Migration of OBIEE servers in to Exalytics i am understanding is that OBIEE Foundation pack comes in-built so what is the migration we need to with respect to WLS ?

Please provide me the steps.

Hi Atul,

Can’t we install OBIEE with jrocket 64 bit?

Here i am using external jrockit by giving jreLoc to different jrockit version in silent mode…
While doing obiee installation patchsets
it searching jdk in ORACLE_HOME/jdk…
but i am using external jrocket…
so it’s failing continuouslly…

please help me on this…
thanks,
Vijay Katreddy

Hi Atul,

Need help on OBIEE 11.1.1.7 installation on OEL6.4 64 bit .When I am trying to install it is getting failed on domain configuration .
=====
progress in calculate progress1
Executing Task: Starting Managed Server: bi_server1
progress in calculate progress1
Executing Task: Configure BI Domain
java.lang.IllegalStateException: INVALID_DISCOVER_PROCESS_CONFIG_RESULT
at oracle.as.install.bi.biconfig.standard.BIDomainConfigureTask.discoverProcessConfig(BIDomainCon
=======
Any idea how to resolve this issue .I have checked all the RPMs and it is passing on all the rpms checks as well.

Thanks
Amar

Hi Atul

Thanks for your reply.

There are no error in the Admin and manage server logs .

Below are the host file entry. The same works on the other instance where I am able to configure domain with same host entry .

127.0.0.1 localhost oraafpo-server
::1 localhost oraafpo-server
IP oraafpo-server oraafpo-server

hostname
oraafpo-server

Thanks
Amar

Hi Atul ,

I am seeing below error in the bi manage server logs.

Thanks
Amar

Sorry I am not able to paste the error in this here.

@ Amar,

Change /etc/hosts from

127.0.0.1 localhost oraafpo-server
::1 localhost oraafpo-server
IP oraafpo-server oraafpo-server

To

127.0.0.1 localhost
::1 localhost oraafpo-server
IP oraafpo-server oraafpo-server

i.e. remove oraafpo-server from 127.0.0.1

Do everything again inclduing loading of OBIEE schema

I tried with the above configuration on hosts entry but it was failing to discover the ports with error ports already in use .

So I removed the IP + hostname and only kept the entries as below and it was installed successfully.But I am still wondering the same entries work on my other instance.

127.0.0.1 localhost oraafpo-server
::1 localhost oraafpo-server

Again thanks for all your suggestion Atul really appreciate.

Reagrds
Amar

Hi,

I need to ask a question, if I’ll be migrating the OBIEE App from a server to a completely different server.

Is it sufficient to copy the OBIEE directory & transfer it for the application to run on the new server, and of course changing the hosts file ?

Or we need other configurations to be altered?

Hi,
I’d like to ask help on the error I’ve encountered on running the config.cmd in Windows 7 platform. Please see screenshot below. Appreciate your help. Thanks

D:\Oracle\Middleware\Oracle_Home\bi\bin