Step by step oracle golden gate integrated extract

Creating OGGUSER and granting permissions:

Creating OGGSRC and granting permissions:

Creating OGGTRG and granting permissions:

Altering database supplemental log data:

Applying patch:

Creating parameter file:

OGG Extract:

ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

When we tried to start ggsci prompt in oracle golden gate some times we got the below error

ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

To resolve this create a soft link as below

Now again try to start the manager

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