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

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

PostgreSQL Process Architecture Diagram and Details

PostgreSQL Process Architecture Diagram                            +------------------+                            |    POSTMASTER    |     ...