ORA-02049: timeout: distributed transaction – Application team reported this error ORA-02049. Some of the jobs are getting failed which are fetching data from remote servers using the DBlink.When we looked the issue we found the application team not used proper commit; within transactions and they are fetching the data in bulk from RAC environments. Cause: … Read more
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 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
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
Its very helpful for everyone to understand the RAC ADMINISTRATION COMMANDS in Oracle database. RAC stands for Real Application Cluster which help to manage the high availability of database in case of any disaster. There are some useful command which are using in daily routine to stop and start the services of RAC. Oracle Real … Read more