Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

OBIA
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 3 / 5

Star ActiveStar ActiveStar ActiveStar InactiveStar Inactive
 

In this part I will be covering installation of OBIA and Middleware patches.

After executing the OBIA RCU the next step is to install OBIA. Follow the directions in the OBIA installation guide (section 3.3.3)

 

Installation of OBIA

Pre –requisite : to run the installer is JDK as mentioned in part 1. The installer will be launched with the command runInstaller –jreLoc <JDK location>

The following screen shots show the installation of OBIA. 

 Specify Installation Location window opens: Browse and select destination for ORacle Middleware Home, and enter name for Oracle Home Directory > Next

 

 

biapps2

 Installation Progress will appear > Next

 

 

After the installation you should see biapps folder in <BI_Oracle_Home>.

The next step is applying middleware patches. It is a required step before proceeding with configuration.

 

Middleware Patches

You have to shut down the weblogic server ,manage server,node manager before applying this patch.

The patches are available as part of OBIA 11.1.1.8.1 Media pack download. The script used to apply patches is a perl script and is available in

<BI_Oracle_Home>/biapps/tools/bin/APPLY_PATCHES.pl.

This perl script requires a parameter file (apply_patches_import.txt).you have to update this parameter file to reflect the appropriate directory paths.

Here is a screen shot of the patch parameter file.

apply patches

 

Lessons learned

 

Patch Lock Issue:

If the parameter file is not updated correctly the patch may fail half way through.  You can check the log file in the WORKDIR you have given in parameter file for the details of the error.

When the patch files, and you fix the parameter file and re-run the patch one issue that could happen is the patch lock.

I had initially entered incorrect path in parameter file. The patch failed. I fixed and re-ran the patch script but got an error about patch lock.

To fix this issue I looked for patch_locked file. This should be in the path

<BI_Oracle_Homee>/.patch_storage

I then removed the patch_lock file. And re- run the patch script. I have a screen shot of the issue with patch_lock file .

patches lock issue

 

Log File:After the patch sccript exeutes check the log file path you have mentioned in the WORK_DIR. Make sure all the patches have been applied succesfully.

Start the weblogic server, managed server and all the OPMN processes.

The next step is to updtae ATG lite data in BIACOMP.

 

ATG lite Patch

There are some good lessons learned while applying this patch which I have mentioned below.

 

To update ATG lite :

Run the following command:

java-jar biappsrepositoryutil.jar upgradeATG <mandatoryparameters>

Where the mandatory parameters are as follows:

Parameter

Description

bi.oracle.home

Full path of the Oracle BIhome.

work.dir

Working directory to be used for the run. This for log files.

db.conn.sid.url

Connection to the database that host the BIACOMP schema.

Note the format. We have to make sure the format is as mentioned:

Host:port:SID

For example: domain:1521:orcl

biacomp.user

BIACOMP schema owner.(this was created using BIAPPS RCU)

biacomp.password

BIACOMP schema owner's password.

atg.db.seed.url

URL used to connect  to the BIACOMPschema.(The ATG user is the BIACOMP schema owner.)The format is host:port/ServiceName.  For example:host:port/orcl.mycompany.com.

db.sys.user

Database system username.

db.sys.password

Database system user password.

Note:If this parameter is no passed in the command line,then the tool will request the password at runtime.

Example

java-jar biappsrepositoryutil.jar upgradeATG bi.oracle.home=scratch/MiddleWareHome/Oracle_BI1/ work.dir=scratch/workfolder biacomp.user=BIAPPS_BIACOMP

biacomp.password=password db.conn.sid.url=<host>:<databaseport>:<SID> atg.db.seed.url=<host>:<databaseport>/<ServiceName> db.sys.user=sysuser db.sys.password=password

Lesson Learned:

I will show the screen shots of error I received when I entered service_name in the place where it requested the sid.

Incorrect (I entered serivce_name instead of SID)

java -jar /home/oracle/Middleware/Oracle_BI1/biapps/tools/lib/biappsrepositoryutil.jar upgradeATG bi.oracle.home=/home/oracle/Middleware/Oracle_BI1/  work.dir=/home/oracle/tmp/work biacomp.user=DEV_BIACOMP  biacomp.password=*****  db.conn.sid.url=dev-obia117:15010:iadevbi atg.db.seed.url=dev-obia117:15010/iadevbi.apps2fusion.net db.sys.user=sys  db.sys.password=******

 

 

After a some research I figured it needs to be entered as given in the example. If it says SID enter SID and for service_name enter the service_name.

  

Correct Command: 

java -jar /home/oracle/Middleware/Oracle_BI1/biapps/tools/lib/biappsrepositoryutil.jar upgradeATG bi.oracle.home=/home/oracle/Middleware/Oracle_BI1 work.dir=/home/oracle/temp biacomp.user=DEV_BIACOMP biacomp.password=**** db.conn.sid.url=dev-obia117.apps2fusion.net:15010:iadevbi  atg.db.seed.url=dev-obia117.apps2fusion.net:15010/iadevbi db.sys.user=SYS db.sys.password=******

 

Without upgrading this patch you cannot move on to the next steps. I tried it  J It will complaint about ATG lite schema not upgraded.The next step is to upgrade FSM.

 

FSM Upgrade

 It is very similar to ATG lite upgrade. Run the following command:

java-jar biappsrepositoryutil.jar upgradeFSM <mandatoryparameters>

Where the mandatory parameters are as follows:

Parameter

Description

bi.oracle.home

Full path of the Oracle BIhome.

work.dir

Working directory to be used for the run. This for log files.

db.conn.sid.url

Connection to the database that host the BIACOMP schema.

NOTes: Not the format. We have to make sure the format is as mentioned:

Host:port:SID

For example: domain:1521:orcl

biacomp.user

BIACOMP schema owner.(this was created using BIAPPS RCU)

biacomp.password

BIACOMP schema owner's password.

fsm.db.seed.url

URL used to connect  to the BIACOMPschema.(The FSM user is the BIACOMP schema owner.)The format is host:port/ServiceName.  For example:host:port/orcl.mycompany.com.

db.sys.user

Database system username.

db.sys.password

Database system user password.

Note:If this parameter is no passed in the command line,then the tool will request the password at runtime.

 

java -jar /home/oracle/Middleware/Oracle_BI1/biapps/tools/lib/biappsrepositoryutil.jar upgradeFSM bi.oracle.home=/home/oracle/Middleware/Oracle_BI1 work.dir=/home/oracle/temp biacomp.user=DEV_BIACOMP biacomp.password=**** db.conn.sid.url=dev-obia117.apps2fusion.net:15010:iadevbi  fsm.db.seed.url=dev-obia117.apps2fusion.net:15010/iadevbi db.sys.user=SYS db.sys.password=******

 

The next and final step is to execute the configapps.sh for BIAPPS. I will cover this in the next article.

 

 


Srimathi Badri

Add comment


Security code
Refresh

About the Author

Srimathi Badri

Srimathi Badri has over fifteen years of experience as an Applications Developer, and has worked in different technologies and E-business Applications during this time. 
Her specific focus and expertise is in RICE, OAF pages, XML publisher, Java and BI stack of technologies including OBIEE/OBIA with functional domain expertise in Financials, HR, Order Management, and Supply Chain & Warehouse Management. She has a strong desire to keep pace with new technologies which has helped her implement numerous cost saving projects. 
She was a speaker at Oracle Open World -2014 to discuss the implementation phases of OBIA 11.1.1.7.1 with ODI. The topic was "Improve profitability and Cash Flow with Oracle Financia Analytics"

She can be reached at srimathi.badri@yahoo.com

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jun 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
   1  2  3  4  5  6
  7  8  910111213
14151617181920
21222324252627
282930    

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner