Category Archives: OBIEE 12c

Deploying/upload rpd in OBIEE 12.2.1.0 / 12c server

Standard

Dear All,

 

We will learn how to upload / deploy new rpd in obiee 12c server.

Unlike in 11g, em does not have any option for deployments of rpd, it is all now uploading repository to a specific service instance. we should be using weblogic scripting command “uploadrpd’ to upload repository to Oracle BI Server.

You execute the utility through a launcher script, data-model-cmd.sh on UNIX and data-model-cmd.cmd on Windows. You can find the launcher script at the following location:

<Oracle_Home>/user_projects/domains/bi/bitools/bin

>wlst.cmd

Syntax:

uploadrpd -I <RPDname> [-W <RPDpwd>] -SI <service_instance> -U <cred_username> [-P <cred_password>] [-S <hostname>] [-N <port_number>] [-SSL] [-H]

 

  • I specifies the name of the repository that you want to upload.
  • W is the repository’s password. If you do not supply the password, then you will be prompted for the password when the command is run. For security purposes, Oracle recommends that you include a password in the command only if you are using automated scripting to run the command.
  • SI specifies the name of the service instance.
  • U specifies a valid user’s name to be used for Oracle BI EE authentication.
  • P specifies the password corresponding to the user’s name that you specified for U. If you do not supply the password, then you will be prompted for the password when the command is run. For security purposes, Oracle recommends that you include a password in the command only if you are using automated scripting to run the command.
  • S specifies the Oracle BI EE host name. Only include this option when you are running the command from a client installation.
  • N specifies the Oracle BI EE port number. Only include this option when you are running the command from a client installation.
  • SSL specifies to use SSL to connect to the WebLogic Server to run the command. Only include this option when you are running the command from a client installation.
  • H displays the usage information and exits the command.

Example: data-model-cmd.sh uploadrpd -I <RepositoryName.rpd> -SI ssi -U weblogic -S server.example.com -N 9502 -SSL

uploadrpd

Note: Using “uploadrpd”, we can upload an Oracle BI repository in RPD format and cannot upload a repository composed of MDS XML documents.

The online rpd in the server is with name liverpd.rpd_n (n is integer with increased number) and can be found at: <Oracle_Home>\user_projects\domains\bi\bidata\service_instances\ssi\metadata\datamodel\customizations

You can log into analytics and see the subject area contents of new rpd with changes affected.

You can also download current online rpd from server which acts as offline rpd on which you will be developing your changes or for any diagnose purpose

syntax: downloadrpd -O RPDname [-W RPDpwd] -SI service_instance -U cred_username [-P cred_password] [-S hostname] [-N port_number] [-SSL] [-H]

downloadrpd

rpd will be saved under the same location where you executed above command..

 

Thanks,

Kishore

Advertisements

OBIEE New & Deprecated Terminology and architecture – 12.2.1.0.0 (12c)

Standard

Dear all,

from oracle documentation, here is high level architecture diagram for OBIEE 12c – 12.2.1.0 and terminology difference between 11g & 12c

obiee12c_logical_architecture

Terminology difference.

Terminology Used in 11g Terminology Used in 12c
Middleware home

MW_HOME

In 11g the Middleware home is a container for the Oracle WebLogic Server home, and, optionally, one Oracle Common home and one or more Oracle homes.

This term is eliminated in 12c.

Oracle home

ORACLE_HOME

The Oracle home that is created for all the Oracle Fusion Middleware products on a host computer. It includes binary and library files, the Oracle common directory and the individual product directories for each Oracle Fusion Middleware product you install.

Oracle home

PRODUCT_ORACLE_HOME

Product directory

PRODUCT_DIR

The product directories within the Middleware home are no longer Oracle homes. They are simply directories within the Oracle home that are created for all the Oracle Fusion Middleware products. Most Oracle Fusion Middleware components should be installed in the same Oracle home. The names of the product homes are predefined and can no longer be modified by the user during the installation.

Oracle instance

This term is eliminated in 12c.

The installer will no longer create a separate instance directory for system components, such as Oracle HTTP Server. Instead, you can use the Fusion Middleware Configuration Wizard to configure your system components, just as you do for Java components. Instance information about each system component will be stored in the domain home.
Oracle Fusion Middleware farm

This term is eliminated in 12c.

The term “farm” is no longer necessary for 12c. It was used in 11g to refer to a container for a WLS domain and its associated system component instances when presented in Fusion Middleware Control.

Ref: https://docs.oracle.com/middleware/1212/core/ASCON/whatsnew.htm#ASCON11224

 

Thanks,

Kishore

OBIEE 12c Installation on windows 8

Standard

Hi,

 

obiee 12c (12.2.1.0) installation is success in my windows 8 version (note it is not oracle recommended but for practice purpose i tried and able to install)

Generalizing the process of installation …

Prerequisites:

  1. 64 bit OS is must
  2. Loopback adapter settings..
  3. Make sure you unzip the downloaded setup files in the same machine where you’re intended to install obiee. I saw few issues when extracted file is brought from 2008 r2 to win8.
  4. Decide user with whom you’re proceeding with installations and ensure oraInventory access.
  5. Windows firewall set to Off
  6. JDK 1.8.0_51+
  7. oracle database; 12.1.0.1+; 11.2.0.4+

For more information on certification matrix on oracle fusion middleware 12.2.1.0 certification, click here

Installation Steps:

  • Install Oracle Fusion Middleware Infrastructure (no configuring domain for infrastructure)
  • Install obiee
  • Set BI_PRODUCT_HOME env variable for ex: C:\oracle\product\Middleware\Oracle_Home\bi
  • Configure obiee standard topology using 12c configuration assistant(you can alternatively run rcu part of <ORACLE_HOME>/oracle_common/bin to create schema required then sue configuration assistant to configure obiee)

Follow oracle documentation on installation & configuration here

i could not install obiee 12c (12.2.1.0) on windows 2008 r2 and the same success with windows 8

Note: Oracle certifies only 2012 r2 for obiee 12c

 

Thanks,

Kishore