You can create virtual IP address with linux service. I designed the linux service to create a virtual IP address when operating system is rebooted. My System Properties Ethernet Adaptor Name : ens14025 Virtual IP : 192.168.44.55 1. Create Bash Script To Create Virtual IP Address [root@test ~]# vi /opt/scripts/virtual_ip_up.sh #!/bin/bash ifconfig ens14025:1 192.168.44.55 netmask…
How to Using Dblink With DML Operations in PostgreSQL 9
Dblinks provide to connect another databases. Also you can do DML operations with using dblink. I will use dblink to connect two PostgreSQL databases on this post. Also I will tell how to use select, update and delete with dblink. Firstly, you have to create dblink entension with related user which is using dblink. Create…
Unified Auditing in Oracle 12c
Unified Auditing is new audit feature came with Oracle 12c version. You have to do enable Unified Auditing to use after install database. Unified Auditing come as disabled by default. In previous releases of Oracle Database, there were separate audit trails for individual components: SYS.AUD$ for the database audit trail, SYS.FGA_LOG$ for fine-grained auditing, DVSYS.AUDIT_TRAIL$…
Oracle 12c R2 (12.2.0.1) Real Time Apply Data Guard Installation on Oracle Linux 7.3
Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of…
TNS-12547: TNS:lost contact and Linux Error: 32: Broken pipe While Connect Oracle 12c Data Guard
I installed Oracle 12c Data Guard, everything was okey. But, I got an error like below when I wanted to connect data guard database with Toad or SQL Developer. tnsping was okey. Error SQL Developer : Status : Failure -Test failed: IO Error: Got minus one from a read call Listener.log 10-OCT-2017 15:01:16 * (CONNECT_DATA=(CID=(PROGRAM=SQL…
PostgreSQL Hot Standby (Streaming Replication) Database Installation and Failover Operations
PostgreSQL has few feature for standby technology. I generally use streaming replication. This is very easy and confident. Streaming replication use a replication user for replication operations.Streaming replication allows a standby server to stay more up-to-date than is possible with file-based log shipping. The standby connects to the primary, which streams WAL records to the…
Oracle 12c R2 (12.2.0.1) RAC Installation Steps on Oracle Linux 7.3
Oracle Real Application Clusters (Oracle RAC) is a clustered database infrastructure of Oracle Database based on a comprehensive high-availability stack that can be used as the foundation of a database cloud system as well as a shared infrastructure, ensuring high availability, scalability, and agility for any application. Oracle Real Application Cluster has been using with…
PostgreSQL 10 New Features
PostgreSQL 10 has very good new features. In my opinion, mainly new features are Logical Replication, Improved Parallel Query, Scram Authentication, Declarative Partitioning. Logical Replication : PostgreSQL has had physical replication that often called streaming replication since version 9.0, but this requires replicating the entire database, cannot tolerate writes in any form on the standby…
Find And Delete Files Greater Than Given Size on Linux
If you want to delete files which are greater than given size on Linux, you can use below examples by changing as your need. Delete Files Delete files which are size more than 2 MB. and type is jgp. [root@testserver ~]# find /tmp/ -type f -size +2M -name “*.jpg” -exec rm -rf {} \; Delete…
Oracle 11g R2 Resize Redo Log Size on Data Guard and Primary Database
Sometimes, you may need to change redo log size to perform optimum size for performance. If you want to change redo log size of both standby side and primary side, you can use below commands. Current Status Of Redo Logs Primary Side SQL> select group#,sum(bytes/1024/1024)”Size in MB” from v$log group by group#; GROUP# Size in…