CHKL-OCE 3.0: OCE Oracle 11gR1 Certification Checklist
Approved by:Issue Date: / 12-October-2007
Revision Number: / 1.0.0
To be completed in full by vendor representative:
Engineering Bill Of Material / Configuration as CertifiedCertification Date (Started -> Completed)
Version of Oracle Software being Certified (**Full Version, eg. 11.1.0.6.0**)
Vendor
Server Name / Model
O/S Version
OS Patches Required
Clusterware Version (+ required patches)
CFS Version
# Server Nodes
CPU type (Architecture)
# CPUs per Server
Memory per Server
Network
JDK
C/C++ Compiler
Cobol Compiler (if applicable)
Fortran Compiler (if applicable)
[Linux] Linux Distribution
[Linux] - Linux OS Name
[Linux] - Linux OS Version Number
[Linux] - Kernel Version Number
[Linux] - Glibc Version Number
[Linux] - GCC Version Number
[Linux] - Binutils Version Number
Shared Storage Technology (HBA cards, FC Switch, Shared Disk)
Shared Interconnect Technology (NIC's, Switch, Protocol)
Special Software
Miscellaneous (Cables, Monitor/Keyboard/Mouse)
Miscellaneous Configuration Comments:
OCE Support Details
Support Id:Submitted by (Vendor Contact):
OCE Support Representative:
Please tick the check box when the test/check has been completed, or write "N/A" if the test is not applicable (and write an explanation of why the test is not applicable in the Comments Section).
Oracle11gR1 OCE Certification/Validation
To be completed in full by vendor representative:
Part 1: Pre-Installation Checks/Requirements
If there are any problems please indicate here and in the Comments Section. Send any relevant logs with the checklist.
VERIFICATION CHECK / COMPLETED, YES or NOVerify Shared Storage is visible to all nodes (CFS and RAC testing)
Verify all kernel parameters have been tuned for Oracle
For non-Linux systems verify all Cluster Managers are running on all nodes
Execute runcluvfy utility successfully, without errors
Comments
Insert additional comments regarding Part 1 here
Part 2: Software Installation Testing
This section includes various installation scenarios; all those that are relevant for the system being certified must be completed in order for certification to be awarded.
If there are any problems please indicate here and in the Comments Section. Send any relevant logs with the checklist.
2.1 Verification Checks
VERIFICATION CHECK / COMPLETED, YES or NOLinux x86 only, install OCFS(if applicable)
For NAS clusters verify the NFS mounts use correct NFS mount options, See NAS vendor documentation for more detail
If using raw devices, configure Oracle Cluster Registry (OCR) and if appropriate Quorum (Vote) raw devices/logical volumes on shared storage
CRS INSTALL SCENARIO #1 / Result (Pass/Fail)
Install Oracle Cluster Ready Services 11gR1 (11.1) => SHARED ORA_CRS_HOME => OCR/VDISK ON SHARED FS
Validate Oracle Cluster Ready Services Installation
· Check installActions logfile for errors
· Check CRS Health ($ORA_CRS_HOME/bin/crsctl check crs)
· Check CRS Resources – ONS, GSD, VIP ($ORA_CRS_HOME/bin/crs_stat –t) are all online
CRS INSTALL SCENARIO #2 / Result (Pass/Fail)
Install Oracle Cluster Ready Services 11gR1 (11.1) => SHARED ORA_CRS_HOME => OCR/VDISK ON NAS
Validate Oracle Cluster Ready Services Installation
· Check installActions logfile for errors
· Check CRS Health ($ORA_CRS_HOME/bin/crsctl check crs)
· Check CRS Resources – ONS, GSD, VIP ($ORA_CRS_HOME/bin/crs_stat –t) are all online
CRS INSTALL SCENARIO #3 / Result (Pass/Fail)
Install Oracle Cluster Ready Services 11gR1 (11.1) => NON-SHARED ORA_CRS_HOME => OCR/VDISK ON SHARED FS
Validate Oracle Cluster Ready Services Installation
· Check installActions logfile for errors
· Check CRS Health ($ORA_CRS_HOME/bin/crsctl check crs)
· Check CRS Resources – ONS, GSD, VIP ($ORA_CRS_HOME/bin/crs_stat –t) are all online
CRS INSTALL SCENARIO #4 / Result (Pass/Fail)
Install Oracle Cluster Ready Services 11gR1 (11.1) => NON-SHARED ORA_CRS_HOME => OCR/VDISK ON RAW DEVICES
Validate Oracle Cluster Ready Services Installation
· Check installActions logfile for errors
· Check CRS Health ($ORA_CRS_HOME/bin/crsctl check crs)
· Check CRS Resources – ONS, GSD, VIP ($ORA_CRS_HOME/bin/crs_stat –t) are all online
RAC INSTALL SCENARIO #1 / Result (Pass/Fail)
Install Oracle RAC 11gR1 (11.1) => SHARED ORACLE_HOME => CREATE GENERAL PURPOSE DB ON SHARED FS
Validate Oracle RAC 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Check CRS Health from RAC HOME ($ORACLE_HOME/bin/crsctl check crs)
· Verify database status ($ORACLE_HOME/bin/srvctl status database –d <DB_NAME>)
· Connect to database (using sqlplus)
RAC INSTALL SCENARIO #2 / Result (Pass/Fail)
Install Oracle RAC 11gR1 (11.1) => SHARED ORACLE_HOME => CREATE GENERAL PURPOSE DB ON NAS
Validate Oracle RAC 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Check CRS Health from RAC HOME ($ORACLE_HOME/bin/crsctl check crs)
· Verify database status ($ORACLE_HOME/bin/srvctl status database –d <DB_NAME>)
· Connect to database (using sqlplus)
RAC INSTALL SCENARIO #3 / Result (Pass/Fail)
Install Oracle RAC 11gR1 (11.1) => NON-SHARED ORACLE_HOME => CREATE GENERAL PURPOSE DB ON SHARED FS
Validate Oracle RAC 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Check CRS Health from RAC HOME ($ORACLE_HOME/bin/crsctl check crs)
· Verify database status ($ORACLE_HOME/bin/srvctl status database –d <DB_NAME>)
· Connect to database (using sqlplus)
RAC INSTALL SCENARIO #4 / Result (Pass/Fail)
Install Oracle RAC 11gR1 (11.1) => NON-SHARED ORACLE_HOME => CONFIGURE ASM (SAN)
CREATE CUSTOM DB ON ASM CONFIGURED ABOVE, AS DIFFERENT USER (FROM THAT USED TO PERFORM THE ASM CONFIGURATION)
Validate Oracle RAC 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Check CRS Health from RAC HOME ($ORACLE_HOME/bin/crsctl check crs)
· Verify ASM status ($ORACLE_HOME/bin/srvctl status asm –n <node1>|<node2>|…|<nodeN>)
· Verify database status ($ORACLE_HOME/bin/srvctl status database –d <DB_NAME>)
· Connect to database (using sqlplus)
RAC INSTALL SCENARIO #5 (LINUX ONLY) / Result (Pass/Fail)
Install Oracle RAC 11gR1 (11.1) => NON-SHARED ORACLE_HOME => CONFIGURE ASM w/ ASMLIB => CREATE CUSTOM DB ON ASM w/ASMLIB
Validate Oracle RAC 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Check CRS Health from RAC HOME ($ORACLE_HOME/bin/crsctl check crs)
· Verify ASM status ($ORACLE_HOME/bin/srvctl status asm –n <node1>|<node2>|…|<nodeN>)
· Verify database status ($ORACLE_HOME/bin/srvctl status database –d <DB_NAME>)
· Connect to database (using sqlplus)
RAC INSTALL SCENARIO #6 / Result (Pass/Fail)
Install Oracle RAC 11gR1 (11.1) => SHARED ORACLE_HOME => CREATE GENERAL PURPOSE DB ON ASM (NAS)
Validate Oracle RAC 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Check CRS Health from RAC HOME ($ORACLE_HOME/bin/crsctl check crs)
· Connect to database (using sqlplus)
RAC INSTALL SCENARIO #7 / Result (Pass/Fail)
Install Oracle RAC 11gR1 (11.1) => NON-SHARED ORACLE_HOME => CREATE CUSTOM DB ON RAW DEVICES
Validate Oracle RAC 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Check CRS Health from RAC HOME ($ORACLE_HOME/bin/crsctl check crs)
· Connect to database (using sqlplus)
RAC INSTALL SCENARIO #8 / Result (Pass/Fail)
Install Oracle RAC 11gR1 (11.1) => NON-SHARED ORACLE_HOME => CREATE CUSTOM DB ON NAS
Validate Oracle RAC 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Check CRS Health from RAC HOME ($ORACLE_HOME/bin/crsctl check crs)
· Connect to database (using sqlplus)
SINGLE INSTANCE INSTALL SCENARIO #1 / Result (Pass/Fail)
Install Oracle Single Instance 11gR1 (11.1) => CUSTOM INSTALL => CUSTOM DB with ALL OPTIONS
Validate Oracle Single Instance 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Connect to database (using sqlplus)
SINGLE INSTANCE INSTALL SCENARIO #2 / Result (Pass/Fail)
Install Oracle Single Instance 11gR1 (11.1) => GENERAL PURPOSE DB => SELECT ‘ALL LANGUAGES’ & ‘INSTALL DEMOS’
Validate Oracle Single Instance 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Connect to database (using sqlplus)
SINGLE INSTANCE INSTALL SCENARIO #3 / Result (Pass/Fail)
Install Oracle Single Instance 11gR1 (11.1) => GENERAL PURPOSE DB on ASM (SAN/NAS)
Validate Oracle Single Instance 11gR1 (11.1) Installation
· Check installActions logfile for errors
· Verify ASM status ($ORACLE_HOME/bin/srvctl status asm –n <node1>|<node2>|…|<nodeN>)
· Verify database status ($ORACLE_HOME/bin/srvctl status database –d <DB_NAME>)
· Connect to database (using sqlplus)
SINGLE INSTANCE INSTALL SCENARIO #4 / Result (Pass/Fail)
Install Oracle Companion CD 11gR1 (11.1) => HTML w/ APACHE => NCOMP, Demos
Validate Oracle Companion CD 11gR1 (11.1) Installation
· Check installActions logfile for errors
SINGLE INSTANCE INSTALL SCENARIO #5 / Result (Pass/Fail)
Install Oracle Client 11gR1 (11.1) => RUNTIME
Validate Oracle Client 11gR1 (11.1) Installation
· Check installActions logfile for errors
SINGLE INSTANCE INSTALL SCENARIO #6 / Result (Pass/Fail)
Install Oracle Client 11gR1 (11.1) => CUSTOM
Validate Oracle Client 11gR1 (11.1) Installation
· Check installActions logfile for errors
SINGLE INSTANCE INSTALL SCENARIO #7 / Result (Pass/Fail)
Install Oracle Transparent Gateways 11gR1 (11.1)
Validate Oracle Transparent Gateways 11gR1 (11.1) Installation
· Check installActions logfile for errors
OCE INSTALL VALIDATION / Result (Pass/Fail)
Install OCE Certification Kit for Oracle 10g Release 2 (11.1)
· Check OCE Installation logfiles for errors
2.2 Comments
Insert additional comments regarding Part 2 herePart 3: Software Post-Installation Verification/Set-up
If there are any problems please indicate here and in the Comments Section. Send any relevant logs with the checklist.
3.1 Post Install Checks
VERIFICATION CHECK / COMPLETED, YES or NOVerify no errors were encountered in
$ORACLE_HOME/OCEinstallSI.log
$ORACLE_HOME/OCEinstallRAC.log
$ORACLE_HOME/OCEinstallexes.log
RAW DEVICE CERTS ONLY - OAST Testing
Set up devices/logical volumes as per $OAST_HOME/oast<N>/files.dat.raw for Oracle Automated Stress Tests (OAST)
where <N> is the number of warehouses generated at install time
RAW DEVICE CERTS ONLY – All RAC Testing
Set up devices/logical volumes as per $INST_HOME/rdbms/test/macro/src/stkdefraw.tsc (Refer to Chapter 5 and Appendix B of OCE Installation and User’s Guide)
Ensure devices are accessible and writable by Oracle user from all nodes
RAC ASM/HAS Testing Only
Set up devices/logical volumes as per files below. Refer to Chapter 5 and Appendix B of OCE Installation and User’s Guide
· $INST_HOME/rdbms/test/macro/src/stkdefraw.tsc
· $INST_HOME/rdbms/test/macro/sosd/stkrawosm
· $INST_HOME/rdbms/test/tkfg/src/tkfgacdisk.tsc
· $INST_HOME/rdbms/test/tkfg/src/tkfgamdu2.tsc
· $INST_HOME/rdbms/test/tkfg/src/tkfgamdu4.tsc
RAC ASM/HAS Testing Only (ORACLE_HOME not shared)
Export the following mounts from node1
$ORACLE_HOME/oce/work
$ORACLE_HOME/dbs
$ORACLE_HOME/network/admin
On all other nodes (not node1) in your cluster :
mount <NODE1>: $ORACLE_HOME/oce/work $ORACLE_HOME/oce/work
mount <NODE1>:$ORACLE_HOME/dbs $ORACLE_HOME/dbs
mount <NODE1>: $ORACLE_HOME/network/admin $ORACLE_HOME/network/admin
3.2 Comments
Insert additional comments regarding Part 3 herePart 4: Additional Manual Tests
4.1 11gR1/10gR2 Interoperability Test
Item / Result (Pass/Fail)Oracle 11gR1 Clusterware installed
Oracle 11gR1 Database installed
Oracle 10gR2 Database installed
Oracle 11gR1 ASM Configured & Started
Oracle 10gR2 Database Created using 11gR1 ASM-managed diskgroup
4.2 OS Stats Test
Regression (view) / # .suc files / # .dif files / Results[Pass/Fail] / Comments
Expected / Actual / Expected / Actual
oceost (osstat) / 3 / 0
oceost2 (osstat2) / 0 / 0 / After execution, complete manual portion. See Release Notes for further details
Depending on your system capability, the above steps (osstat, osstat2) need to be executed multiple times (see Release Notes for further details). Please document multiple runs here, along with the system modifications preceding each additional run
4.3 NUMA Interactive Test
Item / Result (Pass/Fail)Execute NUMA test
COMMENTS:
4.4 Comments
Insert additional comments regarding Part 4: Manual Tests herePart 5: Oracle11gR1 OAST Tests
5.1 System Details
Item / QuantityController
Raid Storage
External Disks
Internal Disks
5.1.1 RAID Configuration
Details / # Disks Used to Build
Data Volume / RAID Specification
(eg. RAID5) / Striping Factor
(# columns) / Comments
OAST
5.1.2 Database & Layout Details
5.2 Test Results
Test Case / Particulars / Details / Runtime (hrs) / Results[Pass/Fail] / Issues / Bugs
O-01 / OAST / IO and CPU ERP load / 24
O-02 / OAST / Interconnect/Cache run / 3
O-03 / OAST / RAC Elevator test / 24
5.3 Comments
Insert additional comments regarding Part 5: OAST Tests herePart 6: Oracle11gR1 Single Instance Tests
[Note: Consult OCE Release Notes for any changes to expected results listed here]
6.1 SI Suites Set 1
Regression (view) / # .suc files / # .dif files / Results[Pass/Fail] / Comments
Expected / Actual / Expected / Actual
Javavm_j10 (j10) / 304 / 0
javavm_j19 (j19) / 196 / 0
javavm_j1 (j1) / 332 / 0
javavm_jsj (jsj) / 107 / 0
6.2 SI Suites Set 2
[Pass/Fail] / Comments
Expected / Actual / Expected / Actual
network javassl (njssl) / 29 / 0
network nl (nnl) / 110 / 0
network nsglsn (nnsg) / 586 / 0
network ns (ns) / 225 / 0
network ntz (nntz) / 529 / 0
6.3 SI Suites Set 3
Regression (view) / # .suc files / # .dif files / Results[Pass/Fail] / Comments
Expected / Actual / Expected / Actual
tkmain_11a (t11a) / 96 / 0
tkmain_3 (t3) / 1 / 0
tkmain_310 (t310) / 96 / 0
tkmain_32 (t32) / 4 / 0
tkmain_33 (t33) / 345 / 0
tkmain_34 (t34) / 92 / 0
tkmain_35 (t35) / 83 / 0
tkmain_36 (t36) / 23 / 0
tkmain_4d7 (t4d7) / 55 / 0
6.4 SI Suites Set 4
Regression (view) / # .suc files / # .dif files / Results[Pass/Fail] / Comments
Expected / Actual / Expected / Actual
tkmain_462 / 13 / 0
tkmain_463 / 21 / 0
tkmain_464 / 21 / 0
tkmain_8d1 (t8d1) / 232 / 0
tkmain_8d5 (t8d5) / 60 / 0
tkmain_8e1 (t8e1) / 195 / 0
tkmain_8g5h (t8g5h) / 1 / 0
tkmain_bc1 (tbc1) / 73 / 0
tkmain_bc2 (tbc2) / 93 / 0
6.5 SI Suites Set 5
Regression (view) / # .suc files / # .dif files / Results[Pass/Fail] / Comments
Expected / Actual / Expected / Actual
tkmain_bc3 (tbc3) / 66 / 0
tkmain_bc4 (tbc4) / 29 / 0
tkmain_bc5 (tbc5) / 20 / 0
tkmain_bc6 (tbc6) / 34 / 0
tkmain_dig1 (tdig1) / 120 / 0
tkmain_dig2 (tdig2) / 90 / 0
tkmain_dig3 (tdig3) / 44 / 0
tkmain_g10 (tg10) / 44 / 0
tkmain_g17 (tg17) / 74 / 0
6.6 SI Suites Set 6
Regression (view) / # .suc files / # .dif files / Results[Pass/Fail] / Comments
Expected / Actual / Expected / Actual
tkmain_g25 (tg25) / 36 / 0
tkmain_gp2 (tgp2) / 106 / 0
tkmain_gp4 (tgp4) / 69 / 0
tkmain_ionfs
(tionfs) / 17 / 0
tkmain_lo6e (tlo6e) / 472 / 0
tkmain_lo6 (tlo6) / 38 / 0
tkmain_o8
(to8) / 127 / 0
tkmain_olp (tolp) / 76 / 0
tkmain_pk1 (tpk1) / 407 / 0
6.7 SI Suites Set 7
Regression (view) / # .suc files / # .dif files / Results[Pass/Fail] / Comments
Expected / Actual / Expected / Actual
tkmain_pv1 (tpv1) / 408 / 0
tkmain_sm1a (tsm1a) / 22 / 0
tkmain_sm1 (tsm1) / 101 / 0
tkmain_smg (tsmg) / 22 / 0
tkmain_sms (tsms) / 60 / 0
tkmain_tx8 (ttx8) / 19 / 0
tkmain_xd1 (txd1) / 13 / 0
6.8 SI Suites Set 8
Regression (view) / # .suc files / # .dif files / Results[Pass/Fail] / Comments
Expected / Actual / Expected / Actual
tkmain_srto (srto) / 87 / 0
tkmain_srtt (srtt) / 77 / 0
6.9 Comments