REAL TIME AI ORACLE DATABASE PROBLEM AND SOLUTIONS

Sunday, June 12, 2022

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

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;

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 :