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

How to Create / Install repo on Solaris 11.4 ?

 Create / Install repo on Solaris 11.4

root@solaris11:/package_sol#

root@solaris11:/package_sol# ./install-repo.ksh -d repo/

Using sol-11_4-repo download.

Uncompressing sol-11_4-repo_1of5.zip...done.

Uncompressing sol-11_4-repo_2of5.zip...

done.

Uncompressing sol-11_4-repo_3of5.zip...done.

Uncompressing sol-11_4-repo_4of5.zip...

done.

Uncompressing sol-11_4-repo_5of5.zip...done.

Repository can be found in repo/.

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol# pkg set-publisher -G '*' -M '*' -g /package_sol/repo solaris

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol# pkg info -r solaris-desktop

          Name: group/system/solaris-desktop

       Summary: Oracle Solaris Desktop

   Description: Provides an Oracle Solaris desktop environment

      Category: Meta Packages/Group Packages

         State: Not installed

     Publisher: solaris

       Version: 11.4

        Branch: 11.4.0.0.1.15.0

Packaging Date: Fri Aug 17 00:35:39 2018

          Size: 2.52 kB

          FMRI: pkg://solaris/group/system/solaris-desktop@11.4-11.4.0.0.1.15.0:20180817T003539Z

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol# pkg install solaris-desktop

           Packages to install: 357

           Mediators to change:   1

            Services to change:  17

       Create boot environment:  No

Create backup boot environment:  No

DOWNLOAD                                PKGS         FILES    XFER (MB)   SPEED

Completed                            357/357   61930/61930  958.4/958.4      --

PHASE                                          ITEMS

Installing new actions                   76265/76265

Updating package state database                 Done

Updating package cache                           0/0

Updating image state                            Done

Creating fast lookup database                   Done

Updating package cache                           1/1

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol#

root@solaris11:/package_sol# shutdown -i6 -g0 -y

AWS Certified Database Specialty

 

How to empty swap if there is free RAM? : Linux Red-hat OS

Using root user 

 

 free -m

              total        used        free      shared  buff/cache   available

Mem:          15646        3908        1360        3237       10376        8192

Swap:           699         285         414

swapoff -a

swapon -a

 free -g

              total        used        free      shared  buff/cache   available

Mem:             15           4           1           3          10           7

Swap:             0           0           0