PostgreSQL : How to verify archive mode is enabled or not

 How to verify archive mode is enabled or not

Login to PostgreSQL database with super privilege 

postgres=#

postgres=# show archive_mode;

 archive_mode

--------------

 off

(1 row)

postgres=#

How to check terraform version using command line

 

Check terraform version using command line :

PS C:\test_terraform> terraform  version

Terraform v1.2.8

on windows_amd64

+ provider registry.terraform.io/hashicorp/aws v4.22.0

PS C:\test_terraform>

PS C:\test_terraform>

Download Terraform binary software

 

Use below link to download the Terraform 

https://www.terraform.io/downloads

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