INSTALLATION DOCUMENTS BY RAVI

Saturday, December 23, 2017

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








Thursday, December 21, 2017

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"










Friday, December 15, 2017

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:


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


Friday, December 1, 2017

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























Purge Oracle Analytics Cloud cache using curl command

Clearing cache for all databases: Syntax: curl -i -X DELETE -u joe@example.com:mypassword1 -H "X-ID-TENANT-NAME:myidentitydomain...