OracleConnector connection clossing intermittentlyORA-12545

vintipa · Post by **vintipa** » Tue Mar 12, 2013 2:14 am

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

chulett · Post by **chulett** » Tue Mar 12, 2013 7:43 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 12, 2013 3:32 pm

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

lstsaur · Post by **lstsaur** » Tue Mar 12, 2013 3:59 pm

Is your Oracle DB in RAC environment?

vintipa · Post by **vintipa** » Tue Mar 12, 2013 5:40 pm

Oracle DB in not in RAC

vintipa · Post by **vintipa** » Tue Mar 12, 2013 7:00 pm

Hi Ray,

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

vintipa · Post by **vintipa** » Wed Mar 13, 2013 6:58 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 13, 2013 7:29 pm

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

chulett · Post by **chulett** » Wed Mar 13, 2013 7:43 pm

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.

vintipa · Post by **vintipa** » Wed Mar 13, 2013 8:07 pm

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.

vintipa · Post by **vintipa** » Wed Mar 13, 2013 10:43 pm

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.

chulett · Post by **chulett** » Thu Mar 14, 2013 7:10 am

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