Wednesday, April 03, 2013

Oracle BI Discoverer 11g Installation


We are going to install OBI 11g with following sequences.
  • Install Oracle database 11.2.0.3 standard edition database.
  • Install JDK jdk 1.6 or 1.7
  • Install Repository Creation Utility (RCU) 11.1.0.6 (ofm_rcu_win_11.1.1.6.0_disk1_1of1.zip)
  • Weblogic Server 10.3.6 (wls1036_generic.jar)
  • Oracle Portal, Reports,Forms & Discoverer 11g and patching with 11.1.6
  • Run configuration for Discoverer
pfrd 11.1.1.2 Includes

V18772-01_1of4.zip
V18772-01_2of4.zip
V18772-01_3of4.zip
V18772-01_4of4.zip

pfrd 11.1.1.6 Includes
V29883-01.zip

./config.sh to configure 11.1.1.6

Environments:
Make sure the /etc/hosts are like this
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
#::1 localhost6.localdomain6 localhost6
192.168.10.11 biserver.domain.com biserver

Packages:
With an Oracle Database 11g installed, you need only to install one package - compat-db


Install OBI Repository Creation Utility (RCU)

Download the installation files from the http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html on your desktop.

(Note** It has to be the same version as BI software). The name of the installer would be fm_rcu_win_11.1.1.6.0_disk1_1of1.zip

Unzip the file, navigate to the bin directory and start the RCU => rcu.bat.

Welcome > Next


Accept default of Create. Click Next:



·         Leave default of Oracle Database:
·         Set hostname
·         Set port
·         Set service name
·         Set username
·         Set password
·         Leave Role as SYSDBA 




Select the Oracle Business Intelligence Component.This action automatically selects the Metadata Services (MDS) schema (under the AS Common Schemas group).





So at this point, Repository Creation succeded!!

Our next step is to Install Weblogic server & creating middleware home


Install Oracle WebLogic Server and Create the Middleware Home:

Environment Preperation:

We need to make sure that weblogic is using jdk1.7.0_17 while running installer.

SETTING JAVA HOME:
We have installed JDK1.7 into following directory:

Cd /usr/java/jdk1.7.0_17/bin

[oracle@test bin]$ ./java -version
java version "1.7.0_17"
Java(TM) SE Runtime Environment (build 1.7.0_17-b02)
Java HotSpot(TM) 64-Bit Server VM (build 23.7-b01, mixed mode)

[oracle@test bin]$ cd..
[oracle@test jdk1.7.0_17]$ echo $PATH
/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/fnadvi/bin

[oracle@test jdk1.7.0_17]$ pwd
/usr/java/jdk1.7.0_17

[oracle@test jdk1.7.0_17]$ export JAVA_HOME=$PWD
[oracle@test jdk1.7.0_17]$  echo $JAVA_HOME
/usr/java/jdk1.7.0_17

[oracle@test jdk1.7.0_17]$ export PATH=$JAVA_HOME/bin:$PATH

[oracle@test jdk1.7.0_17]$ echo $PATH
/usr/java/jdk1.7.0_17/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/fnadvi/bin

[oracle@test jdk1.7.0_17]$ cd ../
[oracle@test java]$ java -version
java version "1.7.0_17"
Java(TM) SE Runtime Environment (build 1.7.0_17-b02)
Java HotSpot(TM) 64-Bit Server VM (build 23.7-b01, mixed mode)




Install weblogic 10.3.6
Make sure that the weblogic is running using jdk1.7.0 java binaries by running it from java directory, as shown below:

[oracle@test distr]$ /usr/java/jdk1.7.0_17/bin/java -jar wls1036_generic.jar
Extracting 0%....................................................................................................100%




Now that the Weblogic server is installed. Our final step is installing Oracle Discoverer 11g.


Installing Forms,Reports & Discoverer 11.1

1.  We will be installing Oracle Portal, Reports, Forms & Discoverer 11.1.1.2 and then will pathc it with 11.1.1.6



NOTE: Select Install Software - DO NOT CONFIGURE****
We'll do that after applying patches.






Patching to 11.1.1.6:






Configure Discoverer under 11.1.1.6 patched home:

Once everything is installed and patched. Run configure Portal,Forms,Reports & Discoverer.
Configure CONFIG.sh 


cd /u01/app/oracle/middleware/as_1/bin
./config.sh





At this point.....Installation of Oracle Discoverer 11g has been successfully installed.


Just one additional task is, you need to copy the database tns file, (where EUL Schema resides) needs to be copied over to Middleware Instance Directory. Ie, for my case it's

/u01/app/oracle/middleware/asinst_1/config

The link to use Discover would be prety much like this:http://hostname:8888/discoverer/viewer OR 
http://hostname:8090/discoverer/viewer


Note that, even if webcache is down, you can still access Discoverer with the 8888 port!!!

5 comments:

Syed Hassan said...

Dear Nadvi
can you provide me your email id.
i need to ask some question regarding apps r12.

best regards
syed naushad

Ferdous Nadvi said...

Hi Syed,

Unfortunately I donot have experience on apps12 , my working experience limited to core database and on BI+Oracle websphere.

I'd suggest to seek help from apps dba experts, tons of blogs on internet, just google it.

Hope that helps

Unknown said...

Hi Nadvi,
Thanks for you nice post.
I like to know how we can create the EUL schema in the database here we don't have Discoverer administrator to create the EUL then how we can create the EUL.
Regards,
Syed

Ferdous Nadvi said...

Hi Syed,

EUL schema is part of configuration, thats why it wasn't included in this post.

In order to create it, you need to download and install Oracle Discoverer Administration/Desktop module. You'll find a wizard to create EUL. I believe you'll be able to do it.

Incase if you face difficulties, don't hesitate to reply back.

Good luck!

Unknown said...

Thanks very much for your help.

Regards,
Syed