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 MoreDESCRIPTION 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 MoreDESCRIPTION: 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 MoreDESCRIPTION: 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 MoreDESCRIPTION: 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 MoreDESCRIPTION: 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 MoreDESCRIPTION: 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 MoreDESCRIPTION: 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 MoreDESCRIPTION: 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 MoreDescription:- 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