Tuesday, May 31, 2016

step by step process of creating physical standby database

Steps to create a Physical standby database:


1). Prepare primary database for standby database creation

      -- Enable archiving

      -- Enable force logging

      -- Set primary database initialization parameters

      -- Configure standby redo logs

Monday, May 30, 2016

DataGuard Introduction

-- Oracle Data Guard ensures the High Availability, Data Protection and Disaster Recovery for enterprise data.

-- Oracle Data Guard maintains the one or many Secondary databases(Standby databases) as alternative to the Primary (Production) database.

Sunday, May 8, 2016

Dropping or Removing the Database and DeInstallation of Oracle DB server

Dropping or Removing the Database:


-- There are 3 ways to drop or remove the database from the Oracle DB Server. They are

                1). Mannually

Tuesday, May 3, 2016

Oracle Database Creation ( Using OMF )

=>> At first Goto oracle home location and check the databases available.


#

#su - oracle

$ps -eaf | grep smon

$cat /etc/oratab

$clear

Oracle Database Creation ( Silent Mode )

=>> At first Goto oracle home location and check the databases available.

#

#su - oracle

$ps -eaf | grep smon

$cat /etc/oratab

$clear

Sunday, May 1, 2016

Oracle Database Creation Mannually

Mannual DB Creation:


To create the database mannually, Open a terminal and follow the below commands..

#su - oralce

$.  .bash_profile


Here we should create a parameter file on going to the oracle home database location

$cd  $ORACLE_HOME/dbs

Oracle Database creation using DBCA utility


Database Creation using DBCA:

[root@ram ~]#

[root@ram ~]# xhost +


[root@ram ~]# su - oracle

[oracle@ram ~]$ . .bash_profile


[oracle@ram ~]$ dbca

ORACLE 11gR2 INSTALLATION ON RHEL 5.6 USING VMWARE WORKSTATION-Silent Mode

This kind of Installation takes place in two major situations that are
  1. When GUI installation is not supported 
  2. When softwate need to be installed remotely
Here also We take all the steps what we see in GUI mode installation except RDBMS installation step
  • Download  Oracle DB Server  and  Prepare it to Install
  • Checking OS level Requirements
  • Kernel Parameters Setup
  • Security Limits Setup
  • RPM Packages Installation for Oracle
  • USERS  and  GROUPS creation 
  • Directories  and  Permissions  setup