Oracle Database Appliance (ODA)
Software Version 2.2 - ILOM Version 3.0.14.13.a - Firmware Build 70764 - File System Version 0.1.23

General Information
Note: This page is based upon work with an ODA loaded with the June 2012 software release: Database version 11.2.0.3. It may be identical to the ODA you have but that may not be true as Oracle evolves the product over time. So as with all things Oracle ... do not make assumptions ... verify everything.

I have about 20% more material that will be added over the next week.
Document Sections
 
Acronyms
ADR Automatic Diagnostic Repository
AMM Automatic Memory Management
ASM Automatic Storage Management
ASR Automatic Service Requests
ASMM Automatic Shared Memory Management
ILOM Integrated Lights Out Management
IPMI Integrated Platform Management Interface
OAK Oracle Appliance Manager
OEL Oracle Enterprise Linux
OEM Oracle Enterprise Manager Grid Control
 
ASM
ODA_initASM.ora # Oracle init.ora parameter file generated by instance +ASM1 on 06/30/2012 21:31:04
*.__large_pool_size=16M
*._aggregation_optimization_settings=0
*._always_anti_join='CHOOSE'
*._always_semi_join='CHOOSE'
*._and_pruning_enabled=TRUE
*._b_tree_bitmap_plans=TRUE
*._bloom_filter_enabled=TRUE
*._bloom_folding_enabled=TRUE
*._bloom_pruning_enabled=TRUE
*._complex_view_merging=TRUE
*._compression_compatibility='11.2.0'
*._connect_by_use_union_all='TRUE'
*._convert_set_to_join=FALSE
*._cost_equality_semi_join=TRUE
*._cpu_to_io=0
*._dimension_skip_null=TRUE
*._disable_interface_checking=TRUE
*._disk_sector_size_override=TRUE
*._eliminate_common_subexpr=TRUE
*._enable_type_dep_selectivity=TRUE
*._fast_full_scan_enabled=TRUE
*._first_k_rows_dynamic_proration=TRUE
*._gby_hash_aggregation_enabled=TRUE
*._generalized_pruning_enabled=TRUE
*._globalindex_pnum_filter_enabled=TRUE
*._gs_anti_semi_join_allowed=TRUE
*._improved_outerjoin_card=TRUE
*._improved_row_length_enabled=TRUE
*._index_join_enabled=TRUE
*._ksb_restart_policy_times='0'
*._ksb_restart_policy_times='60'
*._ksb_restart_policy_times='120'
*._ksb_restart_policy_times='240' # internal update to set default
*._left_nested_loops_random=TRUE
*._local_communication_costing_enabled=TRUE
*._minimal_stats_aggregation=TRUE
*._mmv_query_rewrite_enabled=TRUE
*._new_initial_join_orders=TRUE
*._new_sort_cost_estimate=TRUE
*._nlj_batching_enabled=1
*._optim_adjust_for_part_skews=TRUE
*._optim_enhance_nnull_detection=TRUE
*._optim_new_default_join_sel=TRUE
*._optim_peek_user_binds=TRUE
*._optimizer_adaptive_cursor_sharing=TRUE
*._optimizer_better_inlist_costing='ALL'
*._optimizer_cbqt_no_size_restriction=TRUE
*._optimizer_coalesce_subqueries=TRUE
*._optimizer_complex_pred_selectivity=TRUE
*._optimizer_compute_index_stats=TRUE
*._optimizer_connect_by_combine_sw=TRUE
*._optimizer_connect_by_cost_based=TRUE
*._optimizer_connect_by_elim_dups=TRUE
*._optimizer_correct_sq_selectivity=TRUE
*._optimizer_cost_based_transformation='LINEAR'
*._optimizer_cost_hjsmj_multimatch=TRUE
*._optimizer_cost_model='CHOOSE'
*._optimizer_dim_subq_join_sel=TRUE
*._optimizer_distinct_agg_transform=TRUE
*._optimizer_distinct_elimination=TRUE
*._optimizer_distinct_placement=TRUE
*._optimizer_eliminate_filtering_join=TRUE
*._optimizer_enable_density_improvements=TRUE
*._optimizer_enable_extended_stats=TRUE
*._optimizer_enable_table_lookup_by_nl=TRUE
*._optimizer_enhanced_filter_push=TRUE
*._optimizer_extend_jppd_view_types=TRUE
*._optimizer_extended_cursor_sharing='UDO'
*._optimizer_extended_cursor_sharing_rel='SIMPLE'
*._optimizer_extended_stats_usage_control=192
*._optimizer_false_filter_pred_pullup=TRUE
*._optimizer_fast_access_pred_analysis=TRUE
*._optimizer_fast_pred_transitivity=TRUE
*._optimizer_filter_pred_pullup=TRUE
*._optimizer_fkr_index_cost_bias=10
*._optimizer_full_outer_join_to_outer=TRUE
*._optimizer_group_by_placement=TRUE
*._optimizer_improve_selectivity=TRUE
*._optimizer_interleave_jppd=TRUE
*._optimizer_join_elimination_enabled=TRUE
*._optimizer_join_factorization=TRUE
*._optimizer_join_order_control=3
*._optimizer_join_sel_sanity_check=TRUE
*._optimizer_max_permutations=2000
*._optimizer_mode_force=TRUE
*._optimizer_multi_level_push_pred=TRUE
*._optimizer_native_full_outer_join='FORCE'
*._optimizer_new_join_card_computation=TRUE
*._optimizer_null_aware_antijoin=TRUE
*._optimizer_or_expansion='DEPTH'
*._optimizer_order_by_elimination_enabled=TRUE
*._optimizer_outer_join_to_inner=TRUE
*._optimizer_outer_to_anti_enabled=TRUE
*._optimizer_push_down_distinct=0
*._optimizer_push_pred_cost_based=TRUE
*._optimizer_rownum_bind_default=10
*._optimizer_rownum_pred_based_fkr=TRUE
*._optimizer_skip_scan_enabled=TRUE
*._optimizer_sortmerge_join_inequality=TRUE
*._optimizer_squ_bottomup=TRUE
*._optimizer_star_tran_in_with_clause=TRUE
*._optimizer_system_stats_usage=TRUE
*._optimizer_table_expansion=TRUE
*._optimizer_transitivity_retain=TRUE
*._optimizer_try_st_before_jppd=TRUE
*._optimizer_undo_cost_change='11.2.0.3'
*._optimizer_unnest_corr_set_subq=TRUE
*._optimizer_unnest_disjunctive_subq=TRUE
*._optimizer_use_cbqt_star_transformation=TRUE
*._optimizer_use_feedback=TRUE
*._or_expand_nvl_predicate=TRUE
*._ordered_nested_loop=TRUE
*._parallel_broadcast_enabled=TRUE
*._partition_view_enabled=TRUE
*._pivot_implementation_method='CHOOSE'
*._pre_rewrite_push_pred=TRUE
*._pred_move_around=TRUE
*._push_join_predicate=TRUE
*._push_join_union_view=TRUE
*._push_join_union_view2=TRUE
*._px_minus_intersect=TRUE
*._px_partition_scan_enabled=TRUE
*._px_pwg_enabled=TRUE
*._px_ual_serial_input=TRUE
*._query_rewrite_setopgrw_enable=TRUE
*._remove_aggr_subquery=TRUE
*._replace_virtual_columns=TRUE
*._right_outer_hash_enable=TRUE
*._selfjoin_mv_duplicates=TRUE
*._sql_model_unfold_forloops='RUN_TIME'
*._subquery_pruning_enabled=TRUE
*._subquery_pruning_mv_enabled=FALSE
*._table_scan_cost_plus_one=TRUE
*._union_rewrite_for_gs='YES_GSET_MVS'
*._unnest_subquery=TRUE
*._use_column_stats_for_function=TRUE
*._vendor_lib_loc='/opt/oracle/extapi'
*.asm_diskgroups='RECO'
*.asm_diskgroups='DATA'
*.asm_diskgroups='REDO' # Manual Mount
*.asm_diskstring='/dev/mapper/*D_*p*'
*.asm_power_limit=1
*.audit_syslog_level='LOCAL0.INFO'
+ASM1.background_dump_dest='/u01/app/grid/diag/asm/+asm/+ASM1/trace' #Deprecate parameter
+ASM2.background_dump_dest='/u01/app/grid/diag/asm/+asm/+ASM2/trace' #Deprecate parameter
+ASM1.core_dump_dest='/u01/app/grid/diag/asm/+asm/+ASM1/cdump'
+ASM2.core_dump_dest='/u01/app/grid/diag/asm/+asm/+ASM2/cdump'
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
+ASM1.local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.0.2.20)(PORT=1521))))'
+ASM2.local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.0.2.21)(PORT=1521))))'
*.memory_target=1G
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
+ASM1.user_dump_dest='/u01/app/grid/diag/asm/+asm/+ASM1/trace' #Deprecate parameter
+ASM2.user_dump_dest='/u01/app/grid/diag/asm/+asm/+ASM2/trace' #Deprecate parameter
alert_+ASM1.log

The entire log file is more than 200K so what I've posted here is an excerpts from the initial startup.
Sun Jun 24 01:04:09 2012
MEMORY_TARGET defaulting to 369098752.
* instance_number obtained from CSS = 1, checking for the existence of node 0...
* node 0 does not exist. instance_number = 1
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Private Interface 'eth0' configured from GPnP for use as a private interconnect.
[name='eth0', type=1, ip=192.168.16.24, mac=00-21-28-e8-62-f6, net=192.168.16.0/24, mask=255.255.255.0, use=cluster_interconnect/6]
Private Interface 'eth1' configured from GPnP for use as a private interconnect.
[name='eth1', type=1, ip=192.168.17.24, mac=00-21-28-e8-62-f7, net=192.168.17.0/24, mask=255.255.255.0, use=cluster_interconnect/6]
Public Interface 'bond0' configured from GPnP for use as a public interface.
[name='bond0', type=1, ip=192.0.2.18, mac=00-21-28-e8-62-f2, net=192.0.2.0/24, mask=255.255.255.0, use=public/1]
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/11.2.0.3/grid/dbs/arch
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
NOTE: Volume support enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options.
ORACLE_HOME = /u01/app/11.2.0.3/grid
System name: Linux
Node name: orclsys1
Release: 2.6.32-300.11.1.el5uek
Version: #1 SMP Wed Mar 7 09:55:50 EST 2012
Machine: x86_64
Using parameter settings in client-side pfile /u01/app/11.2.0.3/grid/dbs/init+ASM1.ora on machine orclsys1
System parameters with non-default values:
large_pool_size = 12M
instance_type = "asm"
remote_login_passwordfile= "EXCLUSIVE"
asm_diskstring = "/dev/mapper/*D_*p*"
asm_power_limit = 1
diagnostic_dest = "/u01/app/grid"
Cluster communication is configured to use the following interface(s) for this instance
192.168.16.24
192.168.17.24
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sun Jun 24 01:04:17 2012
PMON started with pid=2, OS id=1813
Sun Jun 24 01:04:17 2012
PSP0 started with pid=3, OS id=1815
Sun Jun 24 01:04:19 2012
VKTM started with pid=4, OS id=1817 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sun Jun 24 01:04:19 2012
GEN0 started with pid=5, OS id=1821
Sun Jun 24 01:04:19 2012
DIAG started with pid=6, OS id=1823
Sun Jun 24 01:04:19 2012
PING started with pid=7, OS id=1825
Sun Jun 24 01:04:19 2012
DIA0 started with pid=8, OS id=1827
Sun Jun 24 01:04:19 2012
LMON started with pid=9, OS id=1829
Sun Jun 24 01:04:19 2012
LMD0 started with pid=10, OS id=1831
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [23040 - 30720]
Sun Jun 24 01:04:19 2012
LMS0 started with pid=11, OS id=1833 at elevated priority
Sun Jun 24 01:04:19 2012
LMHB started with pid=12, OS id=1837
Sun Jun 24 01:04:19 2012
MMAN started with pid=13, OS id=1839
Sun Jun 24 01:04:19 2012
DBW0 started with pid=14, OS id=1841
Sun Jun 24 01:04:19 2012
LGWR started with pid=15, OS id=1843
Sun Jun 24 01:04:19 2012
CKPT started with pid=16, OS id=1845
Sun Jun 24 01:04:19 2012
SMON started with pid=17, OS id=1847
Sun Jun 24 01:04:19 2012
RBAL started with pid=18, OS id=1849
Sun Jun 24 01:04:19 2012
GMON started with pid=19, OS id=1851
Sun Jun 24 01:04:19 2012
MMON started with pid=20, OS id=1853
Sun Jun 24 01:04:19 2012
MMNL started with pid=21, OS id=1855
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 2)
ASM instance
List of instances:
1 (myinst: 1)
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Sun Jun 24 01:04:19 2012
LCK0 started with pid=22, OS id=1857
Sun Jun 24 01:04:20 2012
ORACLE_BASE from environment = /u01/app/grid
Sun Jun 24 01:04:20 2012
SQL> ALTER DISKGROUP ALL MOUNT
Diskgroup used for OCR is:DATA
NOTE: cache registered group DATA number=1 incarn=0x3f2c6009
NOTE: cache began mount (first) of group DATA number=1 incarn=0x3f2c6009
ERROR: no read quorum in group: required 2, found 0 disks
NOTE: cache dismounting (clean) group 1/0x3F2C6009 (DATA)
NOTE: messaging CKPT to quiesce pins Unix process pid: 1869, image: oracle@orclsys1 (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 1/0x3F2C6009 (DATA)
NOTE: cache ending mount (fail) of group DATA number=1 incarn=0x3f2c6009
NOTE: cache deleting context for group DATA 1/0x3f2c6009
GMON dismounting group 1 at 2 for pid 23, osid 1869
ERROR: diskgroup DATA was not mounted
WARNING: Disk Group DATA containing configured OCR is not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
ERROR: ALTER DISKGROUP ALL MOUNT
Sun Jun 24 01:04:20 2012
ALTER SYSTEM SET asm_diskstring='/dev/mapper/*D_*p*' SCOPE=MEMORY SID='*';
Sun Jun 24 01:04:20 2012
NOTE: No asm libraries found in the system
SQL> CREATE DISKGROUP DATA HIGH REDUNDANCY DISK '/dev/mapper/HDD_E0_S17_1135602799p1',
'/dev/mapper/HDD_E1_S19_1135610547p1',
'/dev/mapper/HDD_E0_S05_1135619487p1',
'/dev/mapper/HDD_E0_S16_1135664919p1',
'/dev/mapper/HDD_E1_S18_1135740479p1',
'/dev/mapper/HDD_E1_S14_1135787679p1',
'/dev/mapper/HDD_E0_S08_1135792215p1',
'/dev/mapper/HDD_E1_S15_1135794951p1',
'/dev/mapper/HDD_E1_S07_1135801023p1',
'/dev/mapper/HDD_E0_S09_1135802123p1',
'/dev/mapper/HDD_E0_S13_1135804119p1',
'/dev/mapper/HDD_E1_S11_1135804775p1',
'/dev/mapper/HDD_E1_S06_1135821887p1',
'/dev/mapper/HDD_E0_S12_1135827487p1',
'/dev/mapper/HDD_E1_S10_1135835919p1',
'/dev/mapper/HDD_E1_S03_1137509855p1',
'/dev/mapper/HDD_E0_S00_1137537659p1',
'/dev/mapper/HDD_E1_S02_1137581539p1',
'/dev/mapper/HDD_E0_S01_1137772287p1' ATTRIBUTE 'compatible.asm'='11.2.0.0.0','au_size'='1M' /* ASMCA */
NOTE: Assigning number (1,0) to disk (/dev/mapper/HDD_E0_S17_1135602799p1)
NOTE: Assigning number (1,1) to disk (/dev/mapper/HDD_E1_S19_1135610547p1)
NOTE: Assigning number (1,2) to disk (/dev/mapper/HDD_E0_S05_1135619487p1)
NOTE: Assigning number (1,3) to disk (/dev/mapper/HDD_E0_S16_1135664919p1)
NOTE: Assigning number (1,4) to disk (/dev/mapper/HDD_E1_S18_1135740479p1)
NOTE: Assigning number (1,5) to disk (/dev/mapper/HDD_E1_S14_1135787679p1)
NOTE: Assigning number (1,6) to disk (/dev/mapper/HDD_E0_S08_1135792215p1)
NOTE: Assigning number (1,7) to disk (/dev/mapper/HDD_E1_S15_1135794951p1)
NOTE: Assigning number (1,8) to disk (/dev/mapper/HDD_E1_S07_1135801023p1)
NOTE: Assigning number (1,9) to disk (/dev/mapper/HDD_E0_S09_1135802123p1)
NOTE: Assigning number (1,10) to disk (/dev/mapper/HDD_E0_S13_1135804119p1)
NOTE: Assigning number (1,11) to disk (/dev/mapper/HDD_E1_S11_1135804775p1)
NOTE: Assigning number (1,12) to disk (/dev/mapper/HDD_E1_S06_1135821887p1)
NOTE: Assigning number (1,13) to disk (/dev/mapper/HDD_E0_S12_1135827487p1)
NOTE: Assigning number (1,14) to disk (/dev/mapper/HDD_E1_S10_1135835919p1)
NOTE: Assigning number (1,15) to disk (/dev/mapper/HDD_E1_S03_1137509855p1)
NOTE: Assigning number (1,16) to disk (/dev/mapper/HDD_E0_S00_1137537659p1)
NOTE: Assigning number (1,17) to disk (/dev/mapper/HDD_E1_S02_1137581539p1)
NOTE: Assigning number (1,18) to disk (/dev/mapper/HDD_E0_S01_1137772287p1)
ASM Health Checker found 1 new failures
NOTE: initializing header on grp 1 disk DATA_0000
NOTE: initializing header on grp 1 disk DATA_0001
NOTE: initializing header on grp 1 disk DATA_0002
NOTE: initializing header on grp 1 disk DATA_0003
NOTE: initializing header on grp 1 disk DATA_0004
NOTE: initializing header on grp 1 disk DATA_0005
NOTE: initializing header on grp 1 disk DATA_0006
NOTE: initializing header on grp 1 disk DATA_0007
NOTE: initializing header on grp 1 disk DATA_0008
NOTE: initializing header on grp 1 disk DATA_0009
NOTE: initializing header on grp 1 disk DATA_0010
NOTE: initializing header on grp 1 disk DATA_0011
NOTE: initializing header on grp 1 disk DATA_0012
NOTE: initializing header on grp 1 disk DATA_0013
NOTE: initializing header on grp 1 disk DATA_0014
NOTE: initializing header on grp 1 disk DATA_0015
NOTE: initializing header on grp 1 disk DATA_0016
NOTE: initializing header on grp 1 disk DATA_0017
NOTE: initializing header on grp 1 disk DATA_0018
GMON updating for reconfiguration, group 1 at 3 for pid 23, osid 1902
NOTE: group 1 PST updated.
NOTE: initiating PST update: grp = 1
GMON updating group 1 at 4 for pid 23, osid 1902
NOTE: group DATA: initial PST location: disk 0000 (PST copy 0)
NOTE: group DATA: initial PST location: disk 0001 (PST copy 1)
NOTE: group DATA: initial PST location: disk 0002 (PST copy 2)
NOTE: group DATA: initial PST location: disk 0003 (PST copy 3)
NOTE: group DATA: initial PST location: disk 0004 (PST copy 4)
NOTE: PST update grp = 1 completed successfully
NOTE: cache registered group DATA number=1 incarn=0x416c600e
NOTE: cache began mount (first) of group DATA number=1 incarn=0x416c600e
NOTE: cache opening disk 0 of grp 1: DATA_0000 path:/dev/mapper/HDD_E0_S17_1135602799p1
NOTE: cache opening disk 1 of grp 1: DATA_0001 path:/dev/mapper/HDD_E1_S19_1135610547p1
NOTE: cache opening disk 2 of grp 1: DATA_0002 path:/dev/mapper/HDD_E0_S05_1135619487p1
NOTE: cache opening disk 3 of grp 1: DATA_0003 path:/dev/mapper/HDD_E0_S16_1135664919p1
NOTE: cache opening disk 4 of grp 1: DATA_0004 path:/dev/mapper/HDD_E1_S18_1135740479p1
NOTE: cache opening disk 5 of grp 1: DATA_0005 path:/dev/mapper/HDD_E1_S14_1135787679p1
NOTE: cache opening disk 6 of grp 1: DATA_0006 path:/dev/mapper/HDD_E0_S08_1135792215p1
NOTE: cache opening disk 7 of grp 1: DATA_0007 path:/dev/mapper/HDD_E1_S15_1135794951p1
NOTE: cache opening disk 8 of grp 1: DATA_0008 path:/dev/mapper/HDD_E1_S07_1135801023p1
NOTE: cache opening disk 9 of grp 1: DATA_0009 path:/dev/mapper/HDD_E0_S09_1135802123p1
NOTE: cache opening disk 10 of grp 1: DATA_0010 path:/dev/mapper/HDD_E0_S13_1135804119p1
NOTE: cache opening disk 11 of grp 1: DATA_0011 path:/dev/mapper/HDD_E1_S11_1135804775p1
NOTE: cache opening disk 12 of grp 1: DATA_0012 path:/dev/mapper/HDD_E1_S06_1135821887p1
NOTE: cache opening disk 13 of grp 1: DATA_0013 path:/dev/mapper/HDD_E0_S12_1135827487p1
NOTE: cache opening disk 14 of grp 1: DATA_0014 path:/dev/mapper/HDD_E1_S10_1135835919p1
NOTE: cache opening disk 15 of grp 1: DATA_0015 path:/dev/mapper/HDD_E1_S03_1137509855p1
NOTE: cache opening disk 16 of grp 1: DATA_0016 path:/dev/mapper/HDD_E0_S00_1137537659p1
NOTE: cache opening disk 17 of grp 1: DATA_0017 path:/dev/mapper/HDD_E1_S02_1137581539p1
NOTE: cache opening disk 18 of grp 1: DATA_0018 path:/dev/mapper/HDD_E0_S01_1137772287p1
* allocate domain 1, invalid = TRUE
NOTE: attached to recovery domain 1
NOTE: cache creating group 1/0x416C600E (DATA)
NOTE: cache mounting group 1/0x416C600E (DATA) succeeded
NOTE: allocating F1X0 on grp 1 disk DATA_0000
NOTE: allocating F1X0 on grp 1 disk DATA_0001
NOTE: allocating F1X0 on grp 1 disk DATA_0002
NOTE: Created Used Space Directory for 1 threads
NOTE: diskgroup must now be re-mounted prior to first use
NOTE: cache dismounting (clean) group 1/0x416C600E (DATA)
NOTE: messaging CKPT to quiesce pins Unix process pid: 1902, image: oracle@orclsys1 (TNS V1-V3)
NOTE: lgwr not being msg'd to dismount
freeing rdom 1
NOTE: detached from domain 1
NOTE: cache dismounted group 1/0x416C600E (DATA)
GMON dismounting group 1 at 5 for pid 23, osid 1902
GMON dismounting group 1 at 6 for pid 23, osid 1902
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
SUCCESS: diskgroup DATA was created
NOTE: cache deleting context for group DATA 1/0x416c600e
NOTE: cache registered group DATA number=1 incarn=0x624c6010
NOTE: cache began mount (first) of group DATA number=1 incarn=0x624c6010
NOTE: Assigning number (1,4) to disk (/dev/mapper/HDD_E1_S18_1135740479p1)
NOTE: Assigning number (1,7) to disk (/dev/mapper/HDD_E1_S15_1135794951p1)
NOTE: Assigning number (1,1) to disk (/dev/mapper/HDD_E1_S19_1135610547p1)
NOTE: Assigning number (1,14) to disk (/dev/mapper/HDD_E1_S10_1135835919p1)
NOTE: Assigning number (1,0) to disk (/dev/mapper/HDD_E0_S17_1135602799p1)
NOTE: Assigning number (1,5) to disk (/dev/mapper/HDD_E1_S14_1135787679p1)
NOTE: Assigning number (1,11) to disk (/dev/mapper/HDD_E1_S11_1135804775p1)
NOTE: Assigning number (1,8) to disk (/dev/mapper/HDD_E1_S07_1135801023p1)
NOTE: Assigning number (1,10) to disk (/dev/mapper/HDD_E0_S13_1135804119p1)
NOTE: Assigning number (1,3) to disk (/dev/mapper/HDD_E0_S16_1135664919p1)
NOTE: Assigning number (1,15) to disk (/dev/mapper/HDD_E1_S03_1137509855p1)
NOTE: Assigning number (1,12) to disk (/dev/mapper/HDD_E1_S06_1135821887p1)
NOTE: Assigning number (1,13) to disk (/dev/mapper/HDD_E0_S12_1135827487p1)
NOTE: Assigning number (1,9) to disk (/dev/mapper/HDD_E0_S09_1135802123p1)
NOTE: Assigning number (1,2) to disk (/dev/mapper/HDD_E0_S05_1135619487p1)
NOTE: Assigning number (1,18) to disk (/dev/mapper/HDD_E0_S01_1137772287p1)
NOTE: Assigning number (1,16) to disk (/dev/mapper/HDD_E0_S00_1137537659p1)
NOTE: Assigning number (1,6) to disk (/dev/mapper/HDD_E0_S08_1135792215p1)
NOTE: Assigning number (1,17) to disk (/dev/mapper/HDD_E1_S02_1137581539p1)
Sun Jun 24 01:04:31 2012
NOTE: GMON heartbeating for grp 1
GMON querying group 1 at 9 for pid 23, osid 1902
Sun Jun 24 01:04:31 2012
NOTE: cache opening disk 0 of grp 1: DATA_0000 path:/dev/mapper/HDD_E0_S17_1135602799p1
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache opening disk 1 of grp 1: DATA_0001 path:/dev/mapper/HDD_E1_S19_1135610547p1
NOTE: F1X0 found on disk 1 au 2 fcn 0.0
NOTE: cache opening disk 2 of grp 1: DATA_0002 path:/dev/mapper/HDD_E0_S05_1135619487p1
NOTE: F1X0 found on disk 2 au 2 fcn 0.0
NOTE: cache opening disk 3 of grp 1: DATA_0003 path:/dev/mapper/HDD_E0_S16_1135664919p1
NOTE: cache opening disk 4 of grp 1: DATA_0004 path:/dev/mapper/HDD_E1_S18_1135740479p1
NOTE: cache opening disk 5 of grp 1: DATA_0005 path:/dev/mapper/HDD_E1_S14_1135787679p1
NOTE: cache opening disk 6 of grp 1: DATA_0006 path:/dev/mapper/HDD_E0_S08_1135792215p1
NOTE: cache opening disk 7 of grp 1: DATA_0007 path:/dev/mapper/HDD_E1_S15_1135794951p1
NOTE: cache opening disk 8 of grp 1: DATA_0008 path:/dev/mapper/HDD_E1_S07_1135801023p1
NOTE: cache opening disk 9 of grp 1: DATA_0009 path:/dev/mapper/HDD_E0_S09_1135802123p1
NOTE: cache opening disk 10 of grp 1: DATA_0010 path:/dev/mapper/HDD_E0_S13_1135804119p1
NOTE: cache opening disk 11 of grp 1: DATA_0011 path:/dev/mapper/HDD_E1_S11_1135804775p1
NOTE: cache opening disk 12 of grp 1: DATA_0012 path:/dev/mapper/HDD_E1_S06_1135821887p1
NOTE: cache opening disk 13 of grp 1: DATA_0013 path:/dev/mapper/HDD_E0_S12_1135827487p1
NOTE: cache opening disk 14 of grp 1: DATA_0014 path:/dev/mapper/HDD_E1_S10_1135835919p1
NOTE: cache opening disk 15 of grp 1: DATA_0015 path:/dev/mapper/HDD_E1_S03_1137509855p1
NOTE: cache opening disk 16 of grp 1: DATA_0016 path:/dev/mapper/HDD_E0_S00_1137537659p1
NOTE: cache opening disk 17 of grp 1: DATA_0017 path:/dev/mapper/HDD_E1_S02_1137581539p1
NOTE: cache opening disk 18 of grp 1: DATA_0018 path:/dev/mapper/HDD_E0_S01_1137772287p1
NOTE: cache mounting (first) high redundancy group 1/0x624C6010 (DATA)
Sun Jun 24 01:04:31 2012
* allocate domain 1, invalid = TRUE
Sun Jun 24 01:04:32 2012
NOTE: attached to recovery domain 1
NOTE: cache recovered group 1 to fcn 0.0
NOTE: redo buffer size is 256 blocks (1053184 bytes)
Sun Jun 24 01:04:32 2012
NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DATA)
NOTE: LGWR found thread 1 closed at ABA 0.10750
NOTE: LGWR mounted thread 1 for diskgroup 1 (DATA)
NOTE: LGWR opening thread 1 at fcn 0.0 ABA 2.0
NOTE: setting 11.2 start ABA for group DATA thread 1 to 2.0
NOTE: cache mounting group 1/0x624C6010 (DATA) succeeded
NOTE: cache ending mount (success) of group DATA number=1 incarn=0x624c6010
GMON querying group 1 at 10 for pid 18, osid 1849
Sun Jun 24 01:04:32 2012
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 1
SUCCESS: diskgroup DATA was mounted
SUCCESS: CREATE DISKGROUP DATA HIGH REDUNDANCY DISK '/dev/mapper/HDD_E0_S17_1135602799p1',
'/dev/mapper/HDD_E1_S19_1135610547p1',
'/dev/mapper/HDD_E0_S05_1135619487p1',
'/dev/mapper/HDD_E0_S16_1135664919p1',
'/dev/mapper/HDD_E1_S18_1135740479p1',
'/dev/mapper/HDD_E1_S14_1135787679p1',
'/dev/mapper/HDD_E0_S08_1135792215p1',
'/dev/mapper/HDD_E1_S15_1135794951p1',
'/dev/mapper/HDD_E1_S07_1135801023p1',
'/dev/mapper/HDD_E0_S09_1135802123p1',
'/dev/mapper/HDD_E0_S13_1135804119p1',
'/dev/mapper/HDD_E1_S11_1135804775p1',
'/dev/mapper/HDD_E1_S06_1135821887p1',
'/dev/mapper/HDD_E0_S12_1135827487p1',
'/dev/mapper/HDD_E1_S10_1135835919p1',
'/dev/mapper/HDD_E1_S03_1137509855p1',
'/dev/mapper/HDD_E0_S00_1137537659p1',
'/dev/mapper/HDD_E1_S02_1137581539p1',
'/dev/mapper/HDD_E0_S01_1137772287p1' ATTRIBUTE 'compatible.asm'='11.2.0.0.0','au_size'='1M' /* ASMCA */
Sun Jun 24 01:04:32 2012
WARNING: failed to online diskgroup resource ora.DATA.dg (unable to communicate with CRSD/OHASD)
ERROR: failed to update diskgroup resource ora.DATA.dg
NOTE: Advanced to new COD format for group DATA
NOTE: updated gpnp profile ASM diskstring: /dev/mapper/*D_*p*
NOTE: updated gpnp profile ASM diskstring: /dev/mapper/*D_*p*
NOTE: updated gpnp profile ASM SPFILE to +DATA/orclsys-c/asmparameterfile/registry.253.786762273
Sun Jun 24 01:04:33 2012
NOTE: [ocrconfig.bin@orclsys1 (TNS V1-V3) 2001] opening OCR file
Starting background process ASMB
Sun Jun 24 01:04:33 2012
ASMB started with pid=27, OS id=2007
Sun Jun 24 01:04:33 2012
NOTE: client +ASM1:+ASM registered, osid 2009, mbr 0x0
Sun Jun 24 01:04:36 2012
NOTE: [ocrconfig.bin@orclsys1 (TNS V1-V3) 2001] opening OCR file
Sun Jun 24 01:04:36 2012
NOTE: [ocrconfig.bin@orclsys1 (TNS V1-V3) 2001] opening OCR file
Sun Jun 24 01:04:36 2012
NOTE: [ocrconfig.bin@orclsys1 (TNS V1-V3) 2001] opening OCR file
Sun Jun 24 01:04:36 2012
NOTE: [ocrconfig.bin@orclsys1 (TNS V1-V3) 2001] opening OCR file
Sun Jun 24 01:04:36 2012
NOTE: [ocrconfig.bin@orclsys1 (TNS V1-V3) 2001] opening OCR file
Sun Jun 24 01:04:37 2012
NOTE: [clscfg.bin@orclsys1 (TNS V1-V3) 2038] opening OCR file
Sun Jun 24 01:04:37 2012
NOTE: [clscfg.bin@orclsys1 (TNS V1-V3) 2038] opening OCR file
Sun Jun 24 01:04:38 2012
NOTE: [crsd.bin@orclsys1 (TNS V1-V3) 2049] opening OCR file
Sun Jun 24 01:04:39 2012
NOTE: [crsctl.bin@orclsys1 (TNS V1-V3) 2084] opening OCR file
Sun Jun 24 01:04:39 2012
NOTE: updated gpnp profile ASM diskstring: /dev/mapper/*D_*p*
Sun Jun 24 01:04:39 2012
NOTE: Creating voting files in diskgroup DATA
NOTE: Voting File refresh pending for group 1/0x624c6010 (DATA)
NOTE: Attempting voting file creation in diskgroup DATA
NOTE: voting file allocation on grp 1 disk DATA_0000
NOTE: voting file allocation on grp 1 disk DATA_0001
NOTE: voting file allocation on grp 1 disk DATA_0002
NOTE: voting file allocation on grp 1 disk DATA_0003
NOTE: voting file allocation on grp 1 disk DATA_0004
Sun Jun 24 01:04:43 2012
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Voting file relocation is required in diskgroup DATA
NOTE: Attempting voting file relocation on diskgroup DATA
NOTE: client exited [2049]
Sun Jun 24 01:04:46 2012
NOTE: ASMB process exiting due to lack of ASM file activity for 2 seconds
Sun Jun 24 01:04:46 2012
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 6
SQL> ALTER DISKGROUP ALL DISMOUNT /* asm agent *//* {0:0:83} */
NOTE: cache dismounting (clean) group 1/0x624C6010 (DATA)
NOTE: messaging CKPT to quiesce pins Unix process pid: 1947, image: oracle@orclsys1 (TNS V1-V3)
Sun Jun 24 01:04:48 2012
NOTE: LGWR doing clean dismount of group 1 (DATA)
NOTE: LGWR closing thread 1 of diskgroup 1 (DATA) at ABA 2.51
NOTE: LGWR released thread recovery enqueue
Sun Jun 24 01:04:48 2012
freeing rdom 1
Sun Jun 24 01:04:48 2012
NOTE: detached from domain 1
NOTE: cache dismounted group 1/0x624C6010 (DATA)
Sun Jun 24 01:04:48 2012
GMON dismounting group 1 at 11 for pid 24, osid 1947
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
NOTE: Disk in mode 0x8 marked for de-assignment
SUCCESS: diskgroup DATA was dismounted
NOTE: cache deleting context for group DATA 1/0x624c6010
SUCCESS: ALTER DISKGROUP ALL DISMOUNT /* asm agent *//* {0:0:83} */
Sun Jun 24 01:04:49 2012
Stopping background process VKTM
Sun Jun 24 01:04:51 2012
freeing rdom 0
Sun Jun 24 01:04:54 2012
Instance shutdown complete
Sun Jun 24 01:08:26 2012
NOTE: No asm libraries found in the system
MEMORY_TARGET defaulting to 369098752.
* instance_number obtained from CSS = 1, checking for the existence of node 0...
* node 0 does not exist. instance_number = 1
 
Basic Access Information
Default Password: Grid welcome1
Default Password: oracle welcome1
Default Password: sys welcome1
Default Password: system welcome1
ILOM Password changeme
Node 1 IP Addresses as set up for testing ILOM 192.0.2.17 - Public 192.168.2.100
Node 2 IP Addresses as set up for testing ILOM 192.0.2.18 - Public 192.168.2.101
SCAN IP Address and Port 192.0.2.16 and 1521
OEM Grid Control URL https://<hostname>:1158/em
 
Directory Structure
ADR Base /u01/app/
Grid Base /u01/app/grid
Grid Home /u01/app/11.2.0.3/grid
IPMI Tool /root/Extras/ipmitool-1.8.10.4-4.e15..x86_64.rpm
OAKCLI Commands /opt/oracle/oak/bin
OAKCLI Logs /opt/oracle/oak/log
Oracle Base /u01/app/oracle
Oracle Home /u01/app/oracle/product/11.2.0/db_home1
Oracle Inventory /u01/app/oraInventory
OS Watcher /opt/oracle/oak/osw/
 
Environment Variables
ADR_BASE Not set by installation
ORACLE_BASE Not set by installation
ORACLE_HOME export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
ORACLE_SID Not set by installation ... must be manually set
ORACLE_UNQNAME Required by OEM Grid Control but not set in the environment so emctl will not start by default. Set it in .bashrc
LD_LIBRARY_PATH Not set by installation
 
Exceptions
Exceptions collected here are exceptions I have encountered that appear to be ODA specific
Error Code Reason
dcodarac03at-ilom:Log:ActDir:critical If you see "ActDir" this is a reference to Microsoft Active Directory. The one time I saw this it was caused by a System Administrator misconfiguration as the client did not have A/D on-site.
 
Feature Usage Report
Default Installation Feature Usage Report SQL> SELECT output FROM TABLE(dbms_feature_usage_report.display_text);

OUTPUT
------------------------------------------------------------------------------------------------
DB FEATURE USAGE report for

DB Name      DB Id       Release     Total Samples Last Sample Time
------------ ----------- ----------- ------------- ------------------
ORCL         1314544628  11.2.0.3.0              1 24-Jun-12 02:40:25

        -------------------------------------------------------------
DB Feature Usage Summary DB/Release: ORCL/11.2.0.3.0
-> This section displays the summary of Usage for Database Features.
-> The Currently Used column is TRUE if usage was detected for
-> the feature at the last sample time.

                                          Curr-
                                          ently Detected    Total Last Usage
Feature Name                              Used  Usages    Samples    Time
----------------------------------------- ----- -------- -------- --------------
Audit Options                             TRUE         1        1 06/24/12 02:40
Automatic Maintenance - Optimizer Statist TRUE         1        1 06/24/12 02:40
Automatic Maintenance - SQL Tuning Adviso TRUE         1        1 06/24/12 02:40
Automatic Maintenance - Space Advisor     TRUE         1        1 06/24/12 02:40
Automatic SGA Tuning                      TRUE         1        1 06/24/12 02:40
Automatic SQL Execution Memory            TRUE         1        1 06/24/12 02:40
Automatic Segment Space Management (syste TRUE         1        1 06/24/12 02:40
Automatic Storage Management (user)       TRUE         1        1 06/24/12 02:40
Automatic Undo Management                 TRUE         1        1 06/24/12 02:40
Character Set                             TRUE         1        1 06/24/12 02:40
Deferred Segment Creation                 TRUE         1        1 06/24/12 02:40
Locally Managed Tablespaces (system)      TRUE         1        1 06/24/12 02:40
Locally Managed Tablespaces (user)        TRUE         1        1 06/24/12 02:40
MTTR Advisor                              TRUE         1        1 06/24/12 02:40
Parallel SQL Query Execution              TRUE         1        1 06/24/12 02:40
Partitioning (system)                     TRUE         1        1 06/24/12 02:40
Real Application Clusters (RAC)           TRUE         1        1 06/24/12 02:40
Recovery Area                             TRUE         1        1 06/24/12 02:40
Server Parameter File                     TRUE         1        1 06/24/12 02:40
ADDM                                      FALSE        0        1
ASO native encryption and checksumming    FALSE        0        1
AWR Baseline                              FALSE        0        1
AWR Baseline Template                     FALSE        0        1
AWR Report                                FALSE        0        1
Active Data Guard - Real-Time Query on Ph FALSE        0        1
Advanced Replication                      FALSE        0        1
Application Express                       FALSE        0        1
Automatic Memory Tuning                   FALSE        0        1
Automatic SQL Tuning Advisor              FALSE        0        1
Automatic Segment Space Management (user) FALSE        0        1
Automatic Workload Repository             FALSE        0        1
Backup BASIC Compression                  FALSE        0        1
Backup BZIP2 Compression                  FALSE        0        1
Backup Encryption                         FALSE        0        1
Backup HIGH Compression                   FALSE        0        1
Backup LOW Compression                    FALSE        0        1
Backup MEDIUM Compression                 FALSE        0        1
Backup Rollforward                        FALSE        0        1
Backup ZLIB Compression                   FALSE        0        1
Baseline Adaptive Thresholds              FALSE        0        1
Baseline Static Computations              FALSE        0        1
Bigfile Tablespace                        FALSE        0        1
Block Media Recovery                      FALSE        0        1
CSSCAN                                    FALSE        0        1
Change Data Capture                       FALSE        0        1
Change-Aware Incremental Backup           FALSE        0        1
Character Semantics                       FALSE        0        1
Client Identifier                         FALSE        0        1
Clusterwide Global Transactions           FALSE        0        1
Compression Advisor                       FALSE        0        1
Crossedition Triggers                     FALSE        0        1
DBMS_STATS Incremental Maintenance        FALSE        0        1
Data Guard                                FALSE        0        1
Data Mining                               FALSE        0        1
Data Recovery Advisor                     FALSE        0        1
Database Migration Assistant for Unicode  FALSE        0        1
Database Replay: Workload Capture         FALSE        0        1
Database Replay: Workload Replay          FALSE        0        1
Deferred Open Read Only                   FALSE        0        1
Direct NFS                                FALSE        0        1
Dynamic SGA                               FALSE        0        1
EM Database Control                       FALSE        0        1
EM Grid Control                           FALSE        0        1
EM Performance Page                       FALSE        0        1
Editioning Views                          FALSE        0        1
Editions                                  FALSE        0        1
Encrypted Tablespaces                     FALSE        0        1
Exadata                                   FALSE        0        1
Extensibility                             FALSE        0        1
File Mapping                              FALSE        0        1
Flashback Data Archive                    FALSE        0        1
Flashback Database                        FALSE        0        1
GoldenGate                                FALSE        0        1
HeapCompression                           FALSE        0        1
Hybrid Columnar Compression               FALSE        0        1
Instance Caging                           FALSE        0        1
Internode Parallel Execution              FALSE        0        1
Job Scheduler                             FALSE        0        1
LOB                                       FALSE        0        1
Label Security                            FALSE        0        1
Locator                                   FALSE        0        1
Logfile Multiplexing                      FALSE        0        1
Long-term Archival Backup                 FALSE        0        1
Materialized Views (User)                 FALSE        0        1
Messaging Gateway                         FALSE        0        1
Multi Section Backup                      FALSE        0        1
Multiple Block Sizes                      FALSE        0        1
OLAP - Analytic Workspaces                FALSE        0        1
OLAP - Cubes                              FALSE        0        1
Object                                    FALSE        0        1
Oracle Database Vault                     FALSE        0        1
Oracle Java Virtual Machine (system)      FALSE        0        1
Oracle Java Virtual Machine (user)        FALSE        0        1
Oracle Managed Files                      FALSE        0        1
Oracle Multimedia                         FALSE        0        1
Oracle Multimedia DICOM                   FALSE        0        1
Oracle Secure Backup                      FALSE        0        1
Oracle Text                               FALSE        0        1
Oracle Utility Datapump (Export)          FALSE        0        1
Oracle Utility Datapump (Import)          FALSE        0        1
Oracle Utility External Table             FALSE        0        1
Oracle Utility Metadata API               FALSE        0        1
Oracle Utility SQL Loader (Direct Path Lo FALSE        0        1
PL/SQL Native Compilation                 FALSE        0        1
Parallel SQL DDL Execution                FALSE        0        1
Parallel SQL DML Execution                FALSE        0        1
Partitioning (user)                       FALSE        0        1
Pillar Storage                            FALSE        0        1
Pillar Storage with EHCC                  FALSE        0        1
Quality of Service Management             FALSE        0        1
RMAN - Disk Backup                        FALSE        0        1
RMAN - Tape Backup                        FALSE        0        1
Read Only Tablespace                      FALSE        0        1
Real-Time SQL Monitoring                  FALSE        0        1
Recovery Manager (RMAN)                   FALSE        0        1
Resource Manager                          FALSE        0        1
Restore Point                             FALSE        0        1
Result Cache                              FALSE        0        1
Rules Manager                             FALSE        0        1
SQL Access Advisor                        FALSE        0        1
SQL Monitoring and Tuning pages           FALSE        0        1
SQL Performance Analyzer                  FALSE        0        1
SQL Plan Management                       FALSE        0        1
SQL Profile                               FALSE        0        1
SQL Repair Advisor                        FALSE        0        1
SQL Tuning Advisor                        FALSE        0        1
SQL Tuning Set (system)                   FALSE        0        1
SQL Tuning Set (user)                     FALSE        0        1
SQL Workload Manager                      FALSE        0        1
SecureFile Compression (system)           FALSE        0        1
SecureFile Compression (user)             FALSE        0        1
SecureFile Deduplication (system)         FALSE        0        1
SecureFile Deduplication (user)           FALSE        0        1
SecureFile Encryption (system)            FALSE        0        1
SecureFile Encryption (user)              FALSE        0        1
SecureFiles (system)                      FALSE        0        1
SecureFiles (user)                        FALSE        0        1
Segment Advisor (user)                    FALSE        0        1
Segment Shrink                            FALSE        0        1
Semantics/RDF                             FALSE        0        1
Server Flash Cache                        FALSE        0        1
Services                                  FALSE        0        1
Shared Server                             FALSE        0        1
Spatial                                   FALSE        0        1
Streams (system)                          FALSE        0        1
Streams (user)                            FALSE        0        1
Sun ZFS with EHCC                         FALSE        0        1
Transparent Data Encryption               FALSE        0        1
Transparent Gateway                       FALSE        0        1
Transportable Tablespace                  FALSE        0        1
Tune MView                                FALSE        0        1
Undo Advisor                              FALSE        0        1
Very Large Memory                         FALSE        0        1
Virtual Private Database (VPD)            FALSE        0        1
Workspace Manager                         FALSE        0        1
XDB                                       FALSE        0        1
XStream In                                FALSE        0        1
XStream Out                               FALSE        0        1
XStream Streams                           FALSE        0        1
ZFS Storage                               FALSE        0        1

-------------------------------------------------------------

High Water Mark Statistics DB/Release: ORCL/11.2.0.3.0
-> This section displays the Database High Water Mark Statistics

Name                                                            High Water Mark
----------------------------------------------------------- -------------------
Maximum Number of Active Sessions seen in the system                          0
Maximum Number of CPUs                                                       16
Maximum Number of Concurrent Sessions seen in the database                   18
Maximum Number of Datafiles                                                   5
Maximum Number of Materialized Views (User)                                   1
Maximum Number of Partitions belonging to an User Index                       0
Maximum Number of Partitions belonging to an User Table                       0
Maximum Number of SQL NCHAR Columns                                          28
Maximum Number of Tablespaces                                                 6
Maximum Query Length                                                        937
Maximum Size of the Database (Bytes)                              1,787,822,080
Number of User Indexes                                                    1,117
Number of User Tables                                                       804
Number of physical disks                                                    N/A
Oracle Database instances                                                     2
Size of Largest Segment (Bytes)                                      48,234,496
number of job runs per day                                                    4
-------------------------------------------------------------

CPU Usage Statistics DB/Release: ORCL/11.2.0.3.0
-> This section displays the Database CPU Usage Statistics

                               CPU Core CPU Socket
Timestamp          CPU Count      Count      Count
----------------- ---------- ---------- ----------
06/24/12 02:40            16         24          4
-------------------------------------------------------------

End of Report
 
Memory Management
ASM Instance

Uses 11g Automatic Memory Management (AMM)
sga_target  is non-zero, statistics_level is set to TYPICAL or ALL, and shared_pool_size is non-zero
-- run in ASM instance
col component format a25
col parameter format a30

SELECT component, current_size, min_size, max_size
FROM v$memory_dynamic_components
ORDER BY 1;

SELECT component, oper_type, parameter, initial_size, target_size, final_size, status
FROM v$memory_resize_ops;
Database Instance

Uses 10gR2 Automatic Shared Memory Mangement (ASMM)
memory_target and memory_max_target initialization parameters are both set to 0 on an ODA
-- run in Database instance
col component format a25

SELECT component, oper_type,
       initial_size/1024/1024 "Initial",
       target_size/1024/1024 "Target",
       final_size/1024/1024 "Final",
       status
FROM v$sga_resize_ops;

SELECT component,
       current_size/1024/1024 "CURRENT_SIZE",
       min_size/1024/1024 "MIN_SIZE",
       user_specified_size/1024/1024 "USER_SPECIFIED_SIZE",
       last_oper_type
FROM v$sga_dynamic_components;
 
Operating System Configuration Files
/etc/cron list cd /etc
[root@orclsys1 etc]# ls -al cron*

-rw-r--r-- 1 root root   0 Jun 7 08:13 cron.deny
-rw-r--r-- 1 root root 255 Jun 5  2007 crontab

cron.d:
total 32
drwx------  2 root root  4096 Jun  7 08:13 .
drwxr-xr-x 94 root root 12288 Jun 30 20:13
..
-rw-r--r--  1 root root   192 Jul 22  2011 sysstat

cron.daily:
total 84
drwxr-xr-x  2 root root  4096 Jun  7 08:14
.
drwxr-xr-x 94 root root 12288 Jun 30 20:13
..
-rwxr-xr-x  1 root root   379 Dec 30  2008
0anacron
lrwxrwxrwx  1 root root    39 Jun  7 08:13
0logwatch -> /usr/share/logwatch/scripts/logwatch.pl
-rwxr-xr-x  1 root root   180 Jul 22  2011
logrotate
-rwxr-xr-x  1 root root   418 Jun  2  2011
makewhatis.cron
-rwxr-xr-x  1 root root   137 Jul  2  2009
mlocate.cron
-rwxr-xr-x  1 root root  2181 Oct 31  2008
prelink
-rwxr-xr-x  1 root root   296 Feb 23 10:33
rpm
-rwxr-xr-x  1 root root   354 Nov 15  2010
tmpwatch

cron.hourly:
total 32
drwxr-xr-x  2 root root  4096 Jun  5  2007
.
drwxr-xr-x 94 root root 12288 Jun 30 20:13
..
-rwxr-xr-x  1 root root   390 May 18  2011
mcelog.cron

cron.monthly:
total 32
drwxr-xr-x  2 root root  4096 Jun  7 08:12
.
drwxr-xr-x 94 root root 12288 Jun 30 20:13
..
-rwxr-xr-x  1 root root   381 Dec 30  2008
0anacron

cron.weekly:
total 48
drwxr-xr-x  2 root root  4096 Jun  7 08:14
.
drwxr-xr-x 94 root root 12288 Jun 30 20:13
..
-rwxr-xr-x  1 root root   380 Dec 30  2008
0anacron
-rwxr-xr-x  1 root root  2812 Jan 28 10:10
99-raid-check
-rwxr-xr-x 1  root root   414 Jun  2  2011
makewhatis.cron
Disk Space [root@orclsys1 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroupSys-LogVolRoot
                       30G  2.7G   25G  10% /
/dev/md0               99M   37M   58M  39% /boot
/dev/mapper/VolGroupSys-LogVolOpt
                       59G  4.6G   51G   9% /opt
/dev/mapper/VolGroupSys-LogVolU01
                       97G   11G   82G  12% /u01
tmpfs                  48G  610M   47G   2% /dev/shm
/etc/fstab /dev/VolGroupSys/LogVolRoot /         ext3    defaults        1 1
/dev/md0                    /boot     ext3    defaults        1 2
/dev/VolGroupSys/LogVolOpt  /opt      ext3    defaults        1 2
/dev/VolGroupSys/LogVolU01  /u01      ext3    defaults        1 2
tmpfs                       /dev/shm  tmpfs   defaults        0 0
devpts                      /dev/pts  devpts  gid=5,mode=620  0 0
sysfs                       /sys      sysfs   defaults        0 0
proc                        /proc     proc    defaults        0 0
/dev/VolGroupSys/LogVolSwap swap      swap    defaults        0 0
/etc/group root:x:0:root
bin:x:1:root,bin,daemon
daemon:x:2:root,bin,daemon
sys:x:3:root,bin,adm
adm:x:4:root,adm,daemon
tty:x:5:
disk:x:6:root
lp:x:7:daemon,lp
mem:x:8:
kmem:x:9:
wheel:x:10:root
mail:x:12:mail
news:x:13:news
uucp:x:14:uucp
man:x:15:
games:x:20:
gopher:x:30:
dip:x:40:
ftp:x:50:
lock:x:54:
nobody:x:99:
users:x:100:
utmp:x:22:
utempter:x:35:
nscd:x:28:
floppy:x:19:
vcsa:x:69:
ntp:x:38:
pcap:x:77:
slocate:x:21:
dbus:x:81:
audio:x:63:gdm
rpc:x:32:
avahi:x:70:
mailnull:x:47:
smmsp:x:51:
sshd:x:74:
oprofile:x:16:
xfs:x:43:
haldaemon:x:68:
avahi-autoipd:x:101:
rpcuser:x:29:
nfsnobody:x:65534:
gdm:x:42:
oinstall:x:1001:grid,oracle
dba:x:1002:oracle
racoper:x:1003:grid,oracle
asmdba:x:1004:grid,oracle
asmoper:x:1005:grid
asmadmin:x:1006:grid
/etc/hosts # Do not remove the following line, or various programs
# that require network functionality will fail.
::1 localhost6.localdomain6 localhost6

192.168.17.24 orclsys1-priv1.example.com orclsys1-priv1
192.168.17.25 orclsys2-priv1.example.com orclsys2-priv1

#SCAN IP
192.0.2.16 orclsys-scan.example.com orclsys-scan

192.168.17.24 orclsys1-priv1.example.com orclsys1-priv1
192.168.17.25 orclsys2-priv1.example.com orclsys2-priv1

#SCAN IP
192.0.2.22 orclsys-scan.example.com orclsys-scan

192.168.17.24 orclsys1-priv1.example.com orclsys1-priv1
192.168.17.25 orclsys2-priv1.example.com orclsys2-priv1

#SCAN IP
192.0.2.22 orclsys-scan.example.com orclsys-scan

# Following added by OneCommand
127.0.0.1 localhost.localdomain localhost

# PUBLIC HOSTNAMES

# PRIVATE HOSTNAMES
192.168.16.24 orclsys1-priv0.example.com orclsys1-priv0
192.168.16.25 orclsys2-priv0.example.com orclsys2-priv0
192.168.17.24 orclsys1-priv1.example.com orclsys1-priv1
192.168.17.25 orclsys2-priv1.example.com orclsys2-priv1

# VIP HOSTNAMES
192.0.2.20 orclsys1-vip.example.com orclsys1-vip
192.0.2.21 orclsys2-vip.example.com orclsys2-vip

# NET(0-3) HOSTNAMES
192.0.2.18 orclsys1.example.com orclsys1
192.0.2.19 orclsys2.example.com orclsys2

#SCAN IP
192.0.2.22 orclsys-scan.example.com orclsys-scan
/etc/inittab #
# inittab   This file describes how the INIT process should set up
#           the system in a certain run-level.
#
# Author:   Miquel van Smoorenburg, <miquels@drinkel.nl.mugnet.org>
#           Modified for RHS Linux by Marc Ewing and Donnie Barnes
#

# Default runlevel. The runlevels used by RHS are:
#   0 - halt (Do NOT set initdefault to this)
#   1 - Single user mode
#   2 - Multiuser, without NFS (The same as 3, if you do not have networking)
#   3 - Full multiuser mode
#   4 - unused
#   5 - X11
#   6 - reboot (Do NOT set initdefault to this)
#
id:3:initdefault:

# System initialization.
si::sysinit:/etc/rc.d/rc.sysinit

l0:0:wait:/etc/rc.d/rc 0
l1:1:wait:/etc/rc.d/rc 1
l2:2:wait:/etc/rc.d/rc 2
l3:3:wait:/etc/rc.d/rc 3
l4:4:wait:/etc/rc.d/rc 4
l5:5:wait:/etc/rc.d/rc 5
l6:6:wait:/etc/rc.d/rc 6

# Trap CTRL-ALT-DELETE
ca::ctrlaltdel:/sbin/shutdown -t3 -r now

# When our UPS tells us power has failed, assume we have a few minutes
# of power left. Schedule a shutdown for 2 minutes from now.
# This does, of course, assume you have powerd installed and your
# UPS connected and working correctly.
pf::powerfail:/sbin/shutdown -f -h +2 "Power Failure; System Shutting Down"

# If power was restored before the shutdown kicked in, cancel it.
pr:12345:powerokwait:/sbin/shutdown -c "Power Restored; Shutdown Cancelled"

# Run gettys in standard runlevels
1:2345:respawn:/sbin/mingetty tty1
2:2345:respawn:/sbin/mingetty tty2
3:2345:respawn:/sbin/mingetty tty3
4:2345:respawn:/sbin/mingetty tty4
5:2345:respawn:/sbin/mingetty tty5
6:2345:respawn:/sbin/mingetty tty6

# Run xdm in runlevel 5
x:5:respawn:/etc/X11/prefdm -nodaemon
h3:35:respawn:/etc/init.d/init.oak run >/dev/null 2>&1 </dev/null
co:2345:respawn:/sbin/agetty -L 9600 ttyS0

h1:35:respawn:/etc/init.d/init.ohasd run >/dev/null 2>&1 </dev/null
iostat Linux 2.6.32-300.11.1.el5uek (orclsys1) 06/30/2012

avg-cpu: %user %nice %system %iowait %steal %idle
          1.14  0.00    3.66    2.03   0.00 93.17

Device:         tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
sda           24.25      2804.43       392.79    2706663     379096
sda1           0.82       238.20         0.09     229895         88
sda2          22.76      2565.09       392.70    2475667     379008
sdb           23.08      2752.33       392.79    2656383     379096
sdb1           0.14         4.06         0.09       3922         88
sdb2          22.27      2747.12       392.70    2651360     379008
sdh            4.89      1770.19        94.99    1708481      91680
sdh1           4.35      1761.59        94.98    1700185      91672
sdj            6.05      1782.15       111.44    1720026     107552
sdj1           5.50      1773.54       111.43    1711714     107544
sdt            6.33      1803.56       111.34    1740684     107456
sdt1           5.78      1794.96       111.33    1732388     107448
sdv            5.12      1734.95        94.40    1674473      91112
sdv1           4.57      1726.36        94.39    1666177      91104
sdc           11.94      4327.79        41.07    4176923      39640
sdc1           8.94      2941.58        29.36    2839035      28340
sdc2           1.84      1372.35        11.65    1324513      11242
sde            6.65      4214.99        34.63    4068059      33424
sde1           4.33      2886.46        34.12    2785840      32928
sde2           1.37      1308.36         0.51    1262754        496
sdf            8.32      4320.18        26.67    4169579      25736
sdf1           6.04      2978.94        26.65    2875096      25720
sdf2           1.32      1321.07         0.02    1275018         16
sdi            6.40      4343.37        34.18    4191960      32987
sdi1           4.10      2980.89        33.67    2876981      32496
sdi2           0.04         1.22         0.51       1178        491
sdaf           0.54         5.16         0.00       4978          0
sdaf1          0.02         1.10         0.00       1062          0
sdg            6.81      4343.89        37.34    4192461      36035
sdg1           3.03      1487.54        28.26    1435682      27272
sdg2           0.06         1.23         9.08       1186       8763
sdk            6.49      4318.44        34.58    4167902      33374
sdk1           2.73      1487.56        25.97    1435707      25064
sdk2           0.06         1.22         8.61       1178       8310
sdl            7.08      4235.36        52.80    4087711      50956
sdl1           3.36      1438.42        44.27 1   388281      42728
sdl2           0.05         1.22         8.53       1179       8228
sdah           0.54         5.16         0.00       4978          0
sdah1          0.02         1.10         0.00       1062          0
sdm           11.80      4305.16        31.72    4155083      30615
sdm1           9.03      2953.16        21.22    2850215      20479
sdm2           1.61      1338.16        10.44    1291514      10074
sdn           14.68      4374.07        47.07    4221593      45425
sdn1          11.99      3039.12        36.95    2933177      35664
sdn2           1.53      1321.11        10.04    1275058       9692
sdo           11.31      4384.07        17.10    4231242      16502
sdo1           8.62      3036.41        15.57    2930558      15032
sdo2           1.51      1325.33         1.43    1279130       1384
sdq            7.19      4269.48        49.84    4120645      48104
sdq1           4.85      2928.22        40.89    2826138      39464
sdq2           1.39      1329.57         8.94    1283226       8624
sdr            6.15      4260.42        24.48    4111902      23627
sdr1           3.79      2910.42        19.08    2808963      18416
sdr2           1.41      1338.31         5.38    1291658       5195
sds            6.37      4313.74        26.09    4163364      25180
sds1           4.05      2955.49        17.51    2852457      16896
sds2           1.37      1346.55         8.57    1299610       8268
sdy           11.43      4437.01        37.33    4282338      36031
sdy1           8.70      3055.36        35.81    2948852      34557
sdy2           1.55      1367.78         1.45    1320098       1396
sdw            6.17      4317.32        26.22    4166823      25303
sdw1           3.79      2948.51        20.44    2845729      19728
sdw2           1.43      1357.12         5.76    1309813       5559
sdai           0.95         9.00         0.00       8687          0
sdai1          0.02         1.11         0.00       1072          0
sdai2          0.03         1.12         0.00       1082          0
sdab           9.26      4459.92        57.18    4304444      55187
sdab1          6.91      3071.94        43.36    2964849      41848
sdab2          1.39      1376.25        13.79    1328274      13307
sdz            6.63      4342.49        29.15    4191107      28135
sdz1           4.30      2979.95        28.61    2876072      27616
sdz2           1.39      1350.84         0.50    1303746        487
sdae           0.95         9.00         0.00       8687          0
sdae1          0.02         1.11         0.00       1072          0
sdae2          0.03         1.12         0.00       1082          0
sdad           0.94         9.00         0.00       8687          0
sdad1          0.02         1.11         0.00       1072          0
sdad2          0.03         1.12         0.00       1082          0
sdao           0.95         9.00         0.00       8687          0
sdao1          0.02         1.11         0.00       1072          0
sdao2          0.03         1.12         0.00       1082          0
sdaj           7.36      4255.53        15.71    4107179      15164
sdaj1          4.72      2988.03        14.07    2883864      13584
sdaj2          1.68      1255.78         1.60    1212002       1548
sdap           0.94         9.00         0.00       8687          0
sdap1          0.02         1.11         0.00       1072          0
sdap2          0.03         1.12         0.00       1082          0
sdu            6.84      4373.03        40.50    4220590      39088
sdu1           4.38      3006.32        39.27    2901515      37904
sdu2           1.50      1355.01         1.19    1307778       1152
sdac           0.94         9.00         0.00       8687          0
sdac1          0.02         1.11         0.00       1072          0
sdac2          0.03         1.12         0.00       1082          0
sdp            0.94         8.98         0.00       8671          0
sdp1           0.02         1.11         0.00       1072          0
sdp2           0.03         1.12         0.00       1082          0
sdal           0.94         9.00         0.00       8687          0
sdal1          0.02         1.11         0.00       1072          0
sdal2          0.03         1.12         0.00       1082          0
sdx            0.94         8.98         0.00       8663          0
sdx1           0.02         1.11         0.00       1072          0
sdx2           0.03         1.12         0.00       1082          0
sdag           0.94         8.99         0.00       8679          0
sdag1          0.02         1.11         0.00       1072          0
sdag2          0.03         1.12         0.00       1082          0
sdar           0.53         5.16         0.00       4976          0
sdar1          0.02         1.10         0.00       1060          0
sdat           0.54         5.16         0.00       4976          0
sdat1          0.02         1.10         0.00       1060          0
sdaa           0.94         9.00         0.00       8687          0
sdaa1          0.02         1.11         0.00       1072          0
sdaa2          0.03         1.12         0.00       1082          0
sdak           0.94         9.00         0.00       8687          0
sdak1          0.02         1.11         0.00       1072          0
sdak2          0.03         1.12         0.00       1082          0
sdam           0.94         9.00         0.00       8687          0
sdam1          0.02         1.11         0.00       1072          0
sdam2          0.03         1.12         0.00       1082          0
sdas           0.95         8.99         0.00       8679          0
sdas1          0.02         1.11         0.00       1072          0
sdas2          0.03         1.12         0.00       1082          0
sdaw           0.95         9.00         0.00       8687          0
sdaw1          0.02         1.11         0.00       1072          0
sdaw2          0.03         1.12         0.00       1082          0
sdax           0.95         9.00         0.00       8687          0
sdax1          0.02         1.11         0.00       1072          0
sdax2          0.03         1.12         0.00       1082          0
sdav           0.94         8.99         0.00       8679          0
sdav1          0.02         1.11         0.00       1072          0
sdav2          0.03         1.12         0.00       1082          0
sday           0.66        47.32         0.00      45673          0
sday1          0.21        44.50         0.00      42946          0
sdau           2.01      1468.91         0.00    1417703          0
sdau1          1.09      1456.78         0.00    1406000          0
sdau2          0.03         1.12         0.00       1082          0
sdaq           1.86      1260.96         0.00    1216999          0
sdaq1          0.94      1248.83         0.00    1205296          0
sdaq2          0.03         1.12         0.00       1082          0
md1           90.02      5311.48       386.07    5126325     372616
md0            1.80       241.55         0.02     233131         24
dm-0          17.46      1290.42        37.94    1245434      36616
dm-1          13.13       772.77        72.42     745834      69896
dm-2          53.46      1963.99       275.72    1895522     266104
dm-3           2.27       502.31         0.00     484800          0
dm-4           4.36      1765.05        94.99    1703519      91680
dm-5           5.52      1777.01       111.44    1715064     107552
dm-6           5.80      1798.41       111.34    1735722     107456
dm-7           4.58      1729.81        94.40    1669511      91112
dm-8          10.99      4318.81        41.07    4168252      39640
dm-9           5.71      4206.02        34.63    4059396      33424
dm-10          7.38      4311.20        26.67    4160916      25736
dm-11          5.46      4334.39        34.18    4183297      32987
dm-12          5.87      4334.91        37.34    4183798      36035
dm-13          5.55      4309.47        34.58    4159239      33374
dm-14          6.13      4226.38        52.80    4079048      50956
dm-15         10.86      4296.18        31.72    4146412      30615
dm-16         13.74      4365.09        47.07    4212922      45425
dm-17         10.36      4375.09        17.10    4222571      16502
dm-18          6.25      4260.50        49.84    4111982      48104
dm-19          5.21      4251.44        24.48    4103239      23627
dm-20          5.43      4304.77        26.09    4154701      25180
dm-21         10.48      4428.03        37.33    4273667      36031
dm-22          5.22      4308.35        26.22    4158160      25303
dm-23          8.31      4450.91        57.18    4295749      55187
dm-24          5.69      4333.51        29.15    4182444      28135
dm-25          6.41      4246.53        15.71    4098492      15164
dm-26          5.89      4364.06        40.50    4211927      39088
dm-27          3.59      1488.74        40.91    1436844      39480
dm-28          7.99      1520.07        21.27    1467082      20533
dm-29         10.87      1593.30        37.02    1537760      35725
dm-30          7.54      1552.40        15.66    1498281      15110
dm-31          2.54      1462.46        19.10    1411477      18432
dm-32          1.76      1324.45         1.44    1278282       1392
dm-33          1.78      1320.23        10.05    1274210       9700
dm-34          1.86      1337.28        10.45    1290666      10082
dm-35          1.65      1328.70         8.94    1282378       8624
dm-36          1.66      1337.43         5.38    1290810       5195
dm-37          2.65      1494.81        17.52    1442699      16912
dm-38          1.62      1345.67         8.57    1298762       8268
dm-39          7.48      1558.64        35.88    1504305      34627
dm-40          1.81      1366.91         1.45    1319258       1404
dm-41          2.48      1487.82        20.46    1435955      19744
dm-42          1.68      1356.24         5.76    1308965       5559
dm-43          5.62      1590.02        43.38    1534595      41864
dm-44          1.65      1375.38        13.80    1327434      13323
dm-45          3.09      1506.53        28.63    1454010      27632
dm-46          1.64      1349.97         0.52    1302906        503
dm-47          3.16      1524.41        39.29    1471269      37920
dm-48          1.76      1354.14         1.21    1306938       1168
dm-49          4.79      1543.70        26.65    1489890      25720
dm-50          1.57      1320.19         0.02    1274170         16
dm-51          3.37      1510.36        14.09    1457706      13600
dm-52          1.94      1254.91         1.62    1211162       1564
dm-53          3.70       971.37        94.99     937509      91680
dm-54          4.86       983.33       111.44     949054     107552
dm-55          5.14      1004.74       111.34     969712     107456
dm-56          3.93       936.13        94.40     903501      91112
dm-57          8.11      1495.76        29.42    1443619      28390
dm-58          2.10      1371.49        11.66    1323681      11250
dm-59          3.08      1463.96        34.12    1412922      32928
dm-60          1.63      1307.48         0.51    1261906        496
dm-61          2.95      1503.22        33.67    1450815      32496
dm-62          1.61      1349.92         0.51    1302858        491
dm-63          3.24      1507.97        28.26    1455404      27272
dm-64          1.64      1362.66         9.08    1315154       8763
dm-65          2.90      1482.53        25.97    1430853      25064
dm-66          1.64      1354.16         8.61    1306954       8310
dm-67          3.42      1458.86        44.27    1408003      42728
dm-68          1.62      1345.68         8.53    1298765       8228
/etc/security/limits.conf # /etc/security/limits.conf
#
#Each line describes a limit for a user in the form:
#<domain> <type> <item> <value>
#Where:
#<domain> can be:
#        - an user name
#        - a group name, with @group syntax
#        - the wildcard *, for default entry
#        - the wildcard %, can be also used with %group syntax,
#                 for maxlogin limit
#<type> can have the two values:
#        - "soft" for enforcing the soft limits
#        - "hard" for enforcing hard limits
#<item> can be one of the following:
#        - core - limits the core file size (KB)
#        - data - max data size (KB)
#        - fsize - maximum filesize (KB)
#        - memlock 72000000
#        - nofile - max number of open files
#        - rss - max resident set size (KB)
#        - stack - max stack size (KB)
#        - cpu - max CPU time (MIN)
#        - nproc - max number of processes
#        - as - address space limit
#        - maxlogins - max number of logins for this user
#        - maxsyslogins - max number of logins on the system
#        - priority - the priority to run user process with
#        - locks - max number of file locks the user can hold
#        - sigpending - max number of pending signals
#        - msgqueue - max memory used by POSIX message queues (bytes)
#        - nice - max nice priority allowed to raise to
#        - rtprio - max realtime priority
#<domain> <type> <item> <value>

#* soft core 0
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#@student - maxlogins 4
# End of file

# Oracle-Validated setting for nofile soft limit is 131072
oracle soft nofile 131072

# Oracle-Validated setting for nofile hard limit is 131072
oracle hard nofile 131072

# Oracle-Validated setting for nproc soft limit is 131072
oracle soft nproc 131072

# Oracle-Validated setting for nproc hard limit is 131072
oracle hard nproc 131072

# Oracle-Validated setting for core soft limit is unlimited
oracle soft core unlimited

# Oracle-Validated setting for core hard limit is unlimited
oracle hard core unlimited

# Oracle-Validated setting for memlock 72000000
oracle soft memlock 72000000

# Oracle-Validated setting for memlock 72000000
oracle hard memlock 72000000

grid soft nofile  131072
grid hard nofile  131072
grid soft nproc   131072
grid hard nproc   131072
grid soft core    unlimited
grid hard core    unlimited
grid soft memlock 72000000
grid hard memlock 72000000
/etc/pam.d/login #%PAM-1.0
auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so
auth       include      system-auth
account    required     pam_nologin.so
account    include      system-auth
password   include      system-auth
# pam_selinux.so close should be the first session rule
session    required     pam_selinux.so close
session    optional     pam_keyinit.so force revoke
session    required     pam_loginuid.so
session    include      system-auth
session    optional     pam_console.so
# pam_selinux.so open should only be followed by sessions to be executed in the user context
session    required     pam_selinux.so open
/proc/meminfo MemTotal:        98929496 kB
MemFree:         39866112 kB
Buffers:            42520 kB
Cached:           1683548 kB
SwapCached:             0 kB
Active:           1879172 kB
Inactive:         1149592 kB
Active(anon):     1581172 kB
Inactive(anon):    416668 kB
Active(file):      298000 kB
Inactive(file):    732924 kB
Unevictable:       367824 kB
Mlocked:           367824 kB
SwapTotal:       25165816 kB
SwapFree:        25165816 kB
Dirty:               2332 kB
Writeback:              0 kB
AnonPages:        1677812 kB
Mapped:            277536 kB
Shmem:             623920 kB
Slab:             1900740 kB
SReclaimable:      102140 kB
SUnreclaim:       1798600 kB
KernelStack:         9128 kB
PageTables:         59704 kB
NFS_Unstable:           0 kB
Bounce:                 0 kB
WritebackTmp:           0 kB
CommitLimit:     48006564 kB
Committed_AS:     6484064 kB
VmallocTotal: 34359738367 kB
VmallocUsed:       654652 kB
VmallocChunk: 34358994048 kB
HugePages_Total:    26000
HugePages_Free:     24183
HugePages_Rsvd:      6376
HugePages_Surp:         0
Hugepagesize:        2048 kB
DirectMap4k:         5632 kB
DirectMap2M:      2082816 kB
DirectMap1G:     98566144 kB
/etc/modprobe.conf alias scsi_hostadapter mpt2sas
alias scsi_hostadapter1 shpchp
alias scsi_hostadapter2 ahci
alias scsi_hostadapter3 usb-storage
alias eth0 e1000e
alias eth1 e1000e
alias eth2 igb
alias eth3 igb
alias eth4 e1000e
alias eth5 e1000e
alias eth6 e1000e
alias eth7 e1000e
alias eth8 ixgbe
alias eth9 ixgbe
alias bond0 bonding
options bond0 mode=active-backup miimon=100
alias bond1 bonding
options bond1 mode=active-backup miimon=100
alias bond2 bonding
options bond2 mode=active-backup miimon=100
alias xbond0 bonding
options xbond0 mode=active-backup miimon=100
etc/oracle/ocr.loc #Device/file getting replaced by device +DATA
ocrconfig_loc=+RECO
ocrmirrorconfig_loc=+DATA
local_only=false
/etc/passwd root:x:0:0:root:/root:/bin/bash
bin:x:1:1:bin:/bin:/sbin/nologin
daemon:x:2:2:daemon:/sbin:/sbin/nologin
adm:x:3:4:adm:/var/adm:/sbin/nologin
lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin
sync:x:5:0:sync:/sbin:/bin/sync
shutdown:x:6:0:shutdown:/sbin:/sbin/shutdown
halt:x:7:0:halt:/sbin:/sbin/halt
mail:x:8:12:mail:/var/spool/mail:/sbin/nologin
news:x:9:13:news:/etc/news:
uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin
operator:x:11:0:operator:/root:/sbin/nologin
games:x:12:100:games:/usr/games:/sbin/nologin
gopher:x:13:30:gopher:/var/gopher:/sbin/nologin
ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin
nobody:x:99:99:Nobody:/:/sbin/nologin
nscd:x:28:28:NSCD Daemon:/:/sbin/nologin
vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin
ntp:x:38:38::/etc/ntp:/sbin/nologin
pcap:x:77:77::/var/arpwatch:/sbin/nologin
dbus:x:81:81:System message bus:/:/sbin/nologin
rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin
avahi:x:70:70:Avahi daemon:/:/sbin/nologin
mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin
smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin
sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin
oprofile:x:16:16:Special user account to be used by OProfile:/home/oprofile:/sbin/nologin
xfs:x:43:43:X Font Server:/etc/X11/fs:/sbin/nologin
haldaemon:x:68:68:HAL daemon:/:/sbin/nologin
avahi-autoipd:x:100:101:avahi-autoipd:/var/lib/avahi-autoipd:/sbin/nologin
rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin
nfsnobody:x:65534:65534:Anonymous NFS User:/var/lib/nfs:/sbin/nologin
gdm:x:42:42::/var/gdm:/sbin/nologin
svctag:x:54322:2::/tmp:/bin/false
grid:x:1000:1001::/home/grid:/bin/bash
oracle:x:1001:1001::/home/oracle:/bin/bash
etc/profile # /etc/profile

# System wide environment and startup programs, for login setup
# Functions and aliases go in /etc/bashrc

pathmunge () {
        if ! echo $PATH | /bin/egrep -q "(^|:)$1($|:)" ; then
           if [ "$2" = "after" ] ; then
              PATH=$PATH:$1
           else
              PATH=$1:$PATH
           fi
        fi
}

# ksh workaround
if [ -z "$EUID" -a -x /usr/bin/id ]; then
        EUID='id -u'
        UID='id -ru'
fi

# Path manipulation
if [ "$EUID" = "0" ]; then
        pathmunge /sbin
        pathmunge /usr/sbin
        pathmunge /usr/local/sbin
fi

# No core files by default
ulimit -S -c unlimited > /dev/null 2>&1

if [ -x /usr/bin/id ]; then
        USER="'id -un'"
        LOGNAME=$USER
        MAIL="/var/spool/mail/$USER"
fi

HOSTNAME='/bin/hostname'
HISTSIZE=1000

if [ -z "$INPUTRC" -a ! -f "$HOME/.inputrc" ]; then
    INPUTRC=/etc/inputrc
fi

export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE INPUTRC

# By default, we want umask to get set. This sets it for login shell
# Current threshold for system reserved uid/gids is 200
# You could check uidgid reservation validity in
# /usr/share/doc/setup-*/uidgid file
if [ $UID -gt 99 ] && [ "'id -gn'" = "'id -un'" ]; then
    umask 002
else
    umask 022
fi

for i in /etc/profile.d/*.sh ; do
    if [ -r "$i" ]; then
        if [ "${-#*i}" != "$-" ]; then
            . $i
        else
            . $i >/dev/null 2>&1
        fi
    fi
done

unset i
unset pathmunge
/etc/rc.local #!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local
runuser root -c "/opt/oracle/oak/osw/startOSW.sh 10 504 gzip "
/root/Extras/oakimagevalidate.pl
sysctl.conf # Kernel sysctl configuration file for Oracle Enterprise Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
# See /usr/share/doc/kernel-doc-*/Documentation/networking/ip-sysctl.txt
net.ipv4.conf.default.rp_filter = 2

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes

# Controls the default maxmimum size of a mesage queue

# Controls the maximum shared segment size, in bytes

# Controls the maximum number of shared memory segments, in pages

# For 11g, Oracle-Validated setting for fs.file-max is 6815744
# For 10g, uncomment 'fs.file-max = 327679', and comment 'fs.file-max = 6553600' entry and re-run sysctl -p
# fs.file-max = 327679
fs.file-max = 6815744

# Oracle-Validated setting for kernel.msgmni is 2878
kernel.msgmni = 2878

# Oracle-Validated setting for kernel.msgmax is 8192
kernel.msgmax = 8192

# Oracle-Validated setting for kernel.msgmnb is 65536
kernel.msgmnb = 65536

# Oracle-Validated setting for kernel.sem is '250 32000 100 142'
kernel.sem = 250 32000 100 142

# Oracle-Validated setting for kernel.shmmni is 4096
kernel.shmmni = 4096

# Oracle-Validated setting for kernel.shmall is 1073741824
kernel.shmall = 1073741824

# Oracle-Validated setting for kernel.shmmax is 4398046511104 on x86_64 and 4294967295 on i386 architecture. Refer Note id 567506.1
kernel.shmmax = 4398046511104

# Oracle-Validated setting for kernel.sysrq is 1
kernel.sysrq = 1

# Oracle-Validated setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144

# For 11g, Oracle-Validated setting for net.core.rmem_max is 4194304
# For 10g, uncomment 'net.core.rmem_max = 2097152', comment 'net.core.rmem_max = 4194304' entry and re-run sysctl -p
# net.core.rmem_max = 2097152
net.core.rmem_max = 4194304

# Oracle-Validated setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144

# For 11g, Oracle-Validated setting for net.core.wmem_max=2097152
# For 10g, uncomment 'net.core.wmem_max=2097152
# net.core.wmem_max=2097152
net.core.wmem_max=2097152

# Oracle-Validated setting for fs.aio-max-nr is 3145728
fs.aio-max-nr = 3145728

# For 11g, Oracle-Validated setting for net.ipv4.ip_local_port_range is 9000 65500
# For 10g, uncomment 'net.ipv4.ip_local_port_range = 1024 65000', comment 'net.ipv4.ip_local_port_range = 9000 65500' entry and re-run sysctl -p
# net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.ip_local_port_range = 9000 65500

# Oracle-Validated setting for vm.min_free_kbytes is 51200 to avoid OOM killer
vm.min_free_kbytes = 51200

vm.swappiness=100
fs.suid_dumpable=1
kernel.core_pattern=core.%e.%p
net.ipv4.conf.all.arp_announce=2
net.ipv4.conf.all.arp_ignore=1
net.ipv4.conf.all.arp_filter=1
vm.nr_hugepages=26000
top (no load) output top - 03:53:28 up 29 min, 1 user, load average: 1.08, 1.29, 1.83
Tasks: 598 total, 1 running, 597 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.3%us, 3.0%sy, 0.0%ni, 96.2%id, 0.5%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 98929496k total, 58533460k used, 40396036k free, 80884k buffers
Swap: 25165816k total, 0k used, 25165816k free, 1459540k cached


  PID USER      PR  NI  VIRT  RES SHR S %CPU %MEM   TIME+   COMMAND     
 7655 root      39  19     0    0   0 S 63.6  0.0   3:11.42 kipmi0
13003 root      RT   0  181m  86m 55m S  3.3  0.1   0:36.19 osysmond.bin
13049 grid      RT   0  342m 133m 53m S  0.7  0.1   0:08.00 ocssd.bin
14382 root      20   0  749m  26m 13m S  0.7  0.0   0:03.10 orarootagent.bi
12246 root      20   0  381m  49m 21m S  0.3  0.1   0:03.50 ohasd.bin
12870 grid      20   0  306m  36m 15m S  0.3  0.0   0:02.45 oraagent.bin
13020 root      RT   0  312m  91m 55m S  0.3  0.1   0:00.62 cssdmonitor
13388 root      20   0  239m  21m 10m S  0.3  0.0   0:01.58 octssd.bin
13896 grid      20   0 1252m  40m 25m S  0.3  0.0   0:03.37 oracle
13902 grid      -2   0 1251m  32m 19m S  0.3  0.0   0:01.52 oracle
14142 root      RT   0  240m 143m 61m S  0.3  0.1   0:01.01 ologgerd
14167 root      20   0  406m  47m 22m S  0.3  0.0   0:04.04 crsd.bin
14378 grid      20   0  886m  38m 16m S  0.3  0.0   0:01.51 oraagent.bin
15399 oracle    20   0 16.2g  23m 15m S  0.3  0.0   0:00.44 oracle
15411 oracle    20   0 16.2g  27m 14m S  0.3  0.0   0:01.44 oracle
15417 oracle    -2   0 16.2g  29m 16m S  0.3  0.0   0:03.60 oracle
15443 oracle    20   0 16.2g  18m 15m S  0.3  0.0   0:00.66 oracle
23204 root      20   0 13156 1492 808 R  0.3  0.0   0:00.07 top
    1 root      20   0 10364  688 568 S  0.0  0.0   1:27.07 init
    2 root      20   0     0    0   0 S  0.0  0.0   0:00.00 kthreadd
    3 root      RT   0     0    0   0 S  0.0  0.0   0:00.00 migration/0
    4 root      20   0     0    0   0 S  0.0  0.0   0:00.10 ksoftirqd/0
    5 root      RT   0     0    0   0 S  0.0  0.0   0:00.00 watchdog/0
    6 root      RT   0     0    0   0 S  0.0  0.0   0:00.00 migration/1
    7 root      20   0     0    0   0 S  0.0  0.0   0:00.02 ksoftirqd/1
    8 root      RT   0     0    0   0 S  0.0  0.0   0:00.00 watchdog/1
    9 root      RT   0     0    0   0 S  0.0  0.0   0:00.00 migration/2
   10 root      20   0     0    0   0 S  0.0  0.0   0:00.01 ksoftirqd/2
   11 root      RT   0     0    0   0 S  0.0  0.0   0:00.00 watchdog/2
   12 root      RT   0     0    0   0 S  0.0  0.0   0:00.00 migration/3
   13 root      20   0     0    0   0 S  0.0  0.0   0:00.00 ksoftirqd/3
   14 root      RT   0     0    0   0 S  0.0  0.0   0:00.00 watchdog/3
uname output uname -a

Linux orclsys1 2.6.32-300.11.1.el5uek #1 SMP Wed Mar 7 09:55:50 EST 2012 x86_64 x86_64 x86_64 GNU/Linux
Users group associations #id grid
uid=1000(grid) gid=1001(oinstall) groups=1001(oinstall),1003(racoper),1004(asmdba),1005(asmoper),1006(asmadmin)

#id oracle
uid=1001(oracle) gid=1001(oinstall) groups=1001(oinstall),1002(dba),1003(racoper),1004(asmdba)
vmstat output procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
 r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa st
 0  0     0  39967720  30388 1574056    0    0  1983    30  291  247  1  4 93  2  0
 
Clusterware
Cluster Verify CRSINST Performing post-checks for cluster services setup

Checking node reachability...

Check: Node reachability from node "orclsys1"
  Destination Node                     Reachable?
  ------------------------------------ ------------------------
  orclsys1                             yes
  orclsys2                             yes
Result: Node reachability check passed from node "orclsys1"


Checking user equivalence...

Check: User equivalence for user "grid"
  Node Name                            Status
  ------------------------------------ ------------------------
  orclsys2                             passed
  orclsys1                             passed
Result: User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...
  Node Name                            Status
  ------------------------------------ ------------------------
  orclsys2                             passed
  orclsys1                             passed

Verification of the hosts config file successful

Interface information for node "orclsys2"
 Name   IP Address      Subnet         Gateway  Def. Gateway  HW Address         MTU
 ------ --------------- -------------- -------- ------------- ------------------ -----
 eth0   192.168.16.25   192.168.16.0   0.0.0.0  192.0.2.1     00:21:28:E8:3C:92  9000
 eth0   169.254.113.97  169.254.0.0    0.0.0.0  192.0.2.1     00:21:28:E8:3C:92  9000
 eth1   192.168.17.25   192.168.17.0   0.0.0.0  192.0.2.1     00:21:28:E8:3C:93  9000
 eth1   169.254.225.6   169.254.128.0  0.0.0.0  192.0.2.1     00:21:28:E8:3C:93  9000
 bond0  192.0.2.19      192.0.2.0      0.0.0.0  192.0.2.1     00:21:28:E8:3C:8E  1500
 bond0  192.0.2.21      192.0.2.0      0.0.0.0  192.0.2.1     00:21:28:E8:3C:8E  1500


Interface information for node "orclsys1"
 Name   IP Address      Subnet         Gateway  Def. Gateway  HW Address         MTU
 ------ --------------- -------------- -------- ------------- ------------------ -----
 eth0   192.168.16.24   192.168.16.0   0.0.0.0  192.0.2.1     00:21:28:E8:62:F6  9000
 eth0   169.254.92.139  169.254.0.0    0.0.0.0  192.0.2.1     00:21:28:E8:62:F6  9000
 eth1   192.168.17.24   192.168.17.0   0.0.0.0  192.0.2.1     00:21:28:E8:62:F7  9000
 eth1   169.254.228.69  169.254.128.0  0.0.0.0  192.0.2.1     00:21:28:E8:62:F7  9000
 bond0  192.0.2.18      192.0.2.0      0.0.0.0  192.0.2.1     00:21:28:E8:62:F2  1500
 bond0  192.0.2.20      192.0.2.0      0.0.0.0  192.0.2.1     00:21:28:E8:62:F2  1500
 bond0  192.0.2.16      192.0.2.0      0.0.0.0  192.0.2.1     00:21:28:E8:62:F2  1500

Check: Node connectivity for interface "eth0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys2[192.168.16.25]        orclsys1[192.168.16.24]        yes
Result: Node connectivity passed for interface "eth0"


Check: TCP connectivity of subnet "192.168.16.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys1:192.168.16.24         orclsys2:192.168.16.25         passed
Result: TCP connectivity check passed for subnet "192.168.16.0"


Check: Node connectivity for interface "eth1"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys2[192.168.17.25]        orclsys1[192.168.17.24]        yes
Result: Node connectivity passed for interface "eth1"


Check: TCP connectivity of subnet "192.168.17.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys1:192.168.17.24         orclsys2:192.168.17.25         passed
Result: TCP connectivity check passed for subnet "192.168.17.0"

Check: Node connectivity for interface "bond0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys2[192.0.2.19]           orclsys2[192.0.2.21]           yes
  orclsys2[192.0.2.19]           orclsys1[192.0.2.18]           yes
  orclsys2[192.0.2.19]           orclsys1[192.0.2.20]           yes
  orclsys2[192.0.2.19]           orclsys1[192.0.2.16]           yes
  orclsys2[192.0.2.21]           orclsys1[192.0.2.18]           yes
  orclsys2[192.0.2.21]           orclsys1[192.0.2.20]           yes
  orclsys2[192.0.2.21]           orclsys1[192.0.2.16]           yes
  orclsys1[192.0.2.18]           orclsys1[192.0.2.20]           yes
  orclsys1[192.0.2.18]           orclsys1[192.0.2.16]           yes
  orclsys1[192.0.2.20]           orclsys1[192.0.2.16]           yes
Result: Node connectivity passed for interface "bond0"

Check: TCP connectivity of subnet "192.0.2.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys1:192.0.2.18            orclsys2:192.0.2.19            passed
  orclsys1:192.0.2.18            orclsys2:192.0.2.21            passed
  orclsys1:192.0.2.18            orclsys1:192.0.2.20            passed
  orclsys1:192.0.2.18            orclsys1:192.0.2.16            passed
Result: TCP connectivity check passed for subnet "192.0.2.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.16.0".
Subnet mask consistency check passed for subnet "192.168.17.0".
Subnet mask consistency check passed for subnet "192.0.2.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.16.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.16.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "192.168.17.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.17.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "192.0.2.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.0.2.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.
Check: Time zone consistency
Result: Time zone consistency check passed

Checking Oracle Cluster Voting Disk configuration...

ASM Running check passed. ASM is running on all specified nodes

Oracle Cluster Voting Disk configuration check passed

Checking Cluster manager integrity...

Checking CSS daemon...

  Node Name                            Status
  ------------------------------------ ------------------------
  orclsys2                             running
  orclsys1                             running

Oracle Cluster Synchronization Services appear to be online.

Cluster manager integrity check passed

UDev attributes check for OCR locations started...
Result: UDev attributes check passed for OCR locations

UDev attributes check for Voting Disk locations started...
Result: UDev attributes check passed for Voting Disk locations

Check default user file creation mask
  Node Name    Available                Required                 Comment
  ------------ ------------------------ ------------------------ ----------
  orclsys2     0022                     0022                     passed
  orclsys1     0022                     0022                     passed
Result: Default user file creation mask check passed

Checking cluster integrity...

  Node Name
  ------------------------------------
  orclsys1
  orclsys2

Cluster integrity check passed

Checking OCR integrity...

Checking the absence of a non-clustered configuration...
All nodes free of non-clustered, local-only configurations

ASM Running check passed. ASM is running on all specified nodes

Checking OCR config file "/etc/oracle/ocr.loc"...

OCR config file "/etc/oracle/ocr.loc" check successful

Disk group for ocr location "+RECO" available on all the nodes

Disk group for ocr location "+DATA" available on all the nodes

NOTE:
This check does not verify the integrity of the OCR contents. Execute 'ocrcheck' as a privileged user to verify the contents of OCR.

OCR integrity check passed

Checking CRS integrity...

Clusterware version consistency passed
The Oracle Clusterware is healthy on node "orclsys2"
The Oracle Clusterware is healthy on node "orclsys1"

CRS integrity check passed

Checking node application existence...

Checking existence of VIP node application (required)
  Node Name    Required                 Running?                 Comment
  ------------ ------------------------ ------------------------ ----------
  orclsys2     yes                      yes                      passed
  orclsys1     yes                      yes                      passed
VIP node application check passed

Checking existence of NETWORK node application (required)
  Node Name    Required                 Running?                 Comment
  ------------ ------------------------ ------------------------ ----------
  orclsys2     yes                      yes                      passed
  orclsys1     yes                      yes                      passed
NETWORK node application check passed

Checking existence of GSD node application (optional)
  Node Name    Required                 Running?                 Comment
  ------------ ------------------------ ------------------------ ----------
  orclsys2     no                       no                       exists
  orclsys1     no                       no                       exists
GSD node application is offline on nodes "orclsys2,orclsys1"

Checking existence of ONS node application (optional)
  Node Name    Required                 Running?                 Comment
  ------------ ------------------------ ------------------------ ----------
  orclsys2     no                       yes                      passed
  orclsys1     no                       yes                      passed
ONS node application check passed


Checking Single Client Access Name (SCAN)...
  SCAN Name        Node         Running?     ListenerName   Port         Running?
  ---------------- ------------ ------------ ------------   ------------ ------------
  orclsys-scan     orclsys1     true         LISTENER_SCAN1 1521         true

Checking TCP connectivity to SCAN Listeners...
  Node         ListenerName             TCP connectivity?
  ------------ ------------------------ ------------------------
  orclsys1     LISTENER_SCAN1           yes
TCP connectivity to SCAN Listeners exists on all cluster nodes

Checking name resolution setup for "orclsys-scan"...

ERROR:
PRVG-1101 : SCAN name "orclsys-scan" failed to resolve
  SCAN Name    IP Address               Status                   Comment
  ------------ ------------------------ ------------------------ ----------
  orclsys-scan 192.0.2.16               failed                   NIS Entry

ERROR:
PRVF-4657 : Name resolution setup check for "orclsys-scan" (IP address: 192.0.2.16) failed

ERROR:
PRVF-4664 : Found inconsistent name resolution entries for SCAN name "orclsys-scan"


Verification of SCAN VIP and Listener setup failed

Checking OLR integrity...

Checking OLR config file...

OLR config file check successful


Checking OLR file attributes...

OLR file check successful


WARNING:
This check does not verify the integrity of the OLR contents. Execute 'ocrcheck -local' as a privileged user to verify the contents of OLR.

OLR integrity check passed
OCR detected on ASM. Running ACFS Integrity checks...

Starting check to see if ASM is running on all cluster nodes...

ASM Running check passed. ASM is running on all specified nodes

Starting Disk Groups check to see if at least one Disk Group configured...
Disk Group Check passed. At least one Disk Group configured

Task ACFS Integrity check passed

Checking to make sure user "grid" is not in "root" group
  Node Name    Status                   Comment
  ------------ ------------------------ ------------------------
  orclsys2     passed                   does not exist
  orclsys1     passed                   does not exist
Result: User "grid" is not part of "root" group. Check passed

Checking if Clusterware is installed on all nodes...
Check of Clusterware install passed

Checking if CTSS Resource is running on all nodes...
Check: CTSS Resource running on all nodes
  Node Name                            Status
  ------------------------------------ ------------------------
  orclsys2                             passed
  orclsys1                             passed
Result: CTSS resource check passed


Querying CTSS for time offset on all nodes...
Result: Query of CTSS for time offset passed

Check CTSS state started...
Check: CTSS state
  Node Name                            State
  ------------------------------------ ------------------------
  orclsys2                             Active
  orclsys1                             Active
CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
Reference Time Offset Limit: 1000.0 msecs

Check: Reference Time Offset
  Node Name    Time Offset              Status
  ------------ ------------------------ ------------------------
  orclsys2     0.0                      passed
  orclsys1     0.0                      passed

Time offset is within the specified limits on the following set of nodes:
"[orclsys2, orclsys1]"
Result: Check of clock time offsets passed

Oracle Cluster Time Synchronization Services check passed
Checking VIP configuration.
Checking VIP Subnet configuration.
Check for VIP Subnet configuration passed.
Checking VIP reachability
Check for VIP reachability passed.
Performing IPMI configuration check...
Check for IPMI configuration passed

Post-check for cluster services setup was unsuccessful on all the nodes.
Cluster Verify HWOS Performing post-checks for hardware and operating system setup

Checking node reachability...

Check: Node reachability from node "orclsys1"
  Destination Node                     Reachable?
  ------------------------------------ ------------------------
  orclsys1                             yes
  orclsys2                             yes
Result: Node reachability check passed from node "orclsys1"


Checking user equivalence...

Check: User equivalence for user "grid"
  Node Name                            Status
  ------------------------------------ ------------------------
  orclsys2                             passed
  orclsys1                             passed
Result: User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...
  Node Name                            Status
  ------------------------------------ ------------------------
  orclsys2                             passed
  orclsys1                             passed

Verification of the hosts config file successful


Interface information for node "orclsys2"
Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0   192.168.16.25   192.168.16.0    0.0.0.0         192.0.2.1       00:21:28:E8:3C:92 9000
eth0   169.254.113.97  169.254.0.0     0.0.0.0         192.0.2.1       00:21:28:E8:3C:92 9000
eth1   192.168.17.25   192.168.17.0    0.0.0.0         192.0.2.1       00:21:28:E8:3C:93 9000
eth1   169.254.225.6   169.254.128.0   0.0.0.0         192.0.2.1       00:21:28:E8:3C:93 9000
bond0  192.0.2.19      192.0.2.0       0.0.0.0         192.0.2.1       00:21:28:E8:3C:8E 1500
bond0  192.0.2.21      192.0.2.0       0.0.0.0         192.0.2.1       00:21:28:E8:3C:8E 1500


Interface information for node "orclsys1"
  Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU
  ------ --------------- --------------- --------------- --------------- ----------------- ------
  eth0   192.168.16.24   192.168.16.0    0.0.0.0         192.0.2.1       00:21:28:E8:62:F6 9000
  eth0   169.254.92.139  169.254.0.0     0.0.0.0         192.0.2.1       00:21:28:E8:62:F6 9000
  eth1   192.168.17.24   192.168.17.0    0.0.0.0         192.0.2.1       00:21:28:E8:62:F7 9000
  eth1   169.254.228.69  169.254.128.0   0.0.0.0         192.0.2.1       00:21:28:E8:62:F7 9000
  bond0  192.0.2.18      192.0.2.0       0.0.0.0         192.0.2.1       00:21:28:E8:62:F2 1500
  bond0  192.0.2.20      192.0.2.0       0.0.0.0         192.0.2.1       00:21:28:E8:62:F2 1500
  bond0  192.0.2.16      192.0.2.0       0.0.0.0         192.0.2.1       00:21:28:E8:62:F2 1500


Check: Node connectivity of subnet "192.168.16.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys2[192.168.16.25]        orclsys1[192.168.16.24]         yes
Result: Node connectivity passed for subnet "192.168.16.0" with node(s) orclsys2,orclsys1


Check: TCP connectivity of subnet "192.168.16.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys1:192.168.16.24         orclsys2:192.168.16.25         passed
Result: TCP connectivity check passed for subnet "192.168.16.0"


Check: Node connectivity of subnet "169.254.0.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys2[169.254.113.97]       orclsys1[169.254.92.139]       yes
Result: Node connectivity passed for subnet "169.254.0.0" with node(s) orclsys2,orclsys1


Check: TCP connectivity of subnet "169.254.0.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys1:169.254.92.139        orclsys2:169.254.113.97        passed
Result: TCP connectivity check passed for subnet "169.254.0.0"


Check: Node connectivity of subnet "192.168.17.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys2[192.168.17.25]        orclsys1[192.168.17.24]        yes
Result: Node connectivity passed for subnet "192.168.17.0" with node(s) orclsys2,orclsys1


Check: TCP connectivity of subnet "192.168.17.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys1:192.168.17.24         orclsys2:192.168.17.25         passed
Result: TCP connectivity check passed for subnet "192.168.17.0"


Check: Node connectivity of subnet "169.254.128.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys2[169.254.225.6]        orclsys1[169.254.228.69]       yes
Result: Node connectivity passed for subnet "169.254.128.0" with node(s) orclsys2,orclsys1


Check: TCP connectivity of subnet "169.254.128.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys1:169.254.228.69        orclsys2:169.254.225.6         passed
Result: TCP connectivity check passed for subnet "169.254.128.0"


Check: Node connectivity of subnet "192.0.2.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys2[192.0.2.19]           orclsys2[192.0.2.21]           yes
  orclsys2[192.0.2.19]           orclsys1[192.0.2.18]           yes
  orclsys2[192.0.2.19]           orclsys1[192.0.2.20]           yes
  orclsys2[192.0.2.19]           orclsys1[192.0.2.16]           yes
  orclsys2[192.0.2.21]           orclsys1[192.0.2.18]           yes
  orclsys2[192.0.2.21]           orclsys1[192.0.2.20]           yes
  orclsys2[192.0.2.21]           orclsys1[192.0.2.16]           yes
  orclsys1[192.0.2.18]           orclsys1[192.0.2.20]           yes
  orclsys1[192.0.2.18]           orclsys1[192.0.2.16]           yes
  orclsys1[192.0.2.20]           orclsys1[192.0.2.16]           yes
Result: Node connectivity passed for subnet "192.0.2.0" with node(s) orclsys2,orclsys1


Check: TCP connectivity of subnet "192.0.2.0"
  Source                         Destination                    Connected?
  ------------------------------ ------------------------------ ----------------
  orclsys1:192.0.2.18            orclsys2:192.0.2.19            passed
  orclsys1:192.0.2.18            orclsys2:192.0.2.21            passed
  orclsys1:192.0.2.18            orclsys1:192.0.2.20            passed
  orclsys1:192.0.2.18            orclsys1:192.0.2.16            passed
Result: TCP connectivity check passed for subnet "192.0.2.0"


Interfaces found on subnet "169.254.0.0" that are likely candidates for VIP are:
orclsys2 eth0:169.254.113.97
orclsys1 eth0:169.254.92.139

Interfaces found on subnet "169.254.128.0" that are likely candidates for VIP are:
orclsys2 eth1:169.254.225.6
orclsys1 eth1:169.254.228.69

Interfaces found on subnet "192.0.2.0" that are likely candidates for VIP are:
orclsys2 bond0:192.0.2.19 bond0:192.0.2.21
orclsys1 bond0:192.0.2.18 bond0:192.0.2.20 bond0:192.0.2.16

Interfaces found on subnet "192.168.16.0" that are likely candidates for a private interconnect are:
orclsys2 eth0:192.168.16.25
orclsys1 eth0:192.168.16.24

Interfaces found on subnet "192.168.17.0" that are likely candidates for a private interconnect are:
orclsys2 eth1:192.168.17.25
orclsys1 eth1:192.168.17.24
Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.16.0".
Subnet mask consistency check passed for subnet "169.254.0.0".
Subnet mask consistency check passed for subnet "192.168.17.0".
Subnet mask consistency check passed for subnet "169.254.128.0".
Subnet mask consistency check passed for subnet "192.0.2.0".
Subnet mask consistency check passed.
 
Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.16.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.16.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "169.254.0.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "169.254.0.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "192.168.17.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.17.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "169.254.128.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "169.254.128.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "192.0.2.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.0.2.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

Checking for multiple users with UID value 0
Result: Check for multiple users with UID value 0 passed
Check: Time zone consistency
Result: Time zone consistency check passed

Checking shared storage accessibility...

WARNING:
orclsys1:Unable to determine the sharedness of /dev/sday on nodes: orclsys2,orclsys1

WARNING:
orclsys1:Unable to determine the sharedness of /dev/mapper/HDD_E0_S04_1135657835 on nodes: orclsys1


  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdh                             orclsys2 orclsys1
  /dev/sdar                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdj                             orclsys2 orclsys1
  /dev/sdat                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdt                             orclsys2 orclsys1
  /dev/sdaf                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdv                             orclsys2 orclsys1
  /dev/sdah                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdc                             orclsys2 orclsys1
  /dev/sdam                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sde                             orclsys2 orclsys1
  /dev/sdao                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdf                             orclsys2 orclsys1
  /dev/sdap                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdg                             orclsys2 orclsys1
  /dev/sdaq                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdi                             orclsys2 orclsys1
  /dev/sdas                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdk                             orclsys2 orclsys1
  /dev/sdau                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdl                             orclsys2 orclsys1
  /dev/sdav                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdm                             orclsys2 orclsys1
  /dev/sdaw                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdn                             orclsys2 orclsys1
  /dev/sdax                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdo                             orclsys2 orclsys1
  /dev/sdaa                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdp                             orclsys2 orclsys1
  /dev/sdab                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdq                             orclsys2 orclsys1
  /dev/sdac                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdr                             orclsys2 orclsys1
  /dev/sdad                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sds                             orclsys2 orclsys1
  /dev/sdae                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdu                             orclsys2 orclsys1
  /dev/sdag                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdw                             orclsys2 orclsys1
  /dev/sdai                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdy                             orclsys2 orclsys1
  /dev/sdak                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdz                             orclsys2 orclsys1
  /dev/sdal                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/sdx                             orclsys2 orclsys1
  /dev/sdaj                            orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E0_S01_1137772287    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E0_S00_1137537659    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S02_1137581539    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S06_1135821887    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S03_1137509855    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/SSD_E0_S20_805682621 orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E0_S05_1135619487    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/SSD_E0_S21_805682553     orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S07_1135801023    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S10_1135835919    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S11_1135804775    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/SSD_E1_S22_805682628     orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/SSD_E1_S23_805682605     orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E0_S09_1135802123    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E0_S12_1135827487    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S15_1135794951    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E0_S08_1135792215    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E0_S16_1135664919    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E0_S13_1135804119    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S14_1135787679    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E0_S17_1135602799    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S19_1135610547    orclsys2 orclsys1

  Disk Sharing                         Nodes (2 in count)
  ------------------------------------ ------------------------
  /dev/mapper/HDD_E1_S18_1135740479    orclsys2 orclsys1


Shared storage check was successful on nodes "orclsys2,orclsys1"

Post-check for hardware and operating system setup was successful.
Cluster Control CRSCTL STATUS NAME        TARGET  STATE       SERVER                STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
            ONLINE  ONLINE      orclsys1
            ONLINE  ONLINE      orclsys2
ora.LISTENER.lsnr
            ONLINE  ONLINE      orclsys1
            ONLINE  ONLINE      orclsys2
ora.RECO.dg
            ONLINE  ONLINE      orclsys1
            ONLINE  ONLINE      orclsys2
ora.REDO.dg
            ONLINE  ONLINE      orclsys1
            ONLINE  ONLINE      orclsys2
ora.asm
            ONLINE  ONLINE      orclsys1                Started
            ONLINE  ONLINE      orclsys2                Started
ora.gsd
            OFFLINE OFFLINE     orclsys1
            OFFLINE OFFLINE     orclsys2
ora.net1.network
            ONLINE  ONLINE      orclsys1
            ONLINE  ONLINE      orclsys2
ora.ons
            ONLINE  ONLINE      orclsys1
            ONLINE  ONLINE      orclsys2
ora.registry.acfs
            ONLINE  ONLINE      orclsys1
            ONLINE  ONLINE      orclsys2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1     ONLINE  ONLINE      orclsys1
ora.cvu
      1     ONLINE  ONLINE      orclsys1
ora.oc4j
      1     ONLINE  ONLINE      orclsys1
ora.orcl.db
      1     ONLINE  ONLINE      orclsys1                 Open
      2     ONLINE  ONLINE      orclsys2                 Open
ora.orclsys1.vip
      1     ONLINE  ONLINE      orclsys1
ora.orclsys2.vip
      1     ONLINE  ONLINE      orclsys2
ora.scan1.vip
      1     ONLINE  ONLINE      orclsys1
OCRCheck Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3036
Available space (kbytes) : 259084
ID : 427182197
Device/File Name : +RECO
Device/File integrity check succeeded
Device/File Name : +DATA
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded
 
Database Configuration
AMM The ASM instance is configured for AMM, and is using /dev/shm:
--------------------------------------------------------------
SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
memory_max_target                    big integer                             1G
memory_target                        big integer                             1G

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean                              FALSE
sga_max_size                         big integer                             1G
sga_target                           big integer                              0

SQL> show parameter pga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer                              0
ASMM -- the RDBMS instance is configured for 10g ASMM, and appears to be withdrawing from the Huge Pages Pool

SQL> show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------
hi_shared_memory_address             integer          0
memory_max_target                    big integer      0
memory_target                        big integer      0
shared_memory_address                integer          0

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer   16G
sga_target big                       integer       16G

SQL> show parameter pga

NAME                                 TYPE         VALUE
------------------------------------ ----------- ------
pga_aggregate_target                 big integer     8G

SQL> show parameter large

NAME                                 TYPE         VALUE
------------------------------------ ----------- ------
large_pool_size                      big integer      0
use_large_pages string ONLY


[oracle@orclsys1 files]$ grep Huge /proc/meminfo
HugePages_Total: 26000
HugePages_Free: 24164
HugePages_Rsvd: 6357
HugePages_Surp: 0
Hugepagesize: 2048 kB


SQL> SELECT * FROM v$memory_dynamic_components;

COMPONENT                 CURRENT_SIZE MIN_SIZE   MAX_SIZE   LAST_OPER_TYP GRANULE_SIZE
------------------------- ------------ ---------- ---------- ------------- ------------
shared pool                 2181038080 2181038080 2181038080 STATIC            33554432
large pool                    33554432   33554432   33554432 STATIC            33554432
java pool                     33554432   33554432   33554432 STATIC            33554432
streams pool                         0          0          0 STATIC            33554432
SGA Target                  1.7180E+10 1.7180E+10 1.7180E+10 STATIC            33554432
DEFAULT buffer cache        1.4798E+10 1.4798E+10 1.4798E+10 INITIALIZING      33554432
KEEP buffer cache                    0          0          0 STATIC            33554432
RECYCLE buffer cache                 0          0          0 STATIC            33554432
DEFAULT 2K buffer cache              0          0          0 STATIC            33554432
DEFAULT 4K buffer cache              0          0          0 STATIC            33554432
DEFAULT 8K buffer cache              0          0          0 STATIC            33554432
DEFAULT 16K buffer cache             0          0          0 STATIC            33554432
DEFAULT 32K buffer cache             0          0          0 STATIC            33554432
Shared IO Pool                       0          0          0 STATIC            33554432
PGA Target                  8589934592 8589934592 8589934592 STATIC            33554432
ASM Buffer Cache                     0          0          0 STATIC            33554432
/home/oracle/.bashrc # .bashrc

# Source global definitions
if [ -f /etc/bashrc ]; then
        . /etc/bashrc
fi

# User specific aliases and functions
export ORACLE_SID=orcl1
export ORACLE_UNQNAME=orcl
/home/oracle/.bash_profile # .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
export PATH=$ORACLE_HOME/bin:.:$PATH
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
export PATH=$ORACLE_HOME/bin:.:$PATH
Database Startup Parameters

Anyone that thinks a single control file, highlighted, is a good idea should find another job: Change this immediately.
SQL> CREATE PFILE '/home/oracle/pfileFromMem.txt' FROM memory;

# Oracle init.ora parameter file generated by instance orcl1 on 07/03/2012 05:01:02
*.__db_cache_size=14112M
*.__java_pool_size=32M
*.__large_pool_size=32M
*.__pga_aggregate_target=8G
*.__sga_target=16G
*.__shared_io_pool_size=0
*.__shared_pool_size=2080M
*.__streams_pool_size=0
*._aggregation_optimization_settings=0
*._always_anti_join='CHOOSE'
*._always_semi_join='CHOOSE'
*._and_pruning_enabled=TRUE
*._b_tree_bitmap_plans=TRUE
*._bloom_filter_enabled=TRUE
*._bloom_folding_enabled=TRUE
*._bloom_pruning_enabled=TRUE
*._complex_view_merging=TRUE
*._compression_compatibility='11.2.0.2.0'
*._connect_by_use_union_all='TRUE'
*._convert_set_to_join=FALSE
*._cost_equality_semi_join=TRUE
*._cpu_to_io=0
*._dimension_skip_null=TRUE
*._disable_interface_checking=TRUE
*._eliminate_common_subexpr=TRUE
*._enable_NUMA_support=FALSE
*._enable_type_dep_selectivity=TRUE
*._fast_full_scan_enabled=TRUE
*._file_size_increase_increment=2044M
*._first_k_rows_dynamic_proration=TRUE
*._gby_hash_aggregation_enabled=TRUE
*._gc_policy_time=0
*._gc_undo_affinity=FALSE
*._generalized_pruning_enabled=TRUE
*._globalindex_pnum_filter_enabled=TRUE
*._gs_anti_semi_join_allowed=TRUE
*._improved_outerjoin_card=TRUE
*._improved_row_length_enabled=TRUE
*._index_join_enabled=TRUE
*._kgl_cluster_lock_read_mostly=TRUE
*._kill_diagnostics_timeout=140
*._ksb_restart_policy_times='0'
*._ksb_restart_policy_times='60'
*._ksb_restart_policy_times='120'
*._ksb_restart_policy_times='240' # internal update to set default
*._left_nested_loops_random=TRUE
*._lm_rcvr_hang_allow_time=140
*._local_communication_costing_enabled=TRUE
*._minimal_stats_aggregation=TRUE
*._mmv_query_rewrite_enabled=TRUE
*._new_initial_join_orders=TRUE
*._new_sort_cost_estimate=TRUE
*._nlj_batching_enabled=1
*._optim_adjust_for_part_skews=TRUE
*._optim_enhance_nnull_detection=TRUE
*._optim_new_default_join_sel=TRUE
*._optim_peek_user_binds=TRUE
*._optimizer_adaptive_cursor_sharing=TRUE
*._optimizer_better_inlist_costing='ALL'
*._optimizer_cbqt_no_size_restriction=TRUE
*._optimizer_coalesce_subqueries=TRUE
*._optimizer_complex_pred_selectivity=TRUE
*._optimizer_compute_index_stats=TRUE
*._optimizer_connect_by_combine_sw=TRUE
*._optimizer_connect_by_cost_based=TRUE
*._optimizer_connect_by_elim_dups=TRUE
*._optimizer_correct_sq_selectivity=TRUE
*._optimizer_cost_based_transformation='LINEAR'
*._optimizer_cost_hjsmj_multimatch=TRUE
*._optimizer_cost_model='CHOOSE'
*._optimizer_dim_subq_join_sel=TRUE
*._optimizer_distinct_agg_transform=TRUE
*._optimizer_distinct_elimination=TRUE
*._optimizer_distinct_placement=TRUE
*._optimizer_eliminate_filtering_join=TRUE
*._optimizer_enable_density_improvements=TRUE
*._optimizer_enable_extended_stats=TRUE
*._optimizer_enable_table_lookup_by_nl=TRUE
*._optimizer_enhanced_filter_push=TRUE
*._optimizer_extend_jppd_view_types=TRUE
*._optimizer_extended_cursor_sharing='UDO'
*._optimizer_extended_cursor_sharing_rel='SIMPLE'
*._optimizer_extended_stats_usage_control=192
*._optimizer_false_filter_pred_pullup=TRUE
*._optimizer_fast_access_pred_analysis=TRUE
*._optimizer_fast_pred_transitivity=TRUE
*._optimizer_filter_pred_pullup=TRUE
*._optimizer_fkr_index_cost_bias=10
*._optimizer_full_outer_join_to_outer=TRUE
*._optimizer_group_by_placement=TRUE
*._optimizer_improve_selectivity=TRUE
*._optimizer_interleave_jppd=TRUE
*._optimizer_join_elimination_enabled=TRUE
*._optimizer_join_factorization=TRUE
*._optimizer_join_order_control=3
*._optimizer_join_sel_sanity_check=TRUE
*._optimizer_max_permutations=2000
*._optimizer_mode_force=TRUE
*._optimizer_multi_level_push_pred=TRUE
*._optimizer_native_full_outer_join='FORCE'
*._optimizer_new_join_card_computation=TRUE
*._optimizer_null_aware_antijoin=TRUE
*._optimizer_or_expansion='DEPTH'
*._optimizer_order_by_elimination_enabled=TRUE
*._optimizer_outer_join_to_inner=TRUE
*._optimizer_outer_to_anti_enabled=TRUE
*._optimizer_push_down_distinct=0
*._optimizer_push_pred_cost_based=TRUE
*._optimizer_rownum_bind_default=10
*._optimizer_rownum_pred_based_fkr=TRUE
*._optimizer_skip_scan_enabled=TRUE
*._optimizer_sortmerge_join_inequality=TRUE
*._optimizer_squ_bottomup=TRUE
*._optimizer_star_tran_in_with_clause=TRUE
*._optimizer_system_stats_usage=TRUE
*._optimizer_table_expansion=TRUE
*._optimizer_transitivity_retain=TRUE
*._optimizer_try_st_before_jppd=TRUE
*._optimizer_undo_cost_change='11.2.0.3'
*._optimizer_unnest_corr_set_subq=TRUE
*._optimizer_unnest_disjunctive_subq=TRUE
*._optimizer_use_cbqt_star_transformation=TRUE
*._optimizer_use_feedback=TRUE
*._or_expand_nvl_predicate=TRUE
*._ordered_nested_loop=TRUE
*._parallel_broadcast_enabled=TRUE
*._partition_view_enabled=TRUE
*._pga_max_size=1677720K
*._pivot_implementation_method='CHOOSE'
*._pre_rewrite_push_pred=TRUE
*._pred_move_around=TRUE
*._push_join_predicate=TRUE
*._push_join_union_view=TRUE
*._push_join_union_view2=TRUE
*._px_minus_intersect=TRUE
*._px_partition_scan_enabled=TRUE
*._px_pwg_enabled=TRUE
*._px_ual_serial_input=TRUE
*._query_rewrite_setopgrw_enable=TRUE
*._remove_aggr_subquery=TRUE
*._replace_virtual_columns=TRUE
*._right_outer_hash_enable=TRUE
*._selfjoin_mv_duplicates=TRUE
*._smm_max_size=838860
*._smm_min_size=1024
*._smm_px_max_size=4194304
*._sql_model_unfold_forloops='RUN_TIME'
*._sqltune_category_parsed='DEFAULT' # parsed sqltune_category
*._subquery_pruning_enabled=TRUE
*._subquery_pruning_mv_enabled=FALSE
*._table_scan_cost_plus_one=TRUE
*._union_rewrite_for_gs='YES_GSET_MVS'
*._unnest_subquery=TRUE
*._use_column_stats_for_function=TRUE
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_sys_operations=TRUE
*.audit_trail='DB'
orcl1.background_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl1/trace' #Deprecate parameter
orcl2.background_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl2/trace' #Deprecate parameter
*.cluster_database=TRUE
*.compatible='11.2.0.2.0'
*.control_files='+DATA/orcl/control01.ctl'  -- lack of multiplexing is an issue that should be addressed
orcl1.core_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl1/cdump'
orcl2.core_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl2/cdump'
*.cpu_count=8
*.cursor_sharing='EXACT'  -- this may not be what you want
*.db_block_checking='FULL'
*.db_block_checksum='FULL'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+REDO'
*.db_domain=''  -- provide this using an ALTER SYSTEM
*.db_files=1024
*.db_lost_write_protect='TYPICAL'
*.db_name='orcl'
*.db_recovery_file_dest='+RECO'
*.db_recovery_file_dest_size=1800G
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.fast_start_mttr_target=300
*.filesystemio_options='setall'
*.global_names=TRUE
orcl1.instance_number=1
orcl2.instance_number=2
orcl1.local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.0.2.20)(PORT=1521))))'
orcl2.local_listener=' (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.0.2.21)(PORT=1521))))'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=33554432 # log buffer update
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=1000
*.optimizer_dynamic_sampling=2
*.optimizer_mode='ALL_ROWS'
*.os_authent_prefix=''
*.parallel_adaptive_multi_user=FALSE
*.parallel_execution_message_size=16384
*.parallel_min_servers=0
*.parallel_threads_per_cpu=2
*.pga_aggregate_target=8G
*.plsql_warnings='DISABLE:ALL' # PL/SQL warnings at init.ora -- change to ENABLE:ALL
*.processes=800
*.query_rewrite_enabled='TRUE'
*.remote_listener='orclsys-scan:1521'
*.remote_login_passwordfile='EXCLUSIVE'
*.result_cache_max_size=83904K
*.session_cached_cursors=100
*.sga_target=16G
*.skip_unusable_indexes=TRUE
*.sql92_security=TRUE
orcl1.thread=1
orcl2.thread=2
*.undo_retention=900  -- wholly inadequate for almost anything
orcl1.undo_tablespace='UNDOTBS1'
orcl2.undo_tablespace='UNDOTBS2'
*.use_large_pages='ONLY'
orcl1.user_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl1/trace' #Deprecate parameter
orcl2.user_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl2/trace' #Deprecate parameter
DBConsole init #!/bin/bash
#
# chkconfig: 35 95 1
# description: init script to start/stop oracle dbconsole
#
#
#
# match these values to your environment:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
export ORACLE_OWNER=oracle

# see how we are called:
case "$1" in
    start)
        su - $ORACLE_OWNER <<EOF
        export ORACLE_UNQNAME=orcl
        $ORACLE_HOME/bin/emctl start dbconsole &
EOF
        exit 0
        ;;
    stop)
        su - $ORACLE_OWNER <<EOF
        export ORACLE_UNQNAME=orcl
        $ORACLE_HOME/bin/emctl stop dbconsole
EOF
        exit 0
        ;;
esac
User Oracle env HOSTNAME=orclsys1
TERM=xterm
SHELL=/bin/bash
HISTSIZE=1000
ORACLE_UNQNAME=orcl
SSH_CLIENT=192.0.2.200 49499 22
SSH_TTY=/dev/pts/0
USER=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:
or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:
*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:
*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:
*.rpm=00;31: *.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:
*.png=00;35:*.tif=00;35:
ORACLE_SID=orcl1
MAIL=/var/spool/mail/oracle
PATH=/u01/app/oracle/product/11.2.0.3/dbhome_1/bin:
.:/u01/app/oracle/product/11.2.0.3/dbhome_1/bin: .:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
INPUTRC=/etc/inputrc
PWD=/home/oracle/files
LANG=en_US.UTF-8
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/home/oracle
LOGNAME=oracle
SSH_CONNECTION=192.0.2.200 49499 192.0.2.18 22
LESSOPEN=|/usr/bin/lesspipe.sh %s
DISPLAY=localhost:10.0
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
G_BROKEN_FILENAMES=1
_=/bin/env
OLDPWD=/home/oracle
$GRID_HOME Directory Tree [grid@orclsys1 grid]$ pwd
/u01/app/11.2.0.3/grid

[grid@orclsys1 grid]$ ls -al
total 324
drwxr-xr-x 69 root oinstall  4096 Jun 24 01:01 .
drwxr-xr-x  3 root oinstall  4096 Jun 24 00:58
..
drwxr-xr-x  6 grid oinstall  4096 Jun 24 01:23
assistants
drwxrwxrwt  6 root oinstall  4096 Jun 24 01:01
auth
drwxr-xr-x  2 root oinstall 16384 Jun 24 01:01
bin
drwxr-xr-x  9 grid oinstall  4096 Apr  6 20:06
ccr
drwxrwxr-x  5 grid oinstall  4096 Jun 24 01:01
cdata
drwxrwxr-x  6 grid oinstall  4096 Jun 24 01:01
cfgtoollogs
drwxr-xr-x  4 grid oinstall  4096 Apr  6 20:00
clone
drwxr-x---  4 root oinstall  4096 Jun 24 01:01
crf
drwxr-xr-x 17 root oinstall  4096 Jun 24 01:01
crs
drwxr-xr-x  3 grid oinstall  4096 Apr  6 20:00
csmig
drwx--x--x  6 grid oinstall  4096 Apr  6 20:01
css
drwxr-xr-x  3 root oinstall  4096 Jun 24 01:01
ctss
drwxrwxr-x 10 grid oinstall  4096 Jun 24 01:01
cv
drwxr-xr-x  2 grid oinstall  4096 Jun 30 20:15
dbs
drwxr-xr-x  2 grid oinstall  4096 Apr  6 20:01
dc_ocm
drwxr-xr-x  4 grid oinstall  4096 Jun 24 01:00
deinstall
drwxr-xr-x  3 grid oinstall  4096 Apr  6 20:00
demo
drwxr-xr-x  3 grid oinstall  4096 Apr  6 20:00
diagnostics
drwxr-x---  3 grid oinstall  4096 Jun 24 01:01
eons
drwxr-x---  7 grid oinstall  4096 Apr  6 20:01
evm
drwxr-x---  3 grid oinstall  4096 Jun 24 01:01
gipc
drwxr-x---  3 root oinstall  4096 Jun 24 01:01
gns
drwxr-x---  6 grid oinstall  4096 Jun 24 01:04
gpnp
drwxr-xr-x  3 grid oinstall  4096 Apr  6 20:00
has
drwxr-xr-x  3 grid oinstall  4096 Apr  6 20:00
hs
drwxr-xr-x  7 grid oinstall  4096 Jun 24 01:01
install
drwxr-xr-x  2 grid oinstall  4096 Apr  6 20:00
instantclient
drwxrwx--- 14 grid oinstall  4096 Apr  6 20:05
inventory
drwxr-xr-x  7 grid oinstall  4096 Apr  6 20:00
javavm
drwxr-xr-x  3 grid oinstall  4096 Apr  6 20:01
jdbc
drwxr-xr-x  6 grid oinstall  4096 Apr  6 20:01
jdk
drwxr-xr-x  2 grid oinstall  4096 Jun 24 01:01
jlib
lrwxrwxrwx  1 grid oinstall    31 Jun 24 01:00
JRE -> /u01/app/11.2.0.3/grid/jdk/jre/
drwxr-xr-x 12 grid oinstall  4096 Apr  6 20:01
ldap
drwxr-xr-x  3 root oinstall 12288 Jun 24 01:01
lib
drwxrwxr-x  5 grid oinstall  4096 Jun 24 01:01
log
drwxr-xr-x  5 grid oinstall  4096 Apr  6 20:00
md
drwxr-x---  3 grid oinstall  4096 Jun 24 01:01
mdns
drwxr-xr-x  2 grid oinstall  4096 Apr  6 20:00
mesg
drwxr-xr-x 11 grid oinstall  4096 Apr  6 20:02
network
drwxr-xr-x  6 grid oinstall  4096 Apr  6 20:00
nls
drwxr-xr-x 20 grid oinstall  4096 Apr  6 20:01
oc4j
drwxr-x---  3 grid oinstall  4096 Jun 24 01:01
ohasd
drwxr-xr-x  3 root oinstall  4096 Jun 24 01:01
ologgerd
drwxr-xr-x  9 grid oinstall  4096 Jun 24 01:00
OPatch
drwxr-xr-x  7 grid oinstall  4096 Apr  6 20:01
opmn
drwxr-xr-x  4 grid oinstall  4096 Apr  6 20:00
oracore
-rw-r-----  1 grid oinstall    56 Jun 24 01:00 oraInst.loc
drwxr-xr-x  7 grid oinstall  4096 Apr  6 20:00
ord
drwxr-xr-x  3 root oinstall  4096 Jun 24 01:01
osysmond
drwxr-xr-x  8 grid oinstall  4096 Jun 24 01:00
oui
drwxr-xr-x  4 grid oinstall  4096 Apr  6 20:00
owm
drwxr-x---  7 grid oinstall  4096 Apr  6 23:06
.patch_storage
drwxr-xr-x  5 grid oinstall  4096 Jun 24 01:00
perl
drwxr-xr-x  6 grid oinstall  4096 Apr  6 20:00
plsql
drwxr-xr-x  6 grid oinstall  4096 Apr  6 20:02
precomp
drwxr-xr-x  4 grid oinstall  4096 Apr  6 20:07
psu
drwxr-xr-x  9 grid oinstall  4096 Apr  6 20:01
racg
drwxr-xr-x 13 grid oinstall  4096 Apr  6 20:02
rdbms
drwxr-xr-x  3 grid oinstall  4096 Apr  6 20:00
relnotes
-rwxr-x---  1 grid oinstall   495 Jun 24 01:00
root.sh
-rwxr-x---  1 grid oinstall   495 Apr  6 20:02
root.sh.old
-rwxr-x---  1 grid oinstall    10 Apr  6 20:00
root.sh.old.1
-rw-r--r--  1 grid oinstall    10 Jun 24 01:00 root.sh.ouibak
-rwxr-xr-x  1 grid oinstall   508 Jun 24 01:00
rootupgrade.sh
-rw-r--r--  1 grid oinstall   508 Apr  6 20:02 rootupgrade.sh.ouibak
drwxr-xr-x  4 grid oinstall  4096 Apr  6 20:00
scheduler
drwxr-xr-x  3 grid oinstall  4096 Apr  6 20:00
slax
drwxr-xr-x  7 grid oinstall  4096 Apr  6 20:01
sqlplus
drwxr-xr-x  9 grid oinstall  4096 Apr  6 20:01
srvm
drwxr-xr-x  5 grid oinstall  4096 Apr  6 20:00
sysman
drwxr-xr-x  5 grid oinstall  4096 Apr  6 20:00
usm
drwxr-xr-x  2 grid oinstall  4096 Apr  6 20:00
utl
drwxr-xr-x  3 grid oinstall  4096 Apr  6 20:00
wwg
drwxr-xr-x  5 grid oinstall  4096 Apr  6 20:00
xdk

[grid@orclsys1 grid]$ cd /u01/app/grid
[grid@orclsys1 grid]$ ls -al
total 32
drwxr-xr-x  8 grid oinstall 4096 Jun 24 01:18
.
drwxr-xr-x  6 root oinstall 4096 Jun 24 01:25
..
drwxr-x---  4 grid oinstall 4096 Jun 24 01:17
cfgtoollogs
drwxr-xr-x  2 grid oinstall 4096 Jun 24 01:01
checkpoints
drwxr-xr-x  2 grid oinstall 4096 Jun 24 01:01
Clusterware
drwxrwxr-x  4 grid oinstall 4096 Jun 24 01:17
diag
drwxr-xr-x  3 root root     4096 Jun 24 01:18
oradiag_root
drwxr-xr-x  3 grid oinstall 4096 Jun 24 01:01
orclsys1
OPatch Inventory [oracle@orclsys1 ~]$ cd /u01/app/oracle/product/11.2.0.3/dbhome_1/OPatch/
[oracle@orclsys1 OPatch]$ opatch lsinventory -all
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.2.0.3/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2012-07-03_04-16-12AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2012-07-03_04-16-12AM.txt

--------------------------------------------------------------------------------
List of Oracle Homes:
Name Location
OraGrid11gR3 /u01/app/11.2.0.3/grid
dbhome11203 /u01/app/oracle/product/11.2.0.3/dbhome_1

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 13696216 : applied on Fri Apr 06 20:16:57 PDT 2012
Unique Patch ID: 14600705
Patch description: "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Created on 3 Apr 2012, 22:02:51 hrs PST8PDT
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
13070939, 13035804, 10350832, 13632717, 13041324, 12919564, 13420224
13742437, 12861463, 12834027, 13742438, 13332439, 13036331, 13499128
12998795, 12829021, 13492735, 9873405, 13742436, 13503598, 12960925
12718090, 13742433, 12662040, 9703627, 12905058, 12938841, 13742434
12849688, 12950644, 13362079, 13742435, 12620823, 12917230, 12845115
12656535, 12764337, 13354082, 12588744, 11877623, 12612118, 12847466
13742464, 13528551, 12894807, 13343438, 12582664, 12780983, 12748240
12797765, 12780098, 13696216, 12923168, 13466801, 13772618, 11063191, 13554409

Patch 13696251 : applied on Fri Apr 06 20:14:59 PDT 2012
Unique Patch ID: 14600705
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.2 (13696251)"
Created on 5 Apr 2012, 07:21:52 hrs PST8PDT
Bugs fixed:
13696251, 13348650, 12659561, 13039908, 13036424, 12794268, 13011520
13569812, 12758736, 13077654, 13001901, 13430715, 12538907, 13066371
12594616, 12897651, 12897902, 12896850, 12726222, 12829429, 12728585
13079948, 12876314, 13090686, 12925041, 12995950, 13251796, 12398492
12848480, 13652088, 12990582, 12975811, 12917897, 13082238, 12947871
13037709, 13371153, 12878750, 11772838, 13058611, 13001955, 11836951
12965049, 13440962, 12765467, 13425727, 12885323, 12784559, 13332363
13074261, 12971251, 12857064, 13396284, 12899169, 13111013, 12867511
12639013, 13085732, 12829917, 12934171, 12849377, 12349553, 12914824
12730342, 13334158, 12950823, 13355963, 13531373, 13002015, 13024624, 12791719

Rac system comprising of multiple nodes
Local node = orclsys1
Remote node = orclsys2
--------------------------------------------------------------------------------
OPatch succeeded.
Grid listener.ora # location: /u01/app/11.2.0.3/grid/network/admin

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
Listener status # lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 30-JUN-2012 20:37:36

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 30-JUN-2012 20:16:14
Uptime 0 days 0 hr. 21 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0.3/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/orclsys1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.0.2.18)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.0.2.20)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
Grid listener status LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 30-JUN-2012 20:42:19

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN1
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                30-JUN-2012 20:16:14
Uptime                    0 days 0 hr. 26 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0.3/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0.3/grid/log/diag/tnslsnr/orclsys1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.0.2.16)(PORT=1521)))
Services Summary...
Service "orcl" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
  Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
  Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
/???/oak init #!/bin/sh
#
# init.oak - Control script for the oak
#
#
# Supported options:
# init.oak start Starts the oakd, and inittab starts monitoring it
# init.oak stop stops the oakd, but 'init.oak run' is in sleep state
# init.oak restart restarts the oakd process if 'init.oak' is running.
# init.oak shutdown shutdown the oakd. No monitoring from inittab
#

if [ -z "$CP" ]; then CP=/bin/cp; fi
if [ -z "$MV" ]; then MV=/bin/mv; fi
if [ -z "$CHOWN" ]; then CHOWN=/bin/chown; fi
if [ -z "$CHOWNH" ]; then CHOWNH="/bin/chown -h"; fi
if [ -z "$CHMOD" ]; then CHMOD=/bin/chmod; fi
if [ -z "$ECHO" ]; then ECHO=/bin/echo; fi
if [ -z "$CAT" ]; then CAT=/bin/cat; fi
if [ -z "$GREP" ]; then GREP=/bin/grep; fi
if [ -z "$SYNC" ]; then SYNC=/bin/sync; fi
if [ -z "$SLEEP" ]; then SLEEP=/bin/sleep; fi
if [ -z "$MODPROBE" ]; then MODPROBE=/sbin/modprobe; fi
if [ -z "$PERL" ]; then PERL=/usr/bin/perl; fi
if [ -z "$ID" ]; then ID=/usr/bin/id; fi
if [ -z "$EXPRN" ]; then EXPRN=/usr/bin/expr; fi


ORA_OAK_HOME=$ORA_OAK_HOME
if [ -z $ORA_OAK_HOME ]; then
   export ORA_OAK_HOME=/opt/oracle/oak
fi
CH=$ORA_OAK_HOME

UNAME=/bin/uname
PLATFORM='$UNAME'

case $PLATFORM in Linux)
       ID=/etc/init.d
       IT=/etc/inittab
       INIT=/sbin/init
       ;;
*)     /bin/echo "ERROR: Unknown Operating System"
       exit -1
       ;;
esac

# Definitions to Add/Remove inittab entries
ADDITAB="$CAT \$IT | $GREP -v init.oak > \$IT.no_oak || { $ECHO $?; exit 1; } ; \
        $CAT \$IT.no_oak $CH/install/inittab > \$IT.tmp || { $ECHO $?; exit 1; }; \
        $CP \$IT.tmp \$IT.oak || { $ECHO $?; exit 1; }; \
        \$SYNC ; \$SYNC ; \$SYNC ; \
        $MV \$IT.tmp \$IT || { $ECHO $?; exit 1; };\
        \$SYNC ; \$SYNC ; \$SYNC "
RMITAB="$CAT \$IT | $GREP -v init.oak > \$IT.tmp || { $ECHO $?; exit 1; } ; \
        $CP \$IT.tmp \$IT.no_oak || { $ECHO $?; exit 1; }; \
        \$SYNC ; \$SYNC ; \$SYNC ; \
        $MV \$IT.tmp \$IT || { $ECHO $?; exit 1; }; \
        \$SYNC ; \$SYNC ; \$SYNC "


# set the environment specific to oakd
export SUN_HMP_LIBS=/usr/lib64/sun-ssm-2.2/storagelibs/sdks/

export ORA_OAK_HOME
export ORA_CRS_HOME=$ORA_OAK_HOME
export ORA_NLS10=$ORA_OAK_HOME/nls/data
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORA_OAK_HOME/lib:$SUN_HMP_LIBS

# Variables which control the oakd restart attempts..
PREV_RESTART_TIME=0
RESTART_ATTEMPTS=3
FAILED_ATTEMPTS=0
RESTART_TIME_WINDOW=120
TIME_ELAPSED=0
TIME_OUT_WINDOW=86400

#This contains the required flag for the init.oak
AUTORUNFILE=$ORA_OAK_HOME/install/oakdrun

# Main loop

case $1 in
'run')
   # see if there is any init.oak running
   # there might be some stale init.oak running , if so remove it
    initoakpid='ps -ef | grep "init.oak run" | grep -v grep | awk '{print $2}''
    if [ $initoakpid ]; then
       eval $RMITAB
       $INIT q
       $SLEEP 3
       eval $ADDITAB
    fi

STARTUP_LOOP="true"
while ($START_LOOP)
do
  if [ -r $AUTORUNFILE ]
  then
    case '$CAT $AUTORUNFILE' in

      start*)
          $ECHO "Starting oakd.."
          $MODPROBE mptctl
          # copy init.oak to /etc/init.d
          $CP $CH/install/init.oak $ID/init.oak || { $ECHO $?; exit 1; }
          $CHMOD 777 $ID/init.oak || { $ECHO $?; exit 1; }
          # kill if there is any old oakd is running
          oakpid='ps -ef | grep "bin/oakd"| grep -v grep | awk '{print $2}''
          if [ $oakpid ]; then
            $ECHO "Killing the running oakd with pid $oakpid"
            kill -9 $oakpid
          fi
          #get the current time
          CURR_TIME='$PERL -e 'print time''
          $ORA_OAK_HOME/bin/oakd foreground

            TIME_ELAPSED='$EXPRN $CURR_TIME - $PREV_RESTART_TIME'

            # If it is crashed with in a short period then count it
            # as a failure
            if [ $TIME_ELAPSED -lt $RESTART_TIME_WINDOW ]; then
               FAILED_ATTEMPTS='$EXPRN $FAILED_ATTEMPTS + 1'
            fi

            # if it is crashed once in a while (once in 24hrs) do not consider them
            # as failures , and reset the fail count
            if [ $TIME_ELAPSED -gt $TIME_OUT_WINDOW ]; then
               FAILED_ATTEMPTS=0
            fi

            if [ $FAILED_ATTEMPTS -gt $RESTART_ATTEMPTS ]; then
              LOGFILE=$ORA_OAK_HOME/log/$HOSTNAME/oak/oakd.log
              CT=$(date)
              #Do not try to start it again
              $ECHO "ERROR: OAKD is spawning too fast, Human intervention required!!!" >> $LOGFILE
              $ECHO "Disabling OAKD at : $CT " >> $LOGFILE
              $ECHO "stop" > $AUTORUNFILE
              continue
            else
              PREV_RESTART_TIME=$CURR_TIME
            fi
            ;;

      stop*)
      $SLEEP 10
      ;;

      *)
      $ECHO "unknown entry in /opt/oracle/oak/install/oakdrun"
      START_LOOP="false"
      ;;
    esac
  fi
  done
;;


#These entries are for direct user control
'start')
   $ECHO "Starting oakd.."
   # copy init.oak to /etc/init.d
   $CP $CH/install/init.oak $ID/init.oak || { $ECHO $?; exit 1; }
   $CHMOD 777 $ID/init.oak || { $ECHO $?; exit 1; }
   # set the flag in oakdrun
   $ECHO "start" > $AUTORUNFILE
   # remove if there are old entries
   eval $RMITAB
   # kill if there is any old oakd is running
   oakpid='ps -ef | grep "bin/oakd"| grep -v grep | awk '{print $2}''
   if [ $oakpid ]; then
     $ECHO "Killing the running oakd with pid $oakpid"
     kill -9 $oakpid
   fi
   $INIT q
   $SLEEP 5
   # add the entries back and start the oak
   eval $ADDITAB
   $INIT q
   $SLEEP 10
   oakpid='ps -ef | grep "bin/oakd"| grep -v grep | awk '{print $2}''
   if [ $oakpid ]; then
     $ECHO "Successfully started the oakd.."
   fi
   ;;

'restart')
# see if init.oak is running
  initoakpid='ps -ef | grep "init.oak run"| grep -v grep | awk '{print $2}''
  if [ $initoakpid ]; then
$ECHO "Restarting the oakd.."
oakpid='ps -ef | grep "bin/oakd"| grep -v grep | awk '{print $2}''
  if [ $oakpid ]; then
    $ECHO "Killing the running oakd with pid $oakpid"
    kill -9 $oakpid
    fi
    $ECHO "start" > $AUTORUNFILE
  else
    $ECHO "Error: init.oak is not running to start oakd.."
    $ECHO "Run: 'init.oak start' to start the oakd"
  fi
  $SLEEP 10
  oakpid='ps -ef | grep "bin/oakd"| grep -v grep | awk '{print $2}''
  if [ $oakpid ]; then
    $ECHO "Successfully re-started the oakd.."
  fi
  ;;

'stop')
    $ECHO "Stopping oakd"
    # set the flags in oakdrun file.
    $ECHO "stop" > $AUTORUNFILE
    # kill oakd if it is running
    oakpid='ps -ef | grep "bin/oakd" | grep -v grep | awk '{print $2}''
    if [ $oakpid ]; then
        kill -9 $oakpid
    fi
    $SLEEP 3
    oakdpid='ps -ef | grep "bin/oakd"| grep -v grep | awk '{print $2}''
    if [ ! $oakdpid ]; then
      $ECHO "Successfully stop the oakd.."
    fi
    ;;

'shutdown')
    $ECHO "Shutting down oakd"
    # remove the entries from inittab
    eval $RMITAB
    $INIT q
    $SLEEP 5
    # Kill oakd if it is running
    oakpid='ps -ef | grep "bin/oakd" | grep -v grep | awk '{print $2}''
    if [ $oakpid ]; then
        kill -9 $oakpid
    fi
    $SLEEP 3
    oakdpid='ps -ef | grep "bin/oakd"| grep -v grep | awk '{print $2}''
    if [ ! $oakdpid ]; then
      $ECHO "Successfully shutdown the oakd.."
    fi
    ;;

*)
    $ECHO "Usage: $0 {stop|start|shutdown|restart}"
    exit 1;
    ;;
esac
/???/OCFS2 init #! /bin/bash
# Copyright (c) 2005 Oracle
# All rights reserved.
#
# chkconfig: 2345 25 19
# description: Mount OCFS2 volumes at boot.
#
### BEGIN INIT INFO
## Provides: ocfs2
## Required-Start: $network o2cb
## Required-Stop:
## X-UnitedLinux-Should-Start:
## X-UnitedLinux-Should-Stop:
## Default-Start: 2 3 5
## Default-Stop:
## Short-Description: Mount OCFS2 volumes at boot.
## Description: Mount OCFS2 volumes at boot.
### END INIT INFO

if [ -f /etc/redhat-release ]
then
. /etc/init.d/functions

init_status()
{
    return 0
}

success_status()
{
    success
    echo
}

failure_status()
{
    failure $1
    echo
}

exit_status()
{
exit $?
}
elif [ -f /etc/SuSE-release -o -f /etc/UnitedLinux-release ]
then
. /etc/rc.status

init_status()
{
    rc_reset
}

success_status()
{
/bin/true
    rc_status -v
}

failure_status()
{
/bin/false
    rc_status -v
}

exit_status()
{
    rc_exit
}
else
init_status()
{
    return 0
}

success_status()
{
    echo "OK"
    return 0
}

failure_status()
{
    echo "Failed"
    return 0
}

exit_status()
{
    exit $?
}
fi

ocfs2mounts()
{
    LC_ALL=C awk '$3 == "ocfs2" { print $2 }' /proc/mounts
}

ocfs2fstab()
{
    LC_ALL=C awk '!/^#/ && $3 == "ocfs2" && $4 !~ /noauto/ { print $2 }' /etc/fstab
}

init_status

FUSER='which fuser'

case "$1" in
    start|reload)
    if [ -d /var/lock/subsys ] ; then
        touch /var/lock/subsys/ocfs2
    fi
    if [ -n "'ocfs2fstab'" ] ; then
    echo -n "Starting Oracle Cluster File System (OCFS2) "
        mount -at ocfs2
            if [ $? = 0 ]
            then
                success_status
            else
                failure_status "Unable to mount OCFS2 filesystems"
            fi
        fi
        ;;
    stop)
        echo -n "Stopping Oracle Cluster File System (OCFS2) "
        remaining="'ocfs2mounts'"
        sig=
        retry=3
        while [ -n "$remaining" -a "$retry" -gt 0 ]
        do
            if [ "$retry" -lt 3 ]; then
                echo -n "Retry stopping Oracle Cluster File System (OCFS2) "
            fi
            umount -a -t ocfs2 2>/dev/null
            sleep 1

            remaining="'ocfs2mounts'"
            [ -z "$remaining" ] && break
            failure_status "Unable to unmount OCFS2 filesystems"

            $FUSER -km $sig $remaining >/dev/null
            sleep 5
            retry=$(($retry - 1))
            sig=-9
        done
        if [ -z "$remaining" ] && [ -e /var/lock/subsys/ocfs2 ] ; then
            rm /var/lock/subsys/ocfs2
        fi
        [ -z "$remaining" ] && success_status
        ;;
    restart|force-reload)
        $0 stop
        $0 start
        ;;
    status)
        if [ -f /proc/mounts ] ; then
            [ -n "'ocfs2fstab'" ] && {
                echo "Configured OCFS2 mountpoints: " 'ocfs2fstab'
            }

            [ -n "'ocfs2mounts'" ] && {
                echo "Active OCFS2 mountpoints: " 'ocfs2mounts'
            }
        else
            echo -n "Checking OCFS2 mountpoints: "
            failure_status
        fi
        ;;
    try-restart|condrestart)
        $0 status
        if test $? = 0; then
            $0 restart
        fi
        ;;
    *)
        echo "Usage: $0 {start|stop|status|reload|force-reload|restart|try-restart}"
        exit 1
esac

exit_status
RDBMS directory tree [oracle@orclsys1 dbhome_1]$ cd /u01
[oracle@orclsys1 u01]$ ls -al
total 36
drwxr-xr-x  5 root oinstall  4096 Jun 19 23:57 .
drwxr-xr-x 25 root root      4096 Jun 30 20:13
..
drwxr-xr-x  6 root oinstall  4096 Jun 24 01:25
app
drwxrwxr-x  2 root root     16384 Jun  7 08:09
lost+found
drwxrwxr-x  3 root root      4096 Jun  7 16:54
var

[oracle@orclsys1 u01]$ cd app
[oracle@orclsys1 app]$ ls -al
total 24
drwxr-xr-x 6 root   oinstall 4096 Jun 24 01:25
.
drwxr-xr-x 5 root   oinstall 4096 Jun 19 23:57
..
drwxr-xr-x 3 root   oinstall 4096 Jun 24 00:58
11.2.0.3
drwxr-xr-x 8 grid   oinstall 4096 Jun 24 01:18
grid
drwxr-xr-x 7 oracle oinstall 4096 Jun 24 01:30
oracle
drwxrwx--- 5 grid   oinstall 4096 Jun 24 01:29
oraInventory

[oracle@orclsys1 app]$ cd oracle
[oracle@orclsys1 oracle]$ ls -al
total 28
drwxr-xr-x 7 oracle oinstall 4096 Jun 24 01:30
.
drwxr-xr-x 6 root   oinstall 4096 Jun 24 01:25
..
drwxr-x--- 3 oracle oinstall 4096 Jun 24 01:30
admin
drwxr-x--- 5 oracle oinstall 4096 Jun 24 01:39
cfgtoollogs
drwxr-xr-x 2 oracle oinstall 4096 Jun 24 01:39
checkpoints
drwxrwxr-x 3 oracle asmadmin 4096 Jun 24 01:30
diag
drwxr-xr-x 3 oracle oinstall 4096 Jun 24 01:25
product

[oracle@orclsys1 oracle]$ cd product
[oracle@orclsys1 product]$ ls -al
total 12
drwxr-xr-x 3 oracle oinstall 4096 Jun 24 01:25
.
drwxr-xr-x 7 oracle oinstall 4096 Jun 24 01:30
..
drwxr-xr-x 3 oracle oinstall 4096 Jun 24 01:25
11.2.0.3

[oracle@orclsys1 product]$ cd 11.2.0.3
[oracle@orclsys1 11.2.0.3]$ ls -al
total 12
drwxr-xr-x  3 oracle oinstall 4096 Jun 24 01:25
.
drwxr-xr-x  3 oracle oinstall 4096 Jun 24 01:25
..
drwxr-xr-x 78 oracle oinstall 4096 Jun 24 01:47
dbhome_1

[oracle@orclsys1 11.2.0.3]$ cd dbhome_1
[oracle@orclsys1 dbhome_1]$ ls -al
total 348
drwxr-xr-x 78 oracle oinstall  4096 Jun 24 01:47
.
drwxr-xr-x  3 oracle oinstall  4096 Jun 24 01:25
..
drwxr-xr-x  8 oracle oinstall  4096 Apr  6 20:11
apex
drwxr-xr-x  8 oracle oinstall  4096 Apr  6 20:10
assistants
drwxr-xr-x  2 oracle oinstall 12288 Jun 24 01:29
bin
drwxr-xr-x  9 oracle oinstall  4096 Apr  6 20:15
ccr
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:12
cdata
drwxr-xr-x  5 oracle oinstall  4096 Jun 24 01:29
cfgtoollogs
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:11
clone
drwxr-xr-x  2 oracle oinstall  4096 Apr  6 20:12
config
drwxr-xr-x  6 oracle oinstall  4096 Apr  6 20:10
crs
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:10
csmig
drwxr-xr-x  6 oracle oinstall  4096 Apr  6 20:12
css
drwxr-xr-x 10 oracle oinstall  4096 Apr  6 20:12
ctx
drwxr-xr-x  7 oracle oinstall  4096 Apr  6 20:10
cv
drwxr-xr-x  2 oracle oinstall  4096 Jun 30 20:16
dbs
drwxr-xr-x  2 oracle oinstall  4096 Apr  6 20:12
dc_ocm
drwxr-xr-x  4 oracle oinstall  4096 Jun 24 01:29
deinstall
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:10
demo
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:10
diagnostics
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:10
dv
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:10
emcli
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:12
EMStage
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:10
has
drwxr-xr-x  5 oracle oinstall  4096 Apr  6 20:13
hs
drwxr-xr-x  8 oracle oinstall  4096 Apr  6 20:10
ide
drwxr-xr-x  7 oracle oinstall  4096 Jun 24 01:46
install
drwxr-xr-x  2 oracle oinstall  4096 Apr  6 20:10
instantclient
drwxrwx--- 14 oracle oinstall  4096 Apr  6 20:14
inventory
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:11
j2ee
drwxr-xr-x  8 oracle oinstall  4096 Apr  6 20:10
javavm
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:12
jdbc
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:10
jdev
drwxr-xr-x  6 oracle oinstall  4096 Apr  6 20:12
jdk
drwxr-xr-x  2 oracle oinstall  4096 Apr  6 20:12
jlib
drwxr-xr-x 12 oracle oinstall  4096 Apr  6 20:12
ldap
drwxr-xr-x  4 oracle oinstall 12288 Jun 24 01:29
lib
drwxr-xr-x  4 oracle oinstall  4096 Jun 24 01:29
log
drwxr-xr-x  6 oracle oinstall  4096 Apr  6 20:10
md
drwxr-xr-x  2 oracle oinstall  4096 Apr  6 20:10
mesg
drwxr-xr-x  6 oracle oinstall  4096 Apr  6 20:12
mgw
drwxr-xr-x 11 oracle oinstall  4096 Apr  6 20:13
network
drwxr-xr-x  6 oracle oinstall  4096 Apr  6 20:10
nls
drwxr-xr-x 20 oracle oinstall  4096 Apr  6 20:10
oc4j
drwxr-xr-x  6 oracle oinstall  4096 Apr  6 20:10
odbc
drwxr-xr-x  5 oracle oinstall  4096 Apr  6 20:10
olap
drwxr-xr-x  9 oracle oinstall  4096 Jun 24 01:28
OPatch
drwxr-xr-x  7 oracle oinstall  4096 Apr  6 20:12
opmn
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:10
oracore
-rw-r-----  1 oracle oinstall    56 Jun 24 01:01
oraInst.loc
drwxr-----  3 oracle oinstall  4096 Jun 24 01:47
orclsys1.example.com_orcl1
drwxr-----  3 oracle oinstall  4096 Jun 30 20:14
orclsys1_orcl
drwxr-----  3 oracle oinstall  4096 Jun 24 01:45
orclsys2_orcl
drwxr-xr-x  8 oracle oinstall  4096 Apr  6 20:10
ord
drwxr-xr-x  8 oracle oinstall  4096 Jun 24 01:29
oui
drwxr-xr-x 26 oracle oinstall  4096 Apr  6 20:12
owb
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:10
owm
drwxr-x---  7 oracle oinstall  4096 Apr  6 23:07
.patch_storage
drwxr-xr-x  5 oracle oinstall  4096 Jun 24 01:29
perl
drwxr-xr-x  6 oracle oinstall  4096 Apr  6 20:10
plsql
drwxr-xr-x  7 oracle oinstall  4096 Apr  6 20:10
precomp
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:16
psu
drwxr-xr-x  7 oracle oinstall  4096 Apr  6 20:12
racg
drwxr-xr-x 13 oracle oinstall  4096 Apr  6 20:13
rdbms
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:10
relnotes
-rwxr-x---  1 oracle oinstall   658 Jun 24 01:29
root.sh
-rwxr-x---  1 oracle oinstall   658 Apr  6 20:13
root.sh.old
-rwxr-x---  1 oracle oinstall    10 Apr  6 20:10
root.sh.old.1
-rw-r--r--  1 oracle oinstall    10 Jun 24 01:28 root.sh.ouibak
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:10
scheduler
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:10
slax
drwxr-xr-x 13 oracle oinstall  4096 Apr  6 20:11
sqldeveloper
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:10
sqlj
drwxr-xr-x  7 oracle oinstall  4096 Apr  6 20:13
sqlplus
drwxr-xr-x  9 oracle oinstall  4096 Apr  6 20:12
srvm
drwxr-xr-x 15 oracle oinstall  4096 Apr  6 20:12
sysman
drwxr-xr-x  2 oracle oinstall  4096 Apr  6 20:11
timingframework
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:12
ucp
drwxr-xr-x  4 oracle oinstall  4096 Apr  6 20:10
uix
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:10
usm
drwxr-xr-x  2 oracle oinstall  4096 Apr  6 20:10
utl
drwxr-xr-x  3 oracle oinstall  4096 Apr  6 20:10
wwg
drwxr-xr-x  7 oracle oinstall  4096 Apr  6 20:10
xdk
/u01/app/oraInventory/orainst.loc inventory_loc=/u01/app/oraInventory
inst_group=oinstall
Oracle's idea of setting up redo logs. This is a recipe for disaster ... immediately add additional members to each of the groups. SQL> select group#, thread#, bytes, members, status
2 from v$log
3 order by 1,2;

    GROUP#    THREAD#      BYTES    MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
     1              1 2147483648          1 CURRENT
     2              1 2147483648          1 INACTIVE
     3              2 2147483648          1 CURRENT
     4              2 2147483648          1 INACTIVE
sqlnet.ora # location: /u01/app/11.2.0.3/grid/network/admin

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/app/grid
tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.3/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = orclsys-scan)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
 
Grid Configuration
Grid installation gridInst.pl
TBD
Grid ENV ORA_OAK_HOME=/opt/oracle/oak
HOSTNAME=orclsys1
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
OLDPWD=/home/grid
USER=grid
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;
  41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;
  31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;
  31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
ORACLE_SID=+ASM1
MAIL=/var/spool/mail/grid
PATH=/opt/oracle/oak/bin:/u01/app/11.2.0.3/grid/bin:.:/opt/oracle/oak/bin:/u01/app/11.2.0.3/grid/bin:.:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/grid/bin
INPUTRC=/etc/inputrc
PWD=/home/grid/files
LANG=en_US.UTF-8
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/home/grid
LOGNAME=grid
LESSOPEN=|/usr/bin/lesspipe.sh %s
DISPLAY=localhost:11.0
ORACLE_HOME=/u01/app/11.2.0.3/grid
G_BROKEN_FILENAMES=1
XAUTHORITY=/home/grid/.xauthGK0FmI
_=/bin/env
LISTENER_GRID.ORA LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent

LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
 
IPMI Commands
IPMI commands are substitutes for those usually executed via the ILOM GUI ipmi -h
[root@orclsys1 ~]# ipmitool -h
ipmitool version 1.8.10.4

usage: ipmitool [options...] <command>

       -h This help
       -V             Show version information
       -v             Verbose (can use multiple times)
       -c             Display output in comma separated format
       -d N           Specify a /dev/ipmiN device to use (default=0)
       -I intf        Interface to use
       -H hostname    Remote host name for LAN interface
       -p port Remote RMCP port [default=623]
       -U username    Remote session username
       -f file        Read remote session password from file
       -S sdr         Use local file for remote SDR cache
       -a             Prompt for remote password
       -e char        Set SOL escape character
       -C ciphersuite Cipher suite to be used by lanplus interface
       -k key         Use Kg key for IPMIv2 authentication
       -L level       Remote session privilege level [privilege levels:
                      CALLBACK, USER, OPERATOR, ADMINISTRATOR, OEM][default=ADMINISTRATOR]
                      Append a '+' to use name/privilege lookup in RAKP1
       -A authtype    Force use of auth type NONE, PASSWORD, MD2, MD5 or OEM
       -P password    Remote session password
       -E             Read password from IPMI_PASSWORD environment variable
       -m address     Set local IPMB address
       -b channel     Set destination channel for bridged request
       -l lun         Set destination lun for raw commands
       -t address     Bridge request to remote target address
       -o oemtype     Setup for OEM (use 'list' to see available OEM types)
       -O seloem      Use file for OEM SEL event descriptions

Interfaces:
       open           Linux OpenIPMI Interface [default]
       imb            Intel IMB Interface
       lan            IPMI v1.5 LAN Interface
       lanplus        IPMI v2.0 RMCP+ LAN Interface

Commands:
       raw            Send a RAW IPMI request and print response
       i2c            Send an I2C Master Write-Read command and print response
       spd            Print SPD info from remote I2C device
       lan            Configure LAN Channels
       chassis        Get chassis status and set power state
       power          Shortcut to chassis power commands
       event          Send pre-defined events to MC
       mc             Management Controller status and global enables
       sdr            Print Sensor Data Repository entries and readings
       sensor         Print detailed sensor information
       fru            Print built-in FRU and scan SDR for FRU locators
       sel            Print System Event Log (SEL)
       pef            Configure Platform Event Filtering (PEF)
       sol            Configure and connect IPMIv2.0 Serial-over-LAN
       tsol           Configure and connect with Tyan IPMIv1.5 Serial-over-LAN
       isol           Configure IPMIv1.5 Serial-over-LAN
       user           Configure Management Controller users
       channel        Configure Management Controller channels
       session        Print session information
       sunoem         OEM Commands for Sun servers
       kontronoem     OEM Commands for Kontron devices
       picmg          Run a PICMG/ATCA extended cmd
       fwum           Update IPMC using Kontron OEM Firmware Update Manager
       firewall       Configure Firmware Firewall
       shell          Launch interactive IPMI shell
       exec           Run list of commands from file
       set            Set runtime variable for shell and exec
       hpm            Update HPM components using PICMG HPM.1 file
Show Version Information [root@orclsys1 ~]# ipmitool -V
ipmitool version 1.8.10.4
System Event Log Verbose [root@orclsys1 ~]# ipmitool sel -v
SEL Information
Version : 2.0 (v1.5, v2 compliant)
Entries : 584
Free Space : 5850 bytes
Percent Used : 61%
Last Add Time : 07/03/2012 20:39:03
Last Del Time : Not Available
Overflow : false
Supported Cmds : 'Reserve' 'Get Alloc Info'
# of Alloc Units : 909
Alloc Unit Size : 18
# Free Units : 325
Largest Free Blk : 325
Max Record Size : 18
 
OAKCLI Configuration - Installation Related Commands
Apply
Note: The key at right is not real
oakcli apply <core_configuration_key> <file_location>
# /opt/oracle/oak/bin/oakcli apply ABC123DEF \home\oracle\config.txt
Configure Initial Network Connection before Bare Bones Installation oakcli configure firstnet
# cd /opt/oracle/oak/bin

# oakcli configure firstnet
Deploy using an existing configuration file oakcli deploy
# cd /opt/oracle/oak/bin

# oakcli deploy
Unpack oakcli unpack package <path_and_filename>
# ./oakcli unpack -package /stage/p12978712_21000_Linux-x86-64.zip
 
OAKCLI Miscellaneous Commands
LSIUTIL

Some of  the subsystem were delivered to Oracle by LSI Logic Corp. You can use LSIUtil with all Fibre Channel, SAS, and SCSI LSI Logic host board adapters (HBAs). LSIUtil enables you to perform tasks such as updating board firmware, scanning for connected devices, viewing configuration page information, running diagnostic tests, and displaying current system events and statistics.
The following are a some examples of using lsiutil from the documentation
# cd /opt/oracle/oak/bin

-- display the port settings and targets for port 1
# lsiutil -p 1 -i -s

-- display the targets found on all known ports
# lsiutil -s

-- force linkspeed to 1Gb on port 2
lsiutil -p 2 -l 1

-- set interrupt coalescing to a timeout of 200ms with a depth of 9 and to force N_Port topology on port 1
lsiutil -p 1 -c 200,9 -t 2
OAKCLI oakcli wrapper script.
# cd /opt/oracle/oak/bin
# ls -al oakcli.bin

-- file listing
#!/bin/sh
#
# Copyright (c) 2001, 2012, Oracle and/or its affiliates. All rights reserved.
#
# oakcli wrapper script.
#

# export ORA_OAK_HOME if it is set
if [ -z "$ORA_OAK_HOME" ]
then
  ORA_OAK_HOME=/opt/oracle/oak
fi
export ORA_OAK_HOME

LD_LIBRARY_PATH=$ORA_OAK_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

ORA_NLS10=$ORA_OAK_HOME/nls/data
export ORA_NLS10

if [ -z "$ORA_CRS_HOME" ]
then
ORA_CRS_HOME=/u01/app/11.2.0.3/grid
fi
export ORA_CRS_HOME

$ORA_OAK_HOME/bin/oakcli.bin "$@"
status=$?
exit $status
Package Log Files to ship to Oracle Support oakcli manage diagcollect
# cd /opt/oracle/oak/bin

# oakcli manage diagcollect
Update / Patch oakcli update -patch <patch_name>
# cd /opt/oracle/oak/bin

# oakcli update -patch 2.2.0.1.0
 
OAKCLI Validation Commands
Validate: Run All Checks oakcli validate -a
INFO: oak system information and Validations
RESULT:  System Software inventory details
Reading the metadata. It takes a while...
System Version Component Name  Installed Version    Supported Version
-------------- --------------- ------------------   -----------------
2.2.0.0.0
               Controller      05.00.29.00          Up-to-date
               Expander        0342                 Up-to-date
               SSD_SHARED      E125                 Up-to-date
               HDD_LOCAL       SA03                 Up-to-date
               HDD_SHARED      0A25                 Up-to-date
               ILOM            3.0.14.13.a r70764   Up-to-date
               BIOS            12010304             Up-to-date
               IPMI            1.8.10.4             Up-to-date
               HMP             2.2.0                Up-to-date
               OAK             2.2.0.0.0            Up-to-date
               OEL             5.8 Up-to-date
               GI_HOME         11.2.0.3.2(13696216,  No-update
               13696251)
               DB_HOME         11.2.0.3.2(13696216,  No-update
               13696251)
               ASR             Unknown               3.7

RESULT: System Information:-
Manufacturer:ORACLE CORPORATION
Product Name:SUN FIRE X4370 M2 SERVER
Serial Number:1146FMW00R

RESULT:  BIOS Information:-
Vendor:American Megatrends Inc.
Version:12010304
Release Date:06/19/2009
BIOS Revision:1.3
Firmware Revision:1.3

SUCCESS: Controller p1 has the IR Bypass mode set correctly
SUCCESS: Controller p2 has the IR Bypass mode set correctly
INFO:    Reading ilom data, may take short while..
INFO:    Read the ilom data. Doing Validations
RESULT:  System ILOM Version: 3.0.14.13.a r70764
RESULT:  System BMC firmware version 3.0
RESULT:  Powersupply PS0 V_IN=114 Volts I_IN=3.50 Amps V_OUT=12 Volts I_OUT=28.40 Amps
         IN_POWER=400 Watts OUT_POWER=340 Watts

RESULT:  Powersupply PS1 V_IN=114 Volts I_IN=3.25 Amps V_OUT=12 Volts I_OUT=28.40 Amps
         IN_POWER=370 Watts OUT_POWER=350 Watts

SUCCESS: Both the powersupply are ok and functioning
RESULT:  Cooling Unit FM0 fan speed F0=3900 RPM F1=3200 RPM
RESULT:  Cooling Unit FM1 fan speed F0=3900 RPM F1=3200 RPM
SUCCESS: Both the cooling unit are present
RESULT:  Processor P0 present Details:- Version:Intel(R) Xeon(R) CPU X5675 @ 3.07GHz
         Current Speed:3066 MHz Core Enabled:6 Thread Count:12

SUCCESS: All 6 memory modules of CPU P0 ok, each module is of Size:8192 MB Type:DDR3 Speed:1333
         MHz manufacturer:Samsung

RESULT:  Processor P1 present Details:- Version:Intel(R) Xeon(R) CPU X5675 @ 3.07GHz
         Current Speed:3066 MHz Core Enabled:6 Thread Count:12

SUCCESS: All 6 memory modules of CPU P1 ok, each module is of Size:8192 MB Type:DDR3 Speed:1333
         MHz manufacturer:Samsung

RESULT:  Total System Memory is 98929496 kB
SUCCESS: All OS Disks are present and in ok state
SUCCESS: All expander present and ok status
SUCCESS: All shared Disks are present and in ok state
RESULT:  Temperature System Board=35 degrees C||Riser Board=28 degrees C||Power Supply=25
         degrees C
INFO:    Checking Operating System Storage
SUCCESS: The OS disks have the boot stamp
RESULT:  Raid device /dev/md0 found clean
RESULT:  Raid device /dev/md1 found clean
RESULT:  Physical Volume /dev/md1 in VolGroupSys has 270213.84M out of total 499994.59M
RESULT:  Volumegroup VolGroupSys consist of 1 physical volumes,contains 4 logical volumes,
         has 0 volume snaps with total size of 499994.59M and free space of 270213.84M
RESULT:  Logical Volume LogVolOpt in VolGroupSys Volume group is of size 60.00G
RESULT:  Logical Volume LogVolRoot in VolGroupSys Volume group is of size 30.00G
RESULT:  Logical Volume LogVolSwap in VolGroupSys Volume group is of size 24.00G
RESULT:  Logical Volume LogVolU01 in VolGroupSys Volume group is of size 100.00G
RESULT:  Device /dev/mapper/VolGroupSys-LogVolRoot is mounted on / of type ext3 in (rw)
RESULT:  Device /dev/md0 is mounted on /boot of type ext3 in (rw)
RESULT:  Device /dev/mapper/VolGroupSys-LogVolOpt is mounted on /opt of type ext3 in (rw)
RESULT:  Device /dev/mapper/VolGroupSys-LogVolU01 is mounted on /u01 of type ext3 in (rw)
RESULT:  / has 25520 MB free out of total 29758 MB
RESULT:  /boot has 58 MB free out of total 99 MB
RESULT:  /opt has 51823 MB free out of total 59516 MB
RESULT:  /u01 has 83793 MB free out of total 99194 MB
INFO:    Checking Shared Storage
ERROR:   Multipath HDD_E0_S04 does not exist
RESULT:  Disk HDD_E0_S00_1137537659 path1 status active device sdc with status active path2
         status enabled device sdam with status active
SUCCESS: HDD_E0_S00_1137537659 has both the paths up and current active path is sdc
RESULT:  Disk HDD_E0_S01_1137772287 path1 status active device sdm with status active path2
         status enabled device sdaw with status active
SUCCESS: HDD_E0_S01_1137772287 has both the paths up and current active path is sdm
RESULT:  Disk HDD_E0_S05_1135619487 path1 status active device sdn with status active path2
         status enabled device sdax with status active
SUCCESS: HDD_E0_S05_1135619487 has both the paths up and current active path is sdn
RESULT:  Disk HDD_E0_S08_1135792215 path1 status active device sde with status active path2
         status enabled device sdao with status active
SUCCESS: HDD_E0_S08_1135792215 has both the paths up and current active path is sde
RESULT:  Disk HDD_E0_S09_1135802123 path1 status active device sdk with status active path2
         status enabled device sdau with status active
SUCCESS: HDD_E0_S09_1135802123 has both the paths up and current active path is sdk
RESULT:  Disk HDD_E0_S12_1135827487 path1 status active device sdf with status active path2
         status enabled device sdap with status active
SUCCESS: HDD_E0_S12_1135827487 has both the paths up and current active path is sdf<
RESULT:  Disk HDD_E0_S13_1135804119 path1 status active device sdl with status active path2
         status enabled device sdav with status active
SUCCESS: HDD_E0_S13_1135804119 has both the paths up and current active path is sdl
RESULT:  Disk HDD_E0_S16_1135664919 path1 status active device sdg with status active path2
         status enabled device sdaq with status active
SUCCESS: HDD_E0_S16_1135664919 has both the paths up and current active path is sdg
RESULT:  Disk HDD_E0_S17_1135602799 path1 status active device sdi with status active path2
         status enabled device sdas with status active
SUCCESS: HDD_E0_S17_1135602799 has both the paths up and current active path is sdi
RESULT: Disk HDD_E1_S02_1137581539 path1 status active device sdo with status active path2
         status enabled device sdaa with status active
SUCCESS: HDD_E1_S02_1137581539 has both the paths up and current active path is sdo
RESULT:  Disk HDD_E1_S03_1137509855 path1 status active device sdy with status active path2
         status enabled device sdak with status active
SUCCESS: HDD_E1_S03_1137509855 has both the paths up and current active path is sdy
RESULT:  Disk HDD_E1_S06_1135821887 path1 status active device sdp with status active path2
         status enabled device sdab with status active
SUCCESS: HDD_E1_S06_1135821887 has both the paths up and current active path is sdp
RESULT:  Disk HDD_E1_S07_1135801023 path1 status active device sdz with status active path2
         status enabled device sdal with status active
SUCCESS: HDD_E1_S07_1135801023 has both the paths up and current active path is sdz
RESULT:  Disk HDD_E1_S10_1135835919 path1 status active device sdq with status active path2
         status enabled device sdac with status active
SUCCESS: HDD_E1_S10_1135835919 has both the paths up and current active path is sdq
RESULT:  Disk HDD_E1_S11_1135804775 path1 status active device sdw with status active path2
         status enabled device sdai with status active
SUCCESS: HDD_E1_S11_1135804775 has both the paths up and current active path is sdw
RESULT:  Disk HDD_E1_S14_1135787679 path1 status active device sdr with status active path2
         status enabled device sdad with status active
SUCCESS: HDD_E1_S14_1135787679 has both the paths up and current active path is sdr
RESULT:  Disk HDD_E1_S15_1135794951 path1 status active device sdx with status active path2
         status enabled device sdaj with status active
SUCCESS: HDD_E1_S15_1135794951 has both the paths up and current active path is sdx
RESULT:  Disk HDD_E1_S18_1135740479 path1 status active device sds with status active path2
         status enabled device sdae with status active
SUCCESS: HDD_E1_S18_1135740479 has both the paths up and current active path is sds
RESULT:  Disk HDD_E1_S19_1135610547 path1 status active device sdu with status active path2
         status enabled device sdag with status active
SUCCESS: HDD_E1_S19_1135610547 has both the paths up and current active path is sdu
RESULT:  Disk SSD_E0_S20_805682621 path1 status active device sdh with status active path2
         status enabled device sdar with status active
SUCCESS: SSD_E0_S20_805682621 has both the paths up and current active path is sdh
RESULT:  Disk SSD_E0_S21_805682553 path1 status active device sdj with status active path2
         status enabled device sdat with status active
SUCCESS: SSD_E0_S21_805682553 has both the paths up and current active path is sdj
RESULT:  Disk SSD_E1_S22_805682628 path1 status active device sdt with status active path2
         status enabled device sdaf with status active
SUCCESS: SSD_E1_S22_805682628 has both the paths up and current active path is sdt
RESULT:  Disk SSD_E1_S23_805682605 path1 status active device sdv with status active path2
         status enabled  device sdah with status active
SUCCESS: SSD_E1_S23_805682605 has both the paths up and current active path is sdv
INFO:    Doing oak disk calibration checks
INFO:    About to run random read IOPS throughput tests for SASDisk
RESULT:  Random read throughput across all 19 SASDisk = 4074 IOPS
INFO:    About to run random read IOPS throughput tests for SSDDisk
RESULT:  Random read throughput across all 4 SSDDisk = 16068 IOPS
INFO:    About to run random read MBPS throughput tests for SASDisk
RESULT:  Random read throughput across all 19 SASDisk = 1890 MBPS
INFO:    About to run random read MBPS throughput tests for SSDDisk
RESULT:  Random read throughput across all 4 SSDDisk = 985 MBPS
INFO:    Completed IOPS tests for individual disks of type SASDisk
INFO:    Completed MBPS tests for individual disks of type SASDisk
INFO:    Completed IOPS tests for individual disks of type SSDDisk
INFO:    Completed MBPS tests for individual disks of type SSDDisk
INFO:    Completed all single disk tests
INFO:    Calibration results for SASDisk
RESULT:  Random read throughput of HDD_E0_S00_1137537659 is 306 IOPS 160 MBPS
RESULT:  Random read throughput of HDD_E0_S16_1135664919 is 309 IOPS 166 MBPS
RESULT:  Random read throughput of HDD_E1_S02_1137581539 is 302 IOPS 162 MBPS
RESULT:  Random read throughput of HDD_E1_S07_1135801023 is 308 IOPS 166 MBPS
RESULT:  Random read throughput of HDD_E1_S18_1135740479 is 308 IOPS 165 MBPS
RESULT:  Random read throughput of HDD_E0_S08_1135792215 is 307 IOPS 163 MBPS
RESULT:  Random read throughput of HDD_E0_S13_1135804119 is 307 IOPS 162 MBPS
RESULT:  Random read throughput of HDD_E0_S09_1135802123 is 310 IOPS 165 MBPS
RESULT:  Random read throughput of HDD_E1_S11_1135804775 is 309 IOPS 164 MBPS
RESULT:  Random read throughput of HDD_E1_S03_1137509855 is 306 IOPS 164 MBPS
RESULT:  Random read throughput of HDD_E0_S01_1137772287 is 307 IOPS 160 MBPS
RESULT:  Random read throughput of HDD_E0_S12_1135827487 is 308 IOPS 164 MBPS
RESULT:  Random read throughput of HDD_E1_S06_1135821887 is 309 IOPS 165 MBPS
RESULT:  Random read throughput of HDD_E0_S05_1135619487 is 300 IOPS 159 MBPS
RESULT:  Random read throughput of HDD_E1_S15_1135794951 is 307 IOPS 166 MBPS
RESULT:  Random read throughput of HDD_E0_S17_1135602799 is 308 IOPS 166 MBPS
RESULT:  Random read throughput of HDD_E1_S19_1135610547 is 309 IOPS 167 MBPS
RESULT:  Random read throughput of HDD_E1_S14_1135787679 is 310 IOPS 163 MBPS
RESULT:  Random read throughput of HDD_E1_S10_1135835919 is 312 IOPS 163 MBPS
INFO:    Calibration results for SSDDisk
RESULT:  Random read throughput of SSD_E0_S21_805682553 is 4235 IOPS 353 MBPS
RESULT:  Random read throughput of SSD_E0_S20_805682621 is 4244 IOPS 357 MBPS
RESULT:  Random read throughput of SSD_E1_S22_805682628 is 4247 IOPS 355 MBPS
RESULT:  Random read throughput of SSD_E1_S23_805682605 is 4271 IOPS 357 MBPS
INFO:    Doing oak network checks
RESULT:  Detected active link for interface eth0 with link speed 1000Mb/s
RESULT:  Detected active link for interface eth1 with link speed 1000Mb/s
RESULT:  Detected active link for interface eth2 with link speed 1000Mb/s
WARNING: No Link detected for interface eth3
WARNING: No Link detected for interface eth4
WARNING: No Link detected for interface eth5
WARNING: No Link detected for interface eth6
WARNING: No Link detected for interface eth7
WARNING: No Link detected for interface eth8
WARNING: No Link detected for interface eth9
INFO:    Checking bonding interface status
RESULT:  Bond interface bond0 is up configured in mode:fault-tolerance (active-backup) with
         current active interface as eth2
         Slave1 interface is eth2 with status:up Link fail count=0 Maccaddr:00:21:28:e8:62:f2
         Slave2 interface is eth3 with status:down Link fail count=0 Maccaddr:00:21:28:e8:62:f3
WARNING: Bond interface bond1 has the following current status:down
RESULT:  Bond interface bond1 is down configured in mode:fault-tolerance (active-backup) with
         current active interface as None
         Slave1 interface is eth4 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:01
         Slave2 interface is eth5 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:00
WARNING: Bond interface bond2 has the following current status:down
RESULT:  Bond interface bond2 is down configured in mode:fault-tolerance (active-backup) with
         current active interface as None
         Slave1 interface is eth6 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:03
         Slave2 interface is eth7 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:02
WARNING: Bond interface xbond0 has the following current status:down
RESULT:  Bond interface xbond0 is down configured in mode:fault-tolerance (active-backup) with
         current active interface as None
         Slave1 interface is eth8 with status:down Link fail count=0 Maccaddr:00:1b:21:c5:2b:d0
         Slave2 interface is eth9 with status:down Link fail count=0 Maccaddr:00:1b:21:c5:2b:d1
SUCCESS: eth0 is running 192.168.16.24
SUCCESS: eth1 is running 192.168.17.24
Validate: Run a Comma Delimited List of Validation Checks oakcli validate -c
[root@orclsys1 ~]# oakcli validate -c NetworkComponents
INFO: Doing oak network checks
RESULT: Detected active link for interface eth0 with link speed 1000Mb/s
RESULT: Detected active link for interface eth1 with link speed 1000Mb/s
RESULT: Detected active link for interface eth2 with link speed 1000Mb/s
WARNING: No Link detected for interface eth3
WARNING: No Link detected for interface eth4
WARNING: No Link detected for interface eth5
WARNING: No Link detected for interface eth6
WARNING: No Link detected for interface eth7
WARNING: No Link detected for interface eth8
WARNING: No Link detected for interface eth9
INFO: Checking bonding interface status
RESULT: Bond interface bond0 is up configured in mode:fault-tolerance (active-backup) with current active interface as eth2
       Slave1 interface is eth2 with status:up Link fail count=0 Maccaddr:00:21:28:e8:62:f2
       Slave2 interface is eth3 with status:down Link fail count=0 Maccaddr:00:21:28:e8:62:f3
WARNING: Bond interface bond1 has the following current status:down
RESULT:  Bond interface bond1 is down configured in mode:fault-tolerance (active-backup) with
         current active interface as None
         Slave1 interface is eth4 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:01
         Slave2 interface is eth5 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:00

WARNING: Bond interface bond2 has the following current status:down
RESULT:  Bond interface bond2 is down configured in mode:fault-tolerance (active-backup) with
         current active interface as None
         Slave1 interface is eth6 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:03
         Slave2 interface is eth7 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:02

WARNING: Bond interface xbond0 has the following current status:down
RESULT:  Bond interface xbond0 is down configured in mode:fault-tolerance (active-backup) with
         current active interface as None
         Slave1 interface is eth8 with status:down Link fail count=0 Maccaddr:00:1b:21:c5:2b:d0
         Slave2 interface is eth9 with status:down Link fail count=0 Maccaddr:00:1b:21:c5:2b:d1

SUCCESS: eth0 is running 192.168.16.24
SUCCESS: eth1 is running 192.168.17.24
Validate: Default System Checks oakcli validate -d
# oakcli validate -d -v

DEBUG: [parseArgs: running default checks
DEBUG: [runDefaultChecks: inside default checks fn
DEBUG: [runDefaultChecks: calling check function SystemComponents
INFO:  [oak system information and Validations
DEBUG:  [oakSystemInfo: oak system info
RESULT: [System Software inventory details
 Reading the metadata. It takes a while...
 System Version  Component Name   Installed Version     Supported Version
 --------------  ---------------  ------------------    -----------------
 2.2.0.0.0
                 Controller       05.00.29.00           Up-to-date
                 Expander         0342                  Up-to-date
                 SSD_SHARED       E125                  Up-to-date
                 HDD_LOCAL        SA03                  Up-to-date
                 HDD_SHARED       0A25                  Up-to-date
                 ILOM             3.0.14.13.a r70764    Up-to-date
                 BIOS             12010304              Up-to-date
                 IPMI             1.8.10.4              Up-to-date
                 HMP              2.2.0                 Up-to-date
                 OAK              2.2.0.0.0             Up-to-date
                 OEL              5.8                   Up-to-date
                 GI_HOME          11.2.0.3.2(13696216,  No-update
                                  13696251)
                 DB_HOME          11.2.0.3.2(13696216,  No-update
                                  13696251)
                 ASR              Unknown               3.7

DEBUG:   dmiSystemInfo: Getting dmidecode based system information and validations
RESULT:  System Information:-
         Manufacturer:ORACLE CORPORATION
         Product Name:SUN FIRE X4370 M2 SERVER
         Serial Number:1146FMW00R

RESULT:  BIOS Information:-
         Vendor:American Megatrends Inc.
         Version:12010304
         Release Date:06/19/2009
         BIOS Revision:1.3
         Firmware Revision:1.3

DEBUG:   checkControllerIRBypass: Checking the IR Bypass mode for the controllers
SUCCESS: Controller p1 has the IR Bypass mode set correctly
SUCCESS: Controller p2 has the IR Bypass mode set correctly
DEBUG:   ilomsdrInfo: checking ipmitool
INFO:    Reading ilom data, may take short while.
DEBUG:   ilomsdrInfo: built ilomdata DS
INFO:    Read the ilom data. Doing Validations
DEBUG:   validateIlomsdrInfo: running validations
RESULT:  System ILOM Version: 3.0.14.13.a r70764
RESULT:  System BMC firmware version 3.0
DEBUG:   validatePowerSupply: checking the powersupply of the system
RESULT:  Powersupply PS0 V_IN=114 Volts I_IN=3.38 Amps V_OUT=12 Volts I_OUT=28.20 Amps
         IN_POWER=380 Watts OUT_POWER=350 Watts

RESULT:  Powersupply PS1 V_IN=116 Volts I_IN=3.38 Amps V_OUT=12 Volts I_OUT=27 Amps
         IN_POWER=390
         Watts OUT_POWER=330 Watts

SUCCESS: Both the powersupply are ok and functioning
DEBUG:   validateFanStatus: checking the cooling unit of the system
RESULT:  Cooling Unit FM0 fan speed F0=3900 RPM F1=3200 RPM
RESULT:  Cooling Unit FM1 fan speed F0=4000 RPM F1=3400 RPM
SUCCESS: Both the cooling unit are present
DEBUG:   validateCpuMemory: running cpu and memory validations
DEBUG:   validateCpuMemory: system config type 2, doing validation
RESULT:  Processor P0 present Details:-
         Version:Intel(R) Xeon(R) CPU X5675 @ 3.07GHz
         Current Speed:3066 MHz Core Enabled:6 Thread Count:12

DEBUG:   validateCpuMemory: Checking memory status P0:D0
DEBUG:   validateCpuMemory: Memory module P0:D0 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P0:D1
DEBUG:   validateCpuMemory: Memory module P0:D1 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P0:D2
DEBUG:   validateCpuMemory: Memory module P0:D2 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P0:D3
DEBUG:   validateCpuMemory: Memory module P0:D3 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P0:D4
DEBUG:   validateCpuMemory: Memory module P0:D4 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P0:D5
DEBUG:   validateCpuMemory: Memory module P0:D5 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

SUCCESS: All 6 memory modules of CPU P0 ok, each module is of Size:8192 MB Type:DDR3
         Speed:1333 MHz manufacturer:Samsung

RESULT:  Processor P1 present Details:-
         Version:Intel(R) Xeon(R) CPU X5675 @ 3.07GHz
         Current Speed:3066 MHz Core Enabled:6 Thread Count:12

DEBUG:   validateCpuMemory: Checking memory status P1:D0
DEBUG:   validateCpuMemory: Memory module P1:D0 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P1:D1
DEBUG:   validateCpuMemory: Memory module P1:D1 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P1:D2
DEBUG:   validateCpuMemory: Memory module P1:D2 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P1:D3
DEBUG:   validateCpuMemory: Memory module P1:D3 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P1:D4
DEBUG:   validateCpuMemory: Memory module P1:D4 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

DEBUG:   validateCpuMemory: Checking memory status P1:D5
DEBUG:   validateCpuMemory: Memory module P1:D5 SIZE:8192 MB TYPE:DDR3 SPEED:1333 MHz
         Manufacturer:Samsung

SUCCESS: All 6 memory modules of CPU P1 ok, each module is of Size:8192 MB Type:DDR3
         Speed:1333 MHz manufacturer:Samsung

RESULT:  Total System Memory is 98929496 kB
DEBUG:   validateOSDisks: checking if all the OS disks are present
DEBUG:   validateOSDisks: checking status of RHDD0
DEBUG:   validateOSDisks: checking status of RHDD1
SUCCESS: All OS Disks are present and in ok state
DEBUG:   validateExpanders: checking if all the Shared disk expanders are present
DEBUG:   validateExpanders: checking status of SASEXP0
DEBUG:   validateExpanders: checking status of SASEXP1
SUCCESS: All expander present and ok status
DEBUG:   validateSharedDiskPresence: checking if all the shared disks are present
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD0
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD1
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD2
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD3
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD4
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD5
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD6
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD7
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD8
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD9
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD10
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD11
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD12
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD13
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD14
         validateSharedDiskPresenceAndState: checking status of HDD15
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD16
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD17
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD18
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD19
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD20
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD21
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD22
DEBUG:   validateSharedDiskPresenceAndState: checking status of HDD23
SUCCESS: All shared Disks are present and in ok state
DEBUG:   validateSystemTemperatur: checking the temperature of system components
RESULT:  Temperature System Board=35 degrees C||Riser Board=28 degrees C||Power Supply=26
         degrees C
DEBUG:   runDefaultChecks: calling check function OSDiskStorage
INFO:    Checking Operating System Storage
DEBUG:   oakOsDiskInfo: oak OS Storage check
DEBUG:   checkMBRstamp: OS disks -> sda sdb
DEBUG:   checkMBRstamp: Disk sda md5 value=8d02bda9f1ecb8f2f5b3a2b321b0f073
DEBUG:   checkMBRstamp: Disk sdb md5 value=8d02bda9f1ecb8f2f5b3a2b321b0f073
SUCCESS: The OS disks have the boot stamp
DEBUG:   validateRaidInfo: Checking raid device status
RESULT:  Raid device /dev/md0 found clean
RESULT:  Raid device /dev/md1 found clean
DEBUG:   validatePhysicalVolue: Checking physical volume status
RESULT:  Physical Volume /dev/md1 in VolGroupSys has 270213.84M out of total 499994.59M
DEBUG:   validateVolumegroup: Checking volume group status
RESULT:  Volumegroup VolGroupSys consist of 1 physical volumes,contains 4 logical volumes,
         has 0 volume snaps with total size of 499994.59M and free space of 270213.84M
DEBUG:   validateLogicalVolume: Checking logical volume status
RESULT:  Logical Volume LogVolOpt in VolGroupSys Volume group is of size 60.00G
RESULT:  Logical Volume LogVolRoot in VolGroupSys Volume group is of size 30.00G
RESULT:  Logical Volume LogVolSwap in VolGroupSys Volume group is of size 24.00G
RESULT:  Logical Volume LogVolU01 in VolGroupSys Volume group is of size 100.00G
DEBUG:   validateMountInfo: Checking filesystem mount info
RESULT:  Device /dev/mapper/VolGroupSys-LogVolRoot is mounted on / of type ext3 in (rw)
RESULT:  Device /dev/md0 is mounted on /boot of type ext3 in (rw)
RESULT:  Device /dev/mapper/VolGroupSys-LogVolOpt is mounted on /opt of type ext3 in (rw)
RESULT:  Device /dev/mapper/VolGroupSys-LogVolU01 is mounted on /u01 of type ext3 in (rw)
DEBUG:   validateFilesystemFreeSpace: Checking filesystem free space
RESULT:  / has 25517 MB free out of total 29758 MB
RESULT:  /boot has 58 MB free out of total 99 MB
RESULT:  /opt has 51819 MB free out of total 59516 MB
RESULT:  /u01 has 83788 MB free out of total 99194 MB
DEBUG:   runDefaultChecks: calling check function SharedStorage
INFO:    Checking Shared Storage
DEBUG:   oakvalidatelib::oaksharedstorageinfo::parseMultipathData: Parsing multipath output
DEBUG:   oakvalidatelib::oaksharedstorageinfo::validateMultipathData: Verifying multipath
         output
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S00 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E0_S00_1137537659 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S01 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E0_S01_1137772287 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S04 exist
ERROR:   Multipath HDD_E0_S04 does not exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S05 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E0_S05_1135619487 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S08 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E0_S08_1135792215 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S09 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E0_S09_1135802123 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S12 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E0_S12_1135827487 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S13 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E0_S13_1135804119 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S16 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E0_S16_1135664919 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E0_S17 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E0_S17_1135602799 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S02 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S02_1137581539 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S03 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S03_1137509855 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S06 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S06_1135821887 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S07 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S07_1135801023 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S10 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S10_1135835919 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S11 exist

DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S11_1135804775 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S14 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S14_1135787679 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S15 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S15_1135794951 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S18 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S18_1135740479 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         HDD_E1_S19 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found HDD_E1_S19_1135610547 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         SSD_E0_S20 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found SSD_E0_S20_805682621 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         SSD_E0_S21 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found SSD_E0_S21_805682553 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         SSD_E1_S22 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found SSD_E1_S22_805682628 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Checking if multipath disk
         SSD_E1_S23 exist
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkExists: Found SSD_E1_S23_805682605 existing
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E0_S00_1137537659

RESULT:  Disk HDD_E0_S00_1137537659 path1 status active device sdc with status active path2
         status enabled device sdam with status active
SUCCESS: HDD_E0_S00_1137537659 has both the paths up and current active path is sdc
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E0_S01_1137772287
RESULT:  Disk HDD_E0_S01_1137772287 path1 status active device sdm with status active path2
         status enabled device sdaw with status active
SUCCESS: HDD_E0_S01_1137772287 has both the paths up and current active path is sdm
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E0_S05_1135619487
RESULT:  Disk HDD_E0_S05_1135619487 path1 status active device sdn with status active path2
         status enabled device sdax with status active
SUCCESS: HDD_E0_S05_1135619487 has both the paths up and current active path is sdn
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E0_S08_1135792215
RESULT:  Disk HDD_E0_S08_1135792215 path1 status active device sde with status active path2
         status enabled device sdao with status active
SUCCESS: HDD_E0_S08_1135792215 has both the paths up and current active path is sde
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E0_S09_1135802123
RESULT:  Disk HDD_E0_S09_1135802123 path1 status active device sdk with status active path2
         status enabled device sdau with status active
SUCCESS: HDD_E0_S09_1135802123 has both the paths up and current active path is sdk
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E0_S12_1135827487
RESULT:  Disk HDD_E0_S12_1135827487 path1 status active device sdf with status active path2
         status enabled device sdap with status active
SUCCESS: HDD_E0_S12_1135827487 has both the paths up and current active path is sdf
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E0_S13_1135804119
RESULT:  Disk HDD_E0_S13_1135804119 path1 status active device sdl with status active path2
         status enabled device sdav with status active
SUCCESS: HDD_E0_S13_1135804119 has both the paths up and current active path is sdl
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E0_S16_1135664919
RESULT:  Disk HDD_E0_S16_1135664919 path1 status active device sdg with status active path2
         status enabled device sdaq with status active
SUCCESS: HDD_E0_S16_1135664919 has both the paths up and current active path is sdg
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E0_S17_1135602799
RESULT:  Disk HDD_E0_S17_1135602799 path1 status active device sdi with status active path2
         status enabled device sdas with status active
SUCCESS: HDD_E0_S17_1135602799 has both the paths up and current active path is sdi
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S02_1137581539
RESULT:  Disk HDD_E1_S02_1137581539 path1 status active device sdo with status active path2
         status enabled device sdaa with status active
SUCCESS: HDD_E1_S02_1137581539 has both the paths up and current active path is sdo
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S03_1137509855
RESULT:  Disk HDD_E1_S03_1137509855 path1 status active device sdy with status active path2
         status enabled device sdak with status active
SUCCESS: HDD_E1_S03_1137509855 has both the paths up and current active pathis sdy
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S06_1135821887
RESULT:  Disk HDD_E1_S06_1135821887 path1 status active device sdp with status active path2
         status enabled device sdab with status active
SUCCESS: HDD_E1_S06_1135821887 has both the paths up and current active path is sdp
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S07_1135801023
RESULT:  Disk HDD_E1_S07_1135801023 path1 status active device sdz with status active path2
         status enabled device sdal with status active
SUCCESS: HDD_E1_S07_1135801023 has both the paths up and current active path is sdz
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S10_1135835919
RESULT:  Disk HDD_E1_S10_1135835919 path1 status active device sdq with status active path2
         status enabled device sdac with status active
SUCCESS: HDD_E1_S10_1135835919 has both the paths up and current active path is sdq
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S11_1135804775
RESULT:  Disk HDD_E1_S11_1135804775 path1 status active device sdw with status active path2
         status enabled device sdai with status active
SUCCESS: HDD_E1_S11_1135804775 has both the paths up and current active path is sdw
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S14_1135787679
RESULT:  Disk HDD_E1_S14_1135787679 path1 status active device sdr with status active path2
         status enabled device sdad with status active
SUCCESS: HDD_E1_S14_1135787679 has both the paths up and current active path is sdr
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S15_1135794951
RESULT:  Disk HDD_E1_S15_1135794951 path1 status active device sdx with status active path2
         status enabled device sdaj with status active
SUCCESS: HDD_E1_S15_1135794951 has both the paths up and current active path is sdx
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S18_1135740479
RESULT:  Disk HDD_E1_S18_1135740479 path1 status active device sds with status active path2
         status enabled device sdae with status active
SUCCESS: HDD_E1_S18_1135740479 has both the paths up and current active path is sds
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         HDD_E1_S19_1135610547
RESULT:  Disk HDD_E1_S19_1135610547 path1 status active device sdu with status active path2
         status enabled device sdag with status active
SUCCESS: HDD_E1_S19_1135610547 has both the paths up and current active path is sdu
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         SSD_E0_S20_805682621
RESULT:  Disk SSD_E0_S20_805682621 path1 status active device sdh with status active path2
         status enabled device sdar with status active
SUCCESS: SSD_E0_S20_805682621 has both the paths up and current active path is sdh
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         SSD_E0_S21_805682553
RESULT:  Disk SSD_E0_S21_805682553 path1 status active device sdj with status active path2
         status enabled device sdat with status active
SUCCESS: SSD_E0_S21_805682553 has both the paths up and current active path is sdj
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         SSD_E1_S22_805682628
RESULT:  Disk SSD_E1_S22_805682628 path1 status active device sdt with status active path2
         status enabled device sdaf with status active
SUCCESS: SSD_E1_S22_805682628 has both the paths up and current active path is sdt
DEBUG:   oakvalidatelib::oaksharedstorageinfo::checkPaths: Checking the path status for
         SSD_E1_S23_805682605
RESULT:  Disk SSD_E1_S23_805682605 path1 status active device sdv with status active path2
         status enabled device sdah with status active
SUCCESS: SSD_E1_S23_805682605 has both the paths up and current active path is sdv
DEBUG:   runDefaultChecks: calling check function NetworkComponents
INFO:    Doing oak network checks
DEBUG:   oakNetworkInfo: oak network info
DEBUG:   checkLinkStatus: Checking link status
RESULT:  Detected active link for interface eth0 with link speed 1000Mb/s
RESULT:  Detected active link for interface eth1 with link speed 1000Mb/s
RESULT:  Detected active link for interface eth2 with link speed 1000Mb/s
WARNING: No Link detected for interface eth3
WARNING: No Link detected for interface eth4
WARNING: No Link detected for interface eth5
WARNING: No Link detected for interface eth6
WARNING: No Link detected for interface eth7
WARNING: No Link detected for interface eth8
WARNING: No Link detected for interface eth9
INFO:    Checking bonding interface status
RESULT:  Bond interface bond0 is up configured in mode:fault-tolerance (active-backup) with
         current active interface as eth2
   Slave1 interface is eth2 with status:up Link fail count=0 Maccaddr:00:21:28:e8:62:f2
   Slave2 interface is eth3 with status:down Link fail count=0 Maccaddr:00:21:28:e8:62:f3

WARNING: Bond interface bond1 has the following current status:down
RESULT:  Bond interface bond1 is down configured in mode:fault-tolerance (active-backup) with
         current active interface as None
   Slave1 interface is eth4 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:01
   Slave2 interface is eth5 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:00

WARNING: Bond interface bond2 has the following current status:down
RESULT:  Bond interface bond2 is down configured in mode:fault-tolerance (active-backup) with
         current active interface as None
   Slave1 interface is eth6 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:03
   Slave2 interface is eth7 with status:down Link fail count=0 Maccaddr:00:1b:21:9d:a0:02

WARNING: Bond interface xbond0 has the following current status:down
RESULT:  Bond interface xbond0 is down configured in mode:fault-tolerance (active-backup) with
         current active interface as None
   Slave1 interface is eth8 with status:down Link fail count=0 Maccaddr:00:1b:21:c5:2b:d0
   Slave2 interface is eth9 with status:down Link fail count=0 Maccaddr:00:1b:21:c5:2b:d1

DEBUG:   getNodeNum: successful in getting nodenumber 0
DEBUG:   checkPrivateIps: Checking private IPs
DEBUG:   checkPrivateIps: Validating eth0
SUCCESS: eth0 is running 192.168.16.24
DEBUG:   checkPrivateIps: Validating eth1
SUCCESS: eth1 is running 192.168.17.24
Validate: Create Output File oakcli validate -f
oakcli validate -d -f $HOME/oda_validate20120701.txt
Validate: Help oakcli validate -h
[root@orclsys1 ~]# oakcli validate -h
Usage:
 oakcli validate [-V | -l | -h]
 oakcli validate [-v] [-f absolute output_file_name] [-a | -d | -c check1[,check2]]
       ARGUMENTS:
               -v verbose output
               -f output_file_name.The output is sent to the file instead of standard output
               -a run all checks
               -d run only default checks.
               -c check1[,check2] run specific checks
               -l list the checks and description
               -V Print the Version
               -h print help
       EXAMPLES:
       oakcli validate -l
       oakcli validate -a
       oakcli validate -c DiskCalibration
       oakcli validate -c SystemComponents,NetworkComponents
Validate: List all system check options oakcli validate -l
[root@orclsys1 ~]# oakcli validate -l

        Checkname -- Description
        ========= ===========
        *SystemComponents  -- Validate system components based on ilom sensor data readings
        *OSDiskStorage     -- Validate OS disks and filesystem information
        *SharedStorage     -- Validate Shared storage and multipathing information
        DiskCalibration    -- Check disk performance with orion
        *NetworkComponents -- Validate public and private network components

* -- Default check
Validate: Verbose output oakcli validate -v
See -d Demo Above
Validate: Print tool version oakcli validate -V
[root@orclsys1 ~]# oakcli validate -V
oakvalidation Version=2.1.0
Validate: Demo oakcli validate -v -f /home/oracle/oakclival20120701.log -d
 
OAKCLI Storage Commands
Locate a specific ASM disk oakcli locate [-h] [diskname on | off]
[root@orclsys1 odachk]# oakcli locate -h
Usage:
oakcli locate disk <diskname> <on | off>
where:
-on   - turns on the LED of the given disk
-off  - turns off the LED of the given disk
Display controllers oakcli show controller <control_id>
[root@orclsys1 odachk]# oakcli show controller 1
Contoller [1] information:
        sun-controller-id = mpt2sas:1f:00.0
        sun-id = mpt2sas:1f:00.0
        sun-controller-manufacturer = LSI Logic
        sun-controller-model = 0x0072
        sun-card-manufacturer = LSI Logic
        sun-card-model = SG-SAS6-INT-Z
        pci-address = 1f:00.0
        pci-vendor-id = 0x00001000
        pci-device-id = 0x00000072
        pci-subvendor-id = 0x00001000
        pci-subdevice-id = 0x00003050
        sun-controller-type = SAS
        raid-pd-count = 0x0000001a
        raid-ld-count = 0
        sun-version-firmware = 05.00.29.00
        sun-version-bios = 07.05.09.00
        sun-version-nvdata = 05.02.00.22
        sun-serial-number = 500605b004428990
        sun-product-name = SGX-SAS6-INT-Z
        sun-bbu-state = 0
Display configuration for active CPU cores oakcli show core_config_key
[root@orclsys1 odachk]# oakcli show core_config_key
Optional core_config_key is not applied on this machine yet !
Display Disks oakcli show disk
[root@orclsys1 odachk]# oakcli show disk
        NAME            PATH            TYPE         STATE         STATE_DETAILS

        pd_00           /dev/sdam       HDD          ONLINE        Good
        pd_01           /dev/sdaw       HDD          ONLINE        Good
        pd_02           /dev/sdaa       HDD          ONLINE        Good
        pd_03           /dev/sdak       HDD          ONLINE        Good
        pd_04           /dev/sdan       HDD          UNINITIALIZED NewDiskInserted
        pd_05           /dev/sdax       HDD          ONLINE        Good
        pd_06           /dev/sdab       HDD          ONLINE        Good
        pd_07           /dev/sdal       HDD          ONLINE        Good
        pd_08           /dev/sdao       HDD          ONLINE        Good
        pd_09           /dev/sdau       HDD          ONLINE        Good
        pd_10           /dev/sdac       HDD          ONLINE        Good
        pd_11           /dev/sdai       HDD          ONLINE        Good
        pd_12           /dev/sdap       HDD          ONLINE        Good
        pd_13           /dev/sdav       HDD          ONLINE        Good
        pd_14           /dev/sdad       HDD          ONLINE        Good
        pd_15           /dev/sdaj       HDD          ONLINE        Good
        pd_16           /dev/sdaq       HDD          ONLINE        Good
        pd_17           /dev/sdas       HDD          ONLINE        Good
        pd_18           /dev/sdae       HDD          ONLINE        Good
        pd_19           /dev/sdag       HDD          ONLINE        Good
        pd_20           /dev/sdar       SSD          ONLINE        Good
        pd_21           /dev/sdat       SSD          ONLINE        Good
        pd_22           /dev/sdaf       SSD          ONLINE        Good
        pd_23           /dev/sdah       SSD          ONLINE        Good
Display Disk Groups oakcli show diskgroup
[root@orclsys1 odachk]# oakcli show diskgroup
DiskGroups
----------
DATA
RECO
REDO
Display Expanders oakcli show expander <expander_id>
[root@orclsys1 odachk]# oakcli show expander 0
Expander [0] information:
        sun-device-name = /dev/sg14
        scsi-vendor-id = SUN
        scsi-product-id = T4 Storage
        scsi-product-revision = 0342
        scsi-naa-scsi-target = 0x5080020000a4ab3d
        scsi-relative-target-port = 1
        sun-scsi-sat-device = 0
        sun-reset = 0
        ses-enclosure-id = 0
        ses-enclosure-service-proc-id = 1
        ses-enclosure-service-proc-count = 1
        ses-logical-id =
        ses-vendor-id = SUN
        ses-product-id = T4 Storage
        ses-product-revision = 0342
        ses-element-index = 14
        ses-element-type = 14
        ses-class-description = Enclosure
        ses-status-code = 1
        ses-swapped = 0
        ses-disabled = 0
        ses-failure-predicted = 0
        ses-identify = 1
        ses-warning = 0
        ses-failed = 0
        ses-power-cycle-delay = 0
        ses-warning-indicator-requested = 0
        ses-failure-indicator-requested = 0
        ses-power-cycle-duration = 0
        ses-description = Enclosure
        ses-microcode-dl-status = 0
        ses-microcode-dl-addl-status = 0
        ses-microcode-maximum-size = 0x01000000
        ses-microcode-buffer-id = 0
        ses-microcode-buffer-offset = 0
        ses-nickname-status = 0x00000081
        ses-nickname-additional-status = 8
        ses-nickname =
        ses-nickname-language = 0
        libses-element-type-name = ENCLOSURE
        libses-chassis-serial = 5080020000a4ab00
        sun-is-internal = 1
        scsi-naa-logical-unit = 0x5080020000a4ab3d
        scsi-naa-target-port = 0x5080020000a4ab3d
        sun-chassis-id = 5080020000a4ab00
        sun-chassis-wwn = 5080020000a4ab00
        sun-chassis-expander-depth-count = 1
        sun-expander-wwn = 5080020000a4ab3d
        sun-expander-name = Primary
        sun-expander-index = 0
        sun-is-primary-path = 1
        sun-expander-fw-version-number = 0342
        sun-id = EC:mpt2sas:0d:00.0:5080020000a4ab3d
        sun-is-dual-of = EC:mpt2sas:1f:00.0:5080020000a4ab3d
Display Help oakcli show -h
[root@orclsys1 odachk]# oakcli -h
Usage: oakcli show - show storage, core_config_key, expander, controller, diskgroup, disk
oakcli locate      - locates a disk
oakcli apply       - applies the core_config_key
oakcli deploy      - deploys the Database Appliance
oakcli update      - updates the Database Appliance
oakcli validate    - validates the Database Appliance
oakcli manage      - manages the oak repository, diagcollect e.t.c
oakcli unpack      - unpack the given package to oak repository
oakcli configure   - configures the network
oakcli copy        - copies the deployment config file
Display Storage Device Status oakcli show storage
[root@orclsys1 odachk]# oakcli show storage
==== BEGIN STORAGE DUMP ========
Host Description: ORACLE CORPORATION:SUN FIRE X4370 M2 SERVER
Total number of controllers: 2
        Id = 0
        Serial Num = 500605b004429890
        Vendor = LSI Logic
        Model = SGX-SAS6-INT-Z
        FwVers = 05.00.29.00
        strId = mpt2sas:0d:00.0

        Id = 1
        Serial Num = 500605b004428990
        Vendor = LSI Logic
        Model = SGX-SAS6-INT-Z
        FwVers = 05.00.29.00
        strId = mpt2sas:1f:00.0

Total number of expanders: 2
        Id = 0
        Serial Num = 5080020000a4ab00
        Vendor = SUN
        Model = T4 Storage
        FwVers = 0342
        strId = Primary

        Id = 1
        Serial Num = 5080020000a4ab10
        Vendor = SUN
        Model = T4 Storage
        FwVers = 0342
        strId = Secondary

Total number of PDs: 24
        /dev/sdam SEAGATE HDD 600gb slot:  0 exp: 0
        /dev/sdaw SEAGATE HDD 600gb slot:  1 exp: 0
        /dev/sdaa SEAGATE HDD 600gb slot:  2 exp: 1
        /dev/sdak SEAGATE HDD 600gb slot:  3 exp: 1
        /dev/sdan SEAGATE HDD   0gb slot:  4 exp: 0
        /dev/sdax SEAGATE HDD 600gb slot:  5 exp: 0
        /dev/sdab SEAGATE HDD 600gb slot:  6 exp: 1
        /dev/sdal SEAGATE HDD 600gb slot:  7 exp: 1
        /dev/sdao SEAGATE HDD 600gb slot:  8 exp: 0
        /dev/sdau SEAGATE HDD 600gb slot:  9 exp: 0
        /dev/sdac SEAGATE HDD 600gb slot: 10 exp: 1
        /dev/sdai SEAGATE HDD 600gb slot: 11 exp: 1
        /dev/sdap SEAGATE HDD 600gb slot: 12 exp: 0
        /dev/sdav SEAGATE HDD 600gb slot: 13 exp: 0
        /dev/sdad SEAGATE HDD 600gb slot: 14 exp: 1
        /dev/sdaj SEAGATE HDD 600gb slot: 15 exp: 1
        /dev/sdaq SEAGATE HDD 600gb slot: 16 exp: 0
        /dev/sdas SEAGATE HDD 600gb slot: 17 exp: 0
        /dev/sdae SEAGATE HDD 600gb slot: 18 exp: 1
        /dev/sdag SEAGATE HDD 600gb slot: 19 exp: 1
        /dev/sdar STEC    SSD  73gb slot: 20 exp: 0
        /dev/sdat STEC    SSD  73gb slot: 21 exp: 0
        /dev/sdaf STEC    SSD  73gb slot: 22 exp: 1
        /dev/sdah STEC    SSD  73gb slot: 23 exp: 1
==== END STORAGE DUMP =========
Display Patch Versions of Software and Firmware

Add oakcli show server command
for the X4-2

also add
oakcli validate -c SystemComponents

oakcli update -patch 12.1.2.3.0 --verify

 
oakcli show version -detail
[root@orclsys1 odachk]# oakcli show version -detail
Reading the metadata. It takes a while...
System Version  Component Name    Installed Version    Supported Version
--------------  ---------------   ------------------   -----------------
2.2.0.0.0
                Controller        05.00.29.00           Up-to-date
                Expander          0342                  Up-to-date
                SSD_SHARED        E125                  Up-to-date
                HDD_LOCAL         SA03                  Up-to-date
                HDD_SHARED        0A25                  Up-to-date
                ILOM              3.0.14.13.a r70764    Up-to-date
                BIOS              12010304              Up-to-date
                IPMI              1.8.10.4              Up-to-date
                HMP               2.2.0                 Up-to-date
                OAK               2.2.0.0.0             Up-to-date
                OEL               5.8                   Up-to-date
                GI_HOME 1         1.2.0.3.2(13696216,   No-update
                                  13696251)
                DB_HOME           11.2.0.3.2(13696216,  No-update
                                  13696251)
                ASR Unknown 3.7
 
ODACHK
The tool is designed to audit various important configuration settings within an ODA system

Note misspellings (right) are Oracle's not mine.

As of this point-in-time still has not been truly modified for ODAs.
WHEN TO RUN THE TOOL
=====================
1. When the Grid Infrastructure and at least one database are all up and running
2. During times of least load on the system
3. After initial deployment
4. Before system maintenance
5. After system maintenance
6. Approximately every two months

the tool can be run with following arguments

1  -a - default, performs all checks
2. -o - for invoking optional functionality
v|verbose to display PASSing audit checks as well as non-PASSing eg., edachk -a -o v or edachk -a -o verbose

3. -v - returns the version of the tool
4. -s   silent, non-interactive mode
5. -S   silent, non-interactive mode
6. -m - suppresses the Maximum Availability Architecture Scorecard which is enabled by default in exachk
# cd /opt/oracle/oak/odachk

[root@orclsys1 odachk]# ./odachk -v

ODACHK VERSION: 2.1.4(DEV)_20120213

[root@orclsys1 odachk]# ./odachk verbose

CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /u01/app/11.2.0.3/grid?[y/n][y]
y

Checking ssh user equivalency setting on all nodes in cluster


Node orclsys2 is not configured for ssh user equivalency and the  script uses ssh to execu checks on remote nodes.

Without this facility the script cannot run audit checks on remote nodes.

If necessary due to security policies the script can be run individually on each node.


Do you want to configure SSH for user root on orclsys2 [y/n][y]
n
We can only configure ssh only for this run and reverse the changes back. do you want to continue?[y/n][y]
y

Checking if the remote hosts are reachable
PING orclsys2.example.com (192.0.2.19) 56(84) bytes of data.
64 bytes from orclsys2.example.com (192.0.2.19): icmp_seq=1 ttl=64 time=0.059 ms

--- orclsys2.example.com ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.059/0.059/0.059/0.000 ms
Remote host reachability check succeeded.
Confirmation provided on the command line
User chose to skip passphrase related questions.
Generating public/private dsa key pair.
Your identification has been saved in /root/.ssh/id_dsa.
Your public key has been saved in /root/.ssh/id_dsa.pub.
The key fingerprint is:
18:de:2d:45:74:a1:aa:50:84:7c:dc:ae:45:dc:ef:4b root@orclsys1
Warning: Permanently added 'orclsys2,192.0.2.19' (RSA) to the list of known hosts.
root@orclsys2's password:
Done with creating .ssh directory and setting permissions on remote host orclsys2.
root@orclsys2's password:
Done copying local host public key to the remote host orclsys2
SSH setup is complete.
Tue Jul 3 04:31:09 PDT 2012
------------------------------------------------------------------------
SSH verification complete.

odachk found that oracle software owner exists and its being run by root.

Please change ownership and permission for odachk and all accompanied files being root to rdbms software owner,login as rdbms software owner and run it again

# ./odachk -a -o verbose
 
ONECMD Perl Scripts
Agent Action Agent_actionScript.pl
#!/usr/bin/perl
#
# This is the script which the clusterware agent uses to manage the Dbconsole.
#
#
if ($#ARGV != 0) {
# This is an unreacheable condition
# Oracle Clusterware would always invoke with a valid argument
exit;
}
#
# Please set the $Oracle_Home to point to the RDBMS Home where the Db console is configured to run.
# And set the $Db_Name as the database name.
#
$command = $ARGV[0];
$Db_Name = "test";
$Oracle_Home = "/u01/app/oracle/product/11.2.0.3/dbhome_1";

# Start command

if ($command eq "start") {

system ("export ORACLE_UNQNAME=$Db_Name; $Oracle_Home/bin/emctl start dbconsole");
if ($? == 0) {
print "Db console started successfully \n";
exit 0;
}
else {
print "Failed to start the Dbconsole..\n";
exit 1
}
}


# Stop command

if ($command eq "stop") {
system ("export ORACLE_UNQNAME=$Db_Name; $Oracle_Home/bin/emctl stop dbconsole");
if ($? == 0) {
print "Db Console stopped successfully\n";
exit 0;
}
else {
print "Failed to stop the Dbconsole..\n";
exit 1
}

}

# Check command

if ($command eq "check") {
system ("export ORACLE_UNQNAME=$Db_Name");
$Agent_Status = 'export ORACLE_UNQNAME=$Db_Name; $Oracle_Home/bin/emctl status dbconsole|grep running';
if ($Agent_Status =~ "is running") {
print "Db Console is running..";
exit 0;
}
else {
print "Db Console is not reachable.";
exit 1;
}

}

# Clean command

if ($command eq "clean") {

$Agent_Pid = 'ps -ef|grep dbconsole|grep $Db_Name|grep -v grep|awk '{print \$2}'';
print "PID: $Agent_Pid";
system ("pkill -9 -P $Agent_Pid");
system ("cd $Oracle_Home; find -name emctl.pid -exec rm -f {} \\;");
if ($? == 0) {
print "Cleaned the agent successfully";
exit 0;
}
else {
print "Agent cleanup failed.";
exit 1;
}
}
Auto Service Request asrIlom.pl
#!/usr/bin/perl
#
# $Header: oak/src/provision/asrIlom.pl /main/5 2012/03/13 23:36:08 ssingla Exp $
#
# asrI.pl
#
# Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
#
# NAME
# asrI.pl - <one-line expansion of the name>
#
# DESCRIPTION
# <short description of component this file declares/defines>
#
# NOTES
# <other useful comments, qualifications, etc.>
#
# MODIFIED (MM/DD/YY)
# ssingla 03/04/12 - ilom new syntax
# ssingla 02/21/12 - XbranchMerge ssingla_bug-13721212 from
# st_oak_2.1.0.0.0
# ssingla 02/20/12 - asr trap notification
# ssingla 02/18/12 - perl path
# ssingla 02/17/12 - ASr ilom commands
# ssingla 02/17/12 - Creation
#
my $ASRCONF="/opt/oracle/oak/conf/asr.conf";
my $HOSTNAME='hostname -s';
chomp($HOSTNAME);
my $asrconfig="/var/opt/SUNWsasm/configuration/config.ini";
my $asrport=227;
my $asrconffile="/opt/oracle/oak/conf/asr.conf";

my $ilomTrycommandInterval=10;
my $ilomNumberOfTries=3;

sub asrIlomconfigChange
{
  my $asrmasterIP;
  if(! -e $asrconffile)
  {
    print "ASR not configured. Skipping ASR config steps\n";
    return;
  }

  $asrmasterIP=getASRMasterIP();
  if($asrmasterIP eq '')
  {
    print "Could not get the ASR master IP, skipping ASR config steps\n";
    return;
  }
# my @asrilomCommands=(
# "ipmitool -I open sunoem cli \"set /SP/alertmgmt/rules/1 level=minor\"",
# "ipmitool -I open sunoem cli \"set /SP/alertmgmt/rules/1 type=snmptrap\"",
# "ipmitool -I open sunoem cli \"set /SP/alertmgmt/rules/1 snmp_version=2c\"",
# "ipmitool -I open sunoem cli \"set /SP/alertmgmt/rules/1 community_or_username=public\"",
# "ipmitool -I open sunoem cli \"set /SP/alertmgmt/rules/1 destination=$asrmasterIP\"",
# "ipmitool -I open sunoem cli \"set /SP/alertmgmt/rules/1 destination_port=$asrport\""
# );

#ilom new syntax
  my @asrilomV2Commands=(
                     "ipmitool sunoem setval /X/alertmgmt/rules/1/level minor",
                     "ipmitool sunoem setval /X/alertmgmt/rules/1/type snmptrap",
                     "ipmitool sunoem setval /X/alertmgmt/rules/1/snmp_version 2c",
                     "ipmitool sunoem setval /X/alertmgmt/rules/1/community_or_username public",
                     "ipmitool sunoem setval /X/alertmgmt/rules/1/destination $asrmasterIP",
                     "ipmitool sunoem setval /X/alertmgmt/rules/1/destination_port $asrport"
                     );
  foreach my $cmd (@asrilomV2Commands)
  {
    print "Running $cmd\n";
    runIlomCommand($cmd);
  }
}

#runIlomCommand - Run the passed ilom command. If errror try after ilomTrycommandInterval and ilomNumberOfTries retries
sub runIlomCommand
{
  my $ilomCommand=shift;
  my $retryCount=0;

  while($retryCount < $ilomNumberOfTries)
  {
    $retryCount++;
    my $ilomCommandStatus='$ilomCommand 2>&1';
    chomp($ilomCommandStatus);
    if($ilomCommandStatus =~ /busy|timed out/i)
    {
      print "$ilomCommand timed out, sleeping for $ilomTrycommandInterval\n";
      sleep($ilomTrycommandInterval);
    }
    else
    {
      print "Successfully completed $ilomCommand\n";
      last;
    }
  }
}

#getASRMasterIP - read asr.conf and get the IP of the ASR master node
sub getASRMasterIP
{
  my $ip_info='';
  if(open(ASRSFILE, $asrconffile))
  {
  while (<ASRSFILE>) {
    my @data1 = split(/;\s*/, $_);
    if ($#data1 < 2) {
      print "Incompatible data \"$_\" in config file - $asrconffile\n";
      #ignore this value.
      }
      else {
        $ip_info = trim($data1[0]);
        last;
      }
    }
    close(ASRSFILE);
  }
  return $ip_info;
}

sub trim
{
  my $string = shift;
  $string =~ s/^\s+//;
  $string =~ s/\s+$//;
  return $string;
}

sub asrsettrapnotification
{

  my $asrManagerIP=getASRMasterIP();
  if($asrManagerIP eq '')
  {
    print "Could not get the ASR master IP, skipping ASR set trap nodtification steps\n";
    return;
  }

  #check if asr manager is installed on this node
  if(-e $asrconfig)
  {
    my $asrtrapnotification="/opt/SUNWswasr/bin/asr set_notification_trap -i $asrManagerIP -p $asrport -c public";
    system($asrtrapnotification);
  }
  else
  {
    print "ASR manager not installed skipping this asr notifcation trap step\n";
  }
}

asrIlomconfigChange();
asrsettrapnotification();
Deinstall and Reinitialize ... return ODA to its original bare metal configuration cleanupDeploy.pl
# cd /opt/oracle/oak/onecmd

# ./cleanupDeploy.pl
 
Registry Components
Default Installed Components SQL> col comp_name format a35
SQL> col version format a15
SQL> col status format a10

SQL> SELECT comp_name, version, status
     FROM dba_registry;

COMP_NAME                           VERSION         STATUS
----------------------------------- --------------- ----------
Oracle Database Catalog Views       11.2.0.3.0      VALID
Oracle Database Packages and Types  11.2.0.3.0      VALID
Oracle Enterprise Manager           11.2.0.3.0      VALID
Oracle Real Application Clusters    11.2.0.3.0      VALID
Oracle Workspace Manager            11.2.0.3.0      VALID
 
Security
STIG STIG Implementation Script for Oracle Database Appliance [ID 1461102.1]
STIG Documentation # stig.sh
#
# Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
#
# NAME
# stig.sh - <one-line expansion of the name>
#
# DESCRIPTION
# <short description of component this file declares/defines>
#
# NOTES
# This script can run by root user only.
# This script will harden OS configuration files. It has following option:
# help : Display help message"
# check : Check for presence of stig violations on system"
# fix : Fixes stig violations reported by check option"
# force : Force can be used only with fix option. It force script to rerun again
# even if it had already ran in the past on system"
# Every run of script generate a log file in dir /opt/oracle/oak/log/nodename/stig/
# Log file format:
# For check option: check-%Y-%m-%d-%H:%M:%S.log
# For fix option : fix-%Y-%m-%d-%H:%M:%S.log
#
# MODIFIED (MM/DD/YY)
# radyadav 06/12/12 - new file
# radyadav 06/12/12 - Creation
STIG run log 2012-06-28 01:18:12 : Running stig script version: '1.0'
2012-06-28 01:18:12 : Executing script : ./stig.sh -check
2012-06-28 01:18:12 : Checking for stig violations on system 'orclsys1'
2012-06-28 01:18:12 : List of Category-1 stig violation found by script
2012-06-28 01:18:12 : [STIG ID : LNX00140] : [CHECK] : Password for grub not enabled : FOUND
2012-06-28 01:18:12 : [STIG ID : GEN004640] : [CHECK] : sendmail decode command is not commented in /etc/aliases : FOUND
2012-06-28 01:18:12 : [STIG ID : LNX00320] : [CHECK] : Privilege account 'shutdown' is present : FOUND
2012-06-28 01:18:12 : [STIG ID : LNX00320] : [CHECK] : Privilege account 'halt' is present : FOUND
2012-06-28 01:18:12 : [STIG ID : LNX00580] : [CHECK] : Ctrl-Alt-Del combination to shutdown system is enabled : FOUND
2012-06-28 01:18:13 : [STIG ID : 2006-T-0013] : [CHECK] : RealVNC rpm is installed on system : FOUND
2012-06-28 01:18:13 : [STIG ID : LNX00040] : [CHECK] : Support for usb device found in kernel : FOUND
2012-06-28 01:18:13 : List of Category-2 stig violation found by script
2012-06-28 01:18:13 : [STIG ID : GEN000020] : [CHECK] : Single user mode boot is enabled without a password : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000340] : [CHECK] : Non privileged account oprofile found on system : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000340] : [CHECK] : Non privileged account avahi-autoipd found on system : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000460] : [CHECK] : pam_tally not used to lock account after 3 consecutive failed logins : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000800] : [CHECK] : remember not used in PAM configuration files : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000600] : [CHECK] : Force of at least one lower case character is not set for password : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000600] : [CHECK] : Force of at least one upper case character is not set for password : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000620] : [CHECK] : Force of at least one numeric character is not set for password : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000640] : [CHECK] : Force of at least one special character is not set for password : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000480] : [CHECK] : FAIL_DELAY is not present in /etc/login.defs : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000480] : [CHECK] : Login delay is not enabled in /etc/pam.d/system-auth : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000700] : [CHECK] : Maximum age for a password change is more than 60 days : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000540] : [CHECK] : Password can be changed more than once in 24 hours : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000580] : [CHECK] : Password length is less than 8 characters : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN001120] : [CHECK] : Direct login as root is enabled from ssh : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN001580] : [CHECK] : Permission of file /etc/init.d/init.oak is more permissive than octal 744 : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN002100] : [CHECK] : ekshell supported by the pam.rhost : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN002960] : [CHECK] : Access to cron is not through cron.allow and cron.deny : FOUND
2012-06-28 01:18:13 : [STIG ID : LNX00520] : [CHECK] : Permission of file /etc/sysctl.conf is more permissive than octal 600 : FOUND
2012-06-28 01:18:13 : [STIG ID : LNX00440] : [CHECK] : Permission of file /etc/security/access.conf is more permissive than octal 600 : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN003080] : [CHECK] : Permission of file /etc/crontab is more permissive than octal 600 : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN003200] : [CHECK] : Permission of file /etc/cron.deny is more permissive than octal 600 : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN005400] : [CHECK] : Permission of file /etc/syslog.conf is more permissive than octal 640 : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN005320] : [CHECK] : Permission of file /etc/snmp/snmpd.conf is more permissive than octal 640 : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN000920] : [CHECK] : Permission of directory /root is more permissive than octal 700 : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN003865] : [CHECK] : tcpdump rpm is installed on system : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN004000] : [CHECK] : Permission of file /bin/traceroute is more permissive than octal 700 : FOUND
2012-06-28 01:18:13 : [STIG ID : LNX00340] : [CHECK] : Unnecessary account ftp found on system : FOUND
2012-06-28 01:18:13 : [STIG ID : LNX00340] : [CHECK] : Unnecessary account games found on system : FOUND
2012-06-28 01:18:13 : [STIG ID : LNX00340] : [CHECK] : Unnecessary account news found on system : FOUND
2012-06-28 01:18:13 : [STIG ID : LNX00340] : [CHECK] : Unnecessary account operator found on system : FOUND
2012-06-28 01:18:13 : [STIG ID : LNX00340] : [CHECK] : Unnecessary account gopher found on system : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN004540] : [CHECK] : sendmail help command is enabled : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN006600] : [CHECK] : Permission of file /etc/xinetd.conf is more permissive than octal 440 : FOUND
2012-06-28 01:18:13 : [STIG ID : GEN006600] : [CHECK] : 21 files in directory '/etc/xinetd.d/' have permission which are more permissive than octal 440 : FOUND
2012-06-28 01:18:35 : [STIG ID : GEN005340] : [CHECK] : 5 MIB files in directory '/' have permission which are more permissive than octal 640 : FOUND
2012-06-28 01:18:35 : [STIG ID : GEN002480] : [CHECK] : 57 files in directory '/opt/oracle/oak/pkgrepos' have world writable permission of octal 777 or 666 : FOUND
2012-06-28 01:18:35 : List of Category-3 stig violation found by script
2012-06-28 01:18:35 : [STIG ID : GEN001280] : [CHECK] : 6059 manual pages in directory '/usr/share/man/' have permission which are more permissive than octal 640 : FOUND
2012-06-28 01:18:35 : [STIG ID : GEN001560] : [CHECK] : Permission of directory /home/grid/.mozilla/extensions is more permissive than octal 750 : FOUND
2012-06-28 01:18:35 : [STIG ID : GEN001560] : [CHECK] : Permission of directory /home/grid/.mozilla/plugins is more permissive than octal 750 : FOUND
2012-06-28 01:18:35 : [STIG ID : GEN001560] : [CHECK] : Permission of directory /home/oracle/.mozilla/extensions is more permissive than octal 750 : FOUND
2012-06-28 01:18:35 : [STIG ID : GEN001560] : [CHECK] : Permission of directory /home/oracle/.mozilla/plugins is more permissive than octal 750 : FOUND
2012-06-28 01:18:35 : [STIG ID : GEN004560] : [CHECK] : sendmail version is not hidden. : FOUND
 
System Statistics
System Stats Collection SELECT pname, pval1
FROM aux_stats$
WHERE sname = 'SYSSTATS_MAIN';

PNAME                               PVAL1
------------------------------ ----------
CPUSPEEDNW                     2730.90482
IOSEEKTIM                              10
IOTFRSPEED                           4096
SREADTIM
MREADTIM
CPUSPEED
MBRC
MAXTHR
SLAVETHR

exec dbms_stats.gather_system_stats('INTERVAL', 15);

-- lots of SQL executed here to push the system

exec dbms_stats.gather_system_stats('STOP');

SELECT pname, pval1
FROM aux_stats$
WHERE sname = 'SYSSTATS_MAIN';

PNAME                               PVAL1
------------------------------ ----------
CPUSPEEDNW                     2730.90482
IOSEEKTIM                              10
IOTFRSPEED                           4096
SREADTIM                            2.827
MREADTIM                            7.024
CPUSPEED                             2735
MBRC                                   89
MAXTHR
SLAVETHR
 
Notes
ASM For user grid: ORACLE_SID, could not connect to ASM instance, nor run asmcmd
Root Bash History exit
cd /opt/oracle/
l
ls -al
cd oak/
ls -al
pwd
cd in
cd bin
ls -al
cd ..
cd install
ls -al
cd ..
su oracle
su - oracle
ipmitool -I open sunoem cli "set /SP/network pendingipdiscovery=static pendingipaddress=192.0.2.100 pendingipgateway=192.0.2.1 pendingipnetmask=255.255.255.0 commitpending=true"
su - root
ls -al
xclock
xclock
ipmitool
cd /opt/oracle/oak/onecmd/tmp/
ls -alt
ls -al STEP*
tail -f STEPS-0-24-20120619235619.log
su - oracle
passwd oracle
exit
hostname
hostname
ifconfig -a
oakcli show version -detail
cd /tmp
ls -al
cd /opt
cd oracle
cd oak
cd bin
ls -al
oakcli show version -detail
./oakcli show version -detail
./oakcli show version -detail | more
ifconfig -a
ifconfig -a | more
ifconfig -a | more
ifconfig -a | more
ifconfig -a | more
pwd
oakcli
./oakcli configure firstnet
cd /
ls -al
ls -al | more
cd /opt
ls
cd oracle
ls
cd oak
ls
cd bin
ls -al | more
cd /software
cd /tmp
ls -al
cd ls -al
cd \ect
cd \etc
cat passwd
ls -al | more
su oracle
cd /tmp
ls -al
ls -al | more
/opt/oracle/oak/bin/oakcli unpack -package p12978712_22000_Linux-x86-64.zip
startx
/opt/oracle/oak/bin/oakcli deploy
top
crsctl stop cluster
crsctl status resource -t
crsctl status cluster
crsctl status cluster
crsctl status server
exit
chkconfig ntpd off
chkconfig --list ntpd
shutdown -r now
mv ntpd ntpd-disable
ps -ef | grep ntp
chkconfig --list ntpd
exit
chkconfig --list ntpd
ps -ef | grep ntpd
exit
mv ntp.conf ntp.conf.disable
mv ntp ntp.disable
exit
crsctl start cluster
crsctl stop cluster
exit
shutdown -r now
crsctl stop cluster
crsctl start cluster
exit
cd /var/log
ls -al
cat messages | grep -i error
cat * | grep -i error
exit
cd /opt/oracle/oak/onecmd
./cleanupDeploy.pl
xclock
xclock
xclock
cd /etc
cat hosts
cp hosts hosts.backup
vi hosts
xclock
cat hosts
cd /tmp
/opt/oracle/oak/bin/oakcli deploy
cd /tmp
/opt/oracle
ps -ef
xclock
/opt/oracle/oak/bin/oakcli deploy
ifconfig -a
ifconfig -a | more

ifconfig -a | more
ifconfig -a | more
  TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
  collisions:0 txqueuelen:0
  RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
eth0 Link encap:Ethernet HWaddr 00:21:28:E8:62:F6
  inet addr:192.168.16.24 Bcast:192.168.16.255 Mask:255.255.255.0
  inet6 addr: fe80::221:28ff:fee8:62f6/64 Scope:Link
  UP BROADCAST RUNNING MULTICAST MTU:9000 Metric:1
  RX packets:5 errors:0 dropped:0 overruns:0 frame:0
  TX packets:7 errors:0 dropped:0 overruns:0 carrier:0
  collisions:0 txqueuelen:1000
  RX bytes:300 (300.0 b) TX bytes:510 (510.0 b)
  Interrupt:28 Memory:dee80000-deea0000
eth1 Link encap:Ethernet HWaddr 00:21:28:E8:62:F7
  inet addr:192.168.17.24 Bcast:192.168.17.255 Mask:255.255.255.0
  inet6 addr: fe80::221:28ff:fee8:62f7/64 Scope:Link
  UP BROADCAST RUNNING MULTICAST MTU:9000 Metric:1
  RX packets:4 errors:0 dropped:0 overruns:0 frame:0
  TX packets:7 errors:0 dropped:0 overruns:0 carrier:0
  collisions:0 txqueuelen:1000
  RX bytes:240 (240.0 b) TX bytes:482 (482.0 b)
  Interrupt:40 Memory:deee0000-def00000
[root@oak1 ~]#
ifconfig -a
ifconfig -a | more
/opt/oracle/oak/bin/oakcli configure firstnet
ps -ef
ifconfig -a
ifconfig -a | more
ps -ef
date
crsctl status resource -t
su - grid
chkconfig --list ntpd
cd /etc
ls -al ntp*
date
chkconfig ntpd off
chkconfig --list ntpd
cd sysconf
cd /etc
cd sysconfig/
ls -al
cd ..
cat sysctl.conf
cd security/
cat limits.conf
cd ..
cat profile
cd /proc/sys
cd net/
cd ipv4/
l
ls -al
cat tcp_mem
pwd
cd ..
cd core/
ls -al
cd /home/oracle/
cat .bashrc
cat .bash_profile
ps -ef
su - grid
ocrcheck
exit
oakcli show version
oakcli -h
oakcli validate
exit
pwd
cd /home/oracle
./stig.sh -check
ls -al stig.sh
pwd
./stig.sh -check
chown root:root stig.sh
./stig.sh -check
mv stig.sh /root
cd /root
ls -al stig.sh
chmod 744 stig.sh
ls -al stig.sh
./stig.sh -check
cat stig.sh | more
cd /opt/oracle/oak/log/nodename/stig/
ls -alt
pwd
cd /opt/oracle/oak/log/
ls -al
cd orclsys1/
ls
cd stig/
ls -al
cat check-2012-06-28-01\:18\:12.log
pwd
ps -ef | grep scan
ps -ef | grep SCAN
exit
cd ~
ls -al
ocrcheck
exit
ocrcheck
exit
ocrcheck
exit
ocrcheck
exit
oakcli show version
cd /tmp
ls -al
ifconfig -a
ifconfig -a > ifconfig.txt
netstat -an
netstat -an > netstat.an.txt
uname
uname -a
uname -a > uname.txt
ls -al
pwd
ls *.txt
mv *.txt /home/oracle
ls -alt
cd /home/oracle
cd files
ls -al
cd ..
ls -al *.txt
mv *.txt files
cd files
ls -al
cat /etc/groups
cat /etc/group
cat /etc/group >group.txt
cat group.txt
cat /etc/passwd
cat /etc/passwd > passwd.txt
id oracle
id oracle >id.oracle.txt
id grid > id.grid.txt
exit
cp /etc/.profile etc_profile.txt
ls -al /etc/*profile*
cp /etc/profile etc_profile.txt
cat etc_profile.txt
cp /etc/sysctl.conf sysctl.conf
cp /etc/rc.local rc.local
cp /etc/modprobe.conf modprobe.conf
cp /etc/fstab fstab
cp /etc/hosts hosts
ls -al /etc/host*
cp /etc/security/limits.conf limits.conf
cp /etc/pam.d/login login
cat login
cat limits.conf
rpm -q
rpm -qa
rpm -qa > rpm.txt
vmstat
vmstat > vmstat.txt
iostat
iostat > iostat.txt
cd /etc
ls -al ora*
cat oratab
cp oratab /home/oracle/files oratab
cp oratab /home/oracle/files/oratab
cat oraInst.loc
cp oraInst.loc /home/oracle/files
cd oracle
ls -al
cat ocr.loc
cp ocr.log /home/oracle/files/
cp ocr.loc /home/oracle/files/
cp olr.loc /home/oracle/files/
cd lastgasp
ls -al
cat cssagent_orclsys1.lgl
cd ..
ls -al
cd ..
cd cron
ls -al cron*
cat crontab
ls -al cron*
ls -al cron* > /home/oracle/files/cron.ls.txt
cd cron.daily/
cat logrotate
cd /etc
cat logrotate.
cat logrotate.conf
cd /etc/init.d
ls -al
cd ..
ls -al init*
cat inittab
cp inittab /home/oracle/files
cd /etc/init.d
cat init.oak
cp init.oak /home/oracle/files
cp init.ohasd /home/oracle/files
ls -al
cd /etc/rc.d
ls -al
cd init.d
ls -al
cd ..
ls -al
cd rc5.d
ls -al
cat /home/oracle/files/inittab
ls -al
ls -al > /home/oracle/files/rc5.d.txt
cd ..
cd rc0.d
ls -al
ls -al > /home/oracle/files/rc0.d.txt
cd ..
cd ..
cd init.d
cp dbconsole /home/oracle/files/init.dbconsole.txt
cp oraclevalidated /home/oracle/files/init.oraclevalidated.txt
cp ocfs2 /home/oracle/files/init.ocfs2
exit
ocrcheck
ocrcheck > ocrcheck.txt
exit
grep Huge /proc/meminfo
grep MemFree /proc/meminfo
cat /proc/meminfo
cat /proc/meminfo /home/oracle/files/meminfo.txt
cat /proc/meminfo > /home/oracle/files/meminfo.txt
cat /home/oracle/files/meminfo.txt
cd /dev/shm/
ls -al
ls -al > /home/oracle/files/dev_shm.txt
exit
odachk
exit
ILOMless shutdown login as: root
root@192.0.2.18's password:
Last login: Tue Jul 3 03:30:13 2012 from 192.0.2.200
[root@orclsys1 ~]# shutdown now

Broadcast message from root (pts/0) (Tue Jul 3 05:11:34 2012):

The system is going down to maintenance mode NOW!
Start XWindows startx

Related Topics
DBA Best Practices
Control Files
Exadata
Log Files
Oracle Linux Installation 11.2.0.2
UNIX and vi

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved