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
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
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 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
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
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
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
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