Step by step installing oracle golden gate

Download and stage the software
Oracle GoldenGate 12.2.0.2.2 for Oracle on Linux x86-64 (584 MB)

Installing required rpms:

Installing the Oracle Golden Gate software for the replication source

Login as oracle user

Create a directory for installing ogg for source as below

Change to software directory and run the installer as below

Select database and click Next

Provide the details and click next

Click on install

Click close to finish the installation

Installing the Oracle Golden Gate software for the replication target

Create a directory for installing ogg for target as below

Change to software directory and run the installer as below

Click next

Provide details and click next

Click install

Click close to complete the installation

Starting manager:

Login to ggsci prompt

Now start the manager as below

Sudo User: Steps To Add and Grant Sudo Privileges to Users in Linux

In order to add the user to sudoers file please find the steps below:

Logged in as root run the visudo command:

When we type this command, we will be taken into a text editor session with the file that defines sudo privileges pre-loaded. We will have to add our user to this file to grant our desired access rights.

Save and close the file

Now, when you are logged in as your oracle user, you can execute a certain command with root privileges by typing:

sudo "command"

Steps for preventing Oracle SQL Developer sessions from being killed

In general when we leave the database connection opened for a while in oracle sql developer, It will throw a "connection timeout" message when we tried to run a query next time.
We have to reconnect the connection for running the query.

To keep the database connection alive in sql developer please follow the below steps:

For Oracle SQL Developer 3 Versions:

1. Download oracle.sqldeveloper.keepalive.jar from this link " https://454e35d1-a-62cb3a1a-s-sites.googlegroups.com/site/keepaliveext/oracle.sqldeveloper.keepalive.jar?attachauth=ANoY7cp8U9ULxrRvTu3b-96lNNGvQAyh_LQ_kRfPmskJS0-qDvLfvoEeyd1jVFkbTRsso4wMuH65pMFVrXECLpUsFXj7D9wxGbYZrBffFy6FNAVRpCVy-j5vJ9h84DdMl_tCBGHaI3_GJzjx2OwutMk2b-bdCvOV_lgSy7_Kb3J2T2CjCR9hg9o_Bk_3f5roc86Vr6XxkncVkpZ87XsphHtEmZveLTVzdHcqf1_a9QEKY77koOcbkKU%3D&attredirects=0"

2. Copy the downloaded jar file to the below location

%SQLDEVELOPER_HOME%\sqldeveloper\extensions

3. Open sql developer and right click on a connection and go to Keep-Alive and select Active

4. Enter the user and password details of the connection if it is not already connected

5. We will get a success keep alive message

6. Now check again for the session time out issue.

For Oracle SQL Developer 4 Versions:

1. Navigate to %SQLDEVELOPER_HOME%\sqldeveloper\bin

2. Open sqldeveloper.conf file

3. Add " AddVMOption -Doracle.net.disableOob=true" to the file and save it.

4. Open sqldeveloper-nondebug.conf file

5. Add " AddVMOption -Doracle.net.disableOob=true" to the file and save it.

6. Open sql developer and connect to the database and check for session time out

Step by Sep Apache Ambari installation and configuration on linux

Downloading Apache Ambari :

Connect to linux machine using putty and issue below command to download Apache Ambari

wget -nv http://public-repo-1.hortonworks.com/ambari/centos6/2.x/updates/2.5.2.0/ambari.repo -O /etc/yum.repos.d/ambari.repo

Installing Apache Ambari :

Install Ambari server using yum as below

Configuring Apache Ambari:

Issue the below command to start configuring Apache Ambari

It will ask for options to choose .

Choose the option you want and click enter.

Starting Ambari server:

Issue the below command to start the Ambari server as below

Accessing Ambari server Admin console using web UI:

We can access the Ambari server admin console using below url

http://localhost:8080

Default user name and password is admin / admin

Steps for backup and restore informatica power center repository

Backup Informatica Power Center Repository:

1. Login to admin console and select repository service

2. Under Actions menu select Repository Contents and then click on Back Up

3.  Give user name and password and specify the backup file name and click ok

4. After completing we can see the backup file in below location.

Restore Informatica Power Center Repository:

1. Login to admin console and select repository service
2. Change the repository service operating mode to Exclusive and click ok ok and ok

3. Under Actions menu select Repository Contents and then click on delete and give user name and password and click ok

4. Now Under Actions menu select Repository Contents and then click on restore.

5. Select the backup repository file to restore and click ok

6. Change the repository service operating mode from Exclusive to Normal

Steps for Restoring Informatica Power Center Repository on new machine:

1. Create a new schema for the new repository.

2. Create a new Repository Service (referencing the new database schema).

3. Select the Do not create content option.

4. Enable the new Repository Service. 

5. It will display a message stating that the repository does not have any content.

6. Restore the backup using this new Repository Service.

7. Enable the new Repository Service to confirm that the restore is successful. 

8. If the Repository Service will display a message indicating that an upgrade is required.

9. Select Action > Repository Contents > Upgrade. 

10. This will start the upgrade of the repository contents.

11. Change the repository mode from Exclusive to Normal.