What is Data Pump Utility? Oracle Data Pump is very fast and high speed utility. Through Data Pump utility we can move data and metadata from one database to another database very fast. Oracle Data Pump flexible, faster and latest alternative to the ‘exp’ and ‘imp’ which is old utilities and used in previous versions. … Read more Oracle Data Pump Utility
Manually Database Creation. In this post i’m going to show you how to create manually Database step by step and how to create password file and how to configure Enterprise Manager (EM). For manually Database creation we have need a directory structure which is mandatory for every Database. In Oracle every Database have a separate Directory … Read more How to create manually Database?
In this article we are going to discus, how to install vmware tools on Linux environment, the vmware tools allow us to make a unity with parent operating system also enable copy & past. So just follow the below steps. STEP 1. Move your cursor upside and click on vm tab then select Install vmware … Read more How to install VMware tools
Create omf Database In this article we are going to discuss how to create database using OMF feature, we don’t need to create location for Datafile, Controlfile, Tempfile, Redolog file and RMAN backups, it all manged automatically. There are three new parameter which is using for making new database. DB_CREATE_FILE_DEST (This parameter defines the location … Read more How to Create Database using OMF parameter.
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. Subscribe us on YouTube Tablespace and Group Name A tablespace group name and … Read more How to add Multiple Temporary Tablespace
Cloning Database is just a copy of your production Database which is using for testing purpose or you can use any other purpose also, after cloning Database you have same copy of your production database. For making Database clone we have many ways. Through backup of controlfile. Using DBCA. Through OEM (Oracle Enterprise Manager). Through … Read more Cloning Database Using DBCA
In this article we are going to discussed how to managed space in tablespace. We have 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 Managed space in Tablespace
In this article we are going to discussed how to install Oracle 11g R2, a briefly guide on Redhat Linux 6 (64 bit). In this article discus about Oracle 11g (R2) Database server for this server minimum 2 GB swap size and selinux=permissive. For Linux Installation see my Linux Installation post or Video. Step 1. … Read more How to Install Oracle 11g R2 on RHEL-6 step by step
Hello Friends in this article i’m going to demonstrate you Linux installation steps, follow all below steps. Firstly mount your system CD/DVD or ISO and then select installation option then press Enter, follow below screenshot Select skip option and then press Enter. Click on Next Select your language type and click on Next button. Then … Read more Redhat Linux installation step by step
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 make it easy to install, update, remove rpm’s. Configure Yum Server step by step We need RHEL 6 DVD or ISO file, mount it with your system, all media automatically mounted … Read more How to configure yum server