Background: New Oracle 12c install on RHEL7 server. Imported data from existing 11gR2 install (all good there). When we try and connect from the web server, via jdbc driver, we receive an "ORA-28040 No matching authentication protocol" error. This issue is reported many times within the community and has been resolved by updating sqlnet.ora file with SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 and SQLNET.ALLOWED_LOGON_VERSION_SERVER=8. I have completed this and restarted Oracle and the Listener.
My issue now is odd and can't seem to find being reported anywhere. After the sqlnet.ora updates, now when I try and access sqlplus (via sqlplus /), i receieve the ORA-28040 error on the database server and access to a sqlplus prompt is denied. (side not, I still get the ORA-28040 on the web server also)
Any and all help will be appreciated.
side note: I have basically a clone of this server in our test environment and all works great there with the addition to the sqlnet.ora file