Oracle Connection failure using LSXLC

HCL Domino Domino Forum
1

We have an agent that connect to oracle to read some information. Below is the sample code. Once the server is started connection is successful. There is no problem for 2 hour. After some time we are getting below error. If we restart the server again then it works for 2 hours and then fails again.

We are not using LEI only making use of LSXLC connection. Orcale 8i is installed in the Lotus Notes server and Oracle server is 9i. DCtest connection is successful when this error is occuring

Can anyone help in debugging the problem??? Its really frustating to restart the server every 3 hours once.

before test Error 12325: Error: [Attach Server]ORA-12154: TNS:could not resolve service name, Connector ‘oracle8’, Method -Connect- (12154)20

Option Public

Uselsx “*lsxlc”

Print "testing "

On Error Goto ErrHandler

Dim src As LCConnection

Set src = New LCConnection ("oracle8")

src.Server = "testdb"

src.Userid = "testid"

src.Password =  "testpwd"

src.Metadata = "testtable"



Print "before test"

Messagebox "before test"



src.Connect





Print "Connection successfully"

Messagebox "Connection successfully"



If src.IsConnected Then

	src.Disconnect 

	Print "Disconnected from successfully"

	Messagebox "Disconnected from successfully"

End If

Exit Sub

ErrHandler:

Print "Error " & Str(Err) & ":  " & Error$ & Erl()

Messagebox "Error " & Str(Err) & ":  " & Error$ & Erl()
2

Subject: Oracle Connection failure using LSXLC

Deleting the lsxlc-objects manually after usage often helped me with strange periodic problems with the SAP connector.So adding a “Delete src” at the end of the code may help you with Oracle, too. Good luck :wink: