OPS$ mechanism suddenly stops working on Windows 2012R2

[symon_braunbaer]

Dear Experts,

there is a weird issue, happening accross the landscape (on Windows Server 2012R2),
but ONLY on 18c databases...
Out of a sudden, sqlplus / as sysdba starts producing ORA-01017 errors !!
It becomes impossible to login to sqlplus and only rebooting the Windows box brings
a solution.
I have noticed, that the DB was only patched from 18.3 to 18.5, but no SAP bundle
patch has been applied...

Any helpful ideas will be highly appreciated 🙂 Many thanks !!!

[janos_mucsi-besze]

Hi Symon,

This looks like very similar to the issue documented in SAP note below:

2773486 - Oracle 12c On Windows: Local SYSDBA Authentication Fails With ORA-1017

Although it might look that this is affecting only 12c, it is a mistake. The same issue is got resolved Windows BP 18.10.0.0.200414. So based on your description, the chances of getting this error on this system is quite high.

[symon_braunbaer]

THANKS a lot, Janos !!

I have also run the select from the note. The parameter is set to FALSE.
I will negotiate either the DB to be patched or to set the parameter. Cheers and thanks AGAIN !!!

[janos_mucsi-besze]

Anytime! 🙂