ORA ERROR > ORA-03113: end-of-file on communication channel

ORA-03113: end-of-file on communication channel – In this Blog I am going to share my experience with you all on below ORA error. To fix this error we need to first check the oracle database alert logfile to find the cause of the issue. There are many reason to get this error in database so … Read more

Apply Patching On Oracle 12c Database Release Update 12.1.0.2.0

Apply Patching On Oracle 12c Database Release Update 12.1.0.2.0 – In this Blog I am going to share steps for apply the latest JAN-2022 PSU (Patch Set Updates the security fixes and priority fixes). Oracle release the quarterly PSU patch to fix the bugs and enhance the security standards of databases.However without applying PSU database … Read more

Apply Patching On Oracle 19c Database Release Update 19.14.0.0.0

Apply Patching On Oracle 19c Database Release Update 19.14.0.0.0 – In this Blog I am going to share steps for apply the latest JAN-2022 PSU(Patch Set Updates the security fixes and priority fixes). Oracle release the quarterly PSU patch to fix the bugs and enhance the security standards of databases.However without applying PSU database is … Read more

How to reconfigure Oracle Restart

How to reconfigure Oracle Restart – In this article I am going to share steps of re-configure the HAS(high availability services) on GRID Machine. Today I had to reconfigure an Oracle Restart 12c environment, and I want to share with you all who are working on oracle platform. If these steps help to anyone please … Read more

ORACLE DATABASE RAC11G R2 ON LINUX USING NFS

ORACLE DATABASE RAC11G R2 On Linux Using NFS Technology In this article we are describes the installation of ORACLE DATABASE RAC11G R2 (11.2 64-bit) RAC(Real Application Cluster) on Linux (Oracle Enterprise Linux 5.4 64-bit) using NFS to provide the shared storage. • Introduction• Download Software• Operation System Installation• Oracle Installation Prerequisites• Automatic Setup• Manual Setup• … Read more

ORACLE 10G RAC INSTALLATION USING NFS

ORACLE 10G RAC INSTALLATION On Linux Using NFS Technology This article describes the installation of ORACLE 10G RAC (10.2.0.1) on Linux (Oracle Enterprise Linux 4.5) using NFS to provide the shared storage. • Introduction• Download Software• Operating System Installation• Oracle Installation Prerequisites• Create Shared Disks• Install the Cluster ware Software• Install the Database Software• Create … Read more

LOGICAL STANDBY DATABASE

Logical Standby database Logical standby database is a feature introduced in Version 9iR2. In this configuration, redo data is first converted into SQL statements and then applied to the standby database. This process is called SQL Apply. This method makes it possible to access the standby database permanently and allows read/write while the replication of … Read more

DATA GUARD CONFIGURATION WITH PHYSICAL STANDBY MACHINE

Data Guard Configuration

Oracle Data Guard Configuration ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services thatcreate, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guardmaintains these standby databases as transitionally consistent copies of the … Read more

Creating a Snapshot Physical Standby database step by step

Creating a Snapshot Standby database The Snapshot Standby database concept was introduced from the 11g Version, which allows the use of a physical standby database in the read-write mode for a short period of time. You can convert a physical standby to a snapshot standby by using either traditional SQL *Plus or using the Data Guard … Read more

How to enable CRS and restart CRS on all nodes as root owner

In this blog I am going to talk about RAC administration with CRSCTL command. There are most useful command which we are using in daily routine to enable CRS and restart CRS and manage the cluster services. Oracle Real Application Clusters Oracle Real Application Clusters (RAC) allow to run a single standalone Oracle Database across … Read more