Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
sjordery
Premium Member
Posts: 202 Joined: Thu Jun 08, 2006 5:58 am
Post
by sjordery » Mon Apr 28, 2014 4:45 am
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.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Apr 28, 2014 6:18 am
Check that the ODBC driver being used to connect to 11g is valid, and validly referred to in tnsnames.ora file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Apr 28, 2014 6:53 am
Involve your DBA. I too would suspect a tnsnames.ora issue of some kind.
-craig
"You can never have too many knives" -- Logan Nine Fingers
qt_ky
Premium Member
Posts: 2895 Joined: Wed Aug 03, 2011 6:16 am
Location: USA
Post
by qt_ky » Mon Apr 28, 2014 7:19 am
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Apr 28, 2014 7:30 am
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
qt_ky
Premium Member
Posts: 2895 Joined: Wed Aug 03, 2011 6:16 am
Location: USA
Post
by qt_ky » Mon Apr 28, 2014 8:03 am
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."
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Apr 28, 2014 9:43 am
... and then "I'm feeling much better!".
-craig
"You can never have too many knives" -- Logan Nine Fingers
sjordery
Premium Member
Posts: 202 Joined: Thu Jun 08, 2006 5:58 am
Post
by sjordery » Tue Apr 29, 2014 12:50 am
It works fine with Oracle 11g standalone server and Oracle 10g RAC
sjordery
Premium Member
Posts: 202 Joined: Thu Jun 08, 2006 5:58 am
Post
by sjordery » Tue Apr 29, 2014 12:51 am
It is the first time we are connecting to Oracle 11g RAC
qt_ky
Premium Member
Posts: 2895 Joined: Wed Aug 03, 2011 6:16 am
Location: USA
Post
by qt_ky » Sun May 04, 2014 2:31 pm
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius