ORA-28040 when using Oracle 10g Client with Voyager 10.2
- Product: Voyager
- Product Version: 10.2
- Relevant for Installation Type: All
Question
After upgrading to Voyager 10.2 connection to Voyager using Oracle 10g client produces error "ORA-28040: No matching authentication protocol" and "Driver's SQLSetConnectAttr failed (#0)".
Answer
The Voyager server requires some additional configuration in order for the ODBC 10g drivers to work with Voyager 10.2.
The steps included below can be run by a server Administrator, or you can contact Support and we will run the steps for you.
The following configurations should be performed as the oracle user:
- Log into the voyager server as oracle
- Open the file /exlibris/oracle/app/oracle/product/<oracle version>/network/admin/sqlnet.ora and add the following line:
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
- Log into sqlplus as sysdba:
sqlplus '/ as sysdba'
- In sqlplus run the following commands using your own read only user and read only password:
alter user <read only user> identified by <read only password>
exit
- Restart the Oracle listener:
lsnrctl reload
- Re-attempt connecting to Voyager using ODBC with Oracle 10g drivers.
- Article last edited: 5/26/2020