Support #11459
[SCP ID :##5698##] : RCAS Database Upgrade
Status: | Closed - End of life cycle | Start date: | December 28, 2020 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi Chee Onn,
Kindly assist below request.
We are in the midst of upgrade RCAS database from 11g to 19c. We have performed the necessary steps in SIT as per advised but encountered below error when performed the connectivity test in Websphere . Error as below: “Encountered java.sql.SQLException: ORA-28040: No matching authentication protocol”.
.
Thank you.
History
#1 Updated by Ngoh Chee Onn over 3 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Ngoh Chee Onn to Zahir Abd Latif
Hi Zahir,
Please refer below for the solution provided to Customer. I just received information from customer this issue fixed after they implement solution 1, please closed this case.
Solution 1 (Work on RCAS WAS server):
- stop application server and remove all others ojdbc.jar in ' /[WEBSPHERE_HOME]/AppServer/lib/ext' like ojdbc6.jar and ojdbc14.jar.
- add in ojdbc8.jar or ojdbc10.jar into ' /[WEBSPHERE_HOME]/AppServer/lib/ext' and restart the application server.
Solution 2 (Work on Oracle Server)
- Change allow logon client version in sqlnet.ora file under path ' $ORACLE_HOME/network/admin/sqlnet.ora'
-Parameter change as below.
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 12a
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12a
#3 Updated by Nurul Akmal over 3 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle