Info Imply@Ravi: OBIEE 11G

Showing posts with label OBIEE 11G. Show all posts

Saturday, April 29, 2017

OBIEE 11g Environment Variables, Config Files and Log File Locations

Environment Variables:

MW_HOME=/u01/mw_home
ORACLE_HOME=$MW_HOME/Oracle_BI1

DOMAIN_HOME=$MW_HOME/user_projects/domains/bifoundation_domain

COMMON_COMPONENTS_HOME=$MW_HOME/oracle_common

WL_HOME=$MW_HOME/wlserver_10.3

INSTANCE_HOME=$MW_HOME/instances/instance1

Config Files:

instanceconfig.xml file location

$INSTANCE_HOME/config/OracleBIPresentationServicesComponent/coreapplication_obips1/

NQSConfig.INI file location

$INSTANCE_HOME/config/OracleBIServerComponent/coreapplication_obis1/

odbc.ini file location

$INSTANCE_HOME/bifoundation/OracleBIApplication/coreapplication/setup

UserScripts.js file location

$DOMAIN_HOME/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/actions

config.xml file location

$DOMAIN_HOME/config/

Catalog location

$INSTANCE_HOME/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog

config directory location

$DOMAIN_HOME/

WRITEBACK FILES LOCATION

$ORACLE_HOME/bifoundation/web/msgdb/messages

BI Admin tool environment initialization script location:
$INSTANCE_HOME/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.cmd

BI Admin tool executable location :
$ORACLE_HOME/bifoundation/server/bin/admintool.exe

Config utility Location

$ORACLE_HOME/bin

Weblogic Scripting Tool WLST utility location

$MW_HOME/oracle_common/common/bin

Configuration file locations:
$INSTANCE_HOME/config

Rpd location:

$INSTANCE_HOME/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository

Common Scripts Location (starting and stopping server scripts)

$DOMAIN_HOME/bin

OPMN Scripts Location:
$INSTANCE_HOME/bin

Log File Locations :

Admin Server Logs

$DOMAIN_HOME/servers/AdminServer/logs

Managed Server Logs

$DOMAIN_HOME/servers/bi_server1/logs

OPMN Logs

$INSTANCE_HOME/diagnostics/logs/OPMN/opmn

Presentation Server Logs

$INSTANCE_HOME/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

Scheduler Logs

$INSTANCE_HOME/diagnostics/logs/OracleBISchedulerComponent/coreapplication_obisch1

BI Server Logs

$INSTANCE_HOME/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

Opatch Logs

$MW_HOME/cfgtoollogs/opatch

Shell script for redirecting list of application roles in obiee 11g to a csv file

Open a text file and write the below code:

import sys
import os
WLS_HOST = 'localhost'
WLS_PORT = '7001'
WLS_USER = 'weblogic'
WLS_PW = 'welcome1'
connect (WLS_USER, WLS_PW,WLS_HOST+ ':'+WLS_PORT)
atnr=cmo.getSecurityConfiguration().getDefaultRealm().lookupAuthenticationProvider('DefaultAuthenticator')
listAppRoles(appStripe="obi")
exit ()

Save the file as list_appRoles.py

Now open the terminal and issue the below commands:

$ cd $MW_HOME/oracle_common/common/bin
$ ./wlst.sh list_appRoles.py >list_appRoles.csv

The above command will redirect all the application roles to list_appRoles.csv file

Steps to List all the Application Roles in OBIEE using command line

OBIEE 11g:

Open the Terminal

Invoke wlst script command line as shown below:

$ cd $MW_HOME/oracle_common/common/bin
$ ./wlst.sh

In the wlst prompt connect the weblogic server using below command:

> connect ('weblogic', 'welcome1', 'localhost:7001')

After the server got connected, list the application roles using the below command:

> listAppRoles(appStripe="obi")

Type the below command to exit from wlst prompt

> exit()

OBIEE 12c:

Open the Terminal

Invoke wlst script command line as shown below:

$ cd $ORACLE_HOME/oracle_common/common/bin
$ ./wlst.sh

In the wlst prompt connect the weblogic server using below command:

> connect ('weblogic', 'welcome1', 'localhost:9500')

After the server got connected, list the application roles using the below command:

> listAppRoles(appStripe="obi")

Type the below command to exit from wlst prompt

> exit()

Saturday, April 22, 2017

Default BI Presentation Catalog Path in OBIEE and OBIA

Default BI presentation catalog path in OBIEE 11g em console:

$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/SampleApplite

Default BI presentation catalog path in OBIA 11.1.1.x.x em console:

$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/OracleBIApps

Saturday, April 15, 2017

Steps for Applying and Roll backing Weblogic server patch

Note: Before applying the patch modify bsu.sh file under {MW_HOME}/utils/bsu directory like below:

#!/bin/sh

JAVA_HOME="/opt/java/jdk1.7.0_79"

MEM_ARGS="-Xms1024m -Xmx1024m -XX:-UseGCOverheadLimit"

#MEM_ARGS="-Xms256m -Xmx512m"

"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*

Applying Oracle WebLogic Server Patch Set Update 10.3.6.0.12

unzip p20780171_1036_Generic.zip to {MW_HOME}/utils/bsu/cache_dir or any local directory

Stop all WebLogic servers.

Navigate to the {MW_HOME}/utils/bsu directory.

Execute bsu.sh -install -patch_download_dir={MW_HOME}/utils/bsu/cache_dir -patchlist={PATCH_ID} -prod_dir={MW_HOME}/{WL_HOME}

Restart all WebLogic servers.

Roll backing Oracle WebLogic Server Patch Set Update 10.3.6.0.12

Stop all WebLogic Servers

Navigate to the {MW_HOME}/utils/bsu directory.

Execute bsu.sh -remove -patchlist={PATCH_ID} -prod_dir={MW_HOME}/{WL_HOME}

Restart all WebLogic Servers

Steps for Working on Rpd in MUD ENVIRONMENT

1. Open Oracle BI Administration Tool
2. Click on Tools - Options - Multiuser
3. Browse the MUD Rpd Shared path and give any name and click ok
4. Click on File - Multiuser - Checkout
5. Enter the RPd password
6. Select any project and click ok
7. Give any name and click on save
8. After finishing work on the rpd save it and go to File - Multiuser and then click on Publish to Network

Note: Rpd must be in shared path

Monday, April 10, 2017

Steps for adding Date In an IBot Email Subject Line obiee 11g

Under Delivery Content tab while creating an Agent in OBIEE 11g,
you can use variables, for example I used the below one within Subject text box under Delivery Content tab,

Agent Run time :@{system.currentTime} Language:@{session.language}

and when I got the agent, I could see the email subject line says,
Agent Run time :12/23/2014 07:45:02 AM Language:en