OBIEE11g Installation Issues along with Resolution

While installing OBIEE11g in Windows os 10 Perform below steps to avoid bipublisher settings issue:

for setup.exe file in "....\OBIEE\11g_Installables\obi_WINDOWSX64_11.1.1.9.0_disk1of5\bishiphome\Disk1"

change the Compatibility Mode as "Run this programe in compatibility mode for "Windows 7" and Click "run as Administartor on setup.exe file

Install Loopbackadaptor and change the hostsfile as mentioned below:
http://gerardnico.com/wiki/windows/loop_back_adaptater


##########################################################################################################################################################################################
1) To Create OCI while importing data from Database in OBIEE RPD, we need to place entire admin folder from "....\product\11.2.0\dbhome_1\NETWORK\ADMIN" to "<<ORACLEBIHOME>>\network"
##########################################################################################################################################################################################

##########################################################################################################################################################################################
2) If RCU gets failed due to below error then run sql "revoke connect from dev_mds";

----------------------------------------------------------------------------------------------------------------------------------------------------------------------
RCU-6083:Failed - Check prerequisites requirement for selected component:MDS
Please refer to RCU log at ....\OBIEE\RCU\rcuHome\rcu\log\logdir.2017-01-15_14-01\rcu.log for details.
The schema owner 'DEV_MDS' is connected to the database. Please disconnect and try again.

RCU-6092:Component Selection validation failed. Please refer to log at ....\OBIEE\RCU\rcuHome\rcu\log\logdir.2017-01-15_14-01\rcu.log for details.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------

##########################################################################################################################################################################################

3) If login page is working and unable to login to application with weblogic user and if BIserver logs and presentation server logs says below:

BI Server:
ISSUE:
Error retrieving user/group data from Oracle BI Server’s User Population API.
Unable to create a system user connection to BI Server while running user population queries

[2017-02-15T18:47:53.228+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 5480fcdc22ba98bf:35c9780b:15a41c710ef:-8000-00000000000003fd,0:1:1:6] [tid: 12a4]  [nQSError: 13057] Error From BI Security Service: SecurityService::execute [OBI-SEC-00048] Identity store provider error. [[

**********  Task: 1. Running for (mls): 21047 **********
Description: Authenticate
RPID: Star; user: weblogic; AppType: 0; Offline: false


[2017-02-15T19:08:36.94+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00idmWJQjAOFw0zknV0DVz5NPoU2zmYwD00033400001_,0] [tid: 2010]  [nQSError: 13057] Error From BI Security Service: SecurityService::execute [OBI-SEC-00048] Identity store provider error. [[

**********  Task: 1. Running for (mls): 21094 **********
Description: Authenticate
RPID: Star; user: BISystemUser; AppType: 0; Offline: false



Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://lorddisk.wordpress.com/2014/12/12/unable-to-create-a-system-user-connection-to-bi-server-while-running-user-population-queries/

To confirm that the password is correct:

    Log into Oracle WebLogic Server Administration Console.
    Go to Domain Structure and click Security Realms, and select myrealm. The Settings for myrealm page displays.
    Click the Users and Groups tab, and then the Users subtab.
    In the Users table, locate and select the user that has the BISystem role assigned to it. The settings page displays.
    Click the Passwords tab and reset the user password. Click Save.
    Log into Fusion Applications Control.
    Open the WebLogic Domain node and right-click BIDomain.
    Select Security, and then select Credentials.
    Select oracle.bi.system and the select system.user.
    Edit the password to match the user password that you set in Oracle WebLogic Server.
    Restart the Oracle BI Administration Server, Oracle Managed Server, and Oracle Process Manager and Notification Server

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Presentation Server:
-------------------------------------------
ISSUE1:

 [OBIPS] [WARNING:1] [] [saw.catalog.local.checkforcatalogupgrade] [ecid: ] [tid: ] Upgrade is recommended to the latest catalog version.[[

Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Upgrade OBIEE 11g catalog
http://obieelearner.blogspot.in/2012/07/upgrade-obiee-11g-catalog.html
http://obieeil.blogspot.in/2014/06/obiee-cant-open-catalog-offline-or.html


I have been getting a warning in the OBIPS log:

OBIEE 11g: Warning: "Upgrade is recommended to the latest 11.1.1.6.0 (Build 120104.0800 64-bit) catalog version" After Upgrading to OBIEE 11.1.1.6
so i decided to upgrade the catalog:

Here are the steps:
Note: RPD should be consistent and take a backup of catalog before starting

Step 1: Stop OBIPS
cd ORACLE_INSTANCE/bin
opmnctl stopproc ias-component=coreapplication_obips1

Step 2: find and set the tag UpgradeAndExit to true from false in instanceconfig.xml
<UpgradeAndExit>true<UpgradeAndExit>

Step 3: Start OBIPS
cd ORACLE_INSTANCE/bin
opmnctl startproc ias-component=coreapplication_obips1

Step 4:
After the catalogs are updated, edit the instanceconfig.xml file again and change the upgradeAndExit option back to false.

Step 5: Restart all services.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------


ISSUE2:

[2017-02-15T18:19:49.000+05:30] [OBIPS] [ERROR:31] [] [saw.rpc.client.impl.verify] [ecid: 00idmT_^XCnFw0zknV0DVz5NPoU2zmYwD0002yo000004,0] [tid: 9108] An error occurred during connect to "10.10.10.10:9810". No connection could be made because the target machine actively refused it.

Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://community.oracle.com/thread/3519959?db=5

Try the following to see if it helps

Check in Database where rcu is installed , Check User is Locked

"SELECT username, account_status FROM dba_users;"

List of Locked Users

"SELECT username,account_status,lock_date from dba_users where lock_date IS NOT NULL;"

Unlock User

"ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;"

RESOLUTION:

    Connect to WebLogic Server (WLS) Console -> Deployments. Ensure that all deployed components are in ‘Active’ state.
    Use the command prompt to verify the opmn status, as the EM console will not always reflect the correct status.
    If any of the components is in ‘Prepared’ state, select that application and then click on “start servicing all requests”.
    Restart BI Server and Presentation Services

If this does not resolve the issue please follow the steps below:

    In some cases, the following additional step might be needed to resolve the issue.
    Access the Enterprise Manager Fusion Middleware control: http://<host.domain&gt;:port/em
    Navigate to Business Intelligence -> coreapplication
    ‘Capacity Management’ tab -> ‘Scalability’ sub-tab
    Click on ‘Lock and Edit Configuration’ button
    Enter the IP address in the ‘Listen Address’ field
    Click on ‘Activate Changes’ followed by ‘Release Configuration’ buttons.

Restart BI Server and Presentation Services
----------------------------------------------------------------------------------------------------------------------------------------------------------------------

ISSUE3:

[2017-02-15T18:43:38.000+05:30] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: 5480fcdc22ba98bf:35c9780b:15a41c710ef:-8000-000000000000026b,0:1:1] [tid: 8196] Authentication Failure.
Odbc driver returned an error (SQLDriverConnectW).
State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.


Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://lorddisk.wordpress.com/2014/12/12/unable-to-create-a-system-user-connection-to-bi-server-while-running-user-population-queries/

To confirm that the password is correct:

    Log into Oracle WebLogic Server Administration Console.
    Go to Domain Structure and click Security Realms, and select myrealm. The Settings for myrealm page displays.
    Click the Users and Groups tab, and then the Users subtab.
    In the Users table, locate and select the user that has the BISystem role assigned to it. The settings page displays.
    Click the Passwords tab and reset the user password. Click Save.
    Log into Fusion Applications Control.
    Open the WebLogic Domain node and right-click BIDomain.
    Select Security, and then select Credentials.
    Select oracle.bi.system and the select system.user.
    Edit the password to match the user password that you set in Oracle WebLogic Server.
    Restart the Oracle BI Administration Server, Oracle Managed Server, and Oracle Process Manager and Notification Server

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

##########################################################################################################################################################################################

OBIEE 11G Architecture

Oracle Business Intelligence 11g Release 1 Architecture

The Oracle BI Server provides native, federated access to data sources, together with security, calculations, and data navigation. The Oracle BI Presentation Server connects to the BI Server to obtain data, which it presents to users in the form of analyses, reports, and dashboards.

In addition to these two servers, there are three other servers that work with them to provide core Oracle Business Intelligence functionality:

   Oracle BI Cluster Controller   This server provides a central point of access for the Oracle BI Presentation Server when two or more BI Servers are working together in a cluster, together with load-balancing, failover, and other cluster services.

   Oracle BI Java Host   This server works alongside the BI Presentation Server to provide connectivity to Java tasks and the Java-based Oracle BI Publisher, as well as to support chart generation.

   Oracle BI Scheduler   This server is used to schedule and automate the production and distribution of analyses, as well as to automate workflow tasks based around business intelligence functionality.

These three servers, together with the Oracle BI Server and the Oracle BI Presentation Server, are known in Oracle Business Intelligence 11g Release 1 terminology as system components, and they run as services and servers directly on the host platform. They are operating system executables written in C-based languages.

To create the link between an end user’s web browser and the dashboards, analyses, and reports provided by the Oracle BI Presentation Server, a Java application called the Oracle BI Analytics Plug-In runs in a Java application server and routes incoming requests through to the BI Presentation Server. (Currently, only Oracle WebLogic Server is supported, but later releases of Oracle Business Intelligence should support other application servers.) A simplified schematic of the Oracle Business Intelligence 11g system components, together with the Oracle BI Plug-In, is shown in below

Oracle Business Intelligence system components schematic

 

This basic, internal architecture has stayed consistent since the days of nQuire and Siebel Analytics and is still at the core of the 11g Release of Oracle Business Intelligence. It, together with two additional Java server applications for publishing reports and connecting to Microsoft office, is largely the architecture of the 10g release of Oracle Business Intelligence and would run fairly comfortably on a smaller server, desktop computer, or laptop. Because the product has been adopted within Oracle Corporation as their strategic business intelligence platform and, in particular, because it has been integrated over time into their wider Oracle Fusion Middleware platform due to customer requirements for BI to integrate into wider business processes and applications, these core components have been built on and enhanced with additional Java components to form the more complete architecture used in the 11g Release 1 version.

 

Oracle Business Intelligence 11g and Oracle Fusion Middleware

While the core components within Oracle Business Intelligence remain the Oracle BI Server and Oracle BI Presentation Server, supported by the Oracle BI Scheduler, Oracle Java Host, and Oracle BI Cluster Controller, these have been supplemented in the 11g Release 1 release by Java-based Oracle Fusion Middleware technologies based around the Oracle WebLogic Server application server (with plans to extend this to other non-WebLogic application servers in future releases). While the previous, 10g release of Oracle Business Intelligence made limited use of application server technology to, for example, host the Oracle BI Plug-In and Java-based applications such as Oracle BI Publisher and Oracle BI Office, the 11g release of Oracle Business Intelligence leverages Fusion Middleware and WebLogic technologies in areas such as the following:

   Security and authentication, which are now delegated to Oracle Fusion Middleware 11g, with users and groups now held, by default, in the WebLogic Server LDAP directory rather than the Oracle BI Repository

   Systems administration, now centralized using Oracle Enterprise Manager Fusion Middleware Control

   Connectivity to outside applications and processes through the Java-based Action Service, with security and credentials handled via Fusion Middleware’s credential and policy stores

   Administration scripting using the Oracle WebLogic Scripting Tool and JMX MBeans (Java managed beans that provide the core administration functionality behind Oracle Enterprise Manager Fusion Middleware Control)

   Process management of the system components (BI Server, BI Presentation Server, and so on) through the Oracle Process Manager and Notification Server

   High availability through clustering of WebLogic Managed Servers within a WebLogic domain

Below architecture diagram shows the logical architecture for Oracle Business Intelligence 11g Release 1, which together is called an Oracle BI domain.

The Oracle Business Intelligence 11g logical architecture

This logical architecture is made up of a number of components:

   Oracle BI domain   The complete set of Java and non-Java components that make up a single Oracle Business Intelligence environment

   WebLogic domain   Houses the Java components within the architecture

   WebLogic Server Admin Server   A JEE container (server) that contains a dedicated Java Virtual Machine used for monitoring and managing the system

   WebLogic Server Managed Server   Another dedicated JEE container that, in this case, is used to house the Java applications used by Oracle Business Intelligence

   Java components   Java applications such as the Oracle BI Analytics Plug-In, Oracle BI Publisher, the Action Service, and Oracle BI Office that work alongside the traditional system components described previously

   System components   The term now used for the original BI Server, BI Presentation Server, and other servers used in the core Oracle Business Intelligence architecture

   WebLogic Server Administration Console   An application that runs in the Admin Server and is used for controlling WebLogic Server

   Oracle Enterprise Manager Fusion Middleware Control   For managing the Oracle Business Intelligence system across a single or multiple cluster nodes

   Supporting database schemas   Created using the Oracle Fusion Middleware Repository Creation Utility, which contains relational tables used for storing additional Oracle Business Intelligence metadata (BIPLATFORM) and metadata used by Oracle Fusion Middleware’s Metadata Services (MDS)