Oracle Clusters

What is an Oracle Cluster?

An Oracle cluster is a network of linked servers that function as a unified system for applications and users, ensuring high availability, scalability, and fault tolerance.

How is an Oracle Cluster useful?

Oracle clusters improve the reliability, scalability, and performance of Oracle databases and applications.

How do you manage an Oracle Cluster?

When Oracle Databases are part of a cluster, multiple assets are discovered by the Password Safe scanner. However, the scanner includes Oracle Database Details for managed systems. For example, if two assets representing two cluster nodes point to the same Oracle database, a single managed system is shown in BeyondInsight, with two pointers to the two hosts or cluster nodes. This occurs because the scanner discovers the Oracle Database GUID and service name, which are the same for both cluster nodes.

If one of the cluster nodes is down or not reachable when Password Safe tries to communicate with it, Password Safe is able to fail over to another node successfully to complete the operation.

ℹ️

Note

Permissions (SYSDBA or SYSOPER) required to scan cluster nodes are the same as those required to scan a non-clustered Oracle Database. The difference is whether or not a Database GUID and service name are unique to a scanned node, or shared across multiple scanned nodes.

The SYSDBA system privilege is for fully empowered database administrators and the SYSOPER system privilege allows a user to perform basic operational tasks, but without the ability to look at user data. The SYSDBA and SYSOPER system privileges allow access to a database instance even when the database is not open.