Verify OS's Patch (in two nodes): [M80A] /> Instfix -ik iy28766 all filesets for iY28766 were found. [M80a] /> instfix -ik iy28949 there Was no data for iy28949 in the FIX DATABASE. [M80A] /> instfix -ik IY29965 All filesets for IY29965 were found. [m80a] /> instfix -ik IY30150 All filesets for IY30150 were found. [m80a] /> instfix -ik IY22854 All filesets for IY22854 were found. [m80a] /> instfix -ik IY26778 All filesets for IY26778 were found. [m80a] /> instfix -ik IY28111 All filesets for IY28111 were found. [m80a] /> instfix -ik IY21047 All filesets for IY21047 were found. [m80a] /> JDK installation And JRE required Patchs If you use http server: IY30886 JRE1.1.8 If you do not use HTTP Server: IY31033 JDK1.3.1 or to IBM Web SiteDownload's special JDK131_64bit package installation, there will be a special directory after installing Oracle, specify this JDK: [M80B] / usr / java13_64> PWD / USR / JAVA13_64 [M80B] / usr / java13_64> [M80A] />
lslpp -l | grep rsct rsct.basic.hacmp 2.2.1.20 APPLIED RSCT Basic Function (HACMP / ES rsct.basic.rte 2.2.1.20 APPLIED RSCT Basic Function rsct.clients.rte 99.99.999.999 COMMITTED Supersede Entry - Not really rsct. compat.basic.hacmp 2.2.1.20 APPLIED RSCT Event Management Basic rsct.compat.basic.rte 2.2.1.20 APPLIED RSCT Event Management Basic rsct.compat.clients.hacmp rsct.compat.clients.rte 2.2.1.20 APPLIED RSCT Event Management Client rsct.core.auditrm 2.2.1.20 APPLIED RSCT Audit Log Resource rsct.core.errm 2.2.1.20 APPLIED RSCT Event Response Resource rsct.core.fsrm 2.2.1.20 APPLIED RSCT File System Resource rsct.core.gui 2.2.1.20 APPLIED RSCT Graphical User Interface rsct.core.hostrm 2.2.1.20 APPLIED RSCT Host Resource Manager rsct.core.rmc 2.2.1.20 APPLIED RSCT Resource Monitoring and rsct.core.sec 2.2.1.20 APPLIED RSCT Security rsct.core.sensorrm 2.2.1.20 APPLIED RSCT Sensor Resource Manager Rsct.core.SR 2.2.1.20 Applied Rsct Registry Rsct.core.UTILS 2.2.1.20 Applied Rsct Utilities Rsct.msg.en_us.core.AuditRM Rsct.msg.en_us.core.errm 2.2.0.0 Committed Rsct Event Response RM Msgs - Rsct.msg.en_us.core.FSRM 2.2.0.0 Committed Rsct File System RM Msgs - rsct.msg .En_us.core.gui 2.2.0.0 COMMITTED RSCT GUI MSGS - US ENGLISH RSCT.MSG.EN_US.CORE.HOSTRM RSCT.MSG.EN_US.CORE.RMC 2.2.0.0 Committed RSCT RMC MSGS - US ENGLISH RSCT.MSG.EN_US. Core.sec 2.2.0.0 COMMITTED RSCT Security Msgs - US rsct.msg.en_us.core.Sensorrm Rsct.msg.en_us.core.SR 2.2.0.0 Committed Rsct Registry Msgs - US Rsct.msg.en_us.core.UTILS 2.2. 0.0 Committed RSCT Utilities Msgs - US Rsct.msg.en_us.core.Auditrm Rsct.msg.en_us.core.errm 2.2.0.0 Committed Rsct Event Response RM Msgs - RSCT.
Msg.en_us.core.fsrm 2.2.0.0 Committed Rsct File System RM Msgs - rsct.msg.en_us.core.gui 2.2.0.0 Committed RSCT GUI MSCT.MSG.EN_US.CORE.HOSTRM RSCT.MSG.EN_US .core.rmc 2.2.0.0 COMMITTED RSCT RMC MSGS - US English Rsct.msg.en_us.core.sec 2.2.0.0 Committed Rsct Security Msgs - US Rsct.msg.en_us.core.Sensorrm Rsct.msg.en_us.core.SR 2.2.0.0 COMMITTED RSCT Registry Msgs - US rsct.msg.en_US.core.utils 2.2.0.0 COMMITTED RSCT Utilities Msgs - US rsct.basic.rte 2.2.1.20 APPLIED RSCT Basic Function rsct.compat.basic.rte 2.2.1.0 COMMITTED RSCT Event Management Basic rsct.core.rmc 2.2.1.20 APPLIED RSCT Resource Monitoring and rsct.core.sec 2.2.1.20 APPLIED RSCT Security rsct.core.sr 2.2.1.20 APPLIED RSCT Registry rsct.core.utils 2.2.1.20 APPLIED RSCT Utilities [M80A] /> [M80A] /> LSLPP -L | Grep -i Hacmp Cluster.doc.en_us.html 4.4.1.4 Applied Hacmp Web-Based HTML Cluster.doc.en_us.pdf 4.4.1.3 Applied Hacmp PDF Documentation - US Cluster.doc.en_us.ps 4.4.1.0 COMMITTED HACM P Postscript Documentation rsct.basic.hacmp 2.2.1.20 APPLIED RSCT Basic Function (HACMP / ES rsct.compat.basic.hacmp 2.2.1.20 APPLIED RSCT Event Management Basic Function (HACMP / ES Support) rsct.compat.clients.hacmp Function ( HACMP / ES Support [M80A] />
=============== Verify the DBA user group and the hagsuser group ========================== in nodes 1: [M80A] / Oracle> TAIL / ETC / Group. . . DBA:!: 300racle Hagsuser:!: 301racle, root. . . [M80A] / Oracle> In Node 2: [M80B] / Oracle> TAIL / ETC / Group. . . DBA:!: 300racle Hagsuser:!: 301: root, oracle. . . . [M80B] / oracle> =============== Verify Oracle users =========================== In node 1: [M80A] / Oracle> CAT / etc / passwd | Grep Oracle Oracle:!: 300: 300 :: / Oracle: / usr / bin / ksh [m80a] / oracle> in node 2: [M80B] / Oracle> CAT / etc / passwd | grep oracle oracle:!: 300: 300 :: / oracle: / usr / bin / ksh [m80b] / oracle> ================ == Configure the network ======================= [m80a] /> tail / etc / hosts 127.0.0.1 loopback localhost # loopback (LO0) Name / AddRESS 192.168.2.215 m80a m80a 10.1.1.1 m80a_stb m80a 192.168.2.216 m80b m80b 10.1.1.2 m80b_stb m80b 192.168.2.205 bepone 192.168.2.207 fepone 192.168.2.208 feptwo 192.168.2.209 ibm170 [m80a] /> ========= ========== Using root users and Oracle users authentication communication: =================== 1.
Rlogin at Node 1: [M80A] /> SU - Oracle [M80A] / Oracle> ID UID = 300 (ORACLE) GID = 300 (DBA) Groups = 1 (STAFF), 301 (Hagsuser) [M80A] / Oracle> Rlogin M80b ******************************************************** ***************************** * * * * * Welcome to Aix Version 5.1! * * * * * * Please see the Readme File In / USR / LPP / BOS for Information Pertit To * * This Release of the Aix Operating System. * * * * * ******************************* *********************************************************** ******* Last unsuccessful login: Fri Dec 20 09:28:05 Beist 2002 on / dev / dtlogin / _0 last login: fri DEC 20 17:00:24 Beist 2002 on 192_168_2_89_0 from 192.168.2.89:0 [ M80B] / Oracle> EXIT CONNECTION CLOSED. [M80A] / Oracle> In Node 2: [M80B] /> SU - Oracle [M80B] / Oracle> ID UID = 300 (Oracle) GID = 300 (DBA) Groups = 1 ( STAFF), 301 (HAGSUSER) [M80B] / Oracle> Rlogin M80a ************************************ ******************************************* * * * * * Welcome TO AIX Version 5.1! * * * * * * please See the Readme File In / USR / LPP / BOS for Inform t r r t t.... t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t ******************************************** Last unsuccessful login : Thu DEC 19 17:50:11 Beist 2002 on / dev / dtlogin / _0 last login: Fri Dec 20 17:01:26 Beist 2002 on 192_168_2_89_0 from 192.168.2.89:0 [M80A] / Oracle> EXIT Connection Closed. M80B] / Oracle> 2.
RCP and RSH in Node 1: [M80A] / Oracle> ID UID = 300 (Oracle) GID = 300 (DBA) Groups = 1 (STAFF), 301 (Hagsuser) [M80A] / Oracle> RCP root.sh M80b: / TMP [M80A] / Oracle> RSH M80B ls -l / TMP/Root.sh -RWXR-XR-X 1 Oracle DBA 6386 DEC 20 17:17 / Tmp/Root.sh [M80A] / Oracle> In Node 2: [ M80B] / Oracle> ID UID = 300 (ORACLE) GID = 300 (DBA) Groups = 1 (STAFF), 301 (HAGSUSER) [M80B] / Oracle> RCP root.sh m80a: /TMP/Root.sh [M80B] / Oracle> RSH M80A LS -L /TMP/ROOT.SH -RWXR-XR-X 1 Oracle DBA 6386 DEC 20 17:18 /tmp/root.sh [m80b] / oracle> ========= === Note When HA is configured, the node relationship must be Concurrent mode: ============= Cluster Configuration Cluster Resources Show Cluster Resources Show Resource Information by Resource Group X Select Resource Group Name XXXME CURSOR To Desired item and press enter. xxxx RAC XX RSG_M80A XX RSG_M80B x Select Resource Group, my name RAC View Information: Node Relationship Concurrent ======================== Open AIO: =============== [M80A] /> LSDEV-CC AIO0 Available Asynchronous I / O [M80A] /> ============ === Start HA: =================== Start HA on both nodes: Startup steps: 1. In the case of not starting HA, do both synchronization first, one is Topology, one is resources; 2.
Start HA (just enough to start Startup Cluster Information Daemon) (the most taboo to HA is the two nodes, especially when you synchronize, it is best to finish another node, do another node, otherwise HA easy to chaos) Start Cluster Services Type or select values in entry fields. Press Enter AFTER making all desired changes. [entry Fields] * Start now, on system restart or both now BROADCAST message at startup? false Startup Cluster Lock Services? False Startup Cluster Information Daemon? True Reacquire Resources After FORCED DOWN? FALSE =================== Verify HA: =========== ======== [M80A] /> tail -f /tmp/hacmp.out end and Time: Fri Dec 20 17:12:26 2002 Action: Resource: Script name: --------- -------------------------------------------------- ----------------- Resource Group Online: Rac Node_up_local_complete search on: fri.dec.20.17: 12: 24.beist.2002.node_up_local_complete.rac.ref Resource Group Online: RSG_M80A Node_up_local_complete search on: fri.dec.20.17: 12: 25.beist.2002.node_up_local_complete.rsg_m80a.ref --------------------------- ------------------------------------------------- [ M80A ] /> [M80a] /> [M80a] /> ================================= ======== [M80A] /> LSVG -O VGA ORAVG ROOTVG [M80A] /> ====================================================================================================================================== ============== [M80A] />
LSSRC -G Cluster Subsystem Group Pid Status ClstrMgres Clsmuxpdes Cluster 794858 Active Clinfoes Cluster 762110 Active [M80A] /> =================================================== =============== [m80a] /> lssrc -a | egrep 'svcs | ES' topsvcs topsvcs 385190 active grpsvcs grpsvcs 680170 active grpglsm grpsvcs 786632 active emsvcs emsvcs 720966 active clstrmgrES cluster 770276 active CLSMUXPDES Cluster 794858 Active Clinfoes Cluster 762110 Active Emaixos Emsvcs Inoperative [M80A] /> =============== Verify Cluster User ================ ===== [m80a] /> lssrc -ls grpsvcs Subsystem Group PID Status grpsvcs grpsvcs 704520 active 4 locally-connected clients Their PIDs:. 803028 (hagsglsmd) 778476 (haemd) 745688 (clstrmgr) 827604 (gsclvmd) HA Group Services domain information: Domain established by node 2 Number of groups known locally: 6 Number of Number of local Group name providers providers / subscribers s001IGKU0009G000000U6SUEB74 2 1 0 hagsglsm_cfg 2 1 0 ha_em_peers 2 1 0 CLRESMGRD_60 2 1 0 CLSTRMGR_60 2 1 0 d001IG KU0009G000000u6Sueb74 2 1 0 [M80A] />
========== Before running runinstaller.sh, do ROOT: ============= [M80A] / CDROM> ./rootpre.sh Configuring Asynchronous I / O ... asynchronous I / o is already defined adding r / w perms for group hagsuser to /var/ha/soc/grpsvcsdsocket.test...success [M80A] / CDROM> If there is a problem, see the part of the following manual ( Configuring hags) =================== Established installation directory ========================= = Follow the prompts / TMP/orainstroot.sh: [M80A] / TMP> ./orainstroot.sh Creat.Loc) Changing Groupname of / Oracle / ORAINVENTORY TO DBA. [M80A ] / TMP> If there is a problem, you can manually do, or refer to the check information before the creation of the database is =============== before creating the database (in two Node must be confirmed): ========================== [M80A] / Oracle> LS -L / DEV / RSRVCONFIG CRW-RW-R - 1 Oracle DBA 45, 21 DEC 17 20:59 / dev / rrvconfig [m80a] / oracle> ls -l /etc/srvconfig.loc -rw-r - r - 1 Oracle DBA 30 DEC 20 14:35 /etc/srvconfig.loc [M80A] / Oracle> CAT /ETC/SRVCONFIG.LOC SRVCONFIG_LOC = / DEV / RSRVCONFIG [M80A] / Oracle> [M80A] / Oracle> LS -L / ETC / ORATAB -RW-RW-R - 1 Oracle DBA 688 DEC 20 15 : 25 / ETC / ORATAB [M80A] / Oracle> Tail / etc / oratab # # the First and Second Fields Are The System Identifier and Home # Directory of The Database Respectiveness. The Third Filed Indicates # to the dbstart utility what the the database shouth, "y", or shop not, # "n"
, Be brountain up at system boot time. # MULTIPLE ENTRIES with the Same $ Oracle_sid area not allowed. # # *: / oracle: n [m80a] / oracle> ls -l /etc/orainst.loc -rw-r- -r - 1 Oracle DBA 50 DEC 20 14:35 /etc/orainst.loc [M80A] / Oracle> CAT /ETC/OrAinst.loc inventory_loc = / oracle / orainventory inst_group = DBA [M80A] / Oracle> [M80A] / Oracle> ls -l /var/opt/oracle/srvconfig.loc -rw-rw-r - 1 Oracle DBA 30 DEC 20 14:12 /VAR/opt/oracle/srvconfig.loc [M80A] / Oracle> Cat /var/opt/oracle/srvconfig.loc srvconfig_loc = / dev / rsrvconfig [M80A] / Oracle> Do not be assured, then manually perform the following commands: (Configure HAGS, see Metalink: 2064876.102) CHMOD A X / USR / SBIN / Cluster / Utilities / CLDOMAIN chgrp hagsuser / var / ha / Soc / Grpsvcsdsocket.` / usr / sbin / cluster / utilities / cldomain` CHMOD G W /VAR/HA/Soc/grpsvcsdsdsocket.`/USR / sbin / cluster / utilities / cldomain` test HAGS: [m80a] /> / usr / sbin / cluster / utilities / cllsif Adapter Type Network Net Type Attribute Node IP Address Hardware Address Interface Name Global Name Netmask m80a service ether_net ether public m80a 192.168 .2.2 15 en0 255.255.255.0 m80a_stb standby ether_net ether public m80a 10.1.1.1 en1 255.255.255.0 m80a_tty0 service rs232_net rs232 serial m80a / dev / tty0 m80b service ether_net ether public m80b 192.168.2.216 en0 255.255.255.0 m80b_stb standby ether_net ether public m80b 10.1.1.2 EN1 255.255.255.0 M80B_TTY0 Service RS232_NET RS232 Serial M80B / DEV / TTY0 [M80A] /> =========== In Oracle Code installation (2 nodes), execution / Oracle/root.sh== ============ [M80B] / Oracle>
./root.sh Running Oracle9 root.sh script ... The following environment variables are set as: ORACLE_OWNER = oracle ORACLE_HOME = / oracle Enter the full pathname of the local bin directory: [/ usr / local / bin]: The file "dbhome" already exissrs in / usr / local / bin. OVERWRITE IT? (Y / N) [N]: y COPYING DBHOME TO / USR / local / bin ... The file "Oracaenv" Already EXISTS IN / USR / LOCAL / bin. OVERWRITE? (Y / N) [N]: y COPYING ORAENV TO / USR / local / bin ... The file "Coraenv" Already EXISTS IN / USR / local / bin. Overwrite it? (Y / N [N]: y COPYING CORENV TO / USR / LOCAL / BIN ... CREANG / ETC / ORATAB FILE ... Adding entry to / etc / oracab file ... Entries Will be added to the / etc / oracability 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. [m80b] / oracle> If a problem occurs, may be done manually if the above problems are solved In installation software, there should be no problem during the software, if any, there is a problem with the possibility of: 1. Solve PRKR-1023: Do $ ln -sf /etc/srvconfig.loc /oracle/srvm/config/srvconfig.loc 2 in both nodes. Solve PRKR-1064: Do $ su root's password: # mkdir / var / opt / oracle # chown oracle: dba / var / opt / oracle # chmod -r 777 / var / opt / oracle # ln -sf /etc/srvconfig.loc /var/opt/oracle/srvconfig.loc # ls -l /var/opt/oracle/srvconfig.loc lrwxrwxrwx 1 root system 18 Nov 27 15:18 /var/opt/oracle/srvconfig.loc -> /etc/srvconfig.loc # # more /var/opt/oracle/srvconfig.loc srvconfig_loc = / dev / rrvconfig # ls -l / dev / rrvconfig crw-rw-r - 1 Oracle DBA 45, 21 NOV 25 14:52 / dev / rsrvconfig # # dd if = / dev / rrvconfig of = / dev / null BS = 8192 16384 0 Records in 16384 0 Records Out # 3.