Oracle RAC Configuration
Enabling Auto Registration: To enable automatic registration of RAC device definitions by SQLProxy, you need to set the following parameter in the system configuration manager:
Parameter Name | Parameter Value |
---|---|
sql.proxy.node.auto.register.enabled | yes |
Adding Oracle RAC Database to KRON PAM: Follow the standard procedure to add the Oracle RAC database to KRON PAM: • Navigate to Device Add. • Assign the device to a Device Group. • Add a user under User add. • Assign the user to a User group. • Define a Policy Key. • Set up a Mask Policy. • Group the policies under Policy Group. • Finally, assign the device to a Realm.
Configuring Database Properties: Once the Oracle RAC database is added to KRON PAM, you need to specify its properties. Follow the standard procedure to add the properties.
Connecting to RAC Database via SQL Client in KRON PAM: When you attempt to connect to the RAC database inside KRON PAM using an SQL client, KRON PAM will automatically detect all the databases within that cluster.