HP OpenView System Administration Handbook [Electronic resources] : Network Node Manager, Customer Views, Service Information Portal, HP OpenView Operations نسخه متنی

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_odcre>

*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
• 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.

HP OpenView System Administration Handbook [Electronic resources] : Network Node Manager, Customer Views, Service Information Portal, HP OpenView Operations نسخه متنی

فارسی

کردی

العربیه

اردو

Türkçe

Русский

English

Français

کانال فیلم من

تبیان من

فایلهای من

کتابخانه من

پنل پیامکی

وبلاگ من

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

HP OpenView System Administration Handbook [Electronic resources] : Network Node Manager, Customer Views, Service Information Portal, HP OpenView Operations - نسخه متنی

Tammy Zitello

آدرس پست الکترونیک گیرنده :

آدرس پست الکترونیک فرستنده :

نام و نام خانوارگی فرستنده :

پیغام برای گیرنده ( حداکثر 250 حرف ) :

کد امنیتی را وارد نمایید

فونت

اندازه قلم

حالت نمایش

18.7 DATABASE REPORT