Script to pull/show a database user’s privileges or clone a user by query.
Continue readingOracle GolgeGate
Oracle GoldenGate is a comprehensive software solution provided by Oracle for real-time data integration and replication in heterogeneous IT environments. It enables the exchange and manipulation of data at the transaction level among multiple, diverse platforms across the enterprise
Continue readingFeb 18 2021
Create a Trace file for Control file
Sometimes DBA needs to create database creation script from existing database. Oracle provides the “alter database backup controlfile to trace” command to copy the create database syntax into a trace file.
Continue readingJan 16 2021
Create a filesystem on Linux
In this article, I will show how to create a filesystem and mount it on Linux.
Continue readingNov 13 2020
Oracle Database Performance Issue Troubleshooting and Tuning Part – I
“Database or query is performing very slow”. This is a very common complain for DBA. Database performance is an art as there is always have an option to tune. There is no limit to tuning the database performance but DBA need to meet the company’s threshold or SLA. There are lots of factors involved to get database response slow.
Continue readingNov 07 2020
Restoring Corrupted Datafile Using RMAN in Oracle
Datafile corrupt is a partial disaster in database. it will impact for all objects belonging the tablespace. In this case, DBA can either restore the problematic/corrupted datafile from backup.
Continue readingNov 07 2020
Performing Block Media Recovery in Oracle
In most cases, the database marks a block as media corrupt and then writes it to disk when the corruption is first encountered. No subsequent read of the block will be successful until the block is recovered. You can only perform block recovery on blocks that are marked corrupt or fail a corruption check.
Continue readingOct 27 2020
Configure and Manage RMAN Recovery Catalog
Recovery Catalog: A set of Oracle tables and views used by RMAN to store RMAN repository information about one or more Oracle databases. RMAN uses this metadata to manage the backup, restore, and recovery of Oracle databases.
Target Database: In an RMAN environment, the database to which you are connected as TARGET
. The target database is the database on which you are performing RMAN operations.
Oct 16 2020
Oracle Database 12c R2 (12.2) RAC On Oracle Linux 7
Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. In this article, I will show how to install Oracle RAC (12.2.0.1) on Oracle Enterprise Linux 7.1.
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.
Oct 16 2020
How to Show All Privileges for a User in Oracle Database
Sometimes DBA needs to generate the report to provide audit team or management about the users access information on database. In this article, I will show how to get list of access for oracle user.
Query to find all privileges for all users in Database:
Continue reading