Info Imply@Ravi

Sunday, April 30, 2017

INSTALLING ADOBE READER

Download the software and right click on it and click open

Click install

Click finish

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

Shell script for redirecting list of application roles in obiee 12c to a csv file

Open a text file and write the below code:

import sys
import os
WLS_HOST = 'localhost'
WLS_PORT = '9500'
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 $ORACLE_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()