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
Undocumented Global Service Manager Administration Utilities.
The installation file contains the following note: "since changes to gsmadmin_internal tables aren't propagated to logical standbys, mark all gsm packages as unsupported"
Puts the provided encryption key in the shard_keys table
The demo at right is from a 21c database without sharding
dbms_gsm_sec.putKey(
key_id IN NUMBER,
sec_key IN RAW);
exec dbms_gsm_sec.putKey(3, 'DCC2ABB2B90B88666D77B929A0A8C1570725F2F7');
BEGIN dbms_gsm_sec.putKey(3, 'DCC2ABB2B90B88666D77B929A0A8C1570725F2F7'); END;
*
ERROR at line 1:
ORA-03876: error -5 when attempting to generate a temporary key to add new shards
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_GSM_SEC", line 168
ORA-06512: at line 1
The demo at right is from a 21c database without sharding
dbms_gsm_sec.putTmpKey(
dbname IN VARCHAR2,
tmp_key IN RAW);
exec dbms_gsm_sec.putTmpKey('TEST21DB', 'DCC2ABB2B90B88666D77B929A0A8C1570725F2F7');
BEGIN dbms_gsm_sec.putTmpKey('TEST21DB', 'DCC2ABB2B90B88666D77B929A0A8C1570725F2F7'); END;
*
ERROR at line 1:
ORA-03876: error 46693 when attempting to generate a temporary key to add new shards
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_GSM_SEC", line 50
ORA-06512: at line 1