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


Copyright (c) 1982, 2021, Oracle.  All rights reserved.



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>

SQL>


Wednesday, July 14, 2021

Check Kernel and Package information in Linux OS

 

Check Kernel and Package information in Linux 


check Linux  distribution and version

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

#1

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


#2

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

Red Hat Enterprise Linux Server release 7.8 (Maipo)

[root@localhost ~]#


#3


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


If Database and Application running in different region in AWS Cloud ?

If Database and Application on different region ? 1. Highest-priority recommendation Move the application and primary database into the same...