Event ID: 7034 & 1000 Solution

Last weekend, my colleagues upgraded the HR database from 10g x32 to 10g x64 and adopted the expdp/impdp method to ensure smooth upgrade. Working on Monday, more than 8 o'clock, AP staff reported that they could not connect to the database. Check the database and find the Oracle service shutdown. The system reports the following error:

Event ID: 7034

The oracleservicehr Service terminated unexpectedly. It has done this 2 time (s ).

 

For more information, see Help and Support Center

Restart the service and recover the database. About 20 minutes later, the database service shut down again. Check the database parameters and find that the default Oracle parameter settings are used, which has not been modified. The physical memory is 16 GB, And the SGA is quite small. Adjust the SGA from 1.6 GB to 10 GB and restart the system. An exception occurs again at around 11 o'clock.

Check System logs and find the following exceptions:

Event ID: 1000

Faulting application oracle.exe, version 10.2.0.3, faulting module oracle.exe, version 10.2.0.3, fault address 0x0000000000fe00009.

On Metalink, it was found that it was an Oracle bug, numbered 6122521. The details are as follows, which can be solved only by going to patch 14. The patch was installed at, and the problem was resolved. No exception occurred. The details are as follows:

The oracleservice crashes on Windows x64 connecting with Old Client versions [ID 470988.1]
	Modified03-dec-2009TypeProblemStatusPublished

In this document
Symptoms
Cause
Solution
References

Applies:

Oracle Server-Enterprise Edition-version: 10.2.0.3
Z * obsolete: Microsoft Windows Server 2003 R2 (64-bit amd64 and Intel em64t)
Microsoft Windows x64 (64-bit)
Z * obsolete: Microsoft Windows XP (64-bit amd64 and Intel em64t)
* ** Checked for relevance on 03-dec-2009 ***

Symptoms

-- Problem Statement:

Using a new installation of 10.2.0.1 64-bit on Windows x64 with Patch Set 10.2.0.3 applied.
In this case no database has been tested with 10.2.0.1 as a full export of a 9.2.0.6 32-bit export dump was imported directly into 10.2.0.3.

Now the database crashes regularly without any messages in the alert. log. Because the oracle.exe (for the Windows oracleservice <Sid>) Just fails repeatedly.

The Windows Event Viewer application log shows similar errors like below.
Note that these errors are also logged into the RDA report.

Event Type: Error
Event Source: application error
Event category: (100)
Event ID: 1000
Date: 07.12.2007
Time: 11:10:07
User: N/
COMPUTER: sbpfmtx5654
Description:
Faulting application oracle.exe, version 10.2.0.3, faulting module oracle.exe, version 10.2.0.3, fault address 0x0000000000fe00009.

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 6f 72 61 ure ora
0018: 63 6C 65 2E 65 78 65 20 cle.exe
0020: 31 30 2E 32 2E 30 2E 33 10.2.0.3
0028: 20 69 6e 20 6f 72 61 63 in Orac
0030: 6C 65 2E 65 78 65 20 31 le.exe 1
0038: 30 2E 32 2E 30 2E 33 20 0.2.0.3
0040: 61 74 20 6f 66 66 73 65 at offse
0048: 74 20 30 30 30 30 30 30 t 000000
0050: 30 30 30 66 65 34 32 running fe42
0058: 34 39 49

 

Cause

The most probable root cause are connection attempts from clients <= 8.1.7.4.
This is based on the following bug reports.

Internal/unpublished bug report
Bug 6122521/6012921-Database Service crashes when a client connects

Published bug report
Bug 6012921-10.2.0.3 Database Service crahses when connecting from remote clients <= 8.1.7.4

Bug 6122521 mentions specifically this problem of the database crashing does not occur
Until the 10.2.0.3 patch set is applied. in other words, on different databases that are at 10.2.0.1.0 (Base Release) on the same 64-bit Windows platform, attempts to connect with these older client tools do not crash the database service.

According to bug 6012921 this issue has been fixed in 10.2.0.3 patch 7.

Solution

-- To implement the solution, Please execute the following steps ::

1. Apply a recent 10.2.0.3 patch bundle for Windows x64, e.g. 10.2.0.3 patch 14 or newer.

Patch bundle 10.2.0.3 patch 14 can be downloaded

Patch 6627414 Oracle Database family: patch
Oracle 10.2.0.3 patch 14 bug for Windows-64 amd64 and Intel em64t XP and 2003
File: p6627414_10203_MSWIN-x86-64.zip

2. Upgrade all clients <= 8.1.7.4 to at least 8.1.7.4 because of the interoperability limitations of the different Oracle versions.
Please note that 8.1.7 is in fact no longer supported.

Refer
Note 207303.1-Client/Server/interoperability support between different Oracle versions

References

BUG: 6154936-database crash with no errors in alertlog
Note: 207303.1-Client/Server/interoperability support between different Oracle versions