DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
sid19
Participant



Joined: 18 Jun 2007
Posts: 64
Location: kolkata
Points: 573

Post Posted: Wed Jan 24, 2018 7:57 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Dear All,

One of the Datastage job was accessing Oracle DB through ODBC connector stage. It is Oracle 11g version. Now as per new requirement we should switch to new Oracle DB that is 12C version. DB team kept user name and password same as old DB. We have updated existing Oracle DB entry of odbc.ini and change the hostname and port number entry for new DB as follows

--------------------------------

[XXXXX]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora25.so
Description=DataDirect Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=XX.XX.XXX.XXX
LocalTimeZoneOffset=
LockTimeOut=220
LogonID=xxxx
Password=xxxx
PortNumber=1531
ProcedureRetResults=0
ServiceName=edhprod
UseCurrentSchema=0

------------------------------------------

We are facing following error on job run

"
PKG_CHANGE: ODBC function "SQLConnect" reported: SQLSTATE = HY000: Native Error Code = 28,040: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol (CC_OdbcConnection::connect, file CC_OdbcConnection.cpp, line 598)


"

Please let me know how to fix it.

Thanks,

_________________
Sid
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1231

Points: 8096

Post Posted: Wed Jan 24, 2018 8:57 am Reply with quote    Back to top    

Have you validated that the version of Branded ODBC driver that you are using is blessed for that version of Oracle?

BTW: now would be a good time to transition to Connector stages, also... time to upgrade your release level of DataStage still using 8.x? tsk tsk
Rate this response:  
Not yet rated
sid19
Participant



Joined: 18 Jun 2007
Posts: 64
Location: kolkata
Points: 573

Post Posted: Wed Jan 24, 2018 9:55 pm Reply with quote    Back to top    

Thanks Paul for your response. As you mentioned about validation of branded odbc. Please elaborate it further how should I do this.

Thanks,

_________________
Sid
Rate this response:  
Not yet rated
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1231

Points: 8096

Post Posted: Wed Jan 24, 2018 10:03 pm Reply with quote    Back to top    

You look at the version you have installed on your hosts, then you consult the documentation to see if Oracle version 11g is supported.

(google the driver version). But most likely if you are still using DataStage 8.x, you might not have updated your ODBC drivers in some time... and you got pinched with this compatibility issue.

(ask the developers to change the job to use a Connector stage and see if that works better for you)
Rate this response:  
Not yet rated
sid19
Participant



Joined: 18 Jun 2007
Posts: 64
Location: kolkata
Points: 573

Post Posted: Thu Feb 15, 2018 1:59 am Reply with quote    Back to top    

Dear Paul,

I have looked into fix Central and found odbc driver as follows

---------------------------------------
interim fix: is_ddodbc_7.1.4_server_aix

DataDirect (OEM) 7.1.4 ODBC Drivers, for InfoSphere Information Server

The following files implement this fix.
---------------------------------------------

If we install this odbc driver will it fix our issue.



Thanks,

_________________
Sid
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42522
Location: Denver, CO
Points: 218815

Post Posted: Thu Feb 15, 2018 8:18 am Reply with quote    Back to top    

That would be a question for IBM Support. Oh, wait... 8.x? Never mind.

Try it, let us know.

Why are you using ODBC rather than native connectivity? Confused

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours