Wednesday, 1 August 2012

Installing 11g Grid Infrastructure for Standalone Server on Solaris 10


Download 11g Grid Infrastructure software from oracle's edelivery site edelivery.oracle.com.In this

Verify the system requirements.


  • Memory : minimum 4GB of RAM and 4GB of swap space.
    • # /usr/sbin/prtconf | grep “Memory size”
    • # /user/sbin/swap -s
    • At least 5.5 GB of space for Grid Infrastructure.
  • At least 3.5 GB of space for Oracle software enterprise edition.
  • At least 1.5 GB of tmp space.
    • df –k /tmp 
Create OS users and groups

We will be creating two separating accounts: grid,oracle. The Unix account grid will be used for 11g grid instrastructure( ASM+clusterware) and oracle will be used for 11g Database software.

Group dba for Oracle sysdba: this group is required for Database software. This group use identify OS accounts who have database administrative(SYSDBA) privilege.
SYSASM is new in 11g and enables the separation of ASM storage administration from database administration(SYSDBA). By default members of dba are not granted SYSASM privileges.
Oracle Automatic Storage Storage Management Group(asmadmin) for ASM administrator and separated from SYSDBA(dba) privilege.The members of this group have SYSASM privilege. The SYSASM allows mounting and dismounting of disk groups and ASM storage tasks. The users with SYSASM previliges cannot connect to database.
ASM database Administrator group (asmdba) : members of these groups are granted read and write access to files managed by ASM. The oracle software owner must be the member of this group.

#groupadd –p 1000 oinstall
#groupadd –p 1020 asmadmin
#groupadd –p  1021 asmdba
#groupadd –p  1031 dba
#groupadd –p 1022 asmoper
#useradd –u 1100 –g oinstall –G asmadmin, asmdba, grid
#useradd –u 1101 –g oinstall –G dba, asmdba, oracle
#mkdir –p /u01/app/11.2.0/grid
#mkdir –p /u01/app/grid
#Chown –R grid:oinstall /u01
#mkdir /u01/app/oracle
#chwon –R oracle:oinstall /u01/app/oracle
#chmod 775 /u01

Verify Storage permissions

Login as grid account and make sure grid can write to RAW devices.

$dd if=/dev/zero of=/dev/rdsk/emcpower1g bs=1024 count=1440
dd: /dev/rdsk/emcpower1g: open: Permission denied

login as root and fix permission issues first. 

$ su -

#chown grid:oinstall  /dev/rdsk/emcpower1g

$dd if=/dev/zero of=/dev/rdsk/emcpower1g bs=1024 count=1440
1440+0 records in
1440+0 records out

Package and Patches for Solaris 10.

SUNWarc
SUNWbtool
SUNWcsl
SUNWhea
SUNWi1cs (ISO8859-1)
SUNWi15cs (ISO8859-15)
SUNWi1of
SUNWlibC
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWxwfnt
119963-14
120753-06
139574-03
141414-02
141444-09 (included with Solaris 5.10 update 8

Package and Patches for Smart Flash Cache


125555-03 
139555-08 
            140796-01       
            140899-01       
141016-01 
141414-10
141736-05 


Check required package before installation.

  # pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibm SUNWlibms SUNWsprot  SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt SUNWcsl

 

Install Grid Infrasture


login as grid account and go to grid infracture directory.
$ id
uid=1100(grid) gid=1000(oinstall)

$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 180 MB.   Actual 511 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 75891 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216   Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-12-03_11-36-45AM. Please wait ...





#sh /u01/app/oraInventory/orainstRoot.sh
     Changing permissions of /u01/app/oraInventory.
     Adding read,write permissions for group.
     Removing read,write,execute permissions for world.
     Changing groupname of /u01/app/oraInventory to oinstall.
     The execution of the script is complete.



#


Checking swap space: 0 MB available, 500 MB required.    Failed <<<<
Some requirement checks failed. You must fulfill these requirements before you continue
# /u01/app/11.2.0/grid/root.sh
........
Errors in file :
ORA-27091: unable to queue I/O
ORA-15081: failed to submit an I/O operation to a disk
ORA-06512: at line 4
PROT-1: Failed to initialize ocrconfig
In my case there was not enough swap space, fix the problem and before running root.sh run the deconfig
#/u01/grid/11.2.0/crs/install/rootcrs.pl -deconfig -force

Run root.sh again..

# sh /u01/app/11.2.0/grid/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2012-04-27 08:27:54: Checking for super user privileges
2012-04-27 08:27:54: User has super user privileges
2012-04-27 08:27:54: Parsing the host name
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
stty: : No such device or address
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
CRS-4664: Node kykewesdrdb1 successfully pinned.
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
kykewesdrdb1     2012/04/27 08:28:23     /u01/app/11.2.0/grid/cdata/server1db1/backup_20120427_082823.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
Updating inventory properties for clusterware
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB.   Actual 91699 MB    Passed
The inventory pointer is located at /var/opt/oracle/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
#
That's it and this will start ohasd.bin( Oracle High Availability Services) which will start following processes
 
 - cssdagent - responsible for I/O fencing.
 - ocssd.bin  - resposible for node membership. (I guess in standalone it required for ASM ?)
 - listener
- orarootagent.bin
 - oraagent

ASM is up and running

asm_gmon_+ASM
asm_smon_+ASM
asm_lgwr_+ASM
asm_ckpt_+ASM
asm_gen0_+ASM
asm_pmon_+ASM
asm_psp0_+ASM
asm_vktm_+ASM
asm_dia0_+ASM
asm_rbal_+ASM
asm_dbw0_+ASM
asm_mman_+ASM
asm_diag_+ASM
asm_mmon_+ASM
asm_mmnl_+ASM

Please look into my other blog http://vkoracle.blogspot.com/2010/11/creating-oracle-10g-rac-database-on-11g.html to see how to install database on top of grid infrastructure.

No comments:

Post a Comment