Posts by Biju Muthusamy

Oracle Database Upgrade from 12c to 19c database Using Manual Upgrade

Introduction: There are different methods to upgrade an Oracle database from a lower version to a higher version. Oracle provides multiple methods to upgrade based on the version. A few…

Read More

Oracle Database 19c Patch Release Update – Jan 2021(Patch Id – 32218454)

DESCRIPTION This article we are going to see steps to apply the latest Oracle 19c Database Release Update Patch 32218454 DOWNLOAD THE PATCH FROM ORACLE SUPPORT  CHECK THE CURRENT OPTACH…

Read More

Oracle Database Cloning

DESCRIPTION: In this blog,we are going to learn Oracle Database Cloning. INTRODUCTION: The cloning operation creates a copy of the database data files, and creates new online redo log files…

Read More

ORA-01157: CANNOT IDENTIFY/LOCK DATA FILE %S – SEE DBWR TRACE FILE

DESCRIPTION: In this blog,we are going to resolve ORA-01157 error in database. Cause: The background process was either unable to find one of the data files or failed to lock…

Read More

ORA – 19809 & ORA – 19804

DESCRIPTION: In this article, we are going to see how to resolve ORA – 19809 & ORA – 19804. CAUSE: By default RMAN backup goes to Flash Recovery Area if…

Read More

ORA-02019: CONNECTION DESCRIPTION FOR REMOTE DATABASE NOT FOUND.

DESCRIPTION: In this blog,we are going to know about how to overcome ORA-02019 error in database. CAUSE: An attempt was made to connect or log in to a remote database…

Read More

RESTORE DROPPED TABLES FROM RECYCLE BIN

DESCRIPTION: In this blog,we are going to see how to restore dropped table from recyclebin. Oracle database has the recycle bin which is a data dictionary table and contains information…

Read More

Transportable Tablespace using RMAN

DESCRIPTION: In this article, we are going to know how to perform Transportable tablespace using Rman. [oracle@trichy BIJU1]$ rman target / Recovery Manager: Release 12.2.0.1.0 - Production on Mon Jan…

Read More

Restore control file without backup

DESCRIPTION: In this article we are going to see how to Restore control file without backup. Step 1 – Start the instance [oracle@trichydoyen ~]$ export ORACLE_SID=BIJU1 [oracle@trichydoyen ~]$ sqlplus /…

Read More

Creating A Multitenant Database in Oracle 19c using DBCA.

Description:- In this Blog,we are going to Creating A MultiTenant Database In Oracle 19c. The primary database that contains multiple plugged-in databases. Many operations can be performed at the container…

Read More