How to setup NFS Server on Ubuntu 18.04 for Dynamic NFS Provisioning

This post will help you setting up NFS Server to be used later for Dynamic Provisioning for Kubernetes. Lets begin. I am setting up NFS Server on Ubuntu 18.04 running on LXC VMs (because it is faster to provision and work on them). But this tutorial will work on Ubuntu 18.04 wherever it is running.

JRE vs JDK

I had a confusion once, so i thought of putting it in my Blog, may be It could be a help for someone: Do you want to run JavaTM programs, or do you want to develop Java programs? If you want to run Java programs, but not develop them, download the Java Runtime Environment, or

How to check Character Set configured in Oracle

Below are the two queries that can be used to find out the character set being configured in Oracle Database: SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’ ; SELECT * FROM NLS_DATABASE_PARAMETERS; In my case below are the outputs from the above queries: SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’ ; VALUE$

MSVCR100.dll is missing from your computer

I was trying to install SQL Developer Latest Version on my Windows 7 64bit OS System and i got the below error: To fix this issue, do the below steps: Go to the URL – https://www.microsoft.com/en-us/download/details.aspx?id=26999 Download as per your architecture, for me I downloaded 64bit one. Install it and you will be saved. Let me

How to Connect Container Databases in 12c

This is one of the many questions, that could come up in anyone’s mind. Definitely there are changes in 12c and other old releases. 12c has come with multitenant concept in 12c. So now we can have multiple databases in 1 container database and share the resources. Next thing is to consider, how can we

How to Reinstall from Failed Grid 11gR2

Today I faced the problem with the GRID installation, one of my team members tried installing GRID and somehow lost the connection in between and GUI also closed. So we tried to install again keeping all old directories cleaned up ($GRID_HOME) and removing the entry from inventory.xml file for the GRID_HOME. If you don’t do

How to change the Temporary Tablespace File Location in 12c

As we know there are 1 or more Temporary Tablespaces in 12c, considering the fact, every container has its own Temp Tablespace. So in our case we have – 1 CDB (Container Database) with 1 PDB (Pluggable Database) and both have same name as TEMP. Lets start with the Root Container Temporary Tablespace File Location

How to change the Data files Location in 12c

In this Section we will cover Data Files location change in Root Container as well in the Pluggable Container. We have this configuration with us: 1 Root Container (cdb1) with 1 Pluggable Database (pdb1) Important Note: You cannot change the pluggable datafile location from the root container. So first start with the Pluggable database pdb1

How to change RedoLog File Location with Different Name in 12c

In this Blog, we are discussing about how to change the location of Redolog file along with the Name Change. This Blog can be used to change the name of redo log file at same location or different location. So we will find out the location of the existing redo log file: SQL> select member

How to change Control File Location with Different Name in 12c

In this blog we will be discussing about how to change the control file location, while changing the location we can also change their names. This example has been tested in 12cR1 (12.1.0.2), however it will also work in previous versions. Find out the current control file location, make sure the current container is root,