Clone Grid Home and Oracle Home

I have done the following steps in that section:

1. Clone Grid home

2. Install and Configure oracleasm, ASMLib

3. Create Disk group

4. Clone Oracle Home

I have clone Grid and Oracle home from a server name testdb1 to testdb2.

OS Version Used: Red hat 5 (2.6.18-398.el5)

Oracle Version: 11.2..0.3

Grid Version: 11.2.0.3

########################################################################

-- Clone Grid Home

########################################################################

[grid@testdb1 ~]$ crsctl stop resource -all

CRS-2500: Cannot stop resource 'ora.diskmon' as it is not running

CRS-2500: Cannot stop resource 'ora.ons' as it is not running

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'testdb1'

CRS-2673: Attempting to stop 'ora.evmd' on 'testdb1'

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'testdb1'

CRS-2673: Attempting to stop 'ora.INDX.dg' on 'testdb1'

CRS-2673: Attempting to stop 'ora.testdb1.db' on 'testdb1'

CRS-2677: Stop of 'ora.INDX.dg' on 'testdb1' succeeded

CRS-2677: Stop of 'ora.evmd' on 'testdb1' succeeded

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'testdb1' succeeded

CRS-2677: Stop of 'ora.testdb1.db' on 'testdb1' succeeded

CRS-2677: Stop of 'ora.DATA.dg' on 'testdb1' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'testdb1'

CRS-2677: Stop of 'ora.asm' on 'testdb1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'testdb1'

CRS-2677: Stop of 'ora.cssd' on 'testdb1' succeeded

CRS-4000: Command Stop failed, or completed with errors.

On the source node, create a copy of the Oracle Grid Infrastructure home.

[root@testdb1 ~]# cp -prf /opt/grid/product/11.2.0.3 /mnt/dbasharedvol

[grid@testdb1 ~]$ crsctl start resource -all

CRS-2501: Resource 'ora.ons' is disabled

CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'testdb1'

CRS-2672: Attempting to start 'ora.cssd' on 'testdb1'

CRS-2672: Attempting to start 'ora.diskmon' on 'testdb1'

CRS-2672: Attempting to start 'ora.evmd' on 'testdb1'

CRS-2676: Start of 'ora.diskmon' on 'testdb1' succeeded

CRS-2676: Start of 'ora.evmd' on 'testdb1' succeeded

CRS-2676: Start of 'ora.LISTENER.lsnr' on 'testdb1' succeeded

CRS-2676: Start of 'ora.cssd' on 'testdb1' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'testdb1'

CRS-2676: Start of 'ora.asm' on 'testdb1' succeeded

CRS-2672: Attempting to start 'ora.DATA.dg' on 'testdb1'

CRS-2672: Attempting to start 'ora.INDX.dg' on 'testdb1'

CRS-2676: Start of 'ora.DATA.dg' on 'testdb1' succeeded

CRS-2672: Attempting to start 'ora.testdb1.db' on 'testdb1'

CRS-2676: Start of 'ora.INDX.dg' on 'testdb1' succeeded

CRS-2676: Start of 'ora.testdb1.db' on 'testdb1' succeeded

CRS-4000: Command Start failed, or completed with errors.

[root@testdb1 ~]# cd /mnt/dbasharedvol/11.2.0.3/

Delete unnecessary files from the copy.

[root@testdb1 11.2.0.3]# rm -rf testdb1

[root@testdb1 11.2.0.3]# rm -rf log/testdb1

[root@testdb1 11.2.0.3]# find gpnp -type f -exec rm -f {} \;

[root@testdb1 11.2.0.3]# find cfgtoollogs -type f -exec rm -f {} \;

[root@testdb1 11.2.0.3]# rm -rf crs/init/*

[root@testdb1 11.2.0.3]# rm -rf cdata/*

[root@testdb1 11.2.0.3]# rm -rf crf/*

[root@testdb1 11.2.0.3]# rm -rf network/admin/*.ora

[root@testdb1 11.2.0.3]# find . -name '*.ouibak' -exec rm {} \;

[root@testdb1 11.2.0.3]# find . -name '*.ouibak.1' -exec rm {} \;

[root@testdb1 11.2.0.3]# rm -rf root.sh*

[root@testdb2 11.2.0.3]# rm -f network/admin/*.ora

Create a compressed copy of the previously copied Oracle Grid Infrastructure home using tar or gzip on Linux and UNIX systems.

[root@testdb1 11.2.0.3]# tar -zcvpf /mnt/dbasharedvol/gridHome.tgz .

[root@testdb2 ~]# groupadd -g 1000 oinstall

[root@testdb2 ~]# groupadd -g 1031 dba

[root@testdb2 ~]# groupadd -g 1032 asmdba

[root@testdb2 ~]# groupadd -g 1033 asmadmin

[root@testdb2 ~]# useradd -u 1100 -g oinstall -G dba,asmadmin,asmdba grid

[root@testdb2 ~]# useradd -u 1101 -g oinstall -G dba,asmadmin,asmdba oracle

[root@testdb2 ~]# /usr/bin/passwd oracle

Changing password for user oracle.

New UNIX password:

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

[root@testdb2 ~]# /usr/bin/passwd grid

Changing password for user grid.

New UNIX password:

Retype new UNIX password:

passwd: all authentication tokens updated successfully.

Deploy the copy of the Oracle Grid Infrastructure home

[root@testdb2 ~]# mkdir -p /opt/grid/product/11.2.0.3

[root@testdb2 ~]# cd /opt/grid/product/11.2.0.3

[root@testdb2 ~]# mkdir -p /opt/oracle

[root@testdb2 ~]# chown oracle:oinstall /opt/oracle

[root@testdb2 11.2.0.3]# tar -zxvf /mnt/dbasharedvol/gridHome.tgz

[root@testdb2 11.2.0.3]# chown -R grid:oinstall /opt/grid/product/11.2.0.3

[root@testdb2 oracle]# chmod -R 775 /opt/

Create a directory for the Oracle Inventory on the destination node and, if necessary, change the ownership of all of the files in the Oracle Grid Infrastructure home to be owned by the Oracle Grid Infrastructure installation owner and by the Oracle Inventory (oinstall privilege) group.

[root@testdb2 11.2.0.3]# mkdir -p /opt/oraInventory

[root@testdb2 11.2.0.3]# chown grid:oinstall /opt/oraInventory

When you run the last of the preceding commands on the Grid home, it clears setuid and setgid information from the Oracle binary. Run the following commands to restore the cleared information:

[root@testdb2 11.2.0.3]# chmod u+s /opt/grid/product/11.2.0.3/bin/oracle

[root@testdb2 11.2.0.3]# chmod g+s /opt/grid/product/11.2.0.3/bin/oracle

[root@testdb2 11.2.0.3]# chmod u+s /opt/grid/product/11.2.0.3/bin/extjob

[root@testdb2 11.2.0.3]# chmod u+s /opt/grid/product/11.2.0.3/bin/jssu

[root@testdb2 11.2.0.3]# chmod u+s /opt/grid/product/11.2.0.3/bin/oradism

[root@testdb2 11.2.0.3]# sudo su - grid

[grid@testdb2 ~]# cd /opt/grid/product/11.2.0.3/clone/bin/

[grid@testdb2 bin]$ perl clone.pl -silent ORACLE_BASE=/opt/oracle ORACLE_HOME=/opt/grid/product/11.2.0.3 ORACLE_HOME_NAME=OraHome2Grid INVENTORY_LOCATION=/opt/oraInventory

./runInstaller -clone -waitForCompletion "ORACLE_BASE=/opt/oracle" "ORACLE_HOME=/opt/grid/product/11.2.0.3" "ORACLE_HOME_NAME=OraHome2Grid" "INVENTORY_LOCATION=/opt/oraInventory" -silent -noConfig -nowait

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 3999 MB Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-04-13_11-50-38PM. Please wait ...Oracle Universal Installer, Version 11.2.0.3.0 Production

You can find the log of this install session at:

/opt/oraInventory/logs/cloneActions2017-04-13_11-50-38PM.log

.................................................................................................... 100% Done.

Installation in progress (Thursday, April 13, 2017 11:50:44 PM CEST)

........................................................................ 72% Done.

Install successful

Linking in progress (Thursday, April 13, 2017 11:50:45 PM CEST)

Link successful

Setup in progress (Thursday, April 13, 2017 11:50:46 PM CEST)

................. 100% Done.

Setup successful

End of install phases.(Thursday, April 13, 2017 11:51:07 PM CEST)

WARNING:A new inventory has been created in this session. However, it has not yet been registered as the central inventory of this system.

To register the new inventory please run the script '/opt/oraInventory/orainstRoot.sh' with root privileges.

If you do not register the inventory, you may not be able to update or patch the products you installed.

The following configuration scripts need to be executed as the "root" user.

/opt/oraInventory/orainstRoot.sh

/opt/grid/product/11.2.0.3/root.sh

To execute the configuration scripts:

1. Open a terminal window

2. Log in as "root"

3. Run the scripts

Run the script on the local node.

The cloning of OraHome2Grid was successful.

Please check '/opt/oraInventory/logs/cloneActions2017-04-13_11-50-38PM.log' for more details.

[root@testdb2 oracle]# /opt/oraInventory/orainstRoot.sh

Changing permissions of /opt/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /opt/oraInventory to oinstall.

The execution of the script is complete.

[root@testdb2 oracle]# /opt/grid/product/11.2.0.3/root.sh

Check /opt/grid/product/11.2.0.3/install/root_testdb2.ipx.com_2017-04-13_23-53-00.log for the output of root script

[root@testdb2 oracle]# less /opt/grid/product/11.2.0.3/install/root_testdb2.ipx.com_2017-04-13_23-53-00.log

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= grid

ORACLE_HOME= /opt/grid/product/11.2.0.3

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:

/opt/grid/product/11.2.0.3/perl/bin/perl -I/opt/grid/product/11.2.0.3/perl/lib -I/opt/grid/product/11.2.0.3/crs/install /opt/grid/product/11.2.0.3/crs/install/roothas.pl

To configure Grid Infrastructure for a Cluster execute the following command:

/opt/grid/product/11.2.0.3/crs/config/config.sh

This command launches the Grid Infrastructure Configuration Wizard. The wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media.

[root@testdb2 ~]# /opt/grid/product/11.2.0.3/perl/bin/perl -I/opt/grid/product/11.2.0.3/perl/lib -I/opt/grid/product/11.2.0.3/crs/install /opt/grid/product/11.2.0.3/crs/install/roothas.pl

Using configuration parameter file: /opt/grid/product/11.2.0.3/crs/install/crsconfig_params

LOCAL ADD MODE

Creating OCR keys for user 'grid', privgrp 'oinstall'..

Operation successful.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4664: Node testdb2 successfully pinned.

Adding Clusterware entries to inittab

testdb2 2017/04/15 14:29:46 /opt/grid/product/11.2.0.3/cdata/testdb2/backup_20170415_142946.olr

Successfully configured Oracle Grid Infrastructure for a Standalone Server

Add environment variable in .bash_profile in grid user

ORACLE_BASE=/opt/grid

export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3

export ORACLE_HOME

ORACLE_SID=+ASM

export ORACLE_SID

NLS_LANG=american_america.UTF8

export NLS_LANG

NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

export NLS_DATE_FORMAT

PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/sbin:$PATH

export PATH

umask 022

[grid@testdb2 ~]$ srvctl add asm

[grid@testdb2 ~]$ srvctl add listener

[grid@testdb2 ~]$ srvctl start listener

[grid@testdb2 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): testdb2

[grid@testdb2 ~]$ srvctl start asm

[grid@testdb2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-APR-2017 10:35:52

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date 16-APR-2017 10:32:00

Uptime 0 days 0 hr. 3 min. 52 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /opt/grid/product/11.2.0.3/network/admin/listener.ora

Listener Log File /opt/grid/product/11.2.0.3/log/diag/tnslsnr/testdb2/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.76.55)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM", status READY, has 1 handler(s) for this service...

The command completed successfully

[grid@testdb2 ~]$ crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....ER.lsnr ora....er.type ONLINE ONLINE testdb2

ora.asm ora.asm.type ONLINE ONLINE testdb2

ora.cssd ora.cssd.type ONLINE ONLINE testdb2

ora.diskmon ora....on.type OFFLINE OFFLINE

ora.evmd ora.evm.type ONLINE ONLINE testdb2

ora.ons ora.ons.type OFFLINE OFFLINE

########################################################################

-- Install and Configure oracleasm, ASMLib

########################################################################

[root@testdb2 ~]# vi /etc/yum.repos.d/oracleasm.repo

[oracleasm]

name=Oracle ASMLib Kernel Drivers for Red Hat Enterprise Linux Server 5

baseurl=http://yum.oracle.com/repo/OracleASM/RHEL5/$basearch/

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

gpgcheck=0

enabled=0

[root@testdb2 ~]# yum --enablerepo=oracleasm install oracleasm-support oracleasm-`uname -r`

Loaded plugins: product-id, security, subscription-manager

Excluding Packages in global exclude list

Finished

Setting up Install Process

Resolving Dependencies

--> Running transaction check

---> Package oracleasm-2.6.18-398.el5.x86_64 0:2.0.5-1.el5 set to be updated

---> Package oracleasm-support.x86_64 0:2.1.8-1.el5 set to be updated

--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================================================

Package Arch Version Repository Size

Installing:

oracleasm-2.6.18-398.el5 x86_64 2.0.5-1.el5 oracleasm 25 k

oracleasm-support x86_64 2.1.8-1.el5 oracleasm 88 k

Transaction Summary

Install 2 Package(s)

Upgrade 0 Package(s)

Total download size: 113 k

Is this ok [y/N]: y

Downloading Packages:

(1/2): oracleasm-2.6.18-398.el5-2.0.5-1.el5.x86_64.rpm | 25 kB 00:00

(2/2): oracleasm-support-2.1.8-1.el5.x86_64.rpm | 88 kB 00:00

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Total 162 kB/s | 113 kB 00:00

Running rpm_check_debug

Running Transaction Test

Finished Transaction Test

Transaction Test Succeeded

Running Transaction

Installing : oracleasm-support 1/2

Installing : oracleasm-2.6.18-398.el5 2/2

Installed:

oracleasm-2.6.18-398.el5.x86_64 0:2.0.5-1.el5 oracleasm-support.x86_64 0:2.1.8-1.el5

Complete!

( If you are running on Red Hat 6 then you will need to install kmod-oracleasm instead oracleasm above, You can install it from Red Hat 6 Repo using # yum install kmod-oracleasm)

[root@testdb2 ~]# rpm -ivh http://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.4-1.el5.x86_64.rpm

Retrieving http://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.4-1.el5.x86_64.rpm

warning: /var/tmp/rpm-xfer.7eaDtc: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

1:oracleasmlib ########################################### [100%]

[root@testdb2 ~]# rpm -qa | grep oracleasm

oracleasm-support-2.1.8-1.el5

oracleasm-2.6.18-398.el5-2.0.5-1.el5

oracleasmlib-2.0.4-1.el5

[root@testdb2 ~]# /etc/init.d/oracleasm configure

Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library

driver. The following questions will determine whether the driver is

loaded on boot and what permissions it will have. The current values

will be shown in brackets ('[]'). Hitting <ENTER> without typing an

answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: grid

Default group to own the driver interface []: asmadmin

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver: [ OK ]

Scanning the system for Oracle ASMLib disks: [ OK ]

########################################################################

-- Create Disk group

########################################################################

[root@testdb1 ~]# /etc/init.d/oracleasm createdisk DATA_0001 /dev/sda3

Marking disk "DATA_0001" as an ASM disk: [ OK ]

[root@testdb1 ~]# /etc/init.d/oracleasm createdisk INDX_0001 /dev/sda4

Marking disk "INDX_0001" as an ASM disk: [ OK ]

[grid@testdb1 ~]$ oracleasm listdisks

DATA_0001

INDX_0001

SQL> select path,header_status from v$asm_disk;

PATH HEADER_STATUS

------------------------------------

ORCL:INDX_0001 PROVISIONED

ORCL:DATA_0001 PROVISIONED

PROVISINED -- It is available to be added diskgroup or create diskgroup. It's configuration done by ASMLIB

SQL> CREATE DISKGROUP DATA EXTERNAL REDUNDANCY DISK 'ORCL:DATA_0001';

Diskgroup created.

SQL> CREATE DISKGROUP INDX EXTERNAL REDUNDANCY DISK 'ORCL:INDX_0001';

Diskgroup created.

SQL> select path,header_status from v$asm_disk;

PATH HEADER_STATUS

------------------------------------

ORCL:INDX_0001 MEMBER

ORCL:DATA_0001 MEMBER

########################################################################

-- Clone Oracle Home

########################################################################

Check rpm package missing to install oracle database.

[root@testdb2 yum.repos.d]# rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel \

gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers ksh \

libaio libaio-devel libgcc libstdc++- libstdc++-devel make \

sysstat unixODBC unixODBC-devel

binutils-2.17.50.0.6-26.el5

compat-libstdc++-33-3.2.3-61

elfutils-libelf-0.137-3.el5

package elfutils-libelf-devel is not installed

package gcc is not installed

package gcc-c++ is not installed

glibc-2.5-123.el5_11.3

glibc-common-2.5-123.el5_11.3

package glibc-devel is not installed

package glibc-headers is not installed

ksh-20100621-24.el5_11

libaio-0.3.106-5

package libaio-devel is not installed

libgcc-4.1.2-55.el5

libstdc++-4.1.2-55.el5

package libstdc++-devel is not installed

make-3.81-3.el5

sysstat-7.0.2-13.el5

package unixODBC is not installed

package unixODBC-devel is not installed

Install the missing rpm example:

[root@testdb2 ~]# yum install elfutils-libelf-devel

Configuring Kernel Parameter for Linux

Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit lines similar to the following. For example:

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

Enter the following command to change the current values of the kernel parameters:

# /sbin/sysctl -p

Review the output from this command to verify that the values are correct. If the values are incorrect, edit the /etc/sysctl.conf file, then enter this command again.

Enter the command /sbin/sysctl -a to confirm that the values are set correctly.

Add the following lines in the /etc/security/limits.d/db.conf file

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft nofile 65536

oracle hard nofile 65536

oracle soft memlock 62914560

oracle hard memlock 62914560

grid soft nproc 16384

grid hard nproc 16384

grid soft nofile 65536

grid hard nofile 65536

Stop all processes related to the Oracle home in testdb1.

[root@testdb1 ~]# cd /opt/oracle/product/

[root@testdb1 product]# tar -cvf clone_oracle_home_11.2.0.3.tgz 11.2.0.3

Start all processes related to the Oracle home in testdb1.

[root@testdb1 product]# cp clone_oracle_home_11.2.0.3.tgz /mnt/dbasharedvol/

[oracle@testdb2 ~]$ mkdir -p /opt/oracle/product

[oracle@testdb2 ~]$ chown -R oracle:oinstall /opt/oracle/product/

[root@testdb2 product]# cd /opt/oracle/product/

[root@testdb2 product]# tar -xvf /mnt/dbasharedvol/clone_oracle_home_11.2.0.3.tgz

[oracle@testdb2 ~]$ cd /opt/oracle/product/11.2.0.3/oui/bin/

[oracle@testdb2 bin]$ ./runInstaller -silent -clone ORACLE_BASE="/opt/oracle" ORACLE_HOME="/opt/oracle/product/11.2.0.3" ORACLE_HOME_NAME="OraHome2"

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 4095 MB Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-04-10_11-05-03AM. Please wait ...[oracle@testdb2 bin]$ Oracle Universal Installer, Version 11.2.0.3.0 Production

You can find the log of this install session at:

/opt/oraInventory/logs/cloneActions2017-04-10_11-05-03AM.log

.................................................................................................... 100% Done.

Installation in progress (Monday, April 10, 2017 11:05:10 AM CEST)

[oracle@testdb2 bin]$ 79% Done.

Install successful

Linking in progress (Monday, April 10, 2017 11:05:14 AM CEST)

Link successful

Setup in progress (Monday, April 10, 2017 11:05:15 AM CEST)

Setup successful

End of install phases.(Monday, April 10, 2017 11:05:37 AM CEST)

WARNING:

The following configuration scripts need to be executed as the "root" user.

/opt/oracle/product/11.2.0.3/root.sh

To execute the configuration scripts:

1. Open a terminal window

2. Log in as "root"

3. Run the scripts

The cloning of OraHome2 was successful.

Please check '/opt/oraInventory/logs/cloneActions2017-04-10_11-05-03AM.log' for more details.

[root@testdb2 ~]# /opt/oracle/product/11.2.0.3/root.sh

Check /opt/oracle/product/11.2.0.3/install/root_testdb2.ipx.com_2017-04-10_11-07-22.log for the output of root script

Add environment variable in .bash_profile in grid user

ORACLE_BASE=/opt/oracle

ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch

NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

NLS_LANG='american_america.UTF8'

export PATH ORACLE_BASE ORACLE_HOME

To see how to create database using dbca please click Create database using dbca