Info Imply@Ravi: April 2017

Sunday, April 30, 2017

Some Linux Commands

How to delete files older than 3 days:
find . -name ‘*.*’ -mtime +3 -exec rm {} \;

How to list files modified in last 3 days:
find . -mtime -3 -exec ls -lt {} \;

How to sort files based on Size of file:
ls -l | sort -nrk 5 | more

How to find CPU & Memory:
cat /proc/cpuinfo
cat /proc/meminfo

How to find if any service is listening on particular port or not:
netstat -an | grep (port no)
Example :
netstat -an | grep 7001

How to find Process ID (PID) associated with any port:
lsof | grep 7001

How to find a pattern in some file in a directory:
To find pattern in particular file :
grep pattern file_name
To find in all files in that directory
grep pattern *

How to create symbolic link to a file:
ln -s target source

INSTALLING WINRAR

Download and run the setup file

Click Run

Click install

Click ok

INSTALLING FLASH PLAYER

Click Run

Click install

CLICK DONE TO FINISH INSTALLATION

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()