How to Create Database using OMF parameter

How to Create Database using OMF parameter

In this article we are going to discuss How to Create Database using OMF parameter, we don’t need to create a location for Datafile, Controlfile, Tempfile, Redolog file, and RMAN backups, it all managed automatically. There are three new parameter which is using for making new database. DB_CREATE_FILE_DEST (This parameter defines the location of the default … Read more

How to create a Database manually?

How to create manually Database

In this post, I’m going to show you how to create a manually Database step by step and how to create a password file and how to configure Enterprise Manager (EM). For manual Database creation, we have to need a directory structure which is mandatory for every Database. In Oracle every Database has a separate Directory … Read more

How to add Multiple Temporary Tablespace

In Oracle Database we can add multiple temporary tablespace using tablespace groups, tablespace groups allowed to use multiple temporary tablespace to store temporary segments. The temporary tablespace group is created automatically when you add first tablespace is assigned a group.

In Oracle Database we can add multiple temporary tablespaces using tablespace groups, tablespace groups allowed to use multiple temporary tablespaces to store temp segments. The temp tablespace group is created automatically when you add the first tablespace is assigned a group. Tablespace and Group Name A tablespace group name and tablespace name must not be the … Read more

Cloning Database Using DBCA

Cloning Database Using DBCA

Cloning Database is just a copy of your production Database which is using for testing purposes or you can use any other purpose also, after cloning Database you have the same copy of your production database. For making a Database clone we have many ways. Through backup of the control file. Using DBCA. Through OEM … Read more

Creating and Deleting Database in Silent Mode using DBCA?

Creating and Deleting Database in Silent Mode using DBCA

In this article, I’m going to demonstrate to you, Creating and Deleting Database in Silent Mode using DBCA (Database Configuration Assistant) steps by steps. Through DBCA we can create a new Database, Delete the database, and modify the Database. As well as it can manage templates and Pluggable Databases in Oracle 12c. These actions are … Read more

Managed space in Tablespace

Managed space in Tablespace

In this article, we are going to discuss how to manage space in tablespace (Managed space in Tablespace). Oracle has two types of tablespaces Locally Managed Tablespace and Dictionary Managed tablespace. Locally Managed Tablespace The Locally Managed Tablespace is default type of tablespace and locally managed tablespace extents are managed within the tablespace via bitmap. Data storage hierarchy in … Read more

How to Install Oracle 11g R2 on RHEL-6 step by step

oracle 11g installation

In this article, we are going to discussed how to install Oracle 11g R2, a brief guide on Redhat Linux 6 (64 bit). This article discusses Oracle 11g (R2) Database server installation, this server minimum 2 GB swap size, and selinux=permissive. For Linux Installation see my Linux Installation post or Video. How to install oracle 11g on … Read more

How to configure yum server

how to configure yum server

Hello friends, in this article we are going to learn how to configure the YUM server step by step. If you have any questions please write in the comment box. What is yum and how do I use it? Configure Yum server (yellow-dog updater modified) it’s a package manager for rpm management, yum server makes it easy … Read more