Tuesday, November 24, 2020

Local User Login Error with PDB in Oracle 19c Database -- Error ORA-01017: invalid username/password; logon denied


Getting below error while connecting local user with PDB database 19c .

ORA-01017: invalid username/password; logon denied

  • Make sure you have PDB instance entry in tnsnames.ora 
  • Listener should be up and running also PDB database service should be register with listener 

 

Query to check service status

SQL>

SQL> SELECT name, pdb FROM   v$services ORDER BY name;

NAME                           PDB

------------------------------ ------------------------------

SYS$BACKGROUND                 CDB$ROOT

SYS$USERS                      CDB$ROOT

sg                             CDB$ROOT

sgXDB                          CDB$ROOT

sg_pdb1                        SG_PDB1

SQL>

SQL>

[oracle@  admin]$ sqlplus test/test@sg_pdb1

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 24 09:17:30 2020

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied



Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

[oracle@admin]$

[oracle@admin]$ vi sqlnet.ora

[oracle@admin]$

[oracle@admin]$

[oracle@admin]$ sqlplus test/test@sg_pdb1

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 24 09:17:46 2020

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Last Successful login time: Tue Nov 24 2020 09:16:12 +00:00

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0


[oracle@admin]$

[oracle@admin]$

[oracle@admin]$ cat sqlnet.ora

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/19.0.0/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.


NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11


[oracle@admin]$

[oracle@admin]$




1 comment:

  1. ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = TRUE;

    please set this parameter to TRUE, issue will be resloved.

    ReplyDelete