Cannot Connect To Oracle

jshurak · Post by **jshurak** » Thu Mar 08, 2007 2:58 pm

We have a few jobs that connect directly to Oracle. Since we applied the DST patches to the Datastage server yesterday, these jobs have failed. We receive two different error messages. They are as follows:

SQLSTATE=IM003, DBMS.CODE=160
[DataStage][SQL Client][ODBC]Specified driver could not be loaded due to system error 998 (Oracle in OraHome90).|

and

Error while trying to retrieve text for error ORA-12154

The ORA error is 'Failed to resolve TNS Name'

We have reinstalled the Oracle Client on the server and the jobs still fail.
Does anyone know what may be going? Any help you could provide would be great. Thanks.

chulett · Post by **chulett** » Thu Mar 08, 2007 3:25 pm

I'd worry more about the 'system error 998' than the tns issue. And since this has happened post-patch, I'd suggest you contact IBM support and open a case.

jshurak · Post by **jshurak** » Thu Mar 08, 2007 3:26 pm

thanks..I did just that...just waiting for them to get back to me.

vnspn · Post by **vnspn** » Fri Mar 23, 2007 3:00 pm

Were you able to resolve this error?

If so, please share the solution. We too are facing the same problem...

ray.wurlod · Post by **ray.wurlod** » Fri Mar 23, 2007 5:36 pm

I suggest that you also open a case with support. The more people it's biting, the more priority it's likely to get in IBM.

karthegx · Post by **karthegx** » Mon Mar 26, 2007 11:33 am

ya, that's correct .escalate it to IBM . i also did the same waiting for the reply , if you get the reply first share with me