Friday, March 25, 2022

User unable to login /connect with database after upgrade AWS RDS to 19c Database : Error - ORA-01017: invalid username/password

 

Users unable to login / connect with database after upgrade AWS RDS to 19c : Error - ORA-01017: invalid username/password


App users were getting below error after upgrade the AWS Oracle RDS database version 12c to 19c .


ORA-01017: invalid username/password;



Solution :


Need to update below parameter in parameter group :

 

sqlnetora.sqlnet.allowed_logon_version_server  => 8


Also check password version : 


SELECT USERNAME,ACCOUNT_STATUS,PASSWORD_VERSIONS FROM DBA_USERS;

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

Tuesday, March 15, 2022

RMAN Error : ORA-19809: limit exceeded for recovery files, ORA-19804: cannot reclaim

 
RMAN Error : ORA-19809: limit exceeded for recovery files, ORA-19804: cannot reclaim



channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/11/2022 09:46:38

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 27108864 bytes disk space from 41474836 limit



Possible Solutions :


  • Check backup retention in RMAN configuration 
  • check FRA size  : DB_RECOVERY_FILE_DEST_SIZE 
  • crosscheck backup/archive and delete 

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

Saturday, February 26, 2022

Solution for Git Error : fatal: Not a valid object name: 'master'.

 fatal: Not a valid object name: 'master'. 


We are getting this error due to master branch is not present . 

so we have to create empty master branch :


Solutions:

[root@oracle19c production]# git branch dev

fatal: Not a valid object name: 'master'.

[root@oracle19c production]#

[root@oracle19c production]#

[root@oracle19c production]# git commit --allow-empty -m "anurag"

[master (root-commit) 47e4721] anurag

[root@oracle19c production]#

[root@oracle19c production]# ls -la

total 0

drwxr-xr-x. 1 root root   8 Feb 26 17:45 .

dr-xr-x---. 1 root root 230 Feb 26 17:45 ..

drwxr-xr-x. 1 root root 134 Feb 26 17:48 .git

[root@oracle19c production]#

[root@oracle19c production]#

[root@oracle19c production]# git branch dev

[root@oracle19c production]#

[root@oracle19c production]#

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

Oracle Database Deep Health Check Checklist

Oracle Database Deep Health Check Checklist Recommended assessment levels Level Purpose Typical scope L1 Operational health Availability, sp...