Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
This undocumented package contains miscellaneous cache layer PL/SQL functions
for Real Application Clusters (RAC) environments.
Try to dissolve object affinity in RAC environment
dbms_cacheutil.dissolve_affinity(
schema IN VARCHAR2,
obj IN VARCHAR2,
partition IN VARCHAR2 := NULL,
dissolve_index IN BOOLEAN := TRUE,
active_drm IN BOOLEAN := FALSE);
exec dbms_cacheutil.dissolve_affinity(USER, 'SERV_INST');
BEGIN dbms_cacheutil.dissolve_affinity(USER, 'SERV_INST');
END;
*
ERROR at line 1:
ORA-01633: Real Application Clusters Option needed for this operation
ORA-06512: at "SYS.DBMS_CACHEUTIL", line 152
ORA-06512: at line 1
Try to dissolve object readmostly in a RAC environment
dbms_cacheutil.dissolve_readmostly(
schema IN VARCHAR2,
obj IN VARCHAR2,
partition IN VARCHAR2 := NULL,
dissolve_index IN BOOLEAN := TRUE);
exec dbms_cacheutil.dissolve_readmostly(USER, 'SERV_INST');
BEGIN dbms_cacheutil.dissolve_readmostly(USER, 'SERV_INST');
END;
*
ERROR at line 1:
ORA-01633: Real Application Clusters Option needed for this operation
ORA-06512: at "SYS.DBMS_CACHEUTIL", line 185
ORA-06512: at line 1
dbms_cacheutil.grab_affinity(
schema IN VARCHAR2,
obj IN VARCHAR2,
partition IN VARCHAR2 := NULL,
grab_index IN BOOLEAN := TRUE,
active_drm IN BOOLEAN := FALSE);
exec dbms_cacheutil.grab_affinity(USER, 'SERV_INST');
BEGIN dbms_cacheutil.grab_affinity(USER, 'SERV_INST');
END;
*
ERROR at line 1:
ORA-01633: Real Application Clusters Option needed for this operation
ORA-06512: at "SYS.DBMS_CACHEUTIL", line 87
ORA-06512: at line 1
dbms_cacheutil.grab_readmostly(
schema IN VARCHAR2,
obj IN VARCHAR2,
partition IN VARCHAR2 := NULL,
grab_index IN BOOLEAN := TRUE);
exec dbms_cacheutil.grab_readmostly(USER, 'SERV_INST');
BEGIN dbms_cacheutil.grab_readmostly(USER, 'SERV_INST');
END;
*
ERROR at line 1:
ORA-01633: Real Application Clusters Option needed for this operation
ORA-06512: at "SYS.DBMS_CACHEUTIL", line 120
ORA-06512: at line 1