Tuesday, May 30, 2017

Installing WinGate

WinGate is an integrated multi-protocol proxy server, email server and internet gateway from Qbik New Zealand Limited in Auckland. 

Operating systemMicrosoft Windows
Initial release5 October 1995
Stable release9.0.4 / 20 December 2016; 4 months ago
LicenseProprietary commercial software Free for 10 users

Steps for installing WinGate :

1. Download the software and run it as administrator

2. In the welcome screen select next

3. In the license agreement screen accept the license and click next

4. In the installation folder screen provide the path and click next

5. In the select packages screen , select the packages to install and click next

6. Enter an admin email address and click next

7. In the ready to install screen click next

8. Installing WinGate

9. In installation finish screen click finish to complete the installation

10. Reboot the computer, click yes to reboot the computer

11. Go to start - programs -  WinGate and click on start the WinGate service

Saturday, May 20, 2017


Create a schema for informatica repository

Increasing the parameter open_cursors to 1000

Go to the software folder and double click on setup file

In the installation type screen select install informatica with hot fix 2
and click next

In the prerequisite screen verify the prerequisites
 and complete the pending tasks if any and click next

In the license and directory screen provide the license key file path
 and installation directory path and then click next

In the pre-installation summary screen check the summary and click install

In the installing screen check the progress of installation

In the domain selection screen select create domain

Check the option enable https and click next

In the configuration repository screen

Provide the repository and database details and click test connection

If the test connection was successful click ok and click next

In the domain configuration screen provide password and click next

In windows service screen uncheck the option and click next

In the post installation summary screen click done

Sunday, May 14, 2017

How to recover the forgot linux root password

Boot into single usermode or boot using rescue disk.

If Grub is password protected then use the rescue disk, chroot /mnt/sysimage, then use the passwd command.

If Grub is not password protected, then you can login to single usermode by appending an "S" to the end of the kernel line that you have to boot. Select the kernel that you wish to boot with and press 'e'.

Now append an 'S' to the end of the line, press Return, and then 'b', once the system is booted into single usermode you can use the passwd command to reset the root password.

Saturday, May 13, 2017

Space required for Oracle Golden Gate installation on different platforms

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


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:


Step by Step installing and Configuring Oracle OHS Server

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

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