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



Group memberships:
Premium Members

Joined: 24 Mar 2008
Posts: 17

Points: 146

Post Posted: Fri Mar 16, 2018 2:28 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
Additional info: Getting "ORA-28040: No matching authentication protocol"
We are using DRS plugin in our DataStage 11.3.1 jobs to connect to Oracle databases with odbc DSNs. These jobs are working fine with Oracle 12.1 version.

But when we upgrade to Oracle 12.2 version these jobs are aborting with "ORA-28040: No matching authentication protocol" error.

As per the progress link (https://www.progress.com/odbc/release-history/oracle-database-odbc), I Even tried installing the most recent version (07.16.0325 (B0373, U0246))of DataDirect ODBC drivers which was certified with Oracle 12.2.

But even then I am getting the same error. Did anyone face the same issue Could any one help me in fixing this.

I know one option of changing the settings on Oracle DB server side to allow the SQL Authentication for lower versions which I don't want to go as it will have security risks associated with it.
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42765
Location: Denver, CO
Points: 220367

Post Posted: Mon Mar 19, 2018 8:43 am Reply with quote    Back to top    

JITeam wrote:
We are using DRS plugin in our DataStage 11.3.1 jobs to connect to Oracle databases with odbc DSNs.

Sorry to go a little off topic here but... why? Why not native connectivity?

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
JITeam



Group memberships:
Premium Members

Joined: 24 Mar 2008
Posts: 17

Points: 146

Post Posted: Tue Mar 20, 2018 6:21 am Reply with quote    Back to top    

Thanks for the reply Chulett.

This is a legacy code which is coming from years (from 7.5.2 days) which contains DRS plugins all over the code and almost present in every job .The reason they used DRS plugin at that time was to use the same jobs with any DataBase (Oracle, DB2, SQL Server) by simply changing the environment variables.

And we don't want to change that plugin as it will cost us a lot in terms of effort. We tried to use the plugin migration tool given by IBM to replace with DRS connector, but is not doing 100% migration and also manually need to make changes and also all features of DRS plugin are not available.
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: 42765
Location: Denver, CO
Points: 220367

Post Posted: Tue Mar 20, 2018 7:31 am Reply with quote    Back to top    

Okay, understood. Wasn't sure from your post how deeply entrenched you were in that stage... pretty darn deep, it would seem. I'm aware of the reasons why someone might choose to use the DRS stage, just don't recall hearing of one where they did so and then later actually took advantage of its 'any database' switching option. Wink

Back on topic, any luck with your issue? Have you involved your official support provider yet to see what options are available? Sounds like you've already seen the SQLNET.ALLOWED_LOGON_VERSION one mentioned here.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
JITeam



Group memberships:
Premium Members

Joined: 24 Mar 2008
Posts: 17

Points: 146

Post Posted: Tue Mar 20, 2018 8:29 pm Reply with quote    Back to top    

Yes I involved official support and they are working on it. Will update here once we are able to fix it. Thanks for your time Smile
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