//
you're reading...
Database, Oracle Installation & Configuration

Install Oracle Database 11g R2 on Linux RHEL/CentOS 6.5 – Section 3 (Single Instance)

Prepare the Oracle Grid Infrastructure software for Installation

Download the Oracle Grid Infrastructure 11.2.0.4 from MOS, if you don’t have the oracle support account you can use the version 11.2.0.1

Login to the Oracle Database Server as user root

Using any FTP or winscp to transfer the Oracle Grid Infrastructure package to the Oracle Database Server

Unzip the Oracle Grid Infrastructure

[root@newzonetechdb02]# unzip p13390677_112040_Linux-x86-64_3of7.zip

Once the unzip complete, Grant the correct permission for grid folder

[root@newzonetechdb02]# chown -R grid:oinstall grid
[root@newzonetechdb02]# chmod -R 777 grid

Start install the Oracle Grid Infrastructure

Login as user grid

[grid@newzonetechdb02]# cd /home/grid/grid
[grid@newzonetechdb02]# ./runInstaller

Select ‘Skip Software Updates

Grid_1

Select ‘Install Oracle Grid Infrastructure Software Only

Grid_2

Select the language option you want to install. In this case, I selected ‘English

Grid_3

  • Oracle ASM Administration Group: asmadmin
  • Oracle ASM DBA: asmdba
  • Oracle ASM Operator Group: asmoper

Grid_4

  • Oracle Base: /ora01/app/grid
  • Oracle Home: /oragi/app/11.2.0.4/grid

Grid_5

Inventory Directory: /ora01/app/oraInventory

Grid_6

Select the ‘Ignore All

Grid_7

Click ‘Yes‘ to carry on the installation

Grid_8

Click ‘Install

Grid_9

At the end of the installation, run 2 scripts

  1. orainstRoot.sh
  2. root.sh

Grid_10

Grid_11

Grid_12

Grid_13

run the roothas.pl script to start Oracle Grid Infrastructure components

Grid_14

Until Now we installed only the Oracle Grid Infrastructure software. In this case, I installed the Oracle Grid Infrastructure 11.2.0.4

Create Oracle ASM Instance Manually

[grid@newzonetechdb02~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.cssd       ora.cssd.type  OFFLINE   OFFLINE
ora.diskmon    ora....on.type OFFLINE   OFFLINE
ora.evmd       ora.evm.type   ONLINE    ONLINE    orcl11gr2
ora.ons        ora.ons.type   OFFLINE   OFFLINE
[grid@newzonetechdb02~]$ crs_start ora.cssd
Attempting to start `ora.cssd` on member `newzonetechdb02`
Attempting to start `ora.diskmon` on member `newzonetechdb02`
Start of `ora.diskmon` on member `newzonetechdb02` succeeded.
Start of `ora.cssd` on member `newzonetechdb02` succeeded.
[grid@newzonetechdb02~]$  crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.cssd       ora.cssd.type  ONLINE    ONLINE    newzonetechdb02
ora.diskmon    ora....on.type OFFLINE   OFFLINE
ora.evmd       ora.evm.type   ONLINE    ONLINE    newzonetechdb02
ora.ons        ora.ons.type   OFFLINE   OFFLINE
[grid@newzonetechdb02]$ srvctl status asm
PRCR-1001 : Resource ora.asm does not exist

Create the init+ASM.ora file for Oracle ASM instance

[grid@newzonetechdb02]$ vi $ORACLE_HOME/dbs/init+ASM.ora
+ASM.__large_pool_size=16777216
+ASM.__oracle_base='/ora01/app/grid'#ORACLE_BASE set from in memory value
+ASM.asm_diskgroups='TESTDBDATA','TESTDBFRA'#Manual Mount
*.asm_power_limit=1
*.asm_diskstring='/dev/oracleasm/disks/*'
*.diagnostic_dest='/ora01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

Login to asm instance with sysasm privilege

[grid@newzonetechdb02]$ sqlplus / as sysasm

Start the instance with nomount status

sqlplus> startup nomount

Create the spfile file from pfile

sqlplus> create spfile='/oragi/app/11.2.0.4/grid/dbs/spfile+ASM.ora' from pfile='/oragi/app/11.2.0.4/grid/dbs/init+ASM.ora';
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]

Shutdown the instance

sqlplus> shutdown immediate

Add the ASM Instance base on the spfile created

[grid@newzonetechdb02]$ srvctl add asm -p $ORACLE_HOME/dbs/spfile${ORACLE_SID}.ora

Check the ASM Instance status

[grid@newzonetechdb02]$ srvctl status asm
ASM is not running.

Start the ASM Instance

[grid@newzonetechdb02]$ srvctl start asm
[grid@newzonetechdb02 dbs]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.cssd       ora.cssd.type  ONLINE    ONLINE    newzonetechdb02
ora.diskmon    ora....on.type OFFLINE   OFFLINE
ora.evmd       ora.evm.type   ONLINE    ONLINE    newzonetechdb02
ora.ons        ora.ons.type   OFFLINE   OFFLINE
[grid@newzonetechdb02 dbs]$ crsctl status resource ora.asm
NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE on newzonetechdb02
Advertisements

About daviewning

I am an Oracle DBA

Discussion

Trackbacks/Pingbacks

  1. Pingback: Install Oracle Database 11g R2 on Linux CentOS 6.5 – Before Start | DBTechZone - February 13, 2016

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: