Mar 05 2020
In this topic, I will show how to Create and manage PDB: Create a PDB from SEED. Clone a PDB with No Data. Clone a PDB from existing local PDB. Clone a PDB from existing remote PDB. Clone a PDB from existing remote Non-CDB. Clone a PDB from non-CDB using DBMS_PDB Package. Plugging In an …
Mar 04 2020
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 …
Mar 03 2020
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 …
Mar 01 2020
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.
Dec 22 2019
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
Dec 12 2019
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. …
Nov 09 2019
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 …
Nov 04 2019
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.
Nov 01 2019
There are number of important video link provided in below. It may helps.
