Create the database using DBCA

Set the ORACLE_HOME, ORACLE_BASE and PATH environment variables:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_home1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE=/u01/app/oracle

Create the directories for the datafiles:
[root@ORAVM1 ~]# mkdir -p /u02/oradata/ocmdb1
[root@ORAVM1 ~]# mkdir -p /u03/oradata/ocmdb1
[root@ORAVM1 ~]# chown -R oracle:oinstall /u02/oradata/ocmdb1
[root@ORAVM1 ~]# chown -R oracle:oinstall /u03/oradata/ocmdb1
[root@ORAVM1 ~]# chmod -R 775 /u02/oradata/ocmdb1
[root@ORAVM1 ~]# chmod -R 775 /u03/oradata/ocmdb1

Launch dbca:
[oracle@ORAVM1 ~]$ dbca

Click Next in the first screen:

Either configure the listener first using netca, or untick “Configure Enterprise Manager”, and configure it after the installation.

Run netca in a different terminal window:
[oracle@ORAVM1 ~]$ netca
 

Click Finish to exit netca.

Continue with the dbca session:

Choose File System or ASM:

 

Choose Unicode as character set:

Make sure that the control files are spread over 3 separate disk groups:

 

The redo logs should be mirrored, and the members of each redo group placed in 2 different disk groups:

 

 

Install the software separately

In this post I’ll install the Oracle database software, without having the Oracle Universal Installer  (OUI) creating a database.
In a future post, I’ll create a database with DBCA (DataBase Configuration Assistant), and also manually (with the CREATE DATABASE statement).

Check that the oracle account exists, and is in the groups oinstall and dba:
id oracle
uid=500(oracle) gid=500(oracle) groups=500(oracle)

In my case it exists, but it's not yet in the groups dba and oinstall.

Create the groups:
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd -g 502 dba
/usr/sbin/groupadd -g 503 oper

Assign the Oracle account to the dba and oracle groups
/usr/sbin/usermod -g oinstall -G dba  oracle [, oper]

(If the Oracle account didn't exist yet, run this instead: /usr/sbin/useradd -u 502 -g oinstall -G dba,[oper] oracle)

Create the ORACLE_BASE directory (logged on as root):
mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle

Create the Oracle inventory location (logged on as root)
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01/app/oraInventory
chmod -R 775 /u01/app/oraInventory

Add The following lines to .bash_profile:
umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LIBPATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$LIBPATH

Log on as the Oracle user.
If you're already logged on, run: . $HOME/.bash_profile
I didn't bother changing kernel parameters / setting resource limits. In theory, the installer will come up with a fixup script to alter this.

Copy over the first 2 11gR2 installation CD's  to $HOME/11gR2
(you can download the correct version immediately from Oracle support, no need anymore to first install the base release and apply patch sets afterwards).Unzip both zip files:

cd $HOME/11gR2
unzip p10404530_112030_Linux-x86-64_1of7.zipunzip p10404530_112030_Linux-x86-64_2of7.zip
rm *.zip
cd database

Unset the ORACLE_HOME: unset ORACLE_HOME
Start the Oracle Universal Installer: ./runInstaller

 

Choose Skip Software Updates:

Choose Install Database Software Only:

Choose Single Instance Database Installation:

Add all the languages in the following screen:

Choose Enterprise Edition (or the edition for which you have a licence...):

The ORACLE_BASE environment variable was set => the OUI has filled out the Oracle Base automatically, and derived an OFA compliant directory for the ORACLE_HOME. Accept both values.

The installer will perform some prerequisite checks, and will show you the result:

Click on Fix and Check Again. Oracle will generate a fix up script (since 11g):

Run the generated script as root: /tmp/CVU_11.2.0.0.2_oracle/runfixup.sh
Click Check Again => No errors are displayed. Click Next to go to the following screen, and click on Install:

Execute the following scripts as root, and afterwards press OK:

The installation will now start.

In next posts, I’ll create the database manually (create database command) and using DBCA.

Removing the Oracle software:

Use the deinstall command (new since 11gR2):

See: Chapter 7, "Removing Oracle Database Software"

Important!
Oracle strongly recommends that you configure your installations using an Optimal Flexible Architecture (OFA) configuration, and that you reserve Oracle base and Oracle home paths for exclusive use of Oracle software.
If you have any user data in these locations in the Oracle base that is owned by the user account that owns the Oracle software, then the deinstall command deletes this data.

You can remove the software by running the following command:

$ORACLE_HOME/deinstall/deinstall

Press Enter (or if you have a listener with a different name, enter it):

….

Specify all Single Instance listeners that are to be de-configured [LISTENER]:
…

The deinstall command will ask for some other information such as the database names which are in this ORACLE_HOME.

You’ll notice that after running the command, the directory dbhome_1 is gone in /u01/app/oracle/product/11.2.0:

/u01/app/oracle/product/11.2.0
[oracle@ORAVM1 11.2.0]$ ls
[oracle@ORAVM1 11.2.0]$


In the next post I’ll install the software separately, and create a database with dbca afterwards.

Drop the database:

With dbca:

Launch dbca: [oracle@ORAVM1 dbhome_1]$ dbca

Choose “Delete a Database” and click Next:

Select the database that you want to delete and click Next:
 

Confirm that you want to delete the database:

Click No to stop DBCA:

Manually with the DROP DATABASE statement:

export ORACLE_SID=ocmdb1

sqlplus / as sysdba

SQL> shutdown immediate
SQL> startup mount exclusive restrict
SQL> drop database;
 

Install Oracle Server software + Create database together in one step

In this post I'll show you how to install the Oracle database software and create a database directly from the Oracle Universal Installer.

1. Check that the oracle account exists, and is in the groups oinstall and dba:
   id oracle
   uid=500(oracle) gid=500(oracle) groups=500(oracle)
   In my case it exists, but it's not yet in the groups dba and oinstall.
   Create the groups:
   /usr/sbin/groupadd oinstall
   /usr/sbin/groupadd -g 502 dba
   /usr/sbin/groupadd -g 503 oper
   Assign the Oracle account to the dba and oracle groups
   /usr/sbin/usermod -g oinstall -G dba  oracle [, oper]
   (If the Oracle account didn't exist yet, run this instead:

   
   /usr/sbin/useradd -u 502 -g oinstall -G dba,[oper] oracle)

   
   
2. Create the ORACLE_BASE directory (logged on as root):
   mkdir -p /u01/app/oracle
   chown -R oracle:oinstall /u01/app/oracle
   chmod -R 775 /u01/app/oracle
   
3. Create the Oracle inventory location (logged on as root)
   mkdir -p /u01/app/oraInventory
   chown -R oracle:oinstall /u01/app/oraInventory
   chmod -R 775 /u01/app/oraInventory
   
4. Add The following lines to .bash_profile:
   umask 022
   export ORACLE_BASE=/u01/app/oracle
   export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
   export PATH=$ORACLE_HOME/bin:$PATH
   export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
   export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
   export LIBPATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$LIBPATH
   
5. Log on as the Oracle user.
   If you're already logged on, run: . $HOME/.bash_profile
   I didn't bother changing kernel parameters / setting resource limits. In theory, the installer will come up with a fixup script to alter this. So let's check if it succeeds in doing so ;-)
   
6. Copy over the first 2 11gR2 installation CD's  to $HOME/11gR2 (you can download the correct version immediately from Oracle support, no need anymore to first install the base release and apply patch sets afterwards).Unzip both zip files:
   cd $HOME/11gR2
   unzip p10404530_112030_Linux-x86-64_1of7.zipunzip p10404530_112030_Linux-x86-64_2of7.zip
   rm *.zip
   cd database
   
7. Unset the ORACLE_HOME: unset ORACLE_HOME
   Start the Oracle Universal Installer: ./runInstaller
   
   Press Next in the following screen, and ignore the warning by pressing the Yes button:
    
   
   Choose Skip Software Updates:
    
   
   Choose: Create and configure a database. This will install a database and automatically launch dbca (the Database Creation Assistant) to create a database.
    
   
   Choose Server Class:
   
    
   
   
   Choose Single instance database installation:
    
   
   Choose Advanced Install:
   
   Add all the languages in the following screen:
    
   
   Choose Enterprise Edition (or the edition for which you have a licence...):
    
   
   The ORACLE_BASE environment variable was set => the OUI has filled out the Oracle Base automatically, and derived an OFA compliant directory for the ORACLE_HOME. Accept both values.
    
   
   Accept /u01/app/oraInventory as a location for the Oracle inventory, and choose oinstall:
    
   
   Choose General Purpose / Transaction Processing:
    
   
   Enter a global database name:
    
   
   Leave memory allocated at 40 %, we can change the memory settings afterwards using the memory advisors.
    
   
   Oracle recommends using AL32UTF8 as character set:
    
   
   Leave the new security settings in place:
    
   
   Choose “Use Oracle Enterprise Manager Database Control”:
    
   
   Choose File System, and choose a path for the datafiles. Preferably on a different disk than the software
   (the screenshot shows a bad example because the datafiles are stored on the same disk as the software…).
    
   
   Don’t enable automatic backups, we’ll configure this afterwards.
    
   
   Enter passwords for the administrative accounts:
    
   
   Enter the groups for the OSDBA and OSOPER groups:
   
   
   The installer will perform some prerequisite checks, and will show you the result:
    
   
   Click on Fix and Check Again. Oracle will generate a fix up script (since 11g):
    
   
   Run the generated script as root: /tmp/CVU_11.2.0.0.2_oracle/runfixup.sh
   Click Check Again => No errors are displayed. Click Next to go to the following screen, and click on Install:
    
   
   Note down the URL for Database Control and the global database name:
   
   Execute the following scripts as root, and afterwards press OK:
   
   
   Click Close to exit the Oracle Universal Installer:
   

In the next post I’ll show you how to install only the software, and afterwards create a database with DBCA (DataBase Creation Assistant).