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$Continue reading “How to check Character Set configured in Oracle”

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 meContinue reading “MSVCR100.dll is missing from your computer”

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 weContinue reading “How to Connect Container Databases in 12c”

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 doContinue reading “How to Reinstall from Failed Grid 11gR2”

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 LocationContinue reading “How to change the Temporary Tablespace File Location in 12c”

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 pdb1Continue reading “How to change the Data files Location in 12c”

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 memberContinue reading “How to change RedoLog File Location with Different Name in 12c”

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,Continue reading “How to change Control File Location with Different Name in 12c”