Thursday, August 18, 2022

Download Terraform binary software

 

Use below link to download the Terraform 



https://www.terraform.io/downloads





Sunday, June 12, 2022

Download Sample database for oracle

 


Here is the link to download sample database for oracle :



https://www.oracle.com/in/database/technologies/appdev/datamodeler-samples.html




https://www.oracle.com/database/technologies/spatial-graph-here-data-downloads.html





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;

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