Friday, October 25, 2013

OBIEE Architecture Design based on type of Installation



OBIEE Architecture Design  based on type of Installation:

The Oracle Business Intelligence 11g logical architecture comprises a single integrated set of manageable components which can be installed and configured to work together on a single host or can be clustered across multiple hosts for performance and availability

3 Types of Installation are available:

Simple Install

Purpose: Demonstration and Evaluation Single-User Development
Definition: Installation with the default settings on a single computer in the minimum number of steps.
Managed Server is not installed. Mainly used for demonstration, or PoC

Enterprise Install

Purpose: Enterprise Deployment for Hosted Development and Production
Definition : Enterprise Install type enables you to specify several more configuration settings than the simple

Software Only Install

Purpose: Enterprise Deployment for Highest Levels of Availability and Security
Definition: Installation of the binary files in Middleware home and useful if you want to have multiple domains or products share a common Middleware Home







Oracle Business Intelligence Components :

Java Components (WebLogic Domain)
Deployed as JEE applications
To service SOAP, HTTP, and other forms of requests
System Components (BI Instance)
Deployed as server processes
Provide the core services that enable OBI
Other Domain Contents
Includes all the necessary software, metadata, configuration files, RPD files, Oracle BI Presentation Catalog, and connection and database configuration information that are
required to run an Oracle Business Intelligence system.

They are managed mainly by 2 administrative user interface :
WebLogic Server Administration Console — which provides advanced management for Weblogic, Java components (BI Publisher, MapViewer, …), and security. 
 Fusion Middleware Control (Enterprise Manager) — which is used to manage the system components (C++, JSE) (BI Server, BI Presentation Services, Scheduler, ….)

Oracle Business Intelligence Components:

Administration Server
Components for administering the system are :

Web Logic Server Administration Console
Monitoring the health and performance of JEE servers
Configuring WebLogic server domains
Stopping and starting JEE servers
Viewing JEE server logs
Managing users in the LDAP Server of the WebLogic Server
Fusion Middleware Control
Starting, stopping, and restarting all system components
Scaling out of system components
Managing performance and monitoring system metrics
Performing diagnostics and logging
JMX Mbeans
Provides programmatic access for managing a BI domain


Managed Server and Node Manager
Managed Server
Provides run-time environment for the Java-based services and applications within the system
Node Manager
Process management services for the Administration Server and Managed Server processes

Managed Server Components
Oracle BI Presentation Services Plug-in
Routes HTTP and SOAP requests to Oracle BI Presentation Services
Oracle BI Action Services
Web services required by the Action Framework
Oracle BI Security Services
Integration of the Oracle BI Server with the Oracle Fusion Middleware security platform
Oracle BI Publisher
Enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents
Oracle Real-Time Decisions (Oracle RTD)
Analytics software solutions allowing companies to make better decisions in real time
Oracle BI SOA Services
Invoke OBI functionality from Business Process Execution Language (BPEL) processes
System Components
System components are deployed as non-JEE components (C++ and J2SE)
Oracle BI Server
– Query and data access capabilities at the centre of OBI
– Provides services for accessing and managing the enterprise semantic model. Also RPD resides here
Oracle BI Presentation Services
– Framework and interface for the presentation of BI data to Web clients
Oracle BI Scheduler
– Scheduling for analyses to be delivered to users at specified times
Oracle BI JavaHost
– Supports various components such as Java tasks for Oracle BI Scheduler,Oracle BI Publisher, and graph generation
– Also enables Oracle BI Server query access to Hyperion Financial Management and
Oracle OLAP data sources
Oracle BI Cluster Controller
– Distributes requests to the BI Server
Ensuring requests are evenly load-balanced across all BI Server process in the BI Domain


Oracle Process Manager and Notification Server (OPMN)
OPMN
Manage system components for Oracle Business Intelligence (for advanced users)
Supports both local and distributed process management
OPMN and Fusion Middleware Control
Fusion Middleware Control is the recommended approach for starting, stopping,
and viewing the status of components
OPMN is suitable only for advanced users

Basic Directory Structure of OBIEE :



WebLogic Server home
WebLogic Server home
Contains Java components
User Projects
contains product domains (including one or more Oracle Business Intelligence domains),
Administration Server, and one or more Managed Servers
Oracle BI Home
Contains all the binary files (read-only) that are specific to Oracle Business Intelligence


 Some Useful Directories of the BI Instance:

Repository
%Middleware Home%\instances\instance1\bifoundation\OracleBIServerComponent\
coreapplication_obis1\repository
Web Catalog
%Middleware Home%\instances\instance1\bifoundation\OracleBIPresentationServerComponent\
coreapplication_obis1\catalog
NQSConfig.ini
%Middleware Home%\instances\instance1\config\OracleBIServerComponent\
coreapplication_obis1\repository
instanceconfig.ini
%Middleware Home%\instances\instance1\config\OracleBIPresentationServerComponent\
coreapplication_obis1\catalog
BI Server Logs (nqserver.log, nqquery.log)
%Middleware Home%\instances\instance1\diagnostics\logs\OracleBIPresentationServerComponent\
coreapplication_obis1

See you next tym :)    (Courtesy : Google)






Friday, September 13, 2013

Connection Pools



Connection Pools – What it is and Best Practices 

The Connection pool is an object in the Physical layer that describes access to the data source. It contains information about the connection between the Oracle BI Server and that data source.
The Physical layer in the Administration Tool contains at least one connection pool for each database. When you create the Physical layer by importing a schema for a data source, the connection pool is created automatically. You can configure multiple connection pools for a database.
Connection pools allow multiple concurrent data source requests (queries) to share a single database connection, reducing the overhead of connecting to a database. For each connection pool, you must specify the maximum number of concurrent connections allowed. After this limit is reached, the connection request waits until a connection becomes available. Increasing the allowed number of concurrent connections can potentially increase the load on the underlying database accessed by the connection pool.
Improperly defined connection pool would affect the OBIEE performance and user experience. Here are some tips to consider while defining connection pool.
  • Change the default maximum connections. The default is 10. Based on your system usage change the value that is more realistic to your system usage
  • Create a separate connection pool for execution of session variables
  • Create a separate connection pool for the execution of aggregate persistence wizard. Remember that you need to give the schema user owner credentials for this connection pool as the wizard creates and drops tables
  • If need be create a separate connection pool for VVIPs. You can control who gets to use the connection pool based on the connection pool permissions.

Log Files paths in OBIEE 11g ..Imp to know !!



Log files store all important information required to troubleshoot issues. Best way in OBIEE 11g, is to get them from Enterprise Manager Console.But we can still see these files in OBIEE install directory.
  • Enterprise Manager Console
Log on to EM Console (http://localhost:7001/em) . Once you logged on, in the left pane navigate to Farm_bifoundation_domain –> Business Intelligence–>coreapplications–>Diagnostics–>Log Messages
Here you can see the Most Recent Errors and Most Recent Warnings.
Available files:
• Presentation Services Log
• Server Log
• Scheduler Log
• Cluster Controller Log and many more
  • Log files in OBIEE Install directory
We can find all log files for OBIEE Components in OBIEE install directory under OBIEE_HOME/instances/instance1/diagnostics/logs 

These are the different type of log files:
Presentation Server log files
/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

BI Server log files
/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

Scheduler log
/instances/instance1/diagnostics/logsOracleBISchedulerComponent/coreapplication_obisch1

Cluster Controller log
/instances/instance1/diagnostics/logs/OracleBIClusterControllerComponent\coreapplication_obiccs1

ODBC log
/instances/instance1/diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1

OPMN log
/instances/instance1/diagnostics/logs/OPMN/opmn

Web logic Server Log Locations: You can also find out server related logs at below locations:

BI Managed Server:

OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\bi_server1\logs


Admin Server:

OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\AdminServer\logs


=============================================================
Other Important file paths:

Catalog Path

Drive:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog

Repository Path

D:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

Instanceconfig.xml ----> file path

D:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

NQSConfig.INI file path :

D:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1