| 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 |
|
||||
| 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 conmponent 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/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 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 | 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 | #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 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 -v sel 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 | 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 |
| 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-2013 Daniel A. Morgan All Rights Reserved | |||||||||
|
||||||||||
