Clone a Database User by Query

Script to pull/show a database user’s privileges or clone a user by query.

Continue reading

Oracle 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 reading

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 reading

Create a filesystem on Linux

In this article, I will show how to create a filesystem and mount it on Linux.

Continue reading

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 reading

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 reading

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 reading

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.

Continue reading

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:

Continue reading

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