Category: Oracle Database

Creating Container and Pluggable Database Using CREATE DATABASE SQL Command

In Oracle OCM exam, You may need to create database using command line. Even in real life, You may no have the option to use the software for GUI. I will show how to create a CDB and PDB using SQL Command. Create required directories. Set Environment Variables. Create Password File. Create a pfile and …

Continue reading

Install Oracle 12.1 Software and Create database in Silent Mode

In this Topic, I will show how to install Oracle 12.1.0.2 Software only and Create database using DBCA by silent mode. Oracle Installation Prerequisites Install Oracle 12c Software in Silent Mode: Create Database Using DBCA with Silent Mode: Oracle Installation Prerequisites: Add following kernel parameters on /etc/sysctl.conf. Run following command to verify and output will …

Continue reading

Move or Rename Oracle Files

DBA needs to rename or move oracle file from one filesystem or ASM DISKGroup to another. Move Datafiles Using ALTER DATABASE MOVE DATAFILE command – 12c and onward Moving Datafile Using RMAN with offline option – 10g or 11g Prerequisites: Database should be configured archive log mode.

Continue reading

Installing Oracle Client In Silent Mode on Linux

In this article I will show how to install Oracle Client 11g, 12c, 18c and 19c in Silent Mode on Linux. Download Software. Prepare response File. Installation

Continue reading

Oracle Database 11g Release 2 RAC On Oracle Linux 7.1

Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. Below high level steps will perform to install/configure Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC. Install Oracle Linux 7.1. Oracle Installation Prerequisites. Additional Setup. Create Shared Disk. Clone the Virtual Machine for Node2. …

Continue reading

Oracle Database 12c, 18c & 19c Product Versions and Upgradation Path

As you may know Oracle introduced a new versioning formation from 18c. Until 12.2.0.1 Oracle was releasing versions like 10g, 11g, and 12c. Oracle announced to release a version every year from 2018 and it could be like Oracle Database 18c, 19c and 20c. Oracle Database 12c: Oracle database 12c consider all version from 12c …

Continue reading

Oracle Database 11g R2 (11.2) Installation On Oracle Enterprise Linux 7 (OEL7)

This article describes the installation of Oracle Database 11g R2 (11.2.0.4) 64-bit on Oracle Linux 7 (OL7) 64-bit. 1. Install Oracle Enterprise Linux 7. 2. Oracle Installation Prerequisites. 2.1 Automatic Setup 2.2 Manual Setup 3. Additional Setup 4. Oracle Database 11gR2 Software Installation. 5. Oracle Database Creation using DBCA.

Continue reading

Important Link About Oracle

There are number of important video link provided in below. It may helps.

Continue reading