A quick Guide on How to Install the Oracle Database 12c Release 2 in Redhat Enterprise Linux 7.5 Server. To Download the Oracle Database Installer, Visit the below URL: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Prerequiste for Installation: Download the Oracle Database 12c installer package. The Swap Space size should be 16GB . Enable X11 Forwarding to “yes” in sshd…
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 ……
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…
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…
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…
Condition: All control files have been deleted After backup of the control file, the newly created data file was deleted The control file has a binary backup . To test this situation, we first get the binary backup of the control file and then delete all the control files: SQL> alter database backup controlfile to…
4 types of data migration are the process of transferring data from one area to another, one system to another, or one application to another. Generally, this is the result of introducing a new system or location for the data. However, data migration is never as easy as it may sound. According to The Bloor Group, more…
Oracle database version 12.2.0.1 is recently released. I searched the database software for Solaris platform, Found it in oracle edelivery. I downloaded the software from edelivery and did an installation and upgrade on a test box. Here we will first Install 12.2. ORACLE_HOME and then upgrade the database TESTDB ( which is on 12.1.0.2…
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…
Oracle database Size depends on the volume of data stored on disk or ASM. You can check size of Oracle database from query mentioned below. As an Oracle DBA this is one of the important task to analyze the growth of the database. In detail, here you will get to know the actual size of the…