TNS: Protocol adapter not loadable
Posted: Wed Oct 15, 2008 12:33 pm
Hello Gurus,
I hope you can help me with the odd message I am getting all of a sudden.
I am trying to run a very simple job that reads from a sequential file and writes to an oracle DB via ODBC stage. No much transformations either but the job fails with the error message: TNS:Protocol adapter not loadable.
I know this is an oracle message but what is surprising me is that I am able to connect to the DB without any problem. Also if I specify a new Datasource in the ODBC stage the job runs fine.
Can you please shed some light on how to fix this issue? I have lot of jobs that read from the current DataSource (which is throwing the error), changing that would mean changing all the jobs.
I hope you can help me with the odd message I am getting all of a sudden.
I am trying to run a very simple job that reads from a sequential file and writes to an oracle DB via ODBC stage. No much transformations either but the job fails with the error message: TNS:Protocol adapter not loadable.
I know this is an oracle message but what is surprising me is that I am able to connect to the DB without any problem. Also if I specify a new Datasource in the ODBC stage the job runs fine.
Can you please shed some light on how to fix this issue? I have lot of jobs that read from the current DataSource (which is throwing the error), changing that would mean changing all the jobs.