Page 1 of 1
ODBC Oracle Wire Protocol driver Oracle Connection Dead
Posted: Mon Apr 28, 2014 4:45 am
by sjordery
Fatal Error: Could not connect to datasource[DataDirect][ODBC Oracle Wire Protocol driver Oracle Connection Dead
Connecting from Linux Datastage server to Oracle 11 RAC server having the above issue.
Connectivity with Linus Datastage server to Oracle 11g Standalone server works fine.
Connectivity with Linus Datastage server to Oracle 10g RAC server works fine.
Posted: Mon Apr 28, 2014 6:18 am
by ray.wurlod
Check that the ODBC driver being used to connect to 11g is valid, and validly referred to in tnsnames.ora file.
Posted: Mon Apr 28, 2014 6:53 am
by chulett
Involve your DBA. I too would suspect a tnsnames.ora issue of some kind.
Posted: Mon Apr 28, 2014 7:19 am
by qt_ky
I hit the "Connection Dead" error last year via DataDirect ODBC drivers. In our case it was because we had enabled Oracle Advanced Security on the database server and forced it to required encrypted client connections. If that is your situation too, then you have to upgrade the DataDirect ODBC drivers on the DataStage server to a newer version that supports encrypted Oracle connections.
Posted: Mon Apr 28, 2014 7:30 am
by chulett
I'd also be curious if this was working and then stopped or are you are trying to get it to work for the first time?
Posted: Mon Apr 28, 2014 8:03 am
by qt_ky
chulett wrote:I'd also be curious if this was working and then stopped or are you are trying to get it to work for the first time? ...
If it used to be working, then the error should say "Connection Died."
Posted: Mon Apr 28, 2014 9:43 am
by chulett
... and then "I'm feeling much better!".
This is the first time we are connecting to Oracle 11g RAC
Posted: Tue Apr 29, 2014 12:50 am
by sjordery
It works fine with Oracle 11g standalone server and Oracle 10g RAC
Posted: Tue Apr 29, 2014 12:51 am
by sjordery
It is the first time we are connecting to Oracle 11g RAC
Posted: Sun May 04, 2014 2:31 pm
by qt_ky
Oracle Advanced Security can be installed on any one Oracle database by itself. Ask your DBA if it's installed and requires encrypted client connections.