Category Archives: OBIEE 11G

OBIEE CPU Patches — Where To Find OBIEE 10g and 11g Critical Patch Updates (CPU) Patches And/Or Security Alerts

Applies to:

Business Intelligence Server Enterprise Edition – Version: 10.1.3.4.1 [1900] to 11.1.1.5.0 [1308] – Release: 10g to 11g
Business Intelligence Server Enterprise Edition – Version: 10.1.3.4.1 [1900] to 11.1.1.5.0 [1308]   [Release: 10g to 11g]
Information in this document applies to any platform.

Goal

How can you determine if there are any Oracle Critical Patch Updates (CPU) and/or Security Alerts for Oracle Business Intelligence Enterprise Edition (OBIEE) 10g and 11g?

Solution

Critical Patch Updates and Security Alerts

Critical Patch Updates (CPU) and Security Alerts notifications are posted on the Oracle Technology Network (OTN) website.  This website maintains a listing of all Oracle products including OBIEE and typically gets updated quarterly, or as needed.  It is possible to receive notification of new CPU and security alerts by email.

Critical Patch Updates (CPU) Patches are cumulative for many Oracle products. This means that, for these products, a CPU includes new security fixes as well as all previously released CPU fixes for this particular
platform and version combination. The main benefit of cumulative CPUs is that it allows customers to
quickly and easily “catch up ” to current security release level by only applying the most recent CPU.

For example,you have the patch for Oct 2011, you do not need to first apply the patch for Jul 2011. Applying the most current CPU patch will include all current fixes.
However, each CPU advisory describes only the security fixes added since the previous Critical Patch Update advisory. Thus, prior Critical Patch Update advisories should be reviewed for information regarding earlier published security fixes.

Full details on released CPU patches and how to enable alerts can be found here.

Locating OBIEE CPU Patch
To determine if a recent CPU Patch affects OBIEE, you will need to go to CPU Patch link  http://www.oracle.com/technetwork/topics/security/alerts-086861.html

Look for section ” Critical Patch Updates” . There will be many links available for CPU patches released during different months. One needs to review these links according to what CPU patches one is looking for.

For example, you can click CPU Patch link(i.e. “Critical Patch Update – October 2011″ )
http://www.oracle.com/technetwork/topics/security/cpuoct2011-330135.html and it will bring up a new page.
In the new page, look for section ” Affected Products and Components” and under this section look for
OBIEE (i.e. “Oracle Business Intelligence Enterprise Edition, versions 10.1.3.4.1, 11.1.1.3, 11.1.1.5″). If you see references to OBIEE, click the Patch Availability ” Fusion Middleware” link and review the patch release notes for applicable patches.

For example, when using the steps just described, you will see section titled “3.2.2 Oracle Business Intelligence Enterprise Edition” and will find the latest CPU patches.

Here you will notice that CPU patches were released for OBIEE for Oct 2011 <<12830486, 12830471>>, July: Patch 11833743 for OBIEE 10g and so on.

The OBIEE Dashboard Is Empty After Upgrading From 10g To OBIEE 11g

Applies to:

Business Intelligence Interactive Dashboard – Version: 11.1.1.5.0 [1308] and later   [Release: 11g and later ]
Information in this document applies to any platform.

Symptoms

Recently upgraded Oracle Business Intelligence Enterprise Edition (OBIEE) from 10g to 11g (OBIEE 11.1.1.5).
All upgrade steps were completed as described in the Upgrade Guide for Oracle Business Intelligence
11g; including upgrading the web catalog and repository (RPD).
The repository was checked and there were no errors.
When logging in to OBIEE Presentation server as a user with OBIEE Administrator role, the 11g dashboard is empty and expected content is not present.

Changes

Upgraded from 10g to 11g.

Cause

Insufficient permissions on ‘shared folders.’
The permissions on catalog folder ‘shared folders’ were available only for ‘Authenticated user’ and ‘Presentation Server Administrators’.

Solution

Login to OBIEE Presentation server as WLS or biadmin user and select Administration link ->
add relevant application role e.g. ‘BI Administrator role’ and grant at least read and traverse permissions to the ‘shared folders.’
Also ensure that you tick the check boxes to apply permissions to all items within the folder and sub folders.

OBIEE 11g: Error: “Server not initialized. Please make sure the repository is ready” When Accessing BI Publisher from OBIEE 11g After Upgrading Repository from 10g to 11g

Applies to:

Business Intelligence Server Enterprise Edition – Version: 11.1.1.3.0 [1905] to 11.1.1.5.0 [1308] – Release: 11g to 11g
Business Intelligence Suite Enterprise Edition – Version: 11.1.1.3.0 [1905] to 11.1.1.5.0 [1308]   [Release: 11g to 11g]
Information in this document applies to any platform.

Symptoms

You have installed OBIEE 11g and upgraded the repository from 10g to 11g.  You log into OBIEE as Administrator and click on the Administration link and then the Manage BI Publisher link.  You get the error:
Server not initialized. Please make sure the repository is ready

Cause

You are missing the privileges Access to SOAP and Impersonate as System User from the  BIAdministrator and BISystem roles.

The BISystemUser communicates with the different components of the OBIEE and when BI Publisher is accessed from answers, it communicates with BI Publisher via SOAP.  The Access to SOAP privilege should be granted to the BISystem role.  Also the Impersonate as System User privilege should be granted to the BIAdministrator and BISystem roles.

Solution

1. Log in to OBIEE 11g with Administrator credentials (superuser in 10g rpd which was upgraded to 11g).

Note: The reason you need to log into OBIEE 11g with Administrator credentials, is because the error is seen only with an upgraded 10g repository.  Also the superuser in OBIEE 11g (the user created at the time of 11g install, the default name of which is weblogic) will not have access to the Administration link with the upgraded repository. See note 1262219.1 for how to add the missing Administration link in OBIEE 11g with the upgraded repository.

2. Click on Administration > Manage Privileges.

3. Assign BISystem or BIConsumer roles the Access to SOAP privilege.

4. Assign Impersonate as System User to BIAdministrator or BISystem role.

Starting OBIEE 11g Server Or Running Requests After Upgrade From OBIEE 10g Fails With Error: “ORA-12504 or ORA-12154″

Applies to Business Intelligence Suite Enterprise Edition – Version: 11.1.1.3.0 [1905] to 11.1.1.5.0 [1308]   [Release: 11g to 11g]

Symptoms

After upgrading to Oracle Business Intelligence Enterprise Edition (OBIEE) 10g to OBIEE 11g, when viewing a dashboard or creating a new analysis in Answers, the following error occurs:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 12504, message: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
Or you might get the error:

[2010-11-16T06:02:38.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004_ILDmfHpFw000jzwkno0002Xk0000qx] [tid: 4f353960] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 43113] Message returned from OBIS.
It looks like all the database connections have been broken.

Another symptom that may occur is that the BI Server does not start up and you get the following error in the nqserver.log:

[ecid: 00hxwa3cUNZ4aq_S9Q2FSx0001SO000000] [tid: 814] [36007] Loading repository E:\obiee11g\instances\instance2\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository\11rpd.rpd.
[2011-01-06T20:20:52.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00hxwa3cUNZ4aq_S9Q2FSx0001SO000000] [tid: 19b4] [nQSError: 17014] Could not connect to Oracle database. [[[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specifiedat OCI call OCILogon.

Changes

Upgraded from OBIEE 10g to OBIEE 11g.

Cause

In OBIEE versions prior to 11g, it uses the database client home tnsnames.ora file to resolve the tnsname. But OBIEE 11g uses the tnsnames.ora file installed within its installation home. The path is
[middleware home]/[oracle home]/Oracle_BI1/network/admin
By default, there are no database tns alias descriptors configured.

Solution

There are three ways to solve this problem:

1. If you just need one TNS alias, then copy the database connection descriptor from database tnsnames.ora file to the tnsnames.ora file under the BIEE directory:

[middleware home]/[oracle home]/Oracle_BI1/network/admin

2. You  may also copy the entire tnsnames.ora file

3. Another alternative is to set the TNS_ADMIN environment varaible which would point to the directory where a tnsnames.ora file is located. This would need to be set as a System Environment variable in Windows or in the command shell if starting from a command-line. For Unix/Linux, it would need to configured in the user profile that owns the software or set explicitly in the shell if starting from the command-line.