Oracle HS issue conecting to sqlserver ORA-28500 and ORA-2063 connection from ORACLE to a non-Oracle
Hi We have only yesterday started receiving the following alerts in an alert log ORA-28500 and ORA-2063
The HS / database link is to a SQLserver database
The oracle database is back level (11.2.0.1). I applied a patch to the DB 2 days ago to fix TNS Poisoning vulnerability - was applied to implement COST doc id 1453883.1.
No error is showing in the listener log. Added the following line to the listener.ora
SECURE_REGISTER_LISTENER_PROD = (TCP)
We are currently unable to upgrade this particular Oracle database.
On checking the sqlserver log I see the following error:
Login failed for user 'RECOVER' reason could not find a login matching the name provided [CLIENT: 10.*.*.*]