2014-06-29 1 Upgrade BIP

Overview

Following the successful upgrade to OMS 12.1.0.4 (as described in 16 Upgrade OMS 12.1.0.4.0), the configuration of BI Publisher had to be upgraded from the installation described in 15 Integrate BI Publisher into OEM.

I also did some other post-upgrade tasks:

    1. Update .bash_profile for new environment
    2. Adjust the parameters for REPOS

References

  • Oracle® Enterprise Manager Cloud Control Advanced Installation and Configuration Guide 12c Release 4 (12.1.0.4)
    • 15 Configuring BI Publisher with Enterprise Manager
      • 15.4 Upgrade Configuration of BI Publisher in Enterprise Manager 12c Release 4 (12.1.0.4)

Procedure

Back Up OMS

I used the following commands to back up the OMS:

cd /opt/app/oracle/em/middleware2/oms/bin ./emctl exportconfig oms

The output is:

Oracle Enterprise Manager Cloud Control 12c Release 4 Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root (SYSMAN) Password : ExportConfig started... Backup directory is /opt/app/oracle/em/gc_inst1/em/EMGC_OMS1/sysman/backup Machine is Admin Server host. Performing Admin Server backup... Exporting emoms properties... Exporting secure properties... Export has determined that the OMS is not fronted by an SLB. The local hostname was NOT exported. The exported data can be imported on any host but resecure of all agents will be required. Please see the EM Advanced Configuration Guide for more details. Warning: Could not export files for module bip: Unable to read file /opt/app/oracle/em/gc_inst1/em/EMGC_OMS1/embip.properties for exporting Exporting configuration for pluggable modules... Preparing archive file... Backup has been written to file: /opt/app/oracle/em/gc_inst1/em/EMGC_OMS1/sysman/backup/opf_ADMIN_20140622_193206.bka The export file contains sensitive data. You must keep it secure. ExportConfig completed successfully!

Upgrade BI Publisher

Following the procedure in 15.4 Upgrade Configuration of BI Publisher in Enterprise Manager 12c Release 4 (12.1.0.4), I used the following command to upgrade BI Publisher:

cd /opt/app/oracle/em/middleware2/oms/bin ./configureBIP -upgrade

The output is:

Configuring BI Publisher Version "11.1.1.7.0" to work with Enterprise Manager Logging started at /opt/app/oracle/em/middleware2/oms/cfgtoollogs/bip/bipca_20140622193257.log. This command is meant to be run from Oracle Enterprise Manager Cloud Control 12c Release 4. Please confirm? (Y|N):Y Before this command is run, a backup of Enterprise Manager should be performed using the :emctl exportconfig oms: command. Have you made a valid backup of Enterprise Manager (yes/no) [no] ? yes Enter sysdba user name (sys): Enter sysdba user password: Enter Administration Server user password: Enter the fully qualified path to the domain you are upgrading from: /opt/app/oracle/em/gc_inst/user_projects/domains/GCDomain Upgrading from a prior release of BI Publisher With a file-system repository Located at: /opt/app/oracle/em/gc_inst/user_projects/domains/GCDomain Configuring BI Publisher in Oracle Home located in /opt/app/oracle/em/middleware2/Oracle_BI1 ... EM 12c BIPLATFORMversion 11.1.1.6.0 schema detected. Begin upgrade process to version 11.1.1.7.0 Begin to execute Oracle Fusion Middleware Patch Set Assistant (PSA) ... PSA returns with status: 0 Successfully upgraded SYSMAN_BIPLATFORM schema... Enter an integer between 9701 and 49152 for the BI Publisher HTTP server port. (9701): Enter an integer between 9702 and 49152 for the BI Publisher HTTPS server port. (9702): Extending domain with BI Publisher. This operations can take some time. Do not interrupt this command while it is running... Migrating BI Publisher Filesystem repository from "/opt/app/oracle/em/gc_inst/user_projects/domains/GCDomain/config/bipublisher/repository" to "/opt/app/oracle/em/gc_inst1/user_projects/domains/GCDomain/config/bipublisher/repository"... Starting the Upgraded BI Publisher Managed Server... Locking Enterprise Manager ... OMS Console is locked. Access the console over HTTPS ports. Restart OMS. Restarting Enterprise Manager ... Stopping Enterprise Manager, this can take some time ... Starting Enterprise Manager. This operation can take some time. Do not interrupt this command while it is running. OMS Started Successfully BI Publisher server named :BIP: running at https://cronulla.yaocm.id.au:9702/xmlpserver. Registering BI Publisher with Enterprise Manager and deploying reports... Performing automatic backup of Enterprise Manager using the command :emctl exportconfig oms:. Successfully backed up Enterprise Manager. The backup file is located in the INSTANCE_HOME sysman backup directory. Successfully setup BI Publisher with Enterprise Manager

Update BASH Profile

I also updated .bash_profile with the following lines:

export ORACLE_BASE=/opt/app/oracle export EM_HOME=${ORACLE_BASE}/em export AGENT_INSTANCE=${EM_HOME}/agent/agent_inst export AGENT_HOME=${EM_HOME}/agent/core/12.1.0.4.0 export MW_HOME=${EM_HOME}/middleware2 export OMS_HOME=${MW_HOME}/oms export WLS_HOME=${MW_HOME}/wlserver_10.3

Update REPOS Parameters

The changes made to the REPOS are described in 14 Change DB Parameters for OEM 12.1.0.4.