TO CREATE ORACLE RG IN SOLARIS 4.X ON SOLARIS 11

1)Creating Pools and file systems:-
#zpool create Z10DBPool  c2d14 c2d13 c2d12 c2d11 c2d10 c2d9 c2d8 c2d7
#zpool  create  Z10LOGPool  c2d5 c2d4
#zpool create  Z10ARCHPool c2d7  c2d6
2)Creating file systems by using following commands
#zfs create –o mountpoint=/desiredmp  poolname/file system

#df -kh
Z10DBPool/Z10           20G    22M        20G     1%    /oracle/Z10
Z10DBPool/112_64        10G   5.0G       5.0G    51%    /oracle/Z10/112_64
Z10DBPool/sapdata1     100G    27G        73G    27%    /oracle/Z10/sapdata1
Z10DBPool/sapdata2     100G    25G        75G    25%    /oracle/Z10/sapdata2
Z10DBPool/sapdata3     100G    24G        76G    25%    /oracle/Z10/sapdata3
Z10DBPool/sapdata4     100G    20G        80G    20%    /oracle/Z10/sapdata4
Z10DBPool/sapreorg      15G    31K        15G     1%    /oracle/Z10/sapreorg
Z10ARCHPool/oraarch    100G   3.9G        96G     4%    /oracle/Z10/oraarch
Z10LOGPool/mirrlogA    3.0G    31K       3.0G     1%    /oracle/Z10/mirrlogA
Z10LOGPool/mirrlogB    3.0G    31K       3.0G     1%    /oracle/Z10/mirrlogB
Z10LOGPool/origlogA    3.0G  1020M       2.0G    34%    /oracle/Z10/origlogA
Z10LOGPool/origlogB    3.0G  1021M       2.0G    34%    /oracle/Z10/origlogB
Z10ERSPool/ERS10       5.0G   195M       4.8G     4%    /usr/sap/Z10/ERS10

3)INSTALL DATABASE.
4) configuring Oracle Database.
1)create oracle RG.
#clrg create Z10DB_RG
2)create datapool resource
#clrt register SUNW.HAStoragePlus
#clrs create –g Z10DB_RG –t  SUNW.HAStoragePlus  -p zpools= Z10DBPool dbdatares

3.create archpool resource
#clrs create –g Z10DB_RG –t  SUNW.HAStoragePlus  -p zpools= Z10ARCHPool –p Resource_dependencies=dbdatares  dbarchres
4.create logpool resource
 
#clrs create –g Z10DB_RG –t  SUNW.HAStoragePlus  -p zpools= Z10LOGPool –p Resource_dependencies=dbdatares  dblogres

5.create IP resource
#clrslh create –g Z10DB_RG –h Z10DB-VIP dbipres
6.create oracle database resource.
% sqlplus "/as sysdba"
SQL> grant connect, resource to mary identified by mary;
 Grant succeeded.
 SQL> alter user mary default tablespace system quota 1m on system;
 User altered.
SQL> grant select on v_$sysstat to mary;
Grant succeeded.
SQL> grant create table to mary;
 Grant succeeded.
 SQL> grant create session to mary;
Grant succeeded.
SQL> exit
#clrt register SUNW.oracle_server   
#clrs create -g Z10DB_RG -t SUNW.oracle_server   
-p ORACLE_HOME=/oracle/Z10/112_64
-p ORACLE_SID=Z10
-p ALERT_LOG_FILE=/oracle/Z10/saptrace/diag/rdbms/z10/Z10/trace/alert_Z10.log
-p connect_string=mary/mary
-p Resource_Dependencies_offline_restart=dbdatares,dblogres,dbarchres -d Z10dbres
#clrs set -p Resource_project_name=Z10 Z10dbres
#clrs enable Z10dbres
7.To configure Listener resource:-
Z10CI% pwd
/oracle/Z10/112_64/network/admin
Z10CI% cat tnsnames.ora
################
# Filename......: tnsnames.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/TNSNAMES.ORA#2 $
################
Z10.WORLD=
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = SAP.WORLD)
          (PROTOCOL = TCP)
          (HOST = Z10DB-VIP)
          (PORT = 1527)
        )
    )
    (CONNECT_DATA =
       (SID = Z10)
       (GLOBAL_NAME = Z10.WORLD)
    )
  )
LISTENER_Z10.WORLD=
(ADDRESS = (PROTOCOL = TCP)(HOST = Z10DB-VIP)(PORT = 1527))
$ sqlplus "/as sysdba”
SQL*Plus: Release 11.2.0.3.0 Production on Thu May 31 11:22:25 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter listener
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------
 listener_networks string
local_listener string
remote_listener string
SQL> alter system set local_listener='LISTENER_Z10' scope=both;
System altered.

SQL> alter system register;
System altered.
SQL> exit
To create listener resource
#clrt register SUNW.oracle_listener
#clrs create -g Z10DB_RG -t SUNW.oracle_listener
-p ORACLE_HOME=/oracle/Z10/112_64
-p listener_name=LISTENER
-p Resource_Dependencies_offline_restart=dbdatares,dblogres,dbarchres -d Z10lisres
#clrs set -p Resource_project_name=Z10 Z10lisres
#clrs enable Z10lisres