#real application cluster

[sandeep2363]

Can we stop table to be globally accessed in Oracle RAC Environment

Limit Global Access in Oracle RAC Efficiently In Oracle RAC, tables are designed to be globally accessible by default, as RAC’s architecture is built on shared access to all database objects across multiple nodes. This is a key feature of RAC, enabling high availability and scalability. However, while you cannot completely stop a table from being globally accessible in the same way you might in…

Can we stop table to be globally accessed in Oracle RAC Environment

[sandeep2363]

ORA-15260: permission denied on ASM disk group

ORA-15032: not all alterations performed Error: While operating from the grid user in the EXADATA, We are getting this permission denied error. [grid@qr01dbadm01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jan 25 06:43:24 2024 Version 19.9.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release…

View On WordPress

[sandeep2363]

How a node is being evicted in Oracle RAC

Reason for Node eviction in Oracle RAC Environment In Oracle Real Application Clusters (RAC), the eviction of a node from the cluster is typically a result of the Oracle Clusterware’s attempt to maintain the integrity and stability of the cluster in the face of various issues such as communication failures, network partitions, or hardware problems. The eviction process is designed to prevent…

View On WordPress

[sandeep2363]

What are voting disks and their uses in Oracle RAC

What are voting disks and their uses? In Oracle Real Application Clusters (RAC), the Voting Disk is a critical component that plays a crucial role in maintaining cluster integrity and preventing split-brain scenarios. The Voting Disk is used to determine the membership and health of nodes in the cluster. It is an essential part of the Oracle Clusterware infrastructure. Purpose: The primary…

View On WordPress

[sandeep2363]

Create a RAC One Node database by converting the existing RAC database

Create a RAC one node database from existing two node RAC in Oracle Check the status for current running RAC instances: [oracle@host01 ~]$ . oraenv ORACLE_SID = [oracle] ? orcl The Oracle base has been set to /u01/app/oracle [oracle@host01 ~]$ [oracle@host01 ~]$ srvctl status database -db orcl Instance orcl1 is running on node host01 Instance orcl2 is running on node host02 Remove the 2nd…

View On WordPress

[sandeep2363]

How to disable archive in Oracle RAC

Disable archive configuration in Oracle RAC Environment Stop the Oracle database with SRVCTL command to stop DB on all instances: [oracle@host01 ~]$ srvctl stop database -db orcl 2. Connect with Oracle database and Connect with SQLPLUS utility --- Set the environment [oracle@host01 ~]$ . oraenv ORACLE_SID = [orcl1] ? The Oracle base remains unchanged with value /u01/app/oracle -- connect with…

View On WordPress

[sandeep2363]

How to enable Archive Log Mode in Oracle RAC

Configure the Archive Log Mode in Oracle RAC Connect with the any instance of Oracle RAC machine. [oracle@host01 ~]$ ssh oracle@host01 2. Set the Environment setting on machine. [oracle@host01 ~]$ . oraenv ORACLE_SID = [oracle] ? orcl The Oracle base has been set to /u01/app/oracle [oracle@host01 ~]$ 3. Check the Oracle Services running on all hosts. [oracle@host01 ~]$ srvctl status…

View On WordPress

[kalvipeter-blog]

This course will introduce you to the general features and capabilities of Oracle Database 11g Release 1 for Oracle Real Application Clusters (RAC).

This course will introduce you to the general features and capabilities of Oracle Database 11g Release 1 for Oracle Real Application Clusters (RAC).