Stop MySQL Database systemctl stop mysqld.service Start MySQL as Safe Mode mysqld_safe –skip-grant-tables & Connect MySQL Database With Root User mysql -uroot Change Root Password use mysql; update user set password=PASSWORD(“newpassword”) where user=’root’; flush privileges; exit Restart MySQL Database systemctl stop mysqld.service systemctl start mysqld.service Connect MySQL Database With Root User With New Password mysql…
Configure Windows Firewall to Allow Pings
Configure Windows Firewall to Allow Pings Open Windows Firewall. Right click Inbound Rules and New Rule. Select Predefined and select File and Printer Sharing (Echo Request – ICMPv4-In). Next and Finish. Your system can respond ping requests.
Virtual IP Creation with Linux Service in CentOS 7
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…