Home » RDBMS Server » Networking and Gateways » Network problems detected in DNS (oracle ,9i,win2003)
Network problems detected in DNS [message #349884] Tue, 23 September 2008 06:50
mohan5
Messages: 2
Registered: September 2008
Junior Member
Dear All,

I am facing problem in our production server.

I am unable to find the root cause for suddenly shutdown of server .please suggest.
we are using SAP with oracle. There is an error in sap log there is
GZZ > 1 possible network problems detected - check tracefile and adjus .In there *LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3893]MtxInit: -2 0 0 what settings to change in DNS and
there is one more error in Listener.
In trace file.
TNSLSNR for 64-bit Windows: Version 9.2.0.7.0 - Production on 22-SEP-2008 11:33:50

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is E:\oracle\ora92\network\admin\listener.ora
Log messages written to E:\oracle\ora92\network\log\listener2.log
Trace information written to E:\oracle\ora92\network\trace\listener2.trc
Trace level is currently 0

Started with pid=1332
TNS-01151: Missing listener name, LISTENER2, in LISTENER.ORA



BY2 Database error 1033 at CON
11:35:20 DIA 006 BY0 > ORA-01033: ORACLE initialization or shutdown in progress


Please find the logs.






Mon Sep 22 11:15:07 2008
Completed checkpoint up to RBA [0x763b.2.10], SCN: 0x0000.15801232
Mon Sep 22 11:17:36 2008
Beginning log switch checkpoint up to RBA [0x763c.2.10], SCN: 0x0000.15803e87
Thread 1 advanced to log sequence 30268
Current log# 4 seq# 30268 mem# 0: J:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF
Mon Sep 22 11:17:36 2008
ARC0: Evaluating archive log 2 thread 1 sequence 30267
Mon Sep 22 11:17:36 2008
Current log# 4 seq# 30268 mem# 1: H:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF
Mon Sep 22 11:17:37 2008
ARC0: Beginning to archive log 2 thread 1 sequence 30267
Creating archive destination LOG_ARCHIVE_DEST_1: 'G:\ORACLE\PRD\ORAARCH\PRDARCHARC30267.001'
ARC0: Completed archiving log 2 thread 1 sequence 30267
Dump file i:\oracle\prd\saptrace\background\alert_prd.log
Mon Sep 22 11:35:08 2008
ORACLE V9.2.0.7.0 - 64bit Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 2200
Mon Sep 22 11:35:08 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
processes = 87
sessions = 100
timed_statistics = TRUE
shared_pool_size = 520093696
sga_max_size = 4129140808
shared_pool_reserved_size= 51464110
enqueue_resources = 8000
control_files = H:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf, L:\oracle\PRD\sapdata1\system_1\cntrl\cntrlPRD.dbf, I:\oracle\PRD\saparch\cntrl\cntrlPRD.dbf
db_block_checksum = FALSE
db_block_size = 8192
db_cache_size = 1291845632
compatible = 9.2.0
log_archive_start = TRUE
log_archive_dest = G:\oracle\PRD\oraarch\PRDarch
log_buffer = 1048576
log_checkpoint_interval = 0
log_checkpoint_timeout = 0
db_files = 254
db_file_multiblock_read_count= 8
fast_start_mttr_target = 900
log_checkpoints_to_alert = TRUE
control_file_record_keep_time= 30
dml_locks = 4000
transaction_auditing = FALSE
undo_management = AUTO
undo_tablespace = PSAPUNDO
undo_retention = 43200
remote_os_authent = TRUE
hash_join_enabled = FALSE
background_dump_dest = I:\oracle\PRD\saptrace\background
user_dump_dest = I:\oracle\PRD\saptrace\usertrace
core_dump_dest = I:\oracle\PRD\saptrace\background
optimizer_features_enable= 9.2.0
sort_area_size = 2097152
sort_area_retained_size = 0
db_name = PRD
open_cursors = 800
optimizer_mode = choose
_sort_elimination_cost_ratio= 10
_b_tree_bitmap_plans = FALSE
_push_join_predicate = FALSE
optimizer_index_cost_adj = 10
_optim_peek_user_binds = FALSE
pga_aggregate_target = 629145600
workarea_size_policy = AUTO
statistics_level = typical
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 Sep 22 11:35:11 2008
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC1 started with pid=9
Mon Sep 22 11:35:11 2008
ARC0: Archival started
Mon Sep 22 11:35:12 2008
ARC1: Archival started
Mon Sep 22 11:35:12 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Mon Sep 22 11:35:12 2008
ARC1: Becoming the 'no FAL' ARCH
Mon Sep 22 11:35:12 2008
ARC0: Becoming the heartbeat ARCH
Mon Sep 22 11:35:12 2008
ARC0: Becoming the heartbeat ARCHARC0: Thread not mounted
Mon Sep 22 11:35:13 2008
alter database "PRD" mount exclusive
Mon Sep 22 11:35:13 2008
ARC1: Becoming the 'no FAL' ARCHARC1: Thread not mounted
Mon Sep 22 11:35:16 2008
Successful mount of redo thread 1, with mount id 1729743217
Mon Sep 22 11:35:16 2008
Database mounted in Exclusive Mode.
Completed: alter database "PRD" mount exclusive
Mon Sep 22 11:35:16 2008
alter database open
Mon Sep 22 11:35:19 2008
Beginning crash recovery of 1 threads
Mon Sep 22 11:35:19 2008
Started redo scan
Mon Sep 22 11:35:19 2008
Completed redo scan
92076 redo blocks read, 4033 data blocks need recovery
Mon Sep 22 11:35:20 2008
Started recovery at
Thread 1: logseq 30267, block 43763, scn 0.0
Mon Sep 22 11:35:21 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 30267 Reading mem 0
Mem# 0 errs 0: J:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF
Mem# 1 errs 0: H:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF
Mon Sep 22 11:35:21 2008
Recovery of Online Redo Log: Thread 1 Group 4 Seq 30268 Reading mem 0
Mem# 0 errs 0: J:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF
Mem# 1 errs 0: H:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF
Mon Sep 22 11:35:21 2008
Completed redo application
Mon Sep 22 11:35:22 2008
Ended recovery at
Thread 1: logseq 30268, block 33442, scn 0.360750754
4033 data blocks read, 4033 data blocks written, 92076 redo blocks read
Crash recovery completed successfully
Mon Sep 22 11:35:22 2008
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 30269
Thread 1 opened at log sequence 30269
Mon Sep 22 11:35:23 2008
ARC0: Evaluating archive log 4 thread 1 sequence 30268
Mon Sep 22 11:35:23 2008
Current log# 3 seq# 30269 mem# 0: H:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF
Current log# 3 seq# 30269 mem# 1: J:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF
Successful open of redo thread 1
Mon Sep 22 11:35:23 2008
ARC1: Evaluating archive log 4 thread 1 sequence 30268
ARC1: Unable to archive log 4 thread 1 sequence 30268
Mon Sep 22 11:35:23 2008
SMON: enabling cache recovery
Mon Sep 22 11:35:23 2008
Log actively being archived by another process
Mon Sep 22 11:35:23 2008
ARC0: Beginning to archive log 4 thread 1 sequence 30268
Creating archive destination LOG_ARCHIVE_DEST_1: 'G:\ORACLE\PRD\ORAARCH\PRDARCHARC30268.001'
ARC0: Completed archiving log 4 thread 1 sequence 30268
Mon Sep 22 11:35:24 2008
Successfully onlined Undo Tablespace 1.
Mon Sep 22 11:35:24 2008
SMON: enabling tx recovery
Mon Sep 22 11:35:24 2008
Database Characterset is UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Mon Sep 22 11:53:02 2008
Beginning log switch checkpoint up to RBA [0x763e.2.10], SCN: 0x0000.1580cd86
Thread 1 advanced to log sequence 30270
Mon Sep 22 11:53:02 2008
ARC1: Evaluating archive log 3 thread 1 sequence 30269
Mon Sep 22 11:53:02 2008
Current log# 1 seq# 30270 mem# 0: H:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF
Current log# 1 seq# 30270 mem# 1: J:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF
Mon Sep 22 11:53:02 2008
ARC1: Beginning to archive log 3 thread 1 sequence 30269
Creating archive destination LOG_ARCHIVE_DEST_1: 'G:\ORACLE\PRD\ORAARCH\PRDARCHARC30269.001'
ARC1: Completed archiving log 3 thread 1 sequence 30269
Mon Sep 22 12:11:11 2008
Completed checkpoint up to RBA [0x763e.2.10], SCN: 0x0000.1580cd86
Mon Sep 22 12:12:57 2008
Beginning log switch checkpoint up to RBA [0x763f.2.10], SCN: 0x0000.1580f03a
Thread 1 advanced to log sequence 30271
Mon Sep 22 12:12:57 2008
ARC1: Evaluating archive log 1 thread 1 sequence 30270
Mon Sep 22 12:12:57 2008
Current log# 2 seq# 30271 mem# 0: J:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF
Current log# 2 seq# 30271 mem# 1: H:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF
Mon Sep 22 12:12:57 2008
ARC1: Beginning to archive log 1 thread 1 sequence 30270
Creating archive destination LOG_ARCHIVE_DEST_1: 'G:\ORACLE\PRD\ORAARCH\PRDARCHARC30270.001'
ARC1: Completed archiving log 1 thread 1 sequence 30270
Mon Sep 22 12:32:17 2008
Completed checkpoint up to RBA [0x763f.2.10], SCN: 0x0000.1580f03a
Mon Sep 22 12:34:42 2008
Beginning log switch checkpoint up to RBA [0x7640.2.10], SCN: 0x0000.15810b3b
Thread 1 advanced to log sequence 30272
Current log# 4 seq# 30272 mem# 0: J:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF
Current log# 4 seq# 30272 mem# 1: H:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF
Mon Sep 22 12:34:42 2008
ARC1: Evaluating archive log 2 thread 1 sequence 30271
ARC1: Beginning to archive log 2 thread 1 sequence 30271
Creating archive destination LOG_ARCHIVE_DEST_1: 'G:\ORACLE\PRD\ORAARCH\PRDARCHARC30271.001'
ARC1: Completed archiving log 2 thread 1 sequence 30271



DEV_rfc.trc

**** ERROR file opened at 20080905 202948 India Standard , SAP-REL 640,0,46 RFC-VER 3 703609 MT-SL

>TS> Mon Sep 22 12:57:22 2008
T:5300 Error RFCIO_ERROR_SYSERROR in abrfcio.c : 2344
>TS> Mon Sep 22 12:58:27 2008
T:5300 Error RFCIO_ERROR_SYSERROR in abrfcio.c : 2344
>TS> Mon Sep 22 12:59:32 2008
T:5300 Error RFCIO_ERROR_SYSERROR in abrfcio.c : 2344
>TS> Mon Sep 22 13:00:33 2008
T:5300 Error RFCIO_ERROR_SYSERROR in abrfcio.c : 2344



Event log.
Event Type: Warning
Event Source: NIC Agents
Event Category: Service
Event ID: 1285
Date: 9/22/2008
Time: 11:34:26 AM
User: N/A
Computer: ##########
Description:
NIC Agent: Connectivity has been lost for the NIC in slot 0, port 2. [SNMP TRAP: 18006 in CPQNIC.MIB]
Data:
0000: 00 00 06 00 00 00 00 00 ........
0008: 02 00 ..

Event Type: Warning
Event Source: ClusSvc
Event Category: Node Mgr
Event ID: 1124
Date: 9/22/2008
Time: 11:34:46 AM
User: N/A
Computer: ##########
Description:
The node determined that its interface to network 'PRIVATE' failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: HpEventLog
Event Category: None
Event ID: 736
Date: 9/22/2008
Time: 11:34:46 AM
User: N/A
Computer: ##########
Description:
HP Event Log : [MSG_2E0] Watchdog timer expired - hard reset
Data:
0000: 20 00 10 00 02 00 01 00 .......
0008: e0 1b 02 9e 81 d7 48 20 .. H
0010: 00 03 23 0c 6f c1 04 ff ..#.o.
0018: 00 00 00 00 00 00 00 00 ........
0020: 08 00 00 00 00 00 01 00 ........


Event Type: Warning
Event Source: ClusSvc
Event Category: Node Mgr
Event ID: 1127
Date: 9/22/2008
Time: 11:34:48 AM
User: N/A
Computer: ##########
Description:
The interface for cluster node ########## on network 'PRIVATE' failed. If the condition persists, check the cable connecting the node to the network. Next, check for hardware or software errors in node's network adapter. Finally, check for failures in any network components to which the node is connected such as hubs, switches, or bridges.

For more information, see Help and Support Center at http://go.microcircuit.com/flunk/events.asp

Event Type: Error
Event Source: Tcpip
Event Category: None
Event ID: 4199
Date: 9/22/2008
Time: 12:06:49 PM
User: N/A
Computer: #########
Description:
The system detected an address conflict for IP address #########with the system having network hardware address 00:1A:4D:0F:9E:D0. Network operations on this system may be disrupted as a result.

For more information, see Help and Support Center at http://go.micro-soft.com/flank/events.asp.
Event Type: Information
Event Source: Service Control Manager
Event Category: None
Event ID: 7035
Date: 9/22/2008
Time: 11:35:02 AM
User: NT AUTHORITY\SYSTEM
Computer: ##################
Description:
The Remote Access Connection Manager service was successfully sent a start control.

For more information, see Help and Support Center at http://go.micros-oft.com/Link/events.asp.






Event Type: Information
Event Source: Service Control Manager
Event Category: None
Event ID: 7035
Date: 9/22/2008
Time: 11:35:03 AM
User: @@@@\sapcluster
Computer:##################
Description:
The OracleOraHome92TNSListenerFsl@@@@-sap-orav service was successfully sent a start control.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7034
Date: 9/22/2008
Time: 11:35:03 AM
User: N/A
Computer: ##################
Description:
The OracleOraHome92TNSListenerLISTENER2 service terminated unexpectedly. It has done this 1 time(s).

Event Type: Information
Event Source: Service Control Manager
Event Category: None
Event ID: 7036
Date: 9/22/2008
Time: 11:35:03 AM
User: N/A
Computer: ##################
Description:
The OracleOraHome92TNSListenerFsl@@@@-sap-orav service entered the running state.

Event Type: Information
Event Source: Application Error
Event Category: (100)
Event ID: 1004
Date: 9/22/2008
Time: 11:35:46 AM
User: N/A
Computer: ************
Description:
Reporting queued error: faulting application disp+work.EXE, version 6400. ************, faulting module disp+work.EXE, version 6400. ************, fault address 0x0000000002c30ec0.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 64 69 73 ure dis
0018: 70 2b 77 6f 72 6b 2e 45 p+work.E
0020: 58 45 20 36 34 30 30 2e XE 6400.
0028: 31 32 38 2e 31 32 2e 34 128.12.4
0030: 35 31 39 32 20 69 6e 20 5192 in
0038: 64 69 73 70 2b 77 6f 72 disp+wor
0040: 6b 2e 45 58 45 20 36 34 k.EXE 64
0048: 30 30 2e 31 32 38 2e 31 00.128.1
0050: 32 2e 34 35 31 39 32 20 2.45192
0058: 61 74 20 6f 66 66 73 65 at offse
0060: 74 20 30 30 30 30 30 30 t 000000
0068: 30 30 30 32 63 33 30 65 0002c30e
0070: 63 30 c0




Event Type: Error
Event Source: SAPPRD_00
Event Category: None
Event ID: 0
Date: 9/22/2008
Time: 11:36:21 AM
User: N/A
Computer: #####
Description:
SAPRC: System died. Reason: (null)

Event Type: Information
Event Source: LoadPerf
Event Category: None
Event ID: 1000
Date: 9/22/2008
Time: 11:37:12 AM
User: N/A
Computer: ######
Description:
Performance counters for the WmiApRpl (WmiApRpl) service were loaded successfully. The Record Data contains the new index values assigned to this service.





In nmiconf.log

DBSNMP for 32-bit Windows: release 9.2.0.7.0 - Production on 22-SEP-08 11:33:50
Discovering services on @@@@@@@ configured on host addresses {$$$$$$$$$}
Warning : Skipping OracleOraHome92TNSListenerFsl@@@@-sap-orav : Could not find corresponding listener definition in {E:\oracle\ora92\network\admin\listener.ora}
Warning : Skipping OracleOraHome92TNSListenerLISTENER2 : Could not find corresponding listener definition in {E:\oracle\ora92\network\admin\listener.ora}
Warning : Skipping OracleOraHome92TNSListenerprd : Could not find corresponding listener definition in {E:\oracle\ora92\network\admin\listener.ora}
Warning : Skipping OracleOraHome92TNSListenerprd.world : Could not find corresponding listener definition in {E:\oracle\ora92\network\admin\listener.ora}
Warning : LISTENER1 defined in E:\oracle\ora92\network\admin\listener.ora will be skipped, because it does not monitor any of the valid SIDs {PRD}
Warning : LISTENER defined in E:\oracle\ora92\network\admin\listener.ora will be skipped, because it does not monitor any of the valid SIDs {PRD}
Warning : No Listener found for SID PRD. PRD will be skipped
Could not determine location of emtab.


Regards,
Mohan




[Updated on: Tue, 23 September 2008 06:54]

Report message to a moderator

Previous Topic: d2k connect to oracle
Next Topic: Netca Error
Goto Forum:
  


Current Time: Tue Dec 06 00:25:25 CST 2016

Total time taken to generate the page: 0.22504 seconds