| Author |
Message
|
| pcoffey |
 Posted: Thu Feb 22, 2007 2:39 am Post subject: Broker failing to re-connect to Oracle database |
 |
|
Apprentice
Joined: 03 Feb 2006
Posts: 33
|
Hi all,
The following has started happening in our development and test environments in the last two weeks (with no apparent change in our configuration).
The broker, once started successfully connects to the Oracle application database. However, after a period of time, it fails to re-connect (presumably on a timed-out/stale connection handle) with the error:
'[DataDirect][ODBC Oracle driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified '
We're a little stumped as to how to proceed here but the following questions might aid us in our investigation:
1) Does the broker use database connection pooling?
2) If so, how many connections in the pool?
3) If so, are these connections using a "keep alive"
(We are on WMB 6 on AIX)
Any help much appreciated,
Pauline |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Feb 22, 2007 3:20 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| pcoffey |
| Posted: Thu Feb 22, 2007 6:31 am Post subject: |
|
|
Apprentice
Joined: 03 Feb 2006
Posts: 33
|
Thanks Jeff. I already tried the odbc tracing route - it shows that the call to SQLConnect is successful but a subsequent call to SQLSetConnectOption fails.
EXIT SQLConnect with return code 1 (SQL_SUCCESS_WITH_INFO)
EXIT SQLSetConnectOption with return code -1 (SQL_ERROR)
I will continue to investigate and maybe open a PMR to get some more assistance.
Thanks again for your help. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Feb 22, 2007 6:34 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Odd.
Do you have EnableSQLDescribeParam turned on?
Did you add a new flow recently, that perhaps uses Passthru?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| pcoffey |
| Posted: Thu Feb 22, 2007 7:51 am Post subject: |
|
|
Apprentice
Joined: 03 Feb 2006
Posts: 33
|
Yes, I know... we do have EnableSQLDescribeParam turned on and we haven't added a new flow (nor do we use passthru).
I'll post the outcome once we resolve. |
|
| Back to top |
|
|
|
|
