| Author |
Message |
JITeam
Group memberships:
Premium Members
Joined: 24 Mar 2008
Posts: 17
Points: 146
|
|
| 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
since January 2006
Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group
Joined: 12 Nov 2002
Posts: 42474
Location: Denver, CO
Points: 218484
|
|
|
|
|
|
| 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
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.
|
|
|
|
|
JITeam
Group memberships:
Premium Members
Joined: 24 Mar 2008
Posts: 17
Points: 146
|
|
|
|
|
|
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.
|
|
|
|
|
|
chulett
since January 2006
Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group
Joined: 12 Nov 2002
Posts: 42474
Location: Denver, CO
Points: 218484
|
|
|
|
|
|
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. 
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
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.
|
|
|
|
|
JITeam
Group memberships:
Premium Members
Joined: 24 Mar 2008
Posts: 17
Points: 146
|
|
|
|
|
|
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 
|
|
|
|
|
|
|
|
