Notes: for space mounted on "/" we need enough space to install Oracle software under "/", And sufficient space for data storage. It will be filled with Oracle_Software(4.7G) and temporary file which generated in /tmp(1G).

root_space=`echo \`df -h |grep -v Filesystem|head -1|awk '{print $4}'|sed 's/G//'\`*10|bc`
test $root_space -lt 58 ** echo "ERRORS :: The / path has no available sapce , It must more than 5.7G""

        For linux(CentOS,RHEL,Oracle Linux, 7 is the max)

• 32-bit Linux:

rpm -q binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libXp libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch --qf '%{name}.%{arch}\n'|grep "not installed"| sort
yum install -y binutils compat-libcap1 compat-libstdc++ compat-libstdc++ gcc gcc-c++ glibc glibc glibc-devel glibc-devel ksh libaio libaio-devel libgcc libgcc libstdc++ libstdc++ libstdc++-devel libstdc++-devel libXi libXtst make sysstat

• 64-bit Linux:

rpm -q binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libXp libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch --qf '%{name}.%{arch}\n'|grep "not installed"| sort
yum install -y binutils compat-libcap1 compat-libstdc++ compat-libstdc++ gcc gcc-c++ glibc glibc glibc-devel glibc-devel ksh libaio libaio-devel libgcc libgcc libstdc++ libstdc++ libstdc++-devel libstdc++-devel libXi libXtst make sysstat

        Gcc will be installed as we install packages during the previous step. So we could skip this.

• hostnamee
  • should be made up with: number,character,sign(except [- " @]
  • should not more than 8 characters
  • It will be better with lower case.
  • you should get the name with `hostname`
• Ipaddress

# check your ipaddress with either the following command
ip a 
ifconfig -a
# edit the ipaddress configure file with vi/vim/emacs and so on.
vi /etc/sysconfig/network-scripts/ifcfg-eth0

TYPE=Ethernet     # network type
#BOOTPROTO=dhcp    # ip allocate automatically
BOOTPROTO=static   # static ip address
IPADDR=192.168.1.101
NETMASK=255.255.255.0
DEFROUTE=yes     
PEERDNS=yes
PEERROUTES=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_PEERDNS=yes
IPV6_PEERROUTES=yes
IPV6_FAILURE_FATAL=no
NAME=eth0         # net-card name
DEVICE=eth0       # device name
ONBOOT=yes        # up when system bootup or not.

# CentOS/RHEL 7 
systemctl stop firewalld.service
systemctl disable firewalld.service
iptables -F

# for CentOS / RHEL /OenSUSE
sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/config

ResponseFile locate at /database/response/db_install.rsp. When you Modifying the file,Please confirm the content listed following:

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=build001
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oracle/oraInventory
SELECTED_LANGUAGES=en,zh_CN,zh_TW
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.isCustomInstall=false
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
DECLINE_SECURITY_UPDATES=true

Attention: The path of responseFile must be absolutely path.

./runInstaller -silent -force -ignoreSysprereqs -ignorePrereq -showProgress -responseFile /home/oracle/database/response/db_install.rsp

The last step we should not skip is to read what showing up in the screen, and JUST DO WHAT IT TOLD US!

...
/u01/app/oracle/oraInventory/orainstRoot.sh
/u01/app/oracle/product/11.2.0/dbhome_1/root.sh
To execute the configuration scripts:
         1. Open a terminal window
         2. Log in as "root"
         3. Run the scripts
         4. Return to this window and hit "Enter" key to continue 

Successfully Setup Software.

[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "uprr"
SID = “uprr"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD="Asdqwe123"
SYSTEMPASSWORD="Asdqwe123"
DATAFILEDESTINATION = "/u01/app/oracle/oradata"
RECOVERYAREADESTINATION= "/u01/app/oracle/flash_recovery_area"
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "UTF8"

        su - oracle
        $ORACLE_HOME/bin/dbca -silent -responseFile /database/response/dbca.rsp

• check file location and file size.

        col file_name for a60
        set lines 200
        select file_name,bytes/(1024*1024) from dba_data_files where tablespace_name='UNDOTBS1';
            FILE_NAME                                 BYTES/(1024*1024)
         -------------------------------------------  -----------------

        /u01/app/oracle/oradata/halberd/undotbs01.dbf                30

• Adjust file size

        alter database datafile '/u01/app/oracle/oradata/halberd/undotbs01.dbf' resize 1G;

• Re-confirm

        SQL> select file_name,bytes/(1024*1024) from dba_data_files where tablespace_name='UNDOTBS1';

        FILE_NAME						     BYTES/(1024*1024)
        ------------------------------------------------------------ -----------------
        /u01/app/oracle/oradata/halberd/undotbs01.dbf				  1024

• Check tablespace(file) size and file_name

        col name for a60
        select file#,bytes/(1024*1024),name from v$tempfile;
             FILE# BYTES/(1024*1024) NAME
        ---------- ----------------- ------------------------------------------------------------
	         1		  20 /u01/app/oracle/oradata/halberd/temp01.dbf

• Adjust file size

        alter database tempfile '/u01/app/oracle/oradata/halberd/temp01.dbf' resize 1G;

一般來說，redo檔案推薦大小為2G. 根據儲存型別及儲存的冗餘級別，每個redo 組使用一個redo 或者 2個redo， 當每個組有2個redo時，建議將兩個redo日誌成員儲存在不同的磁碟上，以防其中一個磁碟損壞。raid 5,自帶冗餘，因此建立一個組裡建立一個日誌檔案即可。

• Check logfile group,members and size of the logfile

        select group#,members,status,bytes/(1024*1024) from v$log;
            GROUP#    MEMBERS STATUS	       BYTES/(1024*1024)
        ---------- ---------- ---------------- -----------------
	         1	    1      INACTIVE		      50
        	 2	    1      CURRENT		      50
	         3	    1      UNUSED		      50

• check redo log file name

        select group#,member from v$logfile;
            GROUP# MEMBER
        ---------- ------------------------------------------------------------
	         3 /u01/app/oracle/oradata/halberd/redo03.log
	         2 /u01/app/oracle/oradata/halberd/redo02.log
	         1 /u01/app/oracle/oradata/halberd/redo01.log

• drop the existing file goups

        alter database drop logfile group 1;
        alter database drop logfile group 2;
        alter database drop logfile group 3;

alter database add logfile group 1 (‘/u01/app/oracle/oradata/halberd/redo01.log’）size 2G reuse;
alter database add logfile group 2 (‘/u01/app/oracle/oradata/halberd/redo02.log’）size 2G reuse;
alter database add logfile group 3 (/u01/app/oracle/oradata/halberd/redo03.log’）size 2G reuse;

After installaion of database,we should adjust some parameters to sute the productive environment.

The default value for the two parameter is too small to support our productive enrionment. We could execute the forllowing command to change it :

sqlplus / as sysdba
alter system set processes=3000 scope=spfile;
alter system set sessions=3000 scope=spfile;  
startup force;
show parameter processes
show parameter sessions