Dream Always Dream , if you don't work on it : Real-world Oracle DBA troubleshooting guides for RAC, Data Guard, RMAN, performance tuning, upgrades, backups, and cloud migration. Tested in production environments.
Tuesday, January 4, 2022
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
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 ~]#
AWS EC2 interview Question and Answers
EC2 Instances What is an EC2 instance? An EC2 instance is a virtual machine running in the Amazon Elastic Compute Cloud (EC2) environment....
-
C:\Users\Administrator.ANURAG-PC>tnsping ducat TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 27-DEC-2017 21:...
-
Error while starting ./runInstaller for oracle 19c installation on Linux 8 [oracle@ip-192-168-43-225 oracle]$ ./runInstaller /u01/or...
-
Install CSSCAN login with SYS user @?/rdbms/admin/csminst.sql ############### csscan \"sys as sysdba\" full=y ...