Clarity

Hi All,

I’d like to ask you where it can be set driver setting/path which is used to connect Clarity to the database – We suppose it should be file ojdbc14.jar in niku/clarity/lib folder…

We are getting this error in admin.log when tried to run Clarity services. (our DB team upgraded to Oracle 12c database)

4/26/18 8:44 AM (admin) Verifying Java Configuration...
4/26/18 8:44 AM (admin) Verifying Database Configuration...
4/26/18 8:44 AM (admin) Failure: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-28040: No matching authentication protocol
4/26/18 8:44 AM (admin) Verifying App Service (app) Configuration...

Here is the same issue with my SQL developer used ojdbc14.jar:

However, My colleague, who has ojdbc8.jar file in his newer SQL developer, can connect to that Oracle 12c Database…

So for us the point is how can we set this driver to use it in Clarity? Simple copying ojdbc8.jar file into niku/clarity/lib and restarting Clarity didn’t help…Or if you have any other way how can we solve it, please advise.

Appreciate help fromNika_Hadzhikidi, gcubed, nick_darlington in advance as this is quite urgent for us because we can't move on with our upgrade activities.

Thanks a lot!

Matej

What Clarity version are you on - IIRC when 12c was "new" then Clarity did not support it for a few versions but you could get it to work by using 12c in a legacy mode (i.e. fix the database not Clarity)

( ref Road map of Oracle 12c support )

Try setting the SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016

V/r,

Gene

^ you mean like it says in the "Actions" in that error message

Hi, 

After setting of param, unfortunately we got to this bug which should be solved in 15.4 installation

https://communities.ca.com/message/242014110-re-when-we-run-installbat-oracle-ora-01017-invalid-username-password-denied… 

Thanks guys again, 

Matej