DSXchange

Hi Experts,

I have an issue where the jobs that ran correctly for months are failing suddenly with oracle connection error : ORA-12545.
"
LKP_INSTALL_NORM_SUP_HIST: [IIS-CONN-ORA-001004] The connector could not establish connection to Oracle server CQRTDM1.WORLD. Method: OCIServerAttach, Error code: 12545, Error message ORA-12545: Connect failed because target host or object does not exist. (CC_OraConnection::verifyConnection, file CC_OraConnection.cpp, line 2851)
"
There is no change in the oracle server of InfoSphere server.
Same job runs sometmes and sometimes it will fail. So we are not able to run any sequencer. Please suggest what can lead the oracle connection to fail time and again. View data and test connection work fine though.

Thanks in advance

Something has changed, it would seem. First thing I'd do in your shoes is take the issue to your DBA and see what they think might be going on.

Are any of the connection values supplied as parameters? If so, are the values supplied for these parameters always accurate?

Is your Oracle DB in RAC environment?

Oracle DB in not in RAC

Hi Ray,

Yes all the credential are passed as parameters and the values are accurate everytime. we have tried passing the values manually aswell.

Hi Chullet,

I have checked with the DBA and he rules out any issues with the database as we are able to connect via PLSQL developer, TOAD etc. even with DS connection test shows successful. also jobs run at some times and fail most other times. Issue is intermitent.

I observe that when a job fails its logs show that If it has 10 Connector stages in it, 7-8 Connectors will show successful connection and the remaining 2-3 connectors fail with error ORA-12545. and some time same jobs succeeds in all connections and completes with same parameters and DB connections etc.

Surprisingly when i am connecting to same DB via other development InfoSphere server, it has not failed yet.

Very confusing and misleading signs of behaviour. Need your help desperately.

How many listeners has the DBA configured? How many of these are you trying to use? What other competition is there for listeners?

Talk to your DBA about the limits they have configured, there are several possible. Connections can be limited by user, there's an overall limit as well. There are also O/S limits that can come into play.

Ray,

There is only 1 listener confirgured. and there is no much competdtion to InfoSphere. another application like SAP will connect and with less load at max.

Experts,

Thanks for your inputs. This has led us to bypass the DNS to point Infosphere directly to Staging DB and vice versa. This has resolved the issue and jobs working fine.

Well... if you're having DNS issues, those should be looked into and resolved as well. By someone else, thankfully.