Monday, January 3, 2022

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

[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]$

[oracle@ip- bin]$

[oracle@ip- bin]$

[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

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

  • Login as root user


[root@ip-192.168.1.1 ~]#

[root@ip-192.168.1.1 ~]#

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

[root@ip-192.168.1.1 ~]#

[root@ip-192.168.1.1 ~]#

[root@ip-192.168.1.1 ~]#





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

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

[root@ip-192.168.1.1 ~]#




[root@ip-192.168.1.1 ~]#

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

[root@ip-192.168.1.1 ~]#



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



[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
  login         Obtain and save credentials for a remote host
  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


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>


Sunday, August 15, 2021

Oracle Database 21c is available for download on Linux OS


Oracle Database 21c is available for download on Linux OS