Oracle DOA/Application connection problem.
674535Aug 27 2009 — edited Aug 27 2009I am looking for some help with a problem we are having with a connection issue with DOA objects and Application objects. We have a number of programs that were written using Delphi (version 5) that contain DOA (Direct Oracle Access) objects and Application Objects. The problem seems to be the order in which the connections are made. We have created a test program that proves this for us.
Our environment is a Windows 2003 Server Standard x64 Edition SP2 with Oracle 10.2.0.3 installed. The processor is a dual core processor with 4 gbs of ram.
When we open Delphi, load the program connect the application (using the application object) and then connect with the DOA object there is no problem. There is 2 connections and the program runs fine.
Whenwe open Delphi, load the program, connect the DOA object and then connect the application object the server hangs. the hour glass displays and sits there. The memory associated with the oracle.exe process continues to get larger and larger (looking in task manager) then when it reaches 1, 386, 750KB approximately the Oracle database service ceases and the windows creats a dump file (oracle.exe.hdmp) the size of the memory allocated. The following trace file is created:
Dump file e:\oracle\product\10.2.0\admin\alt2prod\bdump\alt2prod_lgwr_2448.trc
Thu Aug 27 12:43:26 2009
ORACLE V10.2.0.3.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 2 - type 8664, 1 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:3177M/4031M, Ph+PgF:6170M/8067M
Instance name: alt2prod
Redo thread mounted by this instance: 1
Oracle process number: 6
Windows thread id: 2448, image: ORACLE.EXE (LGWR)
*** 2009-08-27 12:43:26.794
*** SERVICE NAME:() 2009-08-27 12:43:26.720
*** SESSION ID:(716.1) 2009-08-27 12:43:26.720
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150676 bytes
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x10)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x10)
It appears the connection is trying to connect a second time. Does anyone know how to resolve this issue. Is there a configuration parameter to resolve this issue so the server does not lock up and then crash the database service.
Any help would be appreciated.
Chicago
Edited by: Chicago on Aug 27, 2009 1:21 PM