0

I am trying to connect to my Oracle DB with Windows authentication, and it just doesn't seem to work - Whatever I do I keep getting "ORA-01017: invalid username/password; logon denied".

I installed Oracle DB version 21c, and upon that created a new windows user as the Oracle Home User. My global DB name is orcl.ad11.siemens.net, and the PDB is orclpdb.

I've created a new listener with the following configuration in listener.ora:

LISTENER_2 =
    (DESCRIPTION_LIST =
        (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
            (ADDRESS =   (PROTOCOL = IPC)(KEY = PNPKEY))))

SID_LIST_LISTENER_2 =
    (SID_LIST =
        (SID_DESC =
            (GLOBAL_DBNAME = ORCLPDB.AD11.SIEMENS.NET)
            (ORACLE_HOME = C:\Oracle\OraDB21c\WINDOWS.X64_213000_db_home)
            (SID_NAME = ORCLPDB)))

And added an alias in tnsnames.ora:

LISTENER_2 =
    (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
        (CONNECT_DATA =
            (SERVICE_NAME = ORCLPDB.AD11.SIEMENS.NET)))

When I execute "lsnrctl status LISTENER_2", I get:

STATUS of the LISTENER
------------------------
Alias                     LISTENER_2
Version                   TNSLSNR for 64-bit Windows: Version 21.0.0.0.0 - Production
Start Date                05-DEC-2024 15:18:31
Uptime                    0 days 0 hr. 1 min. 0 sec
Trace Level               admin
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\Oracle\OraDB21c\WINDOWS.X64_213000_db_home\network\admin\listener.ora
Listener Log File         C:\Oracle\OraDB21c\diag\tnslsnr\<my-hostname>\listener_2\alert\log.xml
Listener Trace File       C:\Oracle\OraDB21c\diag\tnslsnr\<my-hostname>\listener_2\trace\ora_23584_28284.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\PNPKEYipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<my-hostname>.ad11.siemens.net)(PORT=5500))(Security=(my_wallet_directory=C:\ORACLE\ORADB21C\admin\orcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "75b0d2bd17c4485c998c967244b4515d.ad11.siemens.net" has 1 instance(s).
  Instance "orcl", status READY, has 2 handler(s) for this service...
Service "ORCLPDB.AD11.SIEMENS.NET" has 2 instance(s).
  Instance "ORCLPDB", status UNKNOWN, has 1 handler(s) for this service...
  Instance "orcl", status READY, has 2 handler(s) for this service...
Service "bc74b627f47a416ab26784e660b5c7b2.ad11.siemens.net" has 1 instance(s).
  Instance "orcl", status READY, has 2 handler(s) for this service...
Service "orcl.ad11.siemens.net" has 1 instance(s).
  Instance "orcl", status READY, has 2 handler(s) for this service...
Service "orclXDB.ad11.siemens.net" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

I noticed the status of ORCLPDB is UNKNOWN but I have no idea why - guess it might be something to consider as the source of the problem.

Additionally, I added the following line to sqlnet.ora:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

And I also granted my current windows user with the required privileges, and it's verified by the fact that:

ALTER SESSION SET CONTAINER = ORCLPDB;
SELECT USERNAME, AUTHENTICATION_TYPE FROM DBA_USERS WHERE AUTHENTICATION_TYPE = 'EXTERNAL';

Returns my current windows user.

I use the following command to connect:

sqlplus /@LISTENER_2

And tried many other ways as well, but keep getting that ORA-01017.

Does anyone have a clue what is the problem here and how can I fix it?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.