PostgreSQL 11 Streaming Replication/Hot Standby

Cloud Database, OracleLeave a comment

To create PostgreSQL replication first we must install PostgreSQL on  Primary and  Standby server. On Primary and Standby: [root@localhost ]# yum -y install epel-release [root@localhost ]# yum -y install bash-completion [root@localhost ]# yum -y install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm [root@localhost ]# yum install postgresql11-server [root@localhost ]# yum install postgresql11-contrib On Primary: [root@localhost ]# /usr/pgsql-11/bin/postgresql-11-setup initdb Initializing database ……

Useful ADRCI Commands In Oracle

opinion, OracleLeave a comment

ADRCI is the command line interface for diagnostic utility used for viewing diagnostics data like listener log , alert log ,incident and cor dump etc and creating incident packages. Below are the the list of useful commands. 1. Get current  base location:( Also known as ADR_BASE) adrci> show base ADR base is “/u01/app/oracle/” 2. Set new…

Solving An Unusual Oracle Upgrade Issue

Cloud Database, opinion, Technology, UncategorizedLeave a comment

by Jim Okla January 27, 2015 Posted in: How To I recently came across a very unusual situation. During an upgraded review, I noticed the dba_registry_sqlpatch was empty when it shouldn’t be: SQL> select patch_id, patch_uid, version, action, action_time, status, description from dba_registry_sqlpatch; no rows selected SQL> The expected output should be (from another CDB…

How to Install Oracle Goldengate 12c on Linux 7 OS

opinion, OracleLeave a comment

Lets see the steps. 1. Download the goldengate software for the appropriate os platform. Download the goldengate 12c software from edelivery. 2.  unzip the V46695-01.zip and execute runInstaller [both SOURCE & TARGET ] [oracle@presplaySRV210 sf_stuff]$ unzip V46695-01.zip [oracle@presplaySRV210 sf_stuff]$ cd fbo_ggs_Linux_x64_shiphome [oracle@presplaySRV210 fbo_ggs_Linux_x64_shiphome]$ ls -ltr total 0 drwxr-xr-x. 5 oracle oracle 66 Aug 7 2014…

Scenario 1 – Restore control file from backup after loss of all control files

Cloud Database, OracleLeave a comment

Condition: All copies of the control file have been deleted The data is in the order of files and online redo logs Our control file has backups Database archive works in log mode First we look at where our control files are located SQL> select name from v$controlfile; NAME ——————————————————————————– /u01/app/oracle/oradata/DB11G/control01.ctl /u01/app/oracle/oradata/DB11G/control02.ctl   We then…

How To Run SQL Tuning Advisor For A Sql_id

opinion, OracleLeave a comment

When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done that query to improve performance. It might give suggestion to create few indexes or accepting a SQL profile.   Diagnostic and Tuning license is required to use this feature In this below tutorial we will explain how to run sql tuning advisor…