ORACLE DATABASE PROBLEM AND SOLUTIONS

Tuesday, January 4, 2022

AWS Certified Database Specialty

Monday, January 3, 2022

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

Detach Home from Oracle Inventory - 19c oracle database

Go to below location :

/u01/app/oracle/product/19.0.0/dbhome/oui/bin

[oracle@ip- bin]$

[oracle@ip- bin]$ ./runInstaller -silent -detachhome -invPtrLoc /etc/oraInst.loc oracle_home="/u01/app/oracle/product/19.0.0/dbhome" ORACLE_HOME_NAME="OraDB19Home1"

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 699 MB Passed

The inventory pointer is located at /etc/oraInst.loc

You can find the log of this install session at:

/u01/app/oraInventory/logs/DetachHome2022-01-03_05-40-07PM.log

'DetachHome' was successful.

[oracle@ip- bin]$

[oracle@ip- bin]$ pwd

/u01/app/oracle/product/19.0.0/dbhome/oui/bin

[oracle@ip- bin]$

Thursday, October 14, 2021

How to install Terraform RHEL8

Install Terraform RHEL8

==============================

[root@ip-192.168.1.1 ~]#

[root@ip-192.168.1.1 ~]# dnf install -y dnf-plugins-core

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Red Hat Update Infrastructure 3 Client Configuration Server 8 HA 30 kB/s | 2.1 kB 00:00

Red Hat Enterprise Linux 8 for x86_64 - AppStream from RHUI (RPMs) 38 kB/s | 2.8 kB 00:00

Red Hat Enterprise Linux 8 for x86_64 - AppStream from RHUI (RPMs) 69 MB/s | 33 MB 00:00

Red Hat Enterprise Linux 8 for x86_64 - BaseOS from RHUI (RPMs) 32 kB/s | 2.4 kB 00:00

Red Hat Enterprise Linux 8 for x86_64 - BaseOS from RHUI (RPMs) 101 MB/s | 37 MB 00:00

Red Hat Enterprise Linux 8 for x86_64 - High Availability (RPMs) from RHUI 27 kB/s | 2.4 kB 00:00

Red Hat Enterprise Linux 8 for x86_64 - High Availability (RPMs) from RHUI 11 MB/s | 2.5 MB 00:00

Package dnf-plugins-core-4.0.18-4.el8.noarch is already installed.

Dependencies resolved.

Nothing to do.

Complete!

[root@ip-192.168.1.1 ~]#

[root@ip-192.168.1.1 ~]# dnf config-manager --add-repo https://rpm.releases.hashicorp.com/$release/hashicorp.repo

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Adding repo from: https://rpm.releases.hashicorp.com//hashicorp.repo

Status code: 404 for https://rpm.releases.hashicorp.com//hashicorp.repo (IP: 199.232.66.49)

Error: Configuration of repo failed

[root@ip-192.168.1.1 ~]#

********** Repo url has issue (Status code: 404 for https://rpm.releases.hashicorp.com//hashicorp.repo (IP: 199.232.66.488))*********** You have to set variable export release=RHEL

[root@ip-192.168.1.1 ~]#

[root@ip-192.168.1.1 ~]# dnf config-manager --add-repo https://rpm.releases.hashicorp.com/RHEL/hashicorp.repo

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Adding repo from: https://rpm.releases.hashicorp.com/RHEL/hashicorp.repo

[root@ip-192.168.1.1 ~]#

[root@ip-192.168.1.1 ~]# yum install terraform

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Last metadata expiration check: 0:00:15 ago on Thu 14 Oct 2021 05:11:42 AM UTC.

Dependencies resolved.

=========================================================================================================================================================================

Package Architecture Version Repository Size

=========================================================================================================================================================================

Installing:

terraform x86_64 1.0.9-1 hashicorp 25 M

Transaction Summary

=========================================================================================================================================================================

Install 1 Package

Total size: 25 M

Installed size: 76 M

Is this ok [y/N]: y

Downloading Packages:

[SKIPPED] terraform-1.0.9-1.x86_64.rpm: Already downloaded

warning: /var/cache/dnf/hashicorp-164999f2fbadbd87/packages/terraform-1.0.9-1.x86_64.rpm: Header V4 RSA/SHA512 Signature, key ID a3219f7b: NOKEY

Hashicorp Stable - x86_64 161 kB/s | 3.1 kB 00:00

Importing GPG key 0xA3219F7B:

Userid : "HashiCorp Security (HashiCorp Package Signing) <security+packaging@hashicorp.com>"

Fingerprint: E8A0 32E0 94D8 EB4E A189 D270 DA41 8C88 A321 9F7B

From : https://rpm.releases.hashicorp.com/gpg

Is this ok [y/N]: y

Key imported successfully

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing : terraform-1.0.9-1.x86_64 1/1

Verifying : terraform-1.0.9-1.x86_64 1/1

Installed products updated.

Installed:

terraform-1.0.9-1.x86_64

Complete!

[root@ip-192.168.1.1 ~]#

[root@ip-192.168.1.1 ~]# terraform -version

Terraform v1.0.9

on linux_amd64

[root@ip-192.168.1.1 ~]#

[root@ip-192.168.1.1 ~]# terraform -help

Usage: terraform [global options] <subcommand> [args]

The available commands for execution are listed below.

The primary workflow commands are given first, followed by

less common or more advanced commands.

Main commands:

init Prepare your working directory for other commands

validate Check whether the configuration is valid

plan Show changes required by the current configuration

apply Create or update infrastructure

destroy Destroy previously-created infrastructure

All other commands:

console Try Terraform expressions at an interactive command prompt

fmt Reformat your configuration in the standard style

force-unlock Release a stuck lock on the current workspace

get Install or upgrade remote Terraform modules

graph Generate a Graphviz graph of the steps in an operation

import Associate existing infrastructure with a Terraform resource

logout Remove locally-stored credentials for a remote host

output Show output values from your root module

providers Show the providers required for this configuration

refresh Update the state to match remote systems

show Show the current state or a saved plan

state Advanced state management

taint Mark a resource instance as not fully functional

test Experimental support for module integration testing

untaint Remove the 'tainted' state from a resource instance

version Show the current Terraform version

workspace Workspace management

Global options (use these before the subcommand, if any):

-chdir=DIR Switch to a different working directory before executing the

given subcommand.

-help Show this help output, or the help for a specified subcommand.

-version An alias for the "version" subcommand.

Monday, August 16, 2021

Oracle 21c Database Installation on AWS Redhat Linux 8

Oracle 21c database installation on Linux 8

RPM Requirements :

dnf install -y bc

dnf install -y binutils

dnf install -y compat-openssl10

dnf install -y elfutils-libelf

dnf install -y glibc

dnf install -y glibc-devel

dnf install -y ksh

dnf install -y libaio

dnf install -y libXrender

dnf install -y libX11

dnf install -y libXau

dnf install -y libXi

dnf install -y libXtst

dnf install -y libgcc

dnf install -y libnsl

dnf install -y libstdc++

dnf install -y libxcb

dnf install -y libibverbs

dnf install -y make

dnf install -y policycoreutils

dnf install -y policycoreutils-python-utils

dnf install -y smartmontools

dnf install -y sysstat

dnf install -y unixODBC

dnf install xorg-x11*

Security Limits requirements :

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

oracle hard memlock 134217728

oracle soft memlock 134217728

oracle soft data unlimited

oracle hard data unlimited

[oracle@ip dbhome]$

[oracle@ip dbhome]$ sqlplus "/as sysdba"

SQL*Plus: Release 21.0.0.0.0 - Production on Mon Aug 16 10:40:18 2021

Version 21.3.0.0.0

Connected to:

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

Version 21.3.0.0.0

SQL> select name ,open_mode from v$database;

NAME OPEN_MODE

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

ORCL READ WRITE

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 ORCLPDB READ WRITE NO

SQL>

Sunday, August 15, 2021

Oracle Database 21c is available for download on Linux OS

Wednesday, July 14, 2021

Check Kernel and Package information in Linux OS

Check Kernel and Package information in Linux

check Linux distribution and version

====================================================

[root@localhost ~]# cat /etc/os-release

NAME="Oracle Linux Server"

VERSION="7.8"

ID="ol"

ID_LIKE="fedora"

VARIANT="Server"

VARIANT_ID="server"

VERSION_ID="7.8"

PRETTY_NAME="Oracle Linux Server 7.8"

ANSI_COLOR="0;31"

CPE_NAME="cpe:/o:oracle:linux:7:8:server"

HOME_URL="https://linux.oracle.com/"

BUG_REPORT_URL="https://bugzilla.oracle.com/"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"

ORACLE_BUGZILLA_PRODUCT_VERSION=7.8

ORACLE_SUPPORT_PRODUCT="Oracle Linux"

ORACLE_SUPPORT_PRODUCT_VERSION=7.8

[root@localhost ~]#

[root@localhost ~]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 7.8 (Maipo)

[root@localhost ~]#

[root@localhost ~]# cat /etc/oracle-release

Oracle Linux Server release 7.8

[root@localhost ~]#

check kernel version

============================

[root@localhost ~]# uname -r

4.14.35-1902.300.11.el7uek.x86_64

[root@localhost ~]#

To check Package is installed or not

=========================================

rpm -q package_name

rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep package_name

[root@localhost ~]#

[root@localhost ~]# rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep ssh

openssh-server-7.4p1-21.0.1.el7 (x86_64)

openssh-7.4p1-21.0.1.el7 (x86_64)

openssh-clients-7.4p1-21.0.1.el7 (x86_64)

libssh2-1.8.0-3.el7 (x86_64)

[root@localhost ~]#

check multiple packages, and review the output for the validations

====================================================================

rpm -q binutils compat-libstdc++ gcc glibc libaio libgcc libstdc++ \

make sysstat unixodbc

[root@localhost ~]# rpm -q binutils compat-libstdc++ gcc glibc libaio libgcc libstdc++ \

> make sysstat unixodbc

binutils-2.27-43.base.0.1.el7.x86_64

package compat-libstdc++ is not installed

gcc-4.8.5-39.0.3.el7.x86_64

glibc-2.17-307.0.1.el7.1.x86_64

libaio-0.3.109-13.el7.x86_64

libgcc-4.8.5-39.0.3.el7.x86_64

libstdc++-4.8.5-39.0.3.el7.x86_64

make-3.82-24.el7.x86_64

sysstat-10.1.5-19.el7.x86_64

package unixodbc is not installed

[root@localhost ~]#