INSTALLATION DOCUMENTS BY RAVI

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

Step by Step OFSAA Installation

ORACLE FINANCIAL SERVICES PROFITABILITY ANALYTICS PRODUCT

Installing Application Layer:

















Go to the software staged directory and run the setup file with GUI flag


















In the Introduction screen click next


















In the Pre-setup Information screen select debug and click next


















Enter the 9 digit customer identification number and click next

















Select Application Layer and click next


















Select New infodom and click next


















Add the infadom entry in tnsnames.ora file




























Click next


















In the Pre-Infodom Creation Summary screen click next


















Click next


















Specify the OFSAAI user id and click next



































In the Pre-Installation Summary screen click Install

















Click yes to continue installation


















Click done to finish the installation.


















Now open the OFSAAI CONSOLE and check



































Installing Database Layer:



































In the Introduction screen click next


















In the Pre-setup Information screen select debug and click next


















Enter the 9 digit customer identification number and click next


















Select the database layer and click next

















Provide the details and click next


















Click next


































In the Pre-Installation Summary screen click Install


















Click yes to continue installation

















Click done to finish the installation








































INSTALLING ORACLE DATABASE 11G ENTERPRISE EDITION ON WINDOWS

GO TO THE SOFTWARE FOLDER AND OPEN THE SETUP FILE AS RUN AS ADMINISTRATOR









































































In the configure security updates screen uncheck the option and click next










click yes



















In the select installation option screen, select create and configure database and click next



















In the system class screen select desktop class and click next



















In the typical install configuration screen provide all the details and click next










Click yes



















In the perform prerequisite checks screen if all the prerequisites were passed click next



















In the summary screen click finish to start the installation













































































click ok



















click close to finish the installation


SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...