HP OpenView System Administration Handbook [Electronic resources] : Network Node Manager, Customer Views, Service Information Portal, HP OpenView Operations

Tammy Zitello

نسخه متنی -صفحه : 276/ 159
نمايش فراداده

18.7 DATABASE REPORT

The computer output shown here is a listing from a report you can produce with the database utility program /opt/OV/bin/OpC/utils/opc_odc. This report gives you everything you need to know about the database immediately after installation or after periodic changes. The information collected by the program includes collecting data about the Oracle installation; detecting some Oracle problems and printing corresponding errors or warnings; listing the information about the database tablespaces, tables, and configuration; and listing database run-time parameters that determine utilization of the operating system resources. The output from executing the utility program is stored in the /tmp directory by default. The complete output is provided here for reference purposes. The database internal structure is subject to change by HP. Refer to the OVO Release Notes and OpenView database schema and entity relationship documentation for the most current information about the OVO database.

# ./opc_odc
Oracle data collector tool opc_odc.
Called on Sat Jan 10 19:24:51 PST 2004.
OS:  11.11
SYS: 9000/785/J5600
UNAME: lotus
HOSTNAME: lotus
PHYS. MEMORY: 1024 MB
SWAP: 2048 MB
Please enter the value for the ORACLE_SID [openview]:
Please enter the value for ORACLE_BASE [/opt/oracle]:
Please enter ORACLE_HOME [/opt/oracle/product/9.2.0]:
Checking connection to DB openview...
Can connect to database openview.
Dumping Oracle tables ..
Checking Oracle Errors in the Dump files ..
Checking sqlnet ..
opc_odc finished. See the logfile /tmp/opc_odc.log for a detailed 
protocol

The output from the opc_odc tool is shown here. Some of the output is summarized.

Oracle data collector tool opc_odc. Called on Sat Jan 10 12:15:59 PST 2004. OS: 11.11 SYS: 9000/785/J5600 UNAME: lotus HOSTNAME: lotus PHYS. MEMORY: 1024 MB SWAP: 2048 MB Checking existence of OV database OV database configuration file /etc/opt/OV/share/conf/ovdbconf: DB_VENDOR Oracle DB_NAME openview DB_RELEASE 9.2.0 DB_TIME_STAMP "Thu, Oct 9, 2003 03:34:42 AM" DB_USER ovdb ORACLE_SID openview ORACLE_HOME /opt/oracle/product/9.2.0 ORACLE_BASE /opt/oracle DBA_USER oracle DATA_DIR /ora_db CREATE_DIR /opt/oracle/admin/openview/create INDEX_DIR /ora_db ADMIN_DIR /opt/oracle OS_AUTHENT_PREFIX CHARACTER_SET WE8ISO8859P15 BASE_DATA_TS_SIZE 25 BASE_INDEX_TS_SIZE 5 DATA_TS_SIZE 25 INDEX_TS_SIZE TEMP_TS_SIZE 2 DATA_TS_EXTENT_SIZE 2 DATA_TS_MAX_SIZE 500 INDEX_TS_EXTENT_SIZE ECHO_CMD echo PROMPT TRUE DBA_PROGRAM sqlplus OV_USER ovdb DBA_LOGFILE /var/opt/OV/share/log/sqlplus_log ORACLE_BASE_REV 9 ORACLE_SECOND_REV 2 NLS_LANG american_america.WE8ISO8859P15 ITO_DATADIR /ora_db ITO_INDEXDIR /ora_db OpC configuration file /opt/OV/bin/OpC/install/opcsvinfo: # File: opcsvinfo # Description: Installation Information of ITO Management Server # Package: HP OpenView IT/Operations # # © Copyright 2003 Hewlett-Packard Development Company, L.P. OPC_INSTALLED_VERSION A.08.00.06 OPC_MGMT_SERVER lotus OPC_MGMTSV_CHARSET iso885915 OPC_INSTALLATION_TIME 10/09/03 03:27:01 OPC_SG FALSE DATABASE ov_net Oracle DBA user: oracle:APWUxRlsuHnvc:101:101:,,,:/home/oracle:/usr/bin/sh # # File: initopenview.ora # control_files = (/ora_db/control01.ctl, /ora_db/control02.ctl, /ora_db/control03.ctl) background_dump_dest = /opt/oracle/admin/openview/bdump core_dump_dest = /opt/oracle/admin/openview/cdump user_dump_dest = /opt/oracle/admin/openview/udump # log_archive_start = true # log_archive_dest = /opt/oracle/admin/openview/arch/ # log_archive_format ="T%TS%S.ARC"# if you want automatic archiving db_block_size = 8192 db_name = openview rollback_segments = (r01,r02,r03,r04) os_authent_prefix = " # tuning parameters db_files = 50 db_file_multiblock_read_count = 16 # MEDIUM db_block_buffers = 10000 # MEDIUM shared_pool_size = 128000000 # LARGE log_checkpoint_interval = 99999 processes = 50 # SMALL dml_locks = 100 # SMALL log_buffer = 65536 max_dump_file_size = 10240 #limit trace file size to 5 Meg ea open_cursors = 1024 compatible=9.0.0.0.0 sort_area_size=262144 # # End of file initopenview.ora # # # This file is used by ORACLE utilities. It is created by root.sh # and updated by the Database Configuration Assistant when creating # a database. # A colon, ':', is used as the field terminator. A new line terminates # the entry. Lines beginning with a pound sign, '#', are comments. # # Entries are of the form: # $ORACLE_SID:$ORACLE_HOME:<N|Y>: # # The first and second fields are the system identifier and home # directory of the database respectively. The third filed indicates # to the dbstart utility that the database should , "Y", or should not, # "N", be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # # # *:/opt/oracle/product/9.2.0:N *:/opt/oracle/product/9.2.0:N openview:/opt/oracle/product/9.2.0:N Checking connection to database openview as Oracle DBA. Checking connection to DB openview... Can connect to database openview. Checking connection to database as ITO user opc_op. OpC user: opc_op:*:777:77:OpC default operator:/home/opc_op:/usr/bin/ksh Can connect to database as user opc_op. Checking the ITO tables. All ITO tables exist. Dumping Oracle tables .. Total System Global Area 267479512 bytes Fixed Size 735704 bytes Variable Size 184549376 bytes Database Buffers 81920000 bytes Redo Buffers 274432 bytes NAME TYPE VALUE - - O7_DICTIONARY_ACCESSIBILITY boolean FALSE active_instance_count integer aq_tm_processes integer 0 archive_lag_target integer 0 audit_file_dest string ?/rdbms/audit audit_sys_operations boolean FALSE audit_trail string NONE background_core_dump string partial background_dump_dest string /opt/oracle/admin/openview/bdump backup_tape_io_slaves boolean FALSE bitmap_merge_area_size integer 1048576 blank_trimming boolean FALSE buffer_pool_keep string buffer_pool_recycle string circuits integer 0 cluster_database boolean FALSE cluster_database_instances integer 1 cluster_interconnects string commit_point_strength integer 1 compatible string 9.0.0.0.0 control_file_record_keep_time integer 7 control_files string /ora_db/control01.ctl, /ora_db/control02.ctl, /ora_db/control03.ctl core_dump_dest string /opt/oracle/admin/openview/cdump cpu_count integer 2 create_bitmap_area_size integer 8388608 cursor_sharing string EXACT cursor_space_for_time boolean FALSE db_16k_cache_size big integer 0 db_2k_cache_size big integer 0 NAME TYPE VALUE - db_32k_cache_size big integer 0 db_4k_cache_size big integer 0 db_8k_cache_size big integer 0 db_block_buffers integer 10000 db_block_checking boolean FALSE db_block_checksum boolean TRUE db_block_size integer 8192 db_cache_advice string ON db_cache_size big integer 0 db_create_file_dest string db_create_online_log_dest_1 string db_create_online_log_dest_2 string db_create_online_log_dest_3 string db_create_online_log_dest_4 string db_create_online_log_dest_5 string db_domain string db_file_multiblock_read_count integer 16 db_file_name_convert string db_files integer 50 db_keep_cache_size big integer 0 db_name string openview db_recycle_cache_size big integer 0 db_writer_processes integer 1 dblink_encrypt_login boolean FALSE dbwr_io_slaves integer 0 dg_broker_config_file1 string ?/dbs/dr1@.dat dg_broker_config_file2 string ?/dbs/dr2@.dat dg_broker_start boolean FALSE disk_asynch_io boolean TRUE dispatchers string distributed_lock_timeout integer 60 dml_locks integer 100 drs_start boolean FALSE enqueue_resources integer 205 event string fal_client string fal_server string fast_start_io_target integer 0 fast_start_mttr_target integer 0 fast_start_parallel_rollback string LOW file_mapping boolean FALSE filesystemio_options string asynch fixed_date string gc_files_to_locks string NAME TYPE VALUE - global_context_pool_size string global_names boolean FALSE hash_area_size integer 524288 hash_join_enabled boolean TRUE hi_shared_memory_address integer 0 HP-UX_sched_noage integer 0 hs_autoregister boolean TRUE ifile file instance_groups string instance_name string openview instance_number integer 0 java_max_sessionspace_size integer 0 java_pool_size big integer 33554432 java_soft_sessionspace_limit integer 0 job_queue_processes integer 0 large_pool_size big integer 0 license_max_sessions integer 0 license_max_users integer 0 license_sessions_warning integer 0 local_listener string lock_name_space string lock_sga boolean FALSE log_archive_dest string log_archive_dest_1 string log_archive_dest_10 string log_archive_dest_2 string log_archive_dest_3 string log_archive_dest_4 string log_archive_dest_5 string log_archive_dest_6 string log_archive_dest_7 string log_archive_dest_8 string log_archive_dest_9 string log_archive_dest_state_1 string enable log_archive_dest_state_10 string enable log_archive_dest_state_2 string enable log_archive_dest_state_3 string enable log_archive_dest_state_4 string enable log_archive_dest_state_5 string enable log_archive_dest_state_6 string enable log_archive_dest_state_7 string enable log_archive_dest_state_8 string enable log_archive_dest_state_9 string enable log_archive_duplex_dest string NAME TYPE VALUE - log_archive_format string %t_%s.dbf log_archive_max_processes integer 2 log_archive_min_succeed_dest integer 1 log_archive_start boolean FALSE log_archive_trace integer 0 log_buffer integer 65536 log_checkpoint_interval integer 99999 log_checkpoint_timeout integer 1800 log_checkpoints_to_alert boolean FALSE log_file_name_convert string log_parallelism integer 1 logmnr_max_persistent_sessions integer 1 max_commit_propagation_delay integer 700 max_dispatchers integer 5 max_dump_file_size string 10240 max_enabled_roles integer 30 max_rollback_segments integer 30 max_shared_servers integer 20 mts_circuits integer 0 mts_dispatchers string mts_listener_address string mts_max_dispatchers integer 5 mts_max_servers integer 20 mts_multiple_listeners boolean FALSE mts_servers integer 0 mts_service string openview mts_sessions integer 0 nls_calendar string nls_comp string nls_currency string nls_date_format string nls_date_language string nls_dual_currency string nls_iso_currency string nls_language string AMERICAN nls_length_semantics string BYTE nls_nchar_conv_excp string FALSE nls_numeric_characters string nls_sort string nls_territory string AMERICA nls_time_format string nls_time_tz_format string nls_timestamp_format string nls_timestamp_tz_format string NAME TYPE VALUE - object_cache_max_size_percent integer 10 object_cache_optimal_size integer 102400 olap_page_pool_size integer 33554432 open_cursors integer 1024 open_links integer 4 open_links_per_instance integer 4 optimizer_dynamic_sampling integer 1 optimizer_features_enable string 9.2.0 optimizer_index_caching integer 0 optimizer_index_cost_adj integer 100 optimizer_max_permutations integer 2000 optimizer_mode string CHOOSE oracle_trace_collection_name string oracle_trace_collection_path string ?/otrace/admin/cdf oracle_trace_collection_size integer 5242880 oracle_trace_enable boolean FALSE oracle_trace_facility_name string oracled oracle_trace_facility_path string ?/otrace/admin/fdf os_authent_prefix string os_roles boolean FALSE parallel_adaptive_multi_user boolean FALSE parallel_automatic_tuning boolean FALSE parallel_execution_message_size integer 2152 parallel_instance_group string parallel_max_servers integer 5 parallel_min_percent integer 0 parallel_min_servers integer 0 parallel_server boolean FALSE parallel_server_instances integer 1 parallel_threads_per_cpu integer 2 partition_view_enabled boolean FALSE pga_aggregate_target big integer 0 plsql_compiler_flags string INTERPRETED plsql_native_c_compiler string plsql_native_library_dir string plsql_native_library_subdir_count integer 0 plsql_native_linker string plsql_native_make_file_name string plsql_native_make_utility string plsql_v2_compatibility boolean FALSE pre_page_sga boolean FALSE processes integer 50 query_rewrite_enabled string false query_rewrite_integrity string enforced NAME TYPE VALUE - rdbms_server_dn string read_only_open_delayed boolean FALSE recovery_parallelism integer 0 remote_archive_enable string true remote_dependencies_mode string TIMESTAMP remote_listener string remote_login_passwordfile string NONE remote_os_authent boolean FALSE remote_os_roles boolean FALSE replication_dependency_tracking boolean TRUE resource_limit boolean FALSE resource_manager_plan string rollback_segments string r01, r02, r03, r04 row_locking string always serial_reuse string DISABLE serializable boolean FALSE service_names string openview session_cached_cursors integer 0 session_max_open_files integer 10 sessions integer 60 sga_max_size big integer 267479512 shadow_core_dump string partial shared_memory_address integer 0 shared_pool_reserved_size big integer 6710886 shared_pool_size big integer 134217728 shared_server_sessions integer 0 shared_servers integer 0 sort_area_retained_size integer 0 sort_area_size integer 262144 spfile string sql92_security boolean FALSE sql_trace boolean FALSE sql_version string NATIVE standby_archive_dest string ?/dbs/arch standby_file_management string MANUAL star_transformation_enabled string FALSE statistics_level string TYPICAL tape_asynch_io boolean TRUE thread integer 0 timed_os_statistics integer 0 timed_statistics boolean TRUE trace_enabled boolean TRUE tracefile_identifier string transaction_auditing boolean TRUE NAME TYPE VALUE - transactions integer 66 transactions_per_rollback_segment integer 5 undo_management string MANUAL undo_retention integer 900 undo_suppress_errors boolean FALSE undo_tablespace string use_indirect_data_buffers boolean FALSE user_dump_dest string /opt/oracle/admin/openview/udump utl_file_dir string workarea_size_policy string MANUAL TABLESPACE_ BLOCK INITIAL NEXT MIN MAX PCT NAME: SIZE EXTENT EXT EXT EXT INC SYSTEM 8192 16384 16384 505 50 0 TEMP 8192 106496 5242880 1 505 0 RBS1 8192 5242880 5242880 2 505 0 TOOLS 8192 106496 1048576 1 505 0 OPC_TEMP 8192 1048576 1048576 1 0 1048576 OPC_1 8192 65536 1 OPC_2 8192 65536 1 2147483645 65536 OPC_3 8192 65536 1 2147483645 6553 OPC_4 8192 65536 1 2147483645 65536 6 OPC_5 8192 65536 1 2147483645 65536 OPC_6 8192 65536 1 2147483645 65536 OPC_7 8192 65536 1 2147483645 65536 OPC_8 8192 65536 1 OPC_9 8192 65536 1 2147483645 65536 OPC_10 8192 65536 1 2147483645 65536 OPC_INDEX1 8192 65536 1 2147483645 65536 OPC_INDEX2 8192 65536 1 2147483645 65536 OPC_INDEX3 8192 65536 1 2147483645 65536 Note: The following database parameters are not shown in the summary output shown. STATUS, CONTENTS, LOGGING, FOR EXTENT,_MAN ALLOCATION, PLU, SEGMENT 18 rows selected. FILE FILE TABLESPACE BYTES_BLOCKS STATUS NAME ID NAME /ora_db/system_1.dbf 1 SYSTEM 125829120 15360 AVAILABLE /ora_db/temp_1.dbf 2 TEMP 2097152 256 AVAILABLE /ora_db/RBS1_1.dbf 3 RBS1 47185920 5760 AVAILABLE /ora_db/OPC_1_1.dbf 5 OPC_1 4194304 512 AVAILABLE /ora_db/OPC_2_1.dbf 6 OPC_2 5242880 640 AVAILABLE /ora_db/OPC_3_1.dbf 7 OPC_3 1048576 128 AVAILABLE /ora_db/OPC_4_1.dbf 8 OPC_4 27262976 3328 AVAILABLE /ora_db/OPC_5_1.dbf 9 OPC_5 1048576 128 AVAILABLE /ora_db/OPC_6_1.dbf 10 OPC_6 4194304 512 AVAILABLE /ora_db/OPC_7_1.dbf 11 OPC_7 4194304 512 AVAILABLE /ora_db/OPC_8_1.dbf 12 OPC_8 4194304 512 AVAILABLE /ora_db/OPC_9_1.dbf 13 OPC_9 6291456 768 AVAILABLE /ora_db/OPC_10_1.dbf 14 OPC_10 6291456 768 AVAILABLE /ora_db/OPC_INDEX1_1.dbf 15 OPC_INDEX1 13631488 1664 AVAIL. /ora_db/OPC_INDEX2_1.dbf 16 OPC_INDEX2 10485760 1280 AVAIL. /ora_db/OPC_INDEX3_1.dbf 17 OPC_INDEX3 10485760 1280 AVAIL. Note: The following database parameters are not shown in the summary listing. RELATIVE_FNO, AUT, MAXBYTES, MAXBLOCKS, INCREMENT_BY, USER_BYTES, USER_BLOCKS GROUP# STATUS TYPE MEMBER 1 STALE ONLINE /ora_db/redo01.log 2 STALE ONLINE /ora_db/redo02.log 3 ONLINE /ora_db/redo03.log TABLESPACE_NAME FREE_BLOCKS FREE_BYTE - OPC_1 472 3866624 OPC_10 744 6094848 OPC_2 600 4915200 OPC_3 48 393216 OPC_4 1344 11010048 OPC_5 120 983040 OPC_6 472 3866624 OPC_7 496 4063232 OPC_8 488 3997696 OPC_9 744 6094848 OPC_INDEX1 1512 12386304 OPC_INDEX2 1208 9895936 OPC_INDEX3 1256 10289152 RBS1 639 5234688 SYSTEM 98 802816 TEMP 255 2088960 TOOLS 127 1040384 17 rows selected. TABLESPACE_NAME, FILE_ID, BLOCK_ID, BYTES, BLOCKS, RELATIVE_FNO Note: The following parameters are not shown in the next section: INITIAL_EXTENT NEXT_EXTENT TABLE_NAME TABLESPACE_NAME - OPC_ACT_MESSAGES OPC_1 OPC_ACT_CUST_ATTRIB OPC_1 OPC_SERVICE OPC_10 OPC_SERVICE_LOG OPC_10 OPC_MSG_TEXT OPC_2 OPC_ORIG_MSG_TEXT OPC_2 OPC_ANNOTATION OPC_2 OPC_ANNO_TEXT OPC_2 OPC_NODE_NAMES OPC_3 OPC_NODE_ALT_NAME OPC_3 OPC_NODE_ALT_ADDR OPC_3 OPC_NODE_ALT_V6_ADDR OPC_3 OPC_USER_DATA OPC_4 OPC_CAPABILITIES OPC_4 OPC_OP_PROfiles OPC_4 TABLE_NAME TABLESPACE_NAME OPC_NODES OPC_4 OPC_CLUSTER_MAP OPC_4 OPC_NET_MACHINE OPC_4 OPC_CHSETS OPC_4 OPC_COMM_TYPE OPC_4 OPC_NET_SEC_TYPES OPC_4 OPC_PLTFRM_FAMILY OPC_4 OPC_AGENT_STATUS OPC_4 OPC_NODE_GROUPS OPC_4 OPC_NODES_IN_GROUP OPC_4 OPC_MESSAGE_GROUPS OPC_4 OPC_APPLICATION OPC_4 OPC_INTEGR_APPL OPC_4 OPC_APPL_LOGIN OPC_4 OPC_OV_APPL OPC_4 OPC_APPL_GROUPS OPC_4 OPC_APPL_NODE_LIST OPC_4 OPC_APPL_IN_GROUP OPC_4 OPC_APPLGRP_IN_GRP OPC_4 OPC_OP_REALM OPC_4 OPC_OP_DESK OPC_4 OPC_OP_GROUP_DESK OPC_4 OPC_AUDIT OPC_4 OPC_AUDIT_PARAM OPC_4 OPC_DB_MAINTENANCE OPC_4 OPC_NOTIF_SERVICES OPC_4 OPC_NOTIF_SCHEDULE OPC_4 OPC_TROUBLE_TICKET OPC_4 OPC_NODE_CONFIG OPC_4 OPC_NODE_DEFAULTS OPC_4 OPC_TEMP_OBJECT_LIST OPC_4 OPC_TEMP_APPL_LIST OPC_4 OPC_TEMP_MSGGRP_LIST OPC_4 OPC_TEMP_NODE_LIST OPC_4 OPC_TEMP_TEMPL OPC_4 OPC_INSTR_INTERF OPC_4 OPC_INSTRUCTIONS OPC_4 OPC_SYMBOLS OPC_4 OPC_ESCAL_ASSIGN_M OPC_4 OPC_APPRESP_ID_LST OPC_4 OPC_COND_OPER_LIST OPC_4 OPC_FORWARD_MSGS OPC_4 TABLE_NAME TABLESPACE_NAME OPC_TGRP_ON_NGRP OPC_4 OPC_TGRP_ON_NODE OPC_4 OPC_TEMPL_ON_NGRP OPC_4 OPC_TMPL_ON_NODE OPC_4 OPC_TGRP_IN_TGRP OPC_4 OPC_TEMPL_IN_TGRP OPC_4 OPC_TEMP_SERVICE_LIST OPC_4 OPC_APPL_PLATFORMS OPC_4 OPC_OP_BROWSER_SET_CMA OPC_4 OPC_CMA_NAMES OPC_4 OPC_COND_CUST_ATTRIB OPC_4 OPC_SERVICE_MSGS OPC_4 OPC_OP_SERVICES OPC_4 OPC_CHANGE_STATUS OPC_4 OPC_MSG_KEY_REL OPC_4 OPC_NODEHIER_LAYOUT OPC_4 OPC_NODEHIERS OPC_4 OPC_COND_STAT_VAR OPC_4 OPC_OP_BROWSER_SET_OBJ OPC_4 OPC_OP_BROWSER_SET OPC_4 OPC_MONITOR_COND OPC_4 OPC_TEMPL_GROUPS OPC_4 OPC_EC_SOURCE OPC_4 OPC_COND_TYPE_LIST OPC_4 OPC_MPI_REG_CONDS OPC_4 OPC_OPEN_MPIS OPC_4 OPC_MGMTSV_CONFIG OPC_4 OPC_NODE_PATTERN OPC_4 OPC_OP_OV_GEOMETRY OPC_4 OPC_OP_DEFAULTS OPC_4 OPC_OP_RUNTIME OPC_4 OPC_SOURCE_TEMPL OPC_4 OPC_TEMPL_STATUS OPC_4 OPC_TEMPL_OPTIONS OPC_4 OPC_LOGFILE_SOURCE OPC_4 OPC_CONSOLE_SOURCE OPC_4 OPC_INTERF_SOURCE OPC_4 OPC_MONITOR_SOURCE OPC_4 OPC_SCHED_SOURCE OPC_4 OPC_TRAP_SOURCE OPC_4 OPC_MSG_COND OPC_4 OPC_RGR_COND OPC_4 TABLE_NAME TABLESPACE_NAME OPC_TRAP_COND OPC_4 OPC_COND OPC_4 OPC_COND_SEV_LIST OPC_4 OPC_COND_APPL_LIST OPC_4 OPC_COND_MGRP_LIST OPC_4 OPC_COND_OBJ_LIST OPC_4 OPC_COND_NODE_LIST OPC_4 OPC_COND_TEXT OPC_4 OPC_SNMP_VARIABLES OPC_4 OPC_HIST_MESSAGES OPC_6 OPC_HIST_CUST_ATTRIB OPC_6 OPC_HIST_MSG_TEXT OPC_7 OPC_HIST_ORIG_TEXT OPC_8 OPC_HIST_ANNOTATION OPC_9 OPC_HIST_ANNO_TEXT OPC_9 OPC_TMP_VISIBLE_PROFILE OPC_TMP_VISIBLE_NODE OPC_TMP_VISIBLE_NODE2 OPC_TMP_VISIBLE_PATTERN OPC_TMP_VISIBLE_MSGGRP OPC_TMP_VALID_MSGGRP OPC_TMP_MISC_MSGGRP OPC_TMP_VISIBLE_SERVICE OPC_TMP_MSG_ID OPC_TMP_MSG_ID_SERVICE OPC_TMP_FILTER_APPL OPC_TMP_FILTER_OBJ OPC_TMP_FILTER_CMA OPC_TMP_FILTER_NODE OPC_TMP_FILTER_PATTERN OPC_TMP_FILTER_PATTERN_NODE OPC_TMP_FILTER_MSGGRP OPC_TMP_FILTER_SERVICE 132 rows selected. Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production JServer Release 9.2.0.2.0 - Production SQL> exit List of Tables with their Record Counts as of 10-JAN-04 12:20:18 Total Records in OPC_ACT_CUST_ATTRIB :: 0 Total Records in OPC_ACT_MESSAGES :: 139 Total Records in OPC_AGENT_STATUS :: 0 Total Records in OPC_ANNOTATION :: 60 Total Records in OPC_ANNO_TEXT :: 60 Total Records in OPC_APPLGRP_IN_GRP :: 20 Total Records in OPC_APPLICATION :: 201 Total Records in OPC_APPL_GROUPS :: 20 Total Records in OPC_APPL_IN_GROUP :: 201 Total Records in OPC_APPL_LOGIN :: 13 Total Records in OPC_APPL_NODE_LIST :: 21 Total Records in OPC_APPL_PLATFORMS :: 0 Total Records in OPC_APPRESP_ID_LST :: 4 Total Records in OPC_AUDIT :: 206 Total Records in OPC_AUDIT_PARAM :: 181 Total Records in OPC_CAPABILITIES :: 4 Total Records in OPC_CHANGE_STATUS :: 27 Total Records in OPC_CHSETS :: 37 Total Records in OPC_CLUSTER_MAP :: 0 Total Records in OPC_CMA_NAMES :: 0 Total Records in OPC_COMM_TYPE :: 12 Total Records in OPC_COND :: 1038 Total Records in OPC_COND_APPL_LIST :: 606 Total Records in OPC_COND_CUST_ATTRIB :: 0 Total Records in OPC_COND_MGRP_LIST :: 17 Total Records in OPC_COND_NODE_LIST :: 234 Total Records in OPC_COND_OBJ_LIST :: 7 Total Records in OPC_COND_OPER_LIST :: 4 Total Records in OPC_COND_SEV_LIST :: 1038 Total Records in OPC_COND_STAT_VAR :: 0 Total Records in OPC_COND_TEXT :: 2789 Total Records in OPC_COND_TYPE_LIST :: 4 Total Records in OPC_CONSOLE_SOURCE :: 1 Total Records in OPC_DB_MAINTENANCE :: 1 Total Records in OPC_EC_SOURCE :: 3 Total Records in OPC_ESCAL_ASSIGN_M :: 0 Total Records in OPC_FORWARD_MSGS :: 0 Total Records in OPC_HIST_ANNOTATION :: 0 Total Records in OPC_HIST_ANNO_TEXT :: 0 Total Records in OPC_HIST_CUST_ATTRIB :: 0 Total Records in OPC_HIST_MESSAGES :: 0 Total Records in OPC_HIST_MSG_TEXT :: 0 Total Records in OPC_HIST_ORIG_TEXT :: 0 Total Records in OPC_INSTRUCTIONS :: 2881 Total Records in OPC_INSTR_INTERF :: 0 Total Records in OPC_INTEGR_APPL :: 142 Total Records in OPC_INTERF_SOURCE :: 2 Total Records in OPC_LOGFILE_SOURCE :: 47 Total Records in OPC_MESSAGE_GROUPS :: 16 Total Records in OPC_MGMTSV_CONFIG :: 1 Total Records in OPC_MONITOR_COND :: 55 Total Records in OPC_MONITOR_SOURCE :: 45 Total Records in OPC_MPI_REG_CONDS :: 4 Total Records in OPC_MSG_COND :: 1773 Total Records in OPC_MSG_KEY_REL :: 23 Total Records in OPC_MSG_TEXT :: 216 Total Records in OPC_NET_MACHINE :: 8 Total Records in OPC_NET_SEC_TYPES :: 14 Total Records in OPC_NODEHIERS :: 1 Total Records in OPC_NODEHIER_LAYOUT :: 3 Total Records in OPC_NODES :: 2 Total Records in OPC_NODES_IN_GROUP :: 2 Total Records in OPC_NODE_ALT_ADDR :: 0 Total Records in OPC_NODE_ALT_NAME :: 0 Total Records in OPC_NODE_ALT_V6_ADDR :: 0 Total Records in OPC_NODE_CONFIG :: 18 Total Records in OPC_NODE_DEFAULTS :: 8 Total Records in OPC_NODE_GROUPS :: 2 Total Records in OPC_NODE_NAMES :: 3 Total Records in OPC_NODE_PATTERN :: 0 Total Records in OPC_NOTIF_SCHEDULE :: 0 Total Records in OPC_NOTIF_SERVICES :: 0 Total Records in OPC_OPEN_MPIS :: 4 Total Records in OPC_OP_BROWSER_SET :: 1 Total Records in OPC_OP_BROWSER_SET_CMA :: 0 Total Records in OPC_OP_BROWSER_SET_OBJ :: 2 Total Records in OPC_OP_DEFAULTS :: 4 Total Records in OPC_OP_DESK :: 21 Total Records in OPC_OP_GROUP_DESK :: 26 Total Records in OPC_OP_OV_GEOMETRY :: 12 Total Records in OPC_OP_PROfiles :: 0 Total Records in OPC_OP_REALM :: 79 Total Records in OPC_OP_RUNTIME :: 0 Total Records in OPC_OP_SERVICES :: 0 Total Records in OPC_ORIG_MSG_TEXT :: 156 Total Records in OPC_OV_APPL :: 54 Total Records in OPC_PLTFRM_FAMILY :: 2 Total Records in OPC_RGR_COND :: 0 Total Records in OPC_SCHED_SOURCE :: 0 Total Records in OPC_SERVICE :: 0 Total Records in OPC_SERVICE_LOG :: 0 Total Records in OPC_SERVICE_MSGS :: 0 Total Records in OPC_SNMP_VARIABLES :: 2 Total Records in OPC_SOURCE_TEMPL :: 103 Total Records in OPC_SYMBOLS :: 63 Total Records in OPC_TEMPL_GROUPS :: 33 Total Records in OPC_TEMPL_IN_TGRP :: 182 Total Records in OPC_TEMPL_ON_NGRP :: 0 Total Records in OPC_TEMPL_OPTIONS :: 100 Total Records in OPC_TEMPL_STATUS :: 0 Total Records in OPC_TEMP_APPL_LIST :: 0 Total Records in OPC_TEMP_MSGGRP_LIST :: 0 Total Records in OPC_TEMP_NODE_LIST :: 0 Total Records in OPC_TEMP_OBJECT_LIST :: 0 Total Records in OPC_TEMP_SERVICE_LIST :: 0 Total Records in OPC_TEMP_TEMPL :: 0 Total Records in OPC_TGRP_IN_TGRP :: 32 Total Records in OPC_TGRP_ON_NGRP :: 0 Total Records in OPC_TGRP_ON_NODE :: 3 Total Records in OPC_TMPL_ON_NODE :: 0 Total Records in OPC_TMP_FILTER_APPL :: 0 Total Records in OPC_TMP_FILTER_CMA :: 0 Total Records in OPC_TMP_FILTER_MSGGRP :: 0 Total Records in OPC_TMP_FILTER_NODE :: 0 Total Records in OPC_TMP_FILTER_OBJ :: 0 Total Records in OPC_TMP_FILTER_PATTERN :: 0 Total Records in OPC_TMP_FILTER_PATTERN_NODE :: 0 Total Records in OPC_TMP_FILTER_SERVICE :: 0 Total Records in OPC_TMP_MISC_MSGGRP :: 0 Total Records in OPC_TMP_MSG_ID :: 0 Total Records in OPC_TMP_MSG_ID_SERVICE :: 0 Total Records in OPC_TMP_VALID_MSGGRP :: 0 Total Records in OPC_TMP_VISIBLE_MSGGRP :: 0 Total Records in OPC_TMP_VISIBLE_NODE :: 0 Total Records in OPC_TMP_VISIBLE_NODE2 :: 0 Total Records in OPC_TMP_VISIBLE_PATTERN :: 0 Total Records in OPC_TMP_VISIBLE_PROFILE :: 0 Total Records in OPC_TMP_VISIBLE_SERVICE :: 0 Total Records in OPC_TRAP_COND :: 833 Total Records in OPC_TRAP_SOURCE :: 5 Total Records in OPC_TROUBLE_TICKET :: 1 Total Records in OPC_USER_DATA :: 4 Note: Index Detail, Referential Constraints, and Block Details are not shown in the summary output. *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Files in the Oracle Dump Destination ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Note the complete file listing is not shown in the summary output. /bin/ls -l /opt/oracle/admin/openview/bdump total 266 Checking Oracle Errors in the Dump files .. /opt/oracle/admin/openview/bdump/alert_openview.log:ORA-00130: invalid listener address ' (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))' /opt/oracle/admin/openview/bdump/alert_openview.log:ORA-00130: invalid listener address ' (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))' /opt/oracle/admin/openview/bdump/alert_openview.log:ORA-00130: invalid listener address ' (ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))' *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Dump last 200 Messages of alert_openview.log ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ tail -200 /opt/oracle/admin/openview/bdump/alert_openview.log background_dump_dest = /opt/oracle/admin/openview/bdump user_dump_dest = /opt/oracle/admin/openview/udump max_dump_file_size = 10240 core_dump_dest = /opt/oracle/admin/openview/cdump sort_area_size = 262144 db_name = openview open_cursors = 1024 os_authent_prefix = PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Mon Jan 12 00:03:49 2004 ALTER DATABASE MOUNT Mon Jan 12 00:03:53 2004 Successful mount of redo thread 1, with mount id 2485429285. Mon Jan 12 00:03:53 2004 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Mon Jan 12 00:03:54 2004 ALTER DATABASE OPEN Mon Jan 12 00:03:54 2004 Thread 1 opened at log sequence 101 Current log# 2 seq# 101 mem# 0: /ora_db/redo02.log Successful open of redo thread 1. Mon Jan 12 00:03:54 2004 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Mon Jan 12 00:03:54 2004 SMON: enabling cache recovery SMON: enabling tx recovery Mon Jan 12 00:03:55 2004 Database Characterset is WE8ISO8859P15 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN Sat Jan 10 18:46:46 2004 Shutting down instance: further logons disabled Shutting down instance (normal) License high water mark = 2 Sat Jan 10 18:46:46 2004 ALTER DATABASE CLOSE NORMAL Sat Jan 10 18:46:46 2004 SMON: disabling tx recovery SMON: disabling cache recovery Sat Jan 10 18:46:46 2004 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 101 Successful close of redo thread 1. Sat Jan 10 18:46:47 2004 Completed: ALTER DATABASE CLOSE NORMAL Sat Jan 10 18:46:47 2004 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sat Jan 10 18:55:55 2004 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 1 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.2.0. System parameters with non-default values: processes = 50 shared_pool_size = 134217728 control_files = /ora_db/control01.ctl, /ora_db/control02.ctl, /ora_db /control03.ctl db_block_buffers = 10000 db_block_size = 8192 compatible = 9.0.0.0.0 log_buffer = 65536 log_checkpoint_interval = 99999 db_files = 50 db_file_multiblock_read_count= 16 dml_locks = 100 rollback_segments = r01, r02, r03, r04 background_dump_dest = /opt/oracle/admin/openview/bdump user_dump_dest = /opt/oracle/admin/openview/udump max_dump_file_size = 10240 core_dump_dest = /opt/oracle/admin/openview/cdump sort_area_size = 262144 db_name = openview open_cursors = 1024 os_authent_prefix = PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sat Jan 10 18:55:57 2004 ALTER DATABASE MOUNT Sat Jan 10 18:56:01 2004 Successful mount of redo thread 1, with mount id 2485556221. Sat Jan 10 18:56:01 2004 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sat Jan 10 18:56:01 2004 ALTER DATABASE OPEN Sat Jan 10 18:56:02 2004 Thread 1 opened at log sequence 101 Current log# 2 seq# 101 mem# 0: /ora_db/redo02.log Successful open of redo thread 1. Sat Jan 10 18:56:02 2004 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Jan 10 18:56:02 2004 SMON: enabling cache recovery SMON: enabling tx recovery Sat Jan 10 18:56:02 2004 Database Characterset is WE8ISO8859P15 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN Starting ORACLE instance (normal) Sat Jan 10 20:13:44 2004 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 1 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.2.0. System parameters with non-default values: processes = 50 shared_pool_size = 134217728 control_files = /ora_db/control01.ctl, /ora_db/control02.ctl, /ora_db /control03.ctl db_block_buffers = 10000 db_block_size = 8192 compatible = 9.0.0.0.0 log_buffer = 65536 log_checkpoint_interval = 99999 db_files = 50 db_file_multiblock_read_count= 16 dml_locks = 100 rollback_segments = r01, r02, r03, r04 background_dump_dest = /opt/oracle/admin/openview/bdump user_dump_dest = /opt/oracle/admin/openview/udump max_dump_file_size = 10240 core_dump_dest = /opt/oracle/admin/openview/cdump sort_area_size = 262144 db_name = openview open_cursors = 1024 os_authent_prefix = PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sat Jan 10 20:13:46 2004 ALTER DATABASE MOUNT Sat Jan 10 20:13:51 2004 Successful mount of redo thread 1, with mount id 2485562682. Sat Jan 10 20:13:51 2004 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sat Jan 10 20:13:51 2004 ALTER DATABASE OPEN Sat Jan 10 20:13:51 2004 Beginning crash recovery of 1 threads Sat Jan 10 20:13:51 2004 Started first pass scan Sat Jan 10 20:13:52 2004 Completed first pass scan 89 redo blocks read, 12 data blocks need recovery Sat Jan 10 20:13:52 2004 Started recovery at Thread 1: logseq 101, block 961, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 2 Seq 101 Reading mem 0 Mem# 0 errs 0: /ora_db/redo02.log Sat Jan 10 20:13:53 2004 Ended recovery at Thread 1: logseq 101, block 1050, scn 0.1000291 12 data blocks read, 12 data blocks written, 89 redo blocks read Crash recovery completed successfully Sat Jan 10 20:13:54 2004 Thread 1 advanced to log sequence 102 Thread 1 opened at log sequence 102 Current log# 3 seq# 102 mem# 0: /ora_db/redo03.log Successful open of redo thread 1. Sat Jan 10 20:13:54 2004 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Jan 10 20:13:54 2004 SMON: enabling cache recovery SMON: enabling tx recovery Sat Jan 10 20:13:55 2004 Database Characterset is WE8ISO8859P15 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN Starting ORACLE instance (normal) Checking sqlnet .. *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Check net files in /etc ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ /bin/ls -l /etc/*.ora /etc/*.ora not found *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Check net files in /etc ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ more /etc/*.ora /etc/*.ora: No such file or directory *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Check net files in /opt/oracle/product/9.2.0/ network/admin/*.ora ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ /bin/ls -l /opt/oracle/product/9.2.0/network/admin/listener.ora / opt/oracle/product/9.2.0 /network/admin/snmp_ro.ora /opt/oracle/product/9.2.0/network/admin /snmp_rw.ora /opt/oracle /product/9.2.0/network/admin/sqlnet.ora /opt/oracle/product/9.2.0 /network/admin/tnsnames .ora /opt/oracle/product/9.2.0/network/admin/tnsnav.ora • rw-rr 1 root sys 715 Oct 9 03:49 /opt/oracle/product/9.2 .0/network/admin/listener.ora • rw-rw-r 1 oracle dba 86 Oct 7 10:57 /opt/oracle/product/9.2 .0/network/admin/snmp_ro.ora • rw-rw-r 1 oracle dba 0 Oct 7 10:57 /opt/oracle/product/9.2 .0/network/admin/snmp_rw.ora • rw-rr 1 root sys 352 Oct 9 03:49 /opt/oracle/product/9.2 .0/network/admin/sqlnet.ora • rw-rr 1 root sys 492 Oct 9 03:49 /opt/oracle/product/9.2 .0/network/admin/tnsnames.ora • rw-rr 1 root sys 275 Oct 9 03:49 /opt/oracle/product/9.2 .0/network/admin/tnsnav.ora *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Check net files in /opt/oracle/product/9.2.0.. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ more /opt/oracle/product/9.2.0/network/admin/listener.ora /opt/oracle/product/9.2.0 /network/admin/snmp_ro.ora /opt/ oracle/product/9.2.0/network/admin/snmp_rw.ora /opt/oracle/ product/9.2.0/network/admin/sqlnet.ora /opt/oracle/ product/9.2.0/network/admin/tnsnames.ora /opt/oracle/ product/9.2.0/network/admin/tnsnav.ora # FILENAME: listener.ora # DATE....: Jan 7 1999 # NETWORK.: openview # NODE....: Server # SERVICE.: LISTENER # COMMENT.: For use with HP OpenView IT/Operations LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL=IPC) (KEY= openview) ) (ADDRESS = (PROTOCOL = TCP) (HOST = lotus) (PORT = 1521) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 LOG_DIRECTORY_LISTENER = /opt/oracle/product/9.2.0/network/log LOG_FILE_LISTENER = listener SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME=openview) (ORACLE_HOME=/opt/oracle/product/9.2.0) ) ) TRACE_LEVEL_LISTENER = OFF snmp.visibleservices = () ifile = /opt/oracle/product/9.2.0/network/admin/snmp_rw.ora # FILENAME: sqlnet.ora # DATE....: Jan 7 1999 # NETWORK.: openview # NODE....: Client + Server # SERVICE.: C_OPENVIEW_COMMUNITY # COMMENT.: For use with HP OpenView IT/Operations TRACE_LEVEL_CLIENT = OFF TRACE_DIRECTORY_CLIENT = /opt/oracle/product/9.2.0/network/log LOG_DIRECTORY_CLIENT = /opt/oracle/product/9.2.0/network/log # FILENAME: tnsnames.ora # DATE....: Jan 7 1999 # NETWORK.: openview # NODE....: Client # SERVICE.: C_OPENVIEW_COMMUNITY # COMMENT.: For use with HP OpenView IT/Operations ov_net = (DESCRIPTION= (ADDRESS_LIST= (ADDRESS = (PROTOCOL = IPC)(KEY =openview)) (ADDRESS = (COMMUNITY=OPENVIEW_COMMUNITY) (PROTOCOL=TCP) (HOST=lotus) (PORT=1521) ) ) (CONNECT_DATA= (SID=openview) ) ) # FILENAME: tnsnav.ora # DATE....: Jan 7 1999 # NETWORK.: openview # NODE....: Client # SERVICE.: C_OPENVIEW_COMMUNITY # COMMENT.: For use with HP OpenView IT/Operations LOCAL_COMMUNITIES = (COMMUNITY_LIST = (COMMUNITY = OPENVIEW_COMMUNITY) ) *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Check TNS_ADMIN.. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ echo Checking Listener status ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ LSNRCTL for HP-UX: Version 9.2.0.2.0 - Production on 10-JAN-2004 12:20:41 Copyright © 1991, 2002, Oracle Corporation. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=openview)) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for HP-UX: Version 9.2.0.2.0 - Production Start Date 10-JAN-2004 12:13:32 Uptime 0 days 0 hr. 7 min. 9 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /opt/oracle/product/9.2.0/network/admin/listener.ora Listener Log File /opt/oracle/product/9.2.0/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=openview))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lotus)(PORT=1521))) Services Summary... Service "openview" has 2 instance(s). Instance "openview", status UNKNOWN, has 1 handler(s) for this service... Instance "openview", status READY, has 1 handler(s) for this service... The command completed successfully Checking tnsping ov_net ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ TNS Ping Utility for HP-UX: Version 9.2.0.2.0 - Production on 10-JAN-2004 12:20:41 Copyright © 1997 Oracle Corporation. All rights reserved. Used parameter files: /opt/oracle/product/9.2.0/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION= (ADDRESS_LIST= (ADDRESS = (PROTOCOL = IPC)(KEY =openview)) (ADDRESS = (COMMUNITY=OPENVIEW_COMMUNITY) (PROTOCOL=TCP) (HOST=lotus) (PORT=1521))) (CONNECT_DATA= (SID=openview))) OK (100 msec) Checking trcroute ov_net ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Trace Route Utility for HP-UX: Version 9.2.0.2.0 - Production on 10-JAN-2004 12:20:42 Copyright © 1999 Oracle Corporation. All rights reserved. Route of TrcRoute: Node: Client Time and address of entry into node: 10-JAN-2004 12:20:42 ADDRESS= PROTOCOL=IPC KEY=openview Node: Server Time and address of entry into node: 10-JAN-2004 12:20:42 *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Check uptime ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ uptime 8:20pm up 9 mins, 1 user, load average: 0.38, 0.29, 0.15 *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Print Shell Environment ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ env _=/usr/bin/env OV_ADM_DIR=/opt/oracle MANPATH=/usr/share/man/%L: /usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local /man/%L:/usr/local/man: /opt/upgrade/share/man/%L: /opt/upgrade/share/man:/opt/pd/share/man/ %L:/opt/pd/share/man: /opt/pd/share/man/%L:/opt/pd/share/man: /opt/pd/share/man/%L:/opt/pd /share/man:/opt/resmon/share/man: /opt/hparray/share/man/%L: /opt/hparray/share/man:/opt/scr /share/man:/usr/dt/share/man:// opt/perl/man:/opt/ignite/share/man/%L: /opt/ignite/share/man: /opt/OV/man:/opt/graphics/common/man: /opt/OV/man:/opt/OV/man SHLIB_PATH=/opt/oracle/product/9.2.0/lib32: /opt/oracle/product/9.2.0/lib DBA_TOOL=/opt/oracle/product/9.2.0/bin/sqlplus OV_DATA_DIR=/ora_db PATH=/usr/sbin:/usr/bin:/usr/ccs/bin: /usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin: /opt/upgrade/bin:/opt/fcms/bin:/usr/bin/X11: /usr/contrib/bin/X11:/opt/pd/bin:/opt/resmon /bin:/opt/scr/bin:/opt/atok/bin:/opt/egb/bin:// opt/perl/bin:/usr/sbin/diag/contrib:/opt/vje /bin:/opt/ignite/bin:/opt/graphics/common/bin: /opt/OV/bin:/opt/OV/bin/OpC:/opt/OV/bin/OpC /utils:/opt/OV/bin/OpC/install:/ opt/OV/contrib/OpC:/sbin:/home/root:/opt/oracle/product/9.2 .0/bin NLS_LANG=american_america.WE8ISO8859P15 COLUMNS=80 ORACLE_BASE=/opt/oracle OV_INDEX_DIR=/ora_db OV_DBA_USER=oracle WINDOWID=4194330 EDITOR=vi LOGNAME=root DBA_ERR_GREP=MGR- MAIL=/var/mail/root DBA_TOOL_NAME=sqlplus ORACLE_SID=openview ERASE=^H OV_OS_PREFIX= ITO_INDEXDIR=/ora_db SQLNET_CONF_DIR=/opt/oracle/product/9.2.0/network/admin DBUSER=oracle OV_CHARSET=WE8ISO8859P15 DISPLAY=10.10.210.60:0.0 ORA_USER=oracle SHELL=/sbin/sh ORACLE_TERM=ansi ITO_DATADIR=/ora_db HOME=/ TERM=hpterm ORACLE_HOME=/opt/oracle/product/9.2.0 DB_CONNECT=ov_net PWD=/opt/OV/contrib/OpC TZ=PST8PDT LINES=24 *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Report amount of free disc space ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ bdf Filesystem kbytes used avail %used Mounted on /dev/vg00/lvol3 204800 79691 117293 40% / /dev/vg00/lvol1 299157 68632 200609 25% /stand /dev/vg00/lvol8 2609152 682383 1806416 27% /var /dev/vg00/lvol7 1658880 1560690 92077 94% /usr /dev/vg00/lvol4 122880 118063 4519 96% /tmp /dev/vg01/lvol1 3072000 2957535 107361 96% /ovo_8 /dev/vg01/lvol4 1228800 300612 870240 26% /ora_db /dev/vg00/lvol6 503808 487846 15024 97% /opt /dev/vg01/lvol3 3584000 2327889 1177652 66% /opt/oracle /dev/vg01/lvol2 1228800 984015 229526 81% /opt/OV /dev/vg00/lvol5 20480 1417 17873 7% /home /dev/dsk/c0t0d0 142958 142958 0 100% /SD_CDROM *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Disk Utilization at /ora_db ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ du -s /ora_db 598284 /ora_db *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Collect performance information / Part 1 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ iostat -t tty cpu tin tout us ni sy id 0 30 6 10 8 77 device bps sps msps c3t6d0 0 0.0 1.0 c3t5d0 0 0.0 1.0 c3t4d0 0 0.0 1.0 c0t0d0 0 0.0 1.0 *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Collect performance information / Part 2 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ vmstat -s 0 swap ins 0 swap outs 0 pages swapped in 0 pages swapped out 810394 total address trans. faults taken 603584 page ins 0 page outs 51536 pages paged in 0 pages paged out 789060 reclaims from free list 595960 total page reclaims 76 intransit blocking page faults 597878 zero fill pages created 331594 zero fill page faults 1339274 executable fill pages created 51752 executable fill page faults 0 swap text pages found in free list 95110 inode text pages found in free list 0 revolutions of the clock hand 100726 pages scanned for page out 0 pages freed by the clock daemon 325099 cpu context switches 380801 device interrupts 905970 traps 6374669 system calls 22490 Page Select Size Successes for Page size 4K 87558 Page Select Size Successes for Page size 16K 274 Page Select Size Successes for Page size 64K 15 Page Select Size Successes for Page size 256K 283 Page Select Size Successes for Page size 1M 8 Page Select Size Successes for Page size 4M 5 Page Select Size Successes for Page size 64M 22490 Page Select Size Failures for Page size 16K 2150 Page Select Size Failures for Page size 64K 2424 Page Select Size Failures for Page size 256K 2439 Page Select Size Failures for Page size 1M 2722 Page Select Size Failures for Page size 4M 2730 Page Select Size Failures for Page size 16M 2730 Page Select Size Failures for Page size 64M 326268 Page Allocate Successes for Page size 4K 79889 Page Allocate Successes for Page size 16K 286 Page Allocate Successes for Page size 64K 15 Page Allocate Successes for Page size 256K 308 Page Allocate Successes for Page size 1M 8 Page Allocate Successes for Page size 4M 5 Page Allocate Successes for Page size 64M 566 Page Demotions for Page size 16K *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Collect performance information / Part 3 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ vmstat procs memory page faults cpu r b w avm free re at pi po fr de sr in sy cs us sy id 1 0 0 173523 76537 932 177 95 0 0 0 187 509 11870 605 16 8 77 *++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + • Check for Oracle processes ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ps -ef | grep ora oracle 1638 1 0 20:13:46 ? 0:00 ora_lgwr_openview oracle 1634 1 0 20:13:45 ? 0:00 ora_pmon_openview oracle 1636 1 0 20:13:46 ? 0:00 ora_dbw0_openview oracle 1569 1 0 20:13:31 ? 0:00 /opt/oracle/product/9.2.0 /bin/tnslsnr LISTENER -inherit oracle 1640 1 0 20:13:46 ? 0:00 ora_ckpt_openview oracle 1642 1 0 20:13:46 ? 0:00 ora_smon_openview oracle 1644 1 0 20:13:46 ? 0:00 ora_reco_openview root 4594 2807 1 20:20:44 ttyp1 0:00 grep ora *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Report Global Process status (Note: Summarized Output) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ps -efl

F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME COMD 1001 S oracle 1569 1 0 154 20 42111340 766 9772c0 20:13:31 ? 0:00 /opt/oracle/product/9.2.0/bin/tnslsnr LISTENER -inherit 1001 S oracle 1640 1 0 156 20 41e5fd80 16976 b027a4 20:13:46 ? 0:00 ora_ckpt_openview 1001 S oracle 1642 1 0 156 20 41f79e40 17008 b027ac 20:13:46 ? 0:00 ora_smon_openview 1001 S oracle 1644 1 0 156 20 41e5fec0 16992 b027b4 20:13:46 ? 0:00 ora_reco_openview 1 S root 1752 1 0 154 20 422d1600 176 977280 20:14:04 ? 0:00 ovspmd -U 1 S root 1805 1 0 158 20 427e8180 101 42210040 20:14:58 ? 0:00 /sbin/sh /usr/dt/bin/dtrc 1 R root 1777 1 0 152 20 422854c0 3386 - 20:14:19 ? 0:00 /opt/OV/bin/ovdbrun -c /var/opt/OV/share/databases/analysis/def 1 S root 1753 1752 0 154 20 422d1740 98 9772c0 20:14:05 ? 0:00 ovsessionmgr 1 S root 1825 1 0 154 20 41c84d40 70 977280 20:15:00 ? 0:00 /usr/sbin/stm/uut/bin/tools/monitor/disk_em 1 S root 1767 1752 0 154 20 42089d40 93 977280 20:14:14 ? 0:00 ovtrapd 2401 R bin 1757 1752 0 152 20 42285880 4548 - 20:14:06 ? 0:07 ovrequestd -s 2001 S bin 1761 1760 0 168 20 4234ca40 183 4235d168 20:14:07 ? 0:00 /opt/OV/httpd/bin/httpd 1 R root 1790 1772 0 152 20 425a4e40 323 - 20:14:43 ? 0:00 /opt/OV/lbin/eaagt/opcle 2001 S bin 1762 1760 0 154 20 4234cb80 183 42370168 20:14:07 ? 0:00 /opt/OV/httpd/bin/httpd 2001 S bin 1763 1760 0 168 20 4234ccc0 183 423aa168 20:14:07 ? 0:00 /opt/OV/httpd/bin/httpd 2001 S bin 1764 1760 0 168 20 4234ce00 183 423b8168 20:14:07 ? 0:00 /opt/OV/httpd/bin/httpd 2001 S bin 1765 1760 0 168 20 423c1080 183 423c0168 20:14:07 ? 0:00 /opt/OV/httpd/bin/httpd 2001 S bin 1768 1752 0 154 20 4242b180 283 9772c0 20:14:14 ? 0:00 ovactiond 1 R root 1769 1752 0 152 20 4242b400 1020 - 20:14:15 ? 0:00 ovalarmsrv 1 S root 1770 1752 0 154 20 4242b680 140 9772c0 20:14:15 ? 0:00 genannosrvr -a orch_async 1 S root 1771 1752 0 154 20 422d1240 124 977280 20:14:15 ? 0:00 ovdbcheck -ovspmd 401 R root 1772 1 0 152 20 4242b900 1481 - 20:14:15 ? 0:03 /opt/OV/bin/ovcd 401 R root 1782 1772 0 152 20 425a4440 1395 - 20:14:30 ? 0:00 /opt/OV/lbin/conf/ovconfd 401 R root 1778 1772 0 152 20 424fe200 405 - 20:14:20 ? 0:00 /opt/OV/bin/ovcs 401 R root 1776 1 0 152 20 4242be00 1558 - 20:14:17 ? 0:01 /opt/OV/bin/ovbbccb 1 R root 1788 1772 0 152 20 425a4bc0 281 - 20:14:39 ? 0:00 /opt/OV/lbin/eaagt/opcmsgi 401 R root 1797 1772 0 152 20 425a4a80 657 - 20:14:54 ? 0:00 /opt/OV/lbin/perf/coda 1 R root 1792 1772 0 152 20 424fec00 502 - 20:14:47 ? 0:01 /opt/OV/lbin/eaagt/opcmona 1 R root 1794 1772 0 152 20 425a4d00 1027 - 20:14:50 ? 0:01 /opt/OV/lbin/eaagt/opctrapi 401 R root 1796 1772 0 152 20 42745480 648 - 20:14:53 ? 0:01 /opt/OV/lbin/eaagt/opcmsga 1 S root 2807 2638 12 158 24 42ad5340 155 42b5b040 20:15:59 ttyp1 0:00 /sbin/sh ./opc_odc

*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ • Collect Information about Shared Memory and Semaphore Usage ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ipcs IPC status from /dev/kmem as of Sat Jan 10 12:20:44 2004 T ID KEY MODE OWNER GROUP Message Queues: q 0 0x3c1c0555 -Rrwww- root root q 1 0x3e1c0555 rw-rr root root Shared Memory: m 0 0x411c05ccrw-rw-rw- root root m 1 0x4e0c0002 rw-rw-rw- root root m 2 0x412009c5 rw-rw-rw- root root m 3 0x301c3e75 rw-rw-rw- root root m 4 0x501c7b09 rrr root other m 5 0x00000000 rw- root root m 9478 0x00000000 rw-r- oracle dba m 7 0x00000000 rw-r- oracle dba m 8 0x96e866c0 rw-r- oracle dba m 2825 0x00000000 D-rw- root root m 10 0x01205edfrw-rw-rw- root root m 11 0x01206297 rw-rw-rw- root root m 12 0x012062b0 rw-rw-rw- root root m 13 0x012062a0 rw-rw-rw- root root m 270 0x012062a8 rw-rw-rw- root root m 271 0x01206300 rw-rw-rw- root root m 272 0x012063e0 rw-rw-rw- root root m 17 0x01206352 rw-rw-rw- root root m 18 0x012063d3 rw-rw-rw- root root m 19 0x012063d9 rw-rw-rw- root root m 20 0x012063d8 rw-rw-rw- root root m 277 0x431c8850 rw-rw-rw- daemon daemon Semaphores: s 0 0x411c05ccra-ra-ra- root root s 1 0x4e0c0002 ra-ra-ra- root root s 2 0x412009c5 ra-ra-ra- root root s 3 0x00446f6era-rr root root s 4 0x00446f6dra-rr root root s 5 0x01090522 ra-rr root root s 6 0x311c3e75 ra-ra-ra- root root s 7 0x4004c1d3 ra-ra-ra- root root s 8 0x4004c1d4 ra-ra-ra- root root s 9 0x501c7b09 ra-ra-ra- root other s 10 0x4004c1d8 ra-ra-ra- root root s 11 0x4004c1d9 ra-ra-ra- root root s 12 0x612007c0 ra-ra-ra- root root s 13 0x732007c0 ra-ra-ra- root root s 14 0x702007c0 ra-ra-ra- root root s 15 0x692007c0 ra-ra-ra- root root s 16 0x752007c0 ra-ra-ra- root root s 17 0x632007c0 ra-ra-ra- root root s 18 0x642007c0 ra-ra-ra- root root s 19 0x662007c0 ra-ra-ra- root root s 20 0x6c2007c0 ra-ra-ra- root root s 21 0x6d2007c0 ra-ra-ra- root root s 22 0x6f2007c0 ra-ra-ra- root root s 23 0x410c01f1 ra-ra-ra- root root s 444 0xa467d1a8 ra-r- oracle dba s 25 0x522007c0 ra-ra-ra- root root s 26 0x013d8483 ra-rr root root s 27 0x01205ee6 ra-ra-ra- root root s 28 0x01205ecdra-ra-ra- root root s 29 0x012062bara-ra-ra- root root s 30 0x01206322 ra-ra-ra- root root s 171 0x0120635era-ra-ra- root root s 172 0x012063b7 ra-ra-ra- root root s 173 0x012063e8 ra-ra-ra- root root s 34 0x012063c4 ra-ra-ra- root root s 35 0x012063d6 ra-ra-ra- root root s 36 0x012063dara-ra-ra- root root s 37 0x012063dera-ra-ra- root root s 178 0x4c1c8850 ra-rr daemon daemon opc_odc finished. See the logfile /tmp/opc_odc.log for a detailed protocol.