Oracle Connection after upgrade from 6.5 to 8.5

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: Oracle Connection after upgrade from 6.5 to 8.5

Feedback Type: Problem

Product Area: Database

Technical Area: Application Development

Platform: ALL

Release: 8.5.1

Reproducible: Always

Hi,

We have recently upgraded from notes 6.5 to 8.5.
We use oracle 10.

Since the upgrade we are getting timeout errors on the connection in scheduled agents.

Error: 12325: Error: [Execute Statement]ORA-02396: exceeded maximum idle time, please connect again, Connector 'oracle', Method -Execute-

We are using lsxlc.
Would anyone have any ideas if there are any server settings or development changes we need to look at regarding the upgrade of our server ?

Code below, fails on the connect

On Error Goto ErrorCSN
Dim sLocCSN As String
sLocCSN = "connectSN"

Set sesCSN = New LCSession sesCSN.connectionPooling = True
Set connCSN = New LCConnection( "oracle" )

connCSN.Server = "***.***.***.***"

connCSN.Userid = "*****"
connCSN.Password = "*****"
connCSN.Connect

Feedback number WEBB8L2JY6 created by ~Vera Kirelitakoi on 08/24/2011

Status: Open
Comments: