Search This Blog
Thursday, 28 August 2014
Friday, 1 August 2014
OBIA 11.1.1.8.1 Documentation and Product Guide
You can find the most important OBIA 11.1.1.8.1 documentation at the following locations :
Oracle Business Intelligence Applications (OBIA) Release 11.1.1.8.1 Documentation Library
Major topics :
- Install Guide
- Configuration Guide
- ETL Guide
- Administrator’s Guide
- Security Guide
- Release Notes
BI Applications 11.1.1.8.1 Data Model Reference Guide
Major Topics :
The information provided in this document includes data modeling concepts, nomenclature, table and column descriptions, and star schema diagrams. This information is useful for understanding the functional areas that are mapped in the Oracle Business Analytics Warehouse.
BI Applications 11.1.1.8.1 Content Guide
Content Guide includes following topics for BIApps 11.1.1.8.1:
Section 1, “Oracle Business Intelligence Applications – Licenses and Products
Provides a list of all Products within Oracle Fusion BI Applications
Section 2, “Oracle Business Intelligence Applications – Dashboard
Provides a list of dashboards for each application along with their paths
Section 3, “Oracle Business Intelligence Applications – Dashboards and Reports
Provides a list of dashboards and reports for each application along with their exact paths
Section 4, “Oracle Business Intelligence Applications – All Reports
Provides a complete list of reports including those not exposed in any dashboard page
Section 5, “Oracle Business Intelligence Applications – Subject Areas
Provides a high level overview of the subject areas included in each application
Section 6, “Oracle Business Intelligence Applications – Facts & Dims by Application
Provides a list of fact and dimension relationships for each presentation catalog. The user can filter on a particular dimension table and find all its fact tables across presentation catalogs and vice versa
Section 7, “Oracle Business Intelligence Applications – Webcatalog Function Security
Provides a list of report name, path, associated users, duty/roles and permissions
Cheers!
Bose
Tuesday, 24 June 2014
How to Start and Stop OBIEE 11g in Linux
Create boot.properties:
Create a
"boot.properties" file for each of the servers, so we don't need to
manually enter credentials on startup/shutdown. This only has to be done once.
# AdminServer
echo "username=weblogic" >
$DOMAIN_HOME/servers/AdminServer/security/boot.properties
echo "password=Admin123" >> $DOMAIN_HOME/servers/AdminServer/security/boot.properties
# bi_server1
cp
$DOMAIN_HOME/servers/AdminServer/security/boot.properties
$DOMAIN_HOME/servers/bi_server1/security/boot.properties
Linux Command Terminal |
$ nohup $DOMAIN_HOME/bin/startWebLogic.sh & |
After issueing the
start command we tail the log until we see the message below, indicating that
the server has started successfully.
<WebLogicServer> <BEA-000360> <Server started in RUNNING
mode>
Step 2 of 4: Start NodeManager
There should be a
single Node Manager for the machine. Start it up with the
command below.
Linux Command Line |
$ nohup $MW_HOME/wlserver_10.3/server/bin/startNodeManager.sh
> NOD.out & |
After issuing the
start command we tail the log until we see the message below, indicating that
the server has started successfully.
<Info> <Secure socket listener started on port ####>
Step 3 of 4: Start ManagedWeblogicServer
By default there
should be one managed server, bi_server1 that we will start up. At this
point you should start any other Managed Servers in this Weblogic
domain.
Linux Command Line |
$ nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh bi_server1 & |
After issueing the
start command we tail the log until we see the message below, indicating that
the server has started successfully.
Server started in RUNNING mode
Step 4 of 4: Startup OPMN Components
Oracle Process Manager
should be used to shutdown all system components.
Linux Command Line |
$ nohup $MW_HOME/instances/instance1/bin/opmnctl startall |
Stopping OBIEE 11g services:
It
is exactly in the opposite process of the starting the services. Follow below
steps:
Step 1 of 4: Stop all the OPMN Components
Oracle Process Manager
should be used to shutdown all system components.
Linux Command Line |
$ $MW_HOME/instances/instance1/bin/opmnctl stopall |
Step 2 of 4: Shutdown Managed Server
By default there
should be one managed server, bi_server1 that we will shut down. At the
point you should shut down any other Managed Servers in this WebLogic domain.
Linux Command Line |
$DOMAIN_HOME/bin/stopManagedWebLogic.sh bi_server1 |
Verify that the
Managed Server has shut down completely with the following commands
$ ps -ef | grep
bi_server1.
Step 3 of 4: Shutdown Node Manager
There should be a
single Node Manager for the machine. Shut it down with the command below.
Linux Command Line |
$ $MW_HOME/wlserver_10.3/server/bin/stopNodeManager.sh # Find the process of nodemanager with the below command and kill it $ ps -ef | grep Node | grep nodemanager | grep -v grep | cut
-c10-15 |
Step 4 of 4: Shutdown Admin Server
There should be a
single Node Manager for the machine. Shut it down with the command below.
Linux Command Line |
$ $DOMAIN_HOME/bin/stopWebLogic.sh |
Verify that the Managed Server has shutdown completely with ps -ef | grep AdminServer.
Cheers!
Bose
Thursday, 16 January 2014
How to refresh GUIDs for OBIEE 11g ?
Purpose
Details
2) Edit presentation server instanceconfig.xml with the following - put it inside Catalog tag
<UpdateAccountGUIDs>
3) Edit obiee server NQSconfig.INI file with the following
FMW_UPDATE_ROLE_AND_USER_REF_
4) Start OBIEE services (opmnctl startall)
5) Wait until presentation services are listed as down (opmnctl status)
6) stop obiee services (opmnctl stopall)
The saw log should show the following:
-----------------
Saw.log
[2012-12-19T09:38:03.000-07:
File:initializecatalog.cpp
Line:1046
Location:
saw.subsystem.catalog.
saw.subsystem.catalog.
saw.subsystems.
saw.webextensionbase.init
saw.sawserver
ecid:
]]
[2012-12-19T09:38:07.000-07:
File:initializecatalog.cpp
Line:1131
Location:
saw.subsystem.catalog.
saw.subsystem.catalog.
saw.subsystems.
saw.webextensionbase.init
saw.sawserver
ecid:
]]
7) Edit presentation server instanceconfig.xml with the following
<UpdateAccountGUIDs>none</
8) Edit obiee server NQSconfig.INI file with the following
FMW_UPDATE_ROLE_AND_USER_REF_
9) Start OBIEE services (opmnctl startall)
10) Verify OBIEE services are up (opmnctl status)
Wednesday, 15 January 2014
ADF_FACES-60097 : For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096: Server Exception during PPR, #1
Occurs:
Information in this document applies to any platform.
java.io.IOException: Stream closed
at java.io.BufferedInputStream.getInIfOpen(BufferedInputStream.java:134)
atjava.io.BufferedInputStream.fill(BufferedInputStream.java:218)
This solution is also documented in the following document:
<Doc ID 1303644.1> OBIEE Enterprise Manager Error: Stream Closed Server Exception during PPR, #13
Thursday, 9 January 2014
ODI 11g Step by Step Installation
If you have valid oracle support id then select second option with this step and enter the details so that the latest updates would be updated automatically. otherwise select 'Skip Software Updates' and click 'Next'
Step3:
If you are installed 'OBIEE 11g' in the machine then select all the components with this step so one of step you will be prompted to select middleware home. but here I have just installing ODI without Middleware path
Step4:
Once the prerequisites passed with this step click 'Next'
Step5:
In this step, we could see the default path where ODI will be installed. If we want to change, we could do where we could install ODI
Step6:
We have already created Repository using OBIEE 11g RCU. so select 'Skip Repository Configuration' and then click 'Next'
Step7:
In this step select database type, connection string, db user name and password and then click 'Next'
Step8:
In this step enter SUPERVISOR passoword 'Admin123' and then click 'Next'
Step9:
In this step, work repository which we have created using RCU would be selected. If not select in this step and click 'Next'
Step10:
Give the Agent Name that you want to create with this installation and then click 'Next'
Agent Name: ODIAgent
Agent Port: 20910
Step11:
In this step uncheck receiving my oracle support and click 'Next'
Just click 'Yes' with this popup window
Step12:
This step save ODI path details if you want or just click Install
Installation Progress
After configuration progess reached 100% click 'Next'
Just click 'Finish' the complete ODI Installation
Bose
ODI Master and Work Repository Creation Using RCU (OBIEE 11g)
Select 'Create' and click 'Next' with this screen.
Step3:
In this step, type all the necessary details in the required fields and click 'Next' with this step
Database Type: Oracle Database
Host Name: Bose-PC
Port: 1521
Service Name: ORCL
UserName: sys
Password: Password1
Role: SYSDBA
This step will check the prerequisites. Just click 'OK' once the prerequisites passes
Step4:
In this step check 'Oracle Data Integrator' Component. Type if you want to change the prefix and repository name.
Once we clicked 'Next' with the above screen It will check prerequisites and click 'OK' with the below screen
Step5:
Give the password which you want to give for ODI Work and Master repositories. If you want to give different password, select the appropriate option and click 'Next'
Step6:
This step is an important step so Please keep in your mind or store somewhere all the credentials and details in a file which you are entering here and then click 'Next'
Master Repository ID(001): 001
Supervisor Password: Admin123
Confirm Supervisor Password: Admin123
Work Repository Type: D
Work Repository ID: 101
Work Repository Name: WORKREP01
Work Repository Password: Admin123
Confirm Work Repository Password: Admin123
Step7:
This step will gives the information of ODI Schema name, schema owner and temporary tablespace name. Just Click 'Next' with this step
In this confirmation pop-up, Just click 'OK'
This will create the tablespace and click 'OK' once the steps passes
Step8:
In this step, click 'Create'
Step9:
so ODI Schema creation is completed with the above step. Just click 'Close' to complete the repository creation.
In the next coming post, we will continue to the ODI Installation using this ODI repositories.
Cheers!
Bose
What is Oracle Database Link and How to create database link (DB Link)
https://www.oracletutorial.com/oracle-administration/oracle-create-database-link/
Recent Posts
-
This post will give the example on Go URL. From OBIEE 12.2.1.3.0, Lightweight SSO is enabled. So we have to disable it first to work with...
-
https://www.oracletutorial.com/oracle-administration/oracle-create-database-link/
-
Hi, Here is the OBIA Upgrade Guide Cheers! Bose