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]$
Complex Oracle 19c to PostgreSQL 15 Database Migration
Production-oriented migration approach for a complex Oracle 19c to PostgreSQL 15 workload , covering assessment, schema and code conversion,...
-
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 ...