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

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