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

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

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

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

STEPS FOR INSTALLING ORACLE 11gR2 DB SERVER:

• Download Oracle DB Server and Prepare it to Install
• Check OS level Parameters Required
• Kernel Parameters Setup
• Security Limits Setup
• RPM Packages Installation for Oracle
• Users and Groups creation
• Directories and Permissions Setup
• Install RDBMS (Oracle DB Server) software
• Check the Installed RDBMS software