Tag Archives: 11g
FYI: Error while running Upgrade Assistant OBIEE 11g – UPGAST-00055
When migrating our legacy OBIEE 10g webcat and RPD to Oracle's new 11g platform, we often don't have the privilege of using a GUI based operating system for assembly & system test as most production systems are Solaris or Red Hat.
We can all agree that a unix distribution is more powerful & flexible, yet leaves much to be desired when attempting to resolve configuration issue in a 'friendly UI environment'. This is certainly no exception when attempting to use Oracle's Upgrade Assistant Command Line Interface .
Many users have encountered error " UPGAST-00055: error reading the Universal Installer Inventory. The inventory pointer oraInst.loc is either not readable or doest not exist". A quick search of Oracle's Fusion Middleware Error Message Reference Guide makes me believe that Oracle's writers are playing a cruel joke in their attempt to 'help':
Action: "see the secondary error message?" You've got to be kidding me!!
Oracle's 'help' aside, the upgrade assistant is looking for an oraInst.loc file which contains 2 things:
UA, by default, searches for the oraInst.loc file in your /var/opt/oracle folder. But many times, the file won't be located there - for a number of reasons , including:
You can then use the UA CLI paramater -invPtrLoc to specify your custom oraInst.loc path.:
./ua MT -BIEEE -webcatdir /export/obiee/11g/Oracle_BI1/bin/webcatalog -invPtrLoc /export/obiee/11g/oracle_common/oraInst.loc -webCatDeliversDir /delivers -wlsPort 7001 -wlsUser weblogic
will generate the following:
followed by a series of postupgrade tasks that you can view at 'tail -f $ORACLE_HOME/upgrade/logs/postupgrade.txt'
and ultimately a 'completed successfully' message:
But what if you can't find your oraInst.loc file? Don't worry! Oracle has a template you can use located at:
Problem solved!
keywords : obiee 11g upgrade, upgrade assistant, obiee administration, obiee 11g administration, weblogic obiee
We can all agree that a unix distribution is more powerful & flexible, yet leaves much to be desired when attempting to resolve configuration issue in a 'friendly UI environment'. This is certainly no exception when attempting to use Oracle's Upgrade Assistant Command Line Interface .
Many users have encountered error " UPGAST-00055: error reading the Universal Installer Inventory. The inventory pointer oraInst.loc is either not readable or doest not exist". A quick search of Oracle's Fusion Middleware Error Message Reference Guide makes me believe that Oracle's writers are playing a cruel joke in their attempt to 'help':
Action: "see the secondary error message?" You've got to be kidding me!!
Oracle's 'help' aside, the upgrade assistant is looking for an oraInst.loc file which contains 2 things:
- The location of your installation directory
- The install group of your user
UA, by default, searches for the oraInst.loc file in your /var/opt/oracle folder. But many times, the file won't be located there - for a number of reasons , including:
- custom installation directories
- co-installation of multiple oracle products
- de-installation and subsequent re-installation attempts
You can then use the UA CLI paramater -invPtrLoc to specify your custom oraInst.loc path.:
./ua MT -BIEEE -webcatdir /export/obiee/11g/Oracle_BI1/bin/webcatalog -invPtrLoc /export/obiee/11g/oracle_common/oraInst.loc -webCatDeliversDir /delivers -wlsPort 7001 -wlsUser weblogic
will generate the following:
followed by a series of postupgrade tasks that you can view at 'tail -f $ORACLE_HOME/upgrade/logs/postupgrade.txt'
and ultimately a 'completed successfully' message:
But what if you can't find your oraInst.loc file? Don't worry! Oracle has a template you can use located at:
- /$ORACLE_HOME//bifoundation/provision/scripts/bidomain/inst
- Rename it to oraInst.loc
- Copy it to your $ORACLE_HOME folder
- Populate the inventory_loc line with the path to your oraInventory folder
- Populate the inst_group with the group name of the account you're using to install & upgrade OBIEE
- Run the upgrade assistant as specified above
Problem solved!
FYI: OPMNCTL Failed to Start Managed Process After Maximum Retry Limit on Solaris 10, OBIEE 11g
If you've happened to glance at Oracle Technical Network, it appears that alot of practitioners are encountering an issue when upgrading their 11g platform to the newest 11.1.1.6.4 version if they're using a Solaris or Linux distribution.
After upgrading to 11.1.1.6.4 as outlined in my previous blog post some users encounter the following error(s) when trying to start their BI services using opmnctl (Oracle Process Manager and Notification Server) with the 'opmnctl startall' command:
================================================================================
Response: 1 of 5 processes started.
ias-instance id=instance1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ias-component/process-type/process-set:
coreapplication_obis1/OracleBIServerComponent/coreapplication_obis1/
Error
--> Process (index=1,uid=1445883997,pid=18522)
failed to start a managed process after the maximum retry limit
Log:
/u01/app/oracle/obiee11g/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/console~coreapplication_obis1~1.log
ias-component/process-type/process-set:
coreapplication_obips1/OracleBIPresentationServicesComponent/coreapplication_obips1/
Error
--> Process (index=1,uid=1445883998,pid=0)
Executable file does not have execute permission
/u01/app/oracle/obiee11g/Oracle_BI1/bifoundation/web/bin/sawserver
failed to start a managed process after the maximum retry limit
Executable file does not have execute permission
/u01/app/oracle/obiee11g/Oracle_BI1/bifoundation/web/bin/sawserver
Log:
none
ias-component/process-type/process-set:
coreapplication_obisch1/OracleBISchedulerComponent/coreapplication_obisch1/
Error
--> Process (index=1,uid=1445884000,pid=18523)
failed to start a managed process after the maximum retry limit
Log:
/u01/app/oracle/obiee11g/instances/instance1/diagnostics/logs/OracleBISchedulerComponent/coreapplication_obisch1/console~coreapplication_obisch1~1.log
ias-component/process-type/process-set:
coreapplication_obiccs1/OracleBIClusterControllerComponent/BIClusterController/
Error
--> Process (index=1,uid=1445884001,pid=0)
Executable file does not have execute permission
/u01/app/oracle/obiee11g/Oracle_BI1/bifoundation/server/bin/nqsclustercontroller
failed to start a managed process after the maximum retry limit
The important things to note are:
This can be easily resolved by setting the ulimit at the user level to : ulimit -d unlimited , as outlined in Oracle's note ID: 1292887.1 . Anyone who has worked in OBIEE 10g should be familiar with this as it is required in 10g's installation process as well.
Issue 2: Enable read access on executable files
If you tried re-running opmnctl startall after resolving issue 1, you'll notice that the BI services still fail to run despite increasing the maximum retry limit. Upon examining the log files as outlined in the above error:
/export/obiee/11g/Oracle_BI1/bifoundation/server/bin/biserver.sh: nqsserver: cannot execute--------
12/11/06 15:48:06 Start process
--------
/export/obiee/11g/Oracle_BI1/bifoundation/server/bin/biserver.sh: nqsserver: cannot execute
During the 11.1.1.6.4 upgrade on your Solaris or Linux box, these files became read only!
How to resolve this read only issue:
Navigate to your $ORACLE_HOME/bifoundation/server/bin folder and make the the following files executable by using the chmod +x command: nqscheduler, nqsclustercontroller, nqsserver. These files should have read/write privileges as outlined in the image below:
Now when you run opmnctl startall, all services should execute successfully:
After upgrading to 11.1.1.6.4 as outlined in my previous blog post some users encounter the following error(s) when trying to start their BI services using opmnctl (Oracle Process Manager and Notification Server) with the 'opmnctl startall' command:
================================================================================
Response: 1 of 5 processes started.
ias-instance id=instance1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ias-component/process-type/process-set:
coreapplication_obis1/OracleBIServerComponent/coreapplication_obis1/
Error
--> Process (index=1,uid=1445883997,pid=18522)
failed to start a managed process after the maximum retry limit
Log:
/u01/app/oracle/obiee11g/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/console~coreapplication_obis1~1.log
ias-component/process-type/process-set:
coreapplication_obips1/OracleBIPresentationServicesComponent/coreapplication_obips1/
Error
--> Process (index=1,uid=1445883998,pid=0)
Executable file does not have execute permission
/u01/app/oracle/obiee11g/Oracle_BI1/bifoundation/web/bin/sawserver
failed to start a managed process after the maximum retry limit
Executable file does not have execute permission
/u01/app/oracle/obiee11g/Oracle_BI1/bifoundation/web/bin/sawserver
Log:
none
ias-component/process-type/process-set:
coreapplication_obisch1/OracleBISchedulerComponent/coreapplication_obisch1/
Error
--> Process (index=1,uid=1445884000,pid=18523)
failed to start a managed process after the maximum retry limit
Log:
/u01/app/oracle/obiee11g/instances/instance1/diagnostics/logs/OracleBISchedulerComponent/coreapplication_obisch1/console~coreapplication_obisch1~1.log
ias-component/process-type/process-set:
coreapplication_obiccs1/OracleBIClusterControllerComponent/BIClusterController/
Error
--> Process (index=1,uid=1445884001,pid=0)
Executable file does not have execute permission
/u01/app/oracle/obiee11g/Oracle_BI1/bifoundation/server/bin/nqsclustercontroller
failed to start a managed process after the maximum retry limit
The important things to note are:
- You may encounter all, some, or just 1 of your bi_services which fail to start. In the above example, the following services failed to start:
- BI Server
- BI Publisher
- BI Cluster Controller
- BI Scheduler
- There are actually two issues:
- Managed Processes failed to start after the maximum retry limit
- Certain executable files do not have the execute permission enabled
This can be easily resolved by setting the ulimit at the user level to : ulimit -d unlimited , as outlined in Oracle's note ID: 1292887.1 . Anyone who has worked in OBIEE 10g should be familiar with this as it is required in 10g's installation process as well.
Issue 2: Enable read access on executable files
If you tried re-running opmnctl startall after resolving issue 1, you'll notice that the BI services still fail to run despite increasing the maximum retry limit. Upon examining the log files as outlined in the above error:
- u01/app/oracle/obiee11g/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/console~coreapplication_obis1~1.log
- u01/app/oracle/obiee11g/instances/instance1/diagnostics/logs/OracleBISchedulerComponent/coreapplication_obisch1/console~coreapplication_obisch1~1.log
/export/obiee/11g/Oracle_BI1/bifoundation/server/bin/biserver.sh: nqsserver: cannot execute--------
12/11/06 15:48:06 Start process
--------
/export/obiee/11g/Oracle_BI1/bifoundation/server/bin/biserver.sh: nqsserver: cannot execute
During the 11.1.1.6.4 upgrade on your Solaris or Linux box, these files became read only!
How to resolve this read only issue:
Navigate to your $ORACLE_HOME/bifoundation/server/bin folder and make the the following files executable by using the chmod +x command: nqscheduler, nqsclustercontroller, nqsserver. These files should have read/write privileges as outlined in the image below:
Now when you run opmnctl startall, all services should execute successfully:
Important:
After the upgrade, it is critical that you follow Oracle's recommended start up & shutdown sequence for weblogic & OBIEE 11g
Start up:
- $DOMAIN_HOME/bin/startWebLogic.sh (Weblogic)
- $WL_HOME/server/bin/startNodeManager.sh (Node Manager)
- $DOMAIN_HOME/bin/startManagedWebLogic.sh bi_server1 http://server.domain:7001 (Managed Server)
- $ORACLE_INSTANCE/bin/opmnctl startall (OPMN)
Shutdown:
- $ORACLE_INSTANCE/bin/opmnctl stopall (OPMN)
- $DOMAIN_HOME/bin/stopManagedWebLogic.sh bi_server1 t3://host.domain:7001 username password (Managed Server)
- $DOMAIN_HOME/bin/stopWebLogic.sh username password t3://host.domain:7001 (Admin Server)
In my upcoming blog post i'll discuss how to automate this entire process.
keywords: opmn , opmn start failed, obiee 11g, opmn obiee weblogic, bi_server
How-to: Apply OBIEE 11g Bundle Patch Set (11.1.1.6.4)
If you've been following the patch set history for Oracle Business Intelligence 11g, you'll notice that Oracle releases various OBIEE patches on a fairly regular basis - anywhere from every quarter to every month.
Unfortunately Oracle doesn't announce a new patch set via oracle.com or through any type of mass mailing. So to stay up to date you'll need to review the Oracle Reference Document '[ID 1488475.1] OBIEE 11g Required and Recommended Patch Sets' on http://support.oracle.com .
Today we'll cover how to apply Oracle's newest bundle patch (I call them mega patches!) 11.1.1.6.4. The bundle patches are actually a set of cumulative patches for Oracle Business Intelligence. Meaning, if you apply the 11.1.1.6.4 patch set, you do not need to apply 11.1.1.6.2 as it is already included.
Step 1) Make sure you have the latest OPatch installed on your machine
Oracle uses the Opatch tool to apply patches to OBIEE 11g, and if you attempt to apply a patch with an outdated Opatch version, you get the following error:
You can download the latest version of Opatch by searching http://support.oracle.com for 'How To Download And Install The Latest OPatch Version [ID 274526.1]' or by clicking here
Step 1.1) Extract the opatch folder to your FMW_HOME/Oracle_BI1 folder. There is most likely an Opatch folder already in there - that is the old version. Archive it then remove it from the Oracle_BI1 folder and replace it with the Opatch folder you just downloaded.
Step 2) Back Up Critical Folders
Make sure to save the following folders in the event of a failure when applying the patch set:
The entire weblogic domain must be shut down prior to applying the patch set
Step 4) Confirm Key Environment Variables are Set
On Windows: If the Oracle BI Home directory is C:prod_mwhomeOracle_BI1, then set the environment variables by entering the following:
The quickest way to do this is by navigating to the 'Patches & Updates' tab on support.oracle.com and using the 'Product or Family (advanced)' search feature to download the patch set for your specific OS:
Make sure you check 'Include all products in a family'!
Step 6) Unzip the patch set into your $FMW_HOME/Oracle_BI1 folder
There should be 7 folders - one for each patch:
Step 7) Remove Catalog Manager Cache Files (if they exist)
org.eclipse.osgi
org.eclipse.equinox.app
Step 8) Apply the 7 patches in the 11.1.1.6.4 patch set
It is important that you apply the patches in the following order:
Step 9) Download the JDeveloper Patch
The Oracle Reference Document '[ID 1488475.1] OBIEE 11g Required and Recommended Patch Sets' on http://support.oracle.com indicates that for 11.1.1.6.4 patch set you need to download and apply JDeveloper patch 13952743 which is not included in the core 7 patches. Make sure to download 13952743 and unzip it to your $FMW_HOME/Oracle_BI1 folder as well.
Step 10) Update Environment Variables for the JDeveloper Patch
You'll need to change your environment variables for this patch as follows:
$ORACLE_HOME = FMW_HOME/oracle_common
Step 11) Apply the JDeveloper Patch
Using the same opatch apply command. Make sure you navigate to the 13952743 folder first!
Step 12) Validate all patches have been applied
Execute the following command: opatch lsinventory . All 8 patches should be listed.
Step 13) Validate Version in Answers
After starting your Admin Server, Node Manager, Managed Server and OPMN services. Navigate to your Administration tab in Answers to view the new version:
Potential Issue: Conflict with previous patches
In my earlier post I outlined how to apply an individual patch to resolve bug 1467168.1 (multiple pie charts error) by applying patch 14003822 .
If you've applied any individual patch and then later try to apply a bundle patch you'll get the following error:
indicating there is a conflict between the original patch and the 11.1.1.6.4 bundle patch. Go ahead and override the original patch with the new 11.1.1.6.4 patch set. This new patch set also includes any one off patches you've applied so it's safe to override.
keywords: obiee 11g upgrade, obiee upgrade, upgrade assistant, opatch, 11.1.1.6.4, how to install obiee 11g
Unfortunately Oracle doesn't announce a new patch set via oracle.com or through any type of mass mailing. So to stay up to date you'll need to review the Oracle Reference Document '[ID 1488475.1] OBIEE 11g Required and Recommended Patch Sets' on http://support.oracle.com .
Today we'll cover how to apply Oracle's newest bundle patch (I call them mega patches!) 11.1.1.6.4. The bundle patches are actually a set of cumulative patches for Oracle Business Intelligence. Meaning, if you apply the 11.1.1.6.4 patch set, you do not need to apply 11.1.1.6.2 as it is already included.
Step 1) Make sure you have the latest OPatch installed on your machine
Oracle uses the Opatch tool to apply patches to OBIEE 11g, and if you attempt to apply a patch with an outdated Opatch version, you get the following error:
"The OUI version is not applicable for current OPatch Version":
You can download the latest version of Opatch by searching http://support.oracle.com for 'How To Download And Install The Latest OPatch Version [ID 274526.1]' or by clicking here
Step 1.1) Extract the opatch folder to your FMW_HOME/Oracle_BI1 folder. There is most likely an Opatch folder already in there - that is the old version. Archive it then remove it from the Oracle_BI1 folder and replace it with the Opatch folder you just downloaded.
Step 2) Back Up Critical Folders
Make sure to save the following folders in the event of a failure when applying the patch set:
- The ORACLE_HOMEbifoundationserver directory
- The ORACLE_INSTANCEbifoundationOracleBIServerComponentcoreapplication_obis1repository
- The ORACLE_BI_HOMEbifoundationjeemapviewer.earweb.warWEB_INFconfmapViewerConfig.xml, if you have modified it
The entire weblogic domain must be shut down prior to applying the patch set
Step 4) Confirm Key Environment Variables are Set
On Windows: If the Oracle BI Home directory is C:prod_mwhomeOracle_BI1, then set the environment variables by entering the following:
- set ORACLE_HOME=C:prod_mwhomeOracle_BI1
- set PATH=%ORACLE_HOME%bin;%PATH%
- set JAVA_HOME=%ORACLE_HOME%jdk
- set PATH=%JAVA_HOME%bin;%PATH%
- set PATH=%ORACLE_HOME%OPatch;%PATH%
The quickest way to do this is by navigating to the 'Patches & Updates' tab on support.oracle.com and using the 'Product or Family (advanced)' search feature to download the patch set for your specific OS:
Make sure you check 'Include all products in a family'!
Step 6) Unzip the patch set into your $FMW_HOME/Oracle_BI1 folder
There should be 7 folders - one for each patch:
| Patch | Abstract |
|---|---|
14538078 | Patch 11.1.1.6.4 (1 of 7) Oracle Business Intelligence Installer |
14538128 | Patch 11.1.1.6.4 (2 of 7) Oracle Real Time Decisions |
14285344 | Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher |
14538164 | Patch 11.1.1.6.4 (4 of 7) Oracle Business Intelligence ADF Components |
14415773 | Patch 11.1.1.6.4 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x |
14405222 | Patch 11.1.1.6.4 (6 of 7) Oracle Business Intelligence |
14409674 | Patch 11.1.1.6.4 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer |
- On Linux, AIX, or Solaris: If the Oracle BI Home directory is prod_mwhome/Oracle_BI1, then go to the following directory:prod_mwhome/Oracle_BI1/bifoundation/web/catalogmanager/configuration/
- On Windows: If the Oracle Home directory is C:prod_mwhomeOracle_BI1, then go to the following directory: c:prod_mwhomeOracle_BI1bifoundationwebcatalogmanagerconfiguration
org.eclipse.osgi
org.eclipse.equinox.app
Step 8) Apply the 7 patches in the 11.1.1.6.4 patch set
It is important that you apply the patches in the following order:
- 14538078
- 14538128
- 14285344
- 14538164
- 14415773
- 14405222
- 14409674
Step 9) Download the JDeveloper Patch
The Oracle Reference Document '[ID 1488475.1] OBIEE 11g Required and Recommended Patch Sets' on http://support.oracle.com indicates that for 11.1.1.6.4 patch set you need to download and apply JDeveloper patch 13952743 which is not included in the core 7 patches. Make sure to download 13952743 and unzip it to your $FMW_HOME/Oracle_BI1 folder as well.
Step 10) Update Environment Variables for the JDeveloper Patch
You'll need to change your environment variables for this patch as follows:
$ORACLE_HOME = FMW_HOME/oracle_common
Step 11) Apply the JDeveloper Patch
Using the same opatch apply command. Make sure you navigate to the 13952743 folder first!
Step 12) Validate all patches have been applied
Execute the following command: opatch lsinventory . All 8 patches should be listed.
Step 13) Validate Version in Answers
After starting your Admin Server, Node Manager, Managed Server and OPMN services. Navigate to your Administration tab in Answers to view the new version:
Potential Issue: Conflict with previous patches
In my earlier post I outlined how to apply an individual patch to resolve bug 1467168.1 (multiple pie charts error) by applying patch 14003822 .
If you've applied any individual patch and then later try to apply a bundle patch you'll get the following error:
keywords: obiee 11g upgrade, obiee upgrade, upgrade assistant, opatch, 11.1.1.6.4, how to install obiee 11g
Understanding Oracle BI 11g Security vs Legacy Oracle BI 10g
After conducting a large amount of Oracle BI 10g to Oracle BI 11g upgrades and after writing the book, I still continually get asked one of the most basic question regarding security in Oracle BI 11g; How does it compare to Oracle BI 10g? The trail of questions typically goes on to what are the differences? And, how do we leverage our current Oracle BI 10g security table schema in Oracle BI 11g?
11.1.1.6.4 patch has been released for OBIEE
Patch 11.1.1.6.4 is here and can be downloaded from MOS.
Once more it's a 7-pack patch and here are the patch numbers and direct links:
Patch 14538078: PATCH 11.1.1.6.4 (1 OF 7) ORACLE BUSINESS INTELLIGENCE INSTALLER
Patch 14538128: PATCH 11.1.1.6.4 (2 OF 7) ORACLE REAL TIME DECISIONS
Patch 14285344: Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher
Patch 14538164: PATCH 11.1.1.6.4 ( 4 OF 7) ORACLE BUSINESS INTELLIGENCE ADF COMPONENTS
Patch 14415773: Patch 11.1.1.6.4 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
Patch 14405222: Patch 11.1.1.6.4 (6 of 7) Oracle Business Intelligence
Patch 14409674: Patch 11.1.1.6.4 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer
Documentation's here: https://updates.oracle.com/Orion/Services/download?type=readme&aru=15499675
Cheers!
Once more it's a 7-pack patch and here are the patch numbers and direct links:
Patch 14538078: PATCH 11.1.1.6.4 (1 OF 7) ORACLE BUSINESS INTELLIGENCE INSTALLER
Patch 14538128: PATCH 11.1.1.6.4 (2 OF 7) ORACLE REAL TIME DECISIONS
Patch 14285344: Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher
Patch 14538164: PATCH 11.1.1.6.4 ( 4 OF 7) ORACLE BUSINESS INTELLIGENCE ADF COMPONENTS
Patch 14415773: Patch 11.1.1.6.4 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
Patch 14405222: Patch 11.1.1.6.4 (6 of 7) Oracle Business Intelligence
Patch 14409674: Patch 11.1.1.6.4 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer
Documentation's here: https://updates.oracle.com/Orion/Services/download?type=readme&aru=15499675
Cheers!
