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.

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'

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:

Step by Step installing and Configuring Oracle OHS Server 12.2.1.2.0

Installing OHS Server:

Download and stage the software
Start the installation by executing the command as below

In the welcome screen click next

Provide the installation location and click next

Select standalone http server and click next

If the prerequisite checks succeed click next

Uncheck the option and click next and click yes

Click install

If the installation progress reaches 100 % click next

Click finish to complete the installation

Configuring domain for OHS server:

Select create new domain and click next

Select the product template and click next

Select jdk and click next

click next

Provide the details and click next

Click next

Click create

Click next

Click finish

Starting Oracle OHS Server :

Navigate to $DOMAIN_HOME/bin and start nodemanager.

Starting OHS Component:

Navigate to $DOMAIN_HOME/bin and start ohs component