I have Oracle 12c R2 installed on my Centos instance. I have SQL Developer installed on another Windows instance. I've disabled OS Authentication on the server by adding "local_os_authentication_LISTENER=off" to my listener.ora file. On the database server, I can use sqlplus to connect to my local instance using sqlplus system/xxx@localhost:1521/orcl.
When I use SQL Developer on my Windows instance to connect, I get the following error:
An error was encountered performing the requested operation:
ORA-01017: invalid username/password; logon denied
01017. 00000 - "invalid username/password; logon denied"
*Cause:
*Action:
Vendor code 1017
When I look at my log.xml file, I see that it is attempting to
<msg time='2020-10-06T09:19:19.058+00:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='qaw03-dbol-s002'
host_addr='xxxx::xxx:xxxx:xxxx:xxxx%ens5' pid='32201'>
<txt>06-OCT-2020 09:19:19 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=testuser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.1)(PORT=65460)) * establish * orcl * 0
</txt>
</msg>
How do I change the SQL Developer login authentication to use the standard Oracle authentication instead of the OS authentication?