Hi,
I installed Oracle 12c on Windows 2012. I can connect as SYS, common and local users, but I can't get windows authentication working.
I've set users up in the database with OPS$ in front of their name, as well as OPS$machinename\username and OPS$domain.machinename\username. I've then tried connecting as sqlplus /@orclpdb but they all fail to connect with ORA-01017 invalid username/password.
As a test, on my laptop I created a windows user and successfully logged on using sqlplus /@orclpdb but there are no domain settings on my laptop.
The domain name is is two parts e.g domain.service, so I think OPS$machine.domain.service\username is the correct format.
Has anyone successfully set up windows authentication?