INSTALLATION DOCUMENTS BY RAVI

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
Platformx64




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

INFORMATICA 9.1.0 INSTALLATION IN WINDOWS

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

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

























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...