This document describes steps to troubleshoot kubectl error: The connection to the server x.x.x.x:6443 was refused – did you specify the right host or port? 1. The kubectl should be executed on the Master Node. 2. Current user must have Kubernetes cluster configuration environment variable (Details of how to are listed under section Preparing to […]
Archives for June 2019
Changing the IPset rules from IPtables to Firewalld in CentOS/RHEL 7
The Ask ipset IPtables rule is needed on firewalld for the below rule: -A INPUT -p tcp -m set –match-set SQL_1811 src -m set –match-set DB-IPs dst -m tcp –dport 1811 -j ACCEPT The Answer Below example using SQL_1811 and DB-IPs as IPsets for the two IP addresses (10.1.1.2 and 10.1.1.3) # firewall-cmd –permanent –new-ipset=SQL_1811 […]
Backup and Restore Of Group Replication Node ( MySQL 8.0 )
Note: In MySQL Server 8.0.X you must use the exact same patch release of MEB as the Server, eg MySQL Server 8.0.13 requires the use of MEB 8.0.13. The Basics For *nix OSes, the document uses a shell expansion for simple naming of folders with “todays” date+time, eg shell:~ # d=”$(date ‘+%d%b_%H%M’)” shell:~ # echo […]
MySQL Server 8.0 – How to create a REPLICATION SLAVE using MEB
The Problem A replication slave cannot continue replicating from its Master. One such example is that after being stopped for a long ( or longer than anticipated ) timeframe, the BINARY LOGS required on the Master have been purged. [ERROR] [MY-013114] [Repl] Slave I/O for channel ‘group_replication_recovery’: Got fatal error 1236 from master when reading […]
“uname” Command Examples to Check UNIX/Linux Version
The uname command displays system information. Apart from the hostname command, you can also use the “uname -n” command to display the host name of your system. Without any flags, the uname command will display the operating system that your are using. Here are some useful options: Option Description -a Displays all information -s Displays […]
ORA-12547: TNS:lost Contact (Oracle 12c2)
The Problem While connecting the database as sysdba, we are getting below error: sqlplus /as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed May 10 00:40:31 2017 Copyright (c) 1982, 2016, Oracle. All rights reserved. ERROR: ORA-12547: TNS:lost contact The version of Oracle database used here is 12.2.0.1.0. The Solution The solution is quite simple here. […]
How to Set External Network For Containers in Linux Containers (LXC)
The objective of the post is to setup LXC container which can connect to external networks. There are multiple network modes that can be used in setting up LXC. By default, the lxc-oracle template script sets up networking by setting up a veth bridge. In this mode, a container obtains its IP address from the […]
How to Create Interval-Reference Partitioned Tables in Oracle 12c
This is an example for the 12c new feature of creating interval partitioned tables as parent tables for reference partitioning. 1. Partitions in a reference-partitioned table corresponding to interval partitions in the parent table are created when inserting records into the reference partitioned table. CREATE TABLE parent (pk INT CONSTRAINT parent_pk PRIMARY KEY, i INT) […]
How To Create an Encrypted Tablespace in Oracle 12c Pluggable Database
Question: How to create an encrypted tablespace in a 12c pluggable database of multi tenant DB? To create an encrypted tablespace in a 12c pluggable database requires some additional steps as compared to previous version 11g. The reason is by default the wallet does not hold a tablespace key for the pluggable databases. 1. Set […]
How to extend ASM disk from OS level in CentOS/RHEL
Question: How to expand the physical raw disk which is part of ASM diskgroup? Below are the steps to extend the physical disk which is part of ASM diskgroup. 1. First, you have to unmount the disk you want to extend at the ASM level. 2. Check the disks present at the OS level and […]