How to create manually Database?

Manually Database Creation

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?

Share this
Share

How to Create Database using OMF parameter.

Create omf Database

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.

Share this
Share

How to add Multiple Temporary Tablespace

temporary tablespace

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

Share this
Share

Cloning Database Using DBCA

Cloning Database

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

Share this
Share

Managed space in Tablespace

Managed space in Tablespace

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

Share this
Share

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

Install Oracle 11g R2

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

Share this
Share

Redhat Linux installation step by step

Linux installation steps

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

Share this
Share
Share