INSTALLATION DOCUMENTS BY RAVI

Saturday, May 13, 2017

System requirements for installing obiee on windows

Below are the recommended hardware and system configuration requirements for installing obiee on windows:

Hardware and system configuration requirements for Oracle Data Integrator


Space required for installing Oracle Database

Oracle database size requirement:

Limiting the log file size in obiee 12c

We need to use logrotate to limit the log file size
Modify the logrotate.conf under etc folder as below:

cat /etc/logrotate.conf

$ORACLE_HOME/user_projects/domains/bi/servers/obips1/logs {
    size 50M
    create 700  obiee obiee
    rotate 5
}

Size: 50M – logrotate runs only if the file size is equal to (or greater than) this size.
Create: – rotate the original file and create the new file with specified permission, user and group.

Rotate: – limits the number of log file rotation. So, this would keep only the recent 5 rotated log files.

Thursday, May 11, 2017

sed command to add a line in nth place of a file in linux

Command to add a string in nth line of a file:

sed -i '8i string to add' filename

8: stands for 8th line in file
i: insert

The above command will add the string in 8th line of all the file.

Command to add a string in nth line of all files in a directory:

sed -i '8i string to add' *

The above command will add the string in 8th line of all the files in the directory.


sed -i '8i string to add' filename*.txt

The above command will add the string in 8th line of all the files with extension .txt in the directory.

sed command to search replace a word in a file in linux

Command to search and replace a word in a file:

sed -i 's/original word/word to replace/g' filename

Command to search and replace a word in all of the files in a directory:


grep -rl 'original word' path_of_the_directory | xargs sed -i 's/original word/word to replace/g'

Sunday, May 7, 2017

CONFIGURING OBIEE 12C TO ORACLE OHS SERVER

Navigate to $DOMAIN_HOME/config/fmwconfig/components/OHS/ohs1 and modify mod_wl_ohs.conf file as below on OHS server:























Save the file

Restart the ohs component






































Now try to access weblogic admin ,em and analytic pages using ohs server and its port.
Weblogic Admin Console :






















Weblogic Em Console:






















OBIEE ANALYTICS PAGE:























  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...