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

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;

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 

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]#