URL'S

Oracle Enterprise Manager 11g Fusion Middleware Control


http://machinename:7001/em

Oracle Business Intelligence

http://machinename:7001/analytics/saw.dll?bieehome

Oracle Weblogic Server Administration Console

http://machinename:7001/console

RPD AND WEBCAT PATH

Locations of Repository and Catalog in BI 11g:

We can get the rpd and catalog which we have developed from below folders.

RPD Location Path:

Drive:<BIHome>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

Catalog Location Path:

Drive:<BIHome>\instances\instance1\bifoundation\

OracleBIPresentationServicesComponent \coreapplication_obips1\catalog


OBIEE 11g Log Locations:

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

Install OBIEE11g samples from OTN

Download the Sample Application from

SampleApp V107 Install Files

http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html


Link to deployment guide:-

http://www.oracle.com/technetwork/middleware/bi-foundation/downloads/sampleapp107-deploymentguide-435786.pdf



Restoring Database Dumps
In this section, we will use Oracle data pump to import the definition and data for several database schemas. If any of these schemas exist, they must be dropped before you begin the import. In case they cannot be dropped, the schemas may be imported into different schema names using schema mapping options available for impdp command. If the schema names and/or passwords are changed, it will require additional corrections and configurations in SampleApp RPD.

Schema Password Remarks

BISAMPLE BISAMPLE Main schema that houses data for SampleApp analyses
OBIEE_NAVTEQ obiee_navteq NAVTEQ copyrighted data used for map views
BIFOD BIFOD OLTP 3NF model for FOD (Oracle Fusion Order Demo) data model.
BIBPM BIBPM
BPM (SOA) Business Process Monitoring model to show how BIEE semantic
layer can deliver analytics on BPM context
DEV_ODI_REPO DEV_ODI_REPO This supports the SampleApp Oracle Data Integrator content
ODI_STAGING ODI_STAGING This supports the SampleApp Oracle Data Integrator content


From you SampleApp installation files, copy \DataSources\ORCL\SASCHEMAS.dmp file to the machine where Oracle
database 11gR2 is up and running
Unzip this file to a folder on the database server, say “C:\datapump\”
Connect to database using a sysdba user and create a directory object to import the database dump. Change the data
base connection parameters (highlighted in red) to reflect your connection settings.
sqlplus "sys/Admin123@sampledb1 as sysdba"
create or replace directory datapumpdir as 'c:\datapump';
Import the database dump using the command below.

Need to run the below command from Windows dos.. not on sqlplus

impdp "'"sys/Admin123@sampledb1 as sysdba"'" directory=datapumpdir dumpfile=SASchemas.dmp
version=11.2.0.0.0 schemas=BISAMPLE,OBIEE_NAVTEQ,BIFOD,BIBPM,DEV_ODI_REPO,ODI_STAGING
LOGFILE=SASchemas_imp.log
NOTE:- Change the value of Version parameter depending on the version of your target database.
During the import process you may get the warning ORA-39082: Object type
VIEW:"BISAMPLE"."ODM_SAMP_CUSTOMERS_LTV" created with compilation warnings
This a known warning and can be ignored.


Once the import is completed, connect back to the database using a sysdba user and execute the following sql
commands.
To connect use - sqlplus "sys/Admin123@sampledb1 as sysdba"
alter user BISAMPLE identified by BISAMPLE;
alter user OBIEE_NAVTEQ identified by obiee_navteq;
alter user BIFOD identified by BIFOD;
alter user BIBPM identified by BIBPM;
alter user DEV_ODI_REPO identified by DEV_ODI_REPO;
alter user ODI_STAGING identified by ODI_STAGING;

Next connect as obiee_navteq/obiee_navteq@sampledb1 and execute the following insert statements

insert into user_sdo_maps select * from obiee_navteq.my_maps;
insert into user_sdo_themes select * from obiee_navteq.my_themes;
insert into user_sdo_styles select * from obiee_navteq.my_styles;
insert into user_sdo_cached_maps select * from obiee_navteq.my_tile_cache;
commit;

Error while importing the Meta Data after Installing BI Admin Tool

Hi 

I have installed OBIEE 11g Server in my local machine which is lying on windows 7 environment. 

I tried improting the meta data using BI Admin Tool, it throws ' The Connection has failed' error.

Resolution:-

Copied the TNSNAMES.ora file ( path C: /app/product/11.2.0/dbhome_1/network/admin/tnsnames.ora)
to

C:/Oracle/Middleware/oracle_b11/network/admin/tnsnames.ora and 
C:/Oracle/Middleware/oracle_common/network/admin/tnsnames.ora

In the second path, admin folder was not there.. We need to create a folder manually and copy the tnsnames.ora file.


Its works fine..

Issue while Installing OBIEE 11g RCU

Directories that rcu file storing shouldn’t contain spaces in it.

Here is the path that i stored rcu installer.

C:\Ravi\Softwares\OBIEE 11.1.1.5\rcuHome\BIN

There is space in OBIEE 11.1.1.5 between OBIEE & number.

 There is oracle note that there shouldn’t be any spaces in directories that containing rcu installer.

Remedy: Remove space in directory then try run rcu.bat

Make sure the DEV_BIPLATFORM and DEV_MDS users have the same password and that their accounts aren’t locked after running the RCU.

Despite what Oracle would have you believe it seems the DBA role is not required and nor are SYSDBA nor SYSOPER privileges.

OBIEE 11g Admin Tool Uninstallation

Uninstall OBIEE 11g client (Uninstall Oracle BI Administration Tool)

Uninstall Oracle BI Administration Tool (OBIEE 11g client): client interface

To start the OBIEE 11g client uninstall process, you will go to

start -> All Programs -> Oracle Business Intelligence Enterprise Edition Plus Client -> Change Oracle Business Intelligence Enterprise Edition Plus Client Installation

This you can see in the following picture:

Uninstall Oracle BI Administration Tool (OBIEE 11g client): start uninstall process

You will see the following screen:

Uninstall Oracle BI Administration Tool (OBIEE 11g client): uninstall options

You will choose "Uninstall Product" and after that you will press on "Next". You will see the following screen:

Uninstall Oracle BI Administration Tool (OBIEE 11g client): start to uninstall the OBIEE 11g client

Press on "Next" and you will see the following screen:

Uninstall Oracle BI Administration Tool (OBIEE 11g client):  uninstalling the OBIEE 11g client

When the OBIEE 11g client will be uninstalled you will see the following screen:

Uninstall Oracle BI Administration Tool (OBIEE 11g client):  Uninstall Complete

Siebel Enhancements

Hi

In my next post you can see the enchnacement in Siebel8.0.

Difference between Version 7 to Version 8