Sometimes DBA need to verify or compare multiple tables record count. It is really time consuming to compare one by one table count. So, by using this query, you will able to get record count report for multiple tables in Oracle.
Continue readingJan 06 2020
Move Objects From One Tablespace to Another Tablespace in Oracle
Sometimes need to move objects from one Tablespace to another in Oracle Databases. We can do this multiple ways.
- Move a single object from Multiple Tablespace (one TBS for DATA, another for Index and LOB) to different set of Tablespace
- Move all objects of a schema from Multiple Tablespace (one TBS for DATA, another for Index and LOB) to different set of Tablespace
- Move all objects from one Tablespace to another Tablespace
Jan 05 2020
Tips to Avoid Mistake and Be a Safer DBA
There is around 33% disaster occurs on database world for user error/mistake.
If you follow couple of rules, you will able to overcome lots of possible mistake.
Continue readingDec 22 2019
Installing Oracle Client In Silent Mode on Linux
In this article I will show how to install Oracle Client 11g, 12c, 18c and 19c in Silent Mode on Linux.
- Download Software.
- Prepare response File.
- Installation
Dec 15 2019
ORACLE HANG ANALYZE
How to generate Hang Analyze Report when Database Hanged?
Sometimes database hangs due to multiple reasons and company higher managements always looks for RCA. This is very important to have all trace file to find the issue for hanging the database or fine the RCA. Otherwise Oracle Support will say sorry!!!
Get a hang analyze report by running below commands when you notice that the database is hanged.
Continue readingDec 12 2019
Oracle Database 11g Release 2 RAC On Oracle Linux 7.1
Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability.
Below high level steps will perform to install/configure Oracle RAC:
- Configure 2 Virtual Machine (VM) for 2 Nodes RAC.
- Install Oracle Linux 7.1.
- Oracle Installation Prerequisites.
- Additional Setup.
- Create Shared Disk.
- Clone the Virtual Machine for Node2.
- Install GI (Grid Infrastructure).
- Configure ASM.
- Install Oracle Database Binary and Create Database on RAC.
- Issues.
Nov 20 2019
Connect VM using Putty from Local Computer
For a DBA, this is very important to connect Oracle Database using putty to run command very easily. In real life/working place, most of Oracle DBA use putty to manger oracle databases.
Follow below two very simple steps.
Continue readingNov 15 2019
Configure Network between two Physical Machines for VM Setup
Configure network in two laptops / PC:
Connect two physical machine with network cross cable. Then setup network:
Install VM on Oracle Linux : https://www.virtualbox.org/ticket/14716
Continue readingNov 09 2019
Oracle Database 12c, 18c & 19c Product Versions and Upgradation Path
As you may know Oracle introduced a new versioning formation from 18c. Until 12.2.0.1 Oracle was releasing versions like 10g, 11g, and 12c. Oracle announced to release a version every year from 2018 and it could be like Oracle Database 18c, 19c and 20c.
Oracle Database 12c: Oracle database 12c consider all version from 12c R1(12.1.0.2) to 12c R2 (12.2.0.1) .
Continue readingAbout Me
- Bachelor of Science in Computer Science, Dhaka, Bangladesh
- Master of Science in Data Warehousing & Data Mining, London, UK
- Master of Science in Computer Science, MIU, IA, USA
- Oracle Cloud Infrastructure Architect Professional
- Oracle OCP 9i-12c
- Oracle OCE RAC and GRID 11g
- Oracle OCS Security 11g
- Oracle PL/SQL OCA 10g
- Red Hat Enterprise Linux 6 RHCE
