"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible.
I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Executable by GSM admins in order for GDSCTL to set the XDB port during 'create shardcatalog'.
Used by CREATE SHARDCATALOG -agent_port.
Insufficient INHERIT PRIVILEGES privilege
Owned by GSMADMIN_INTERNAL with EXECUTE granted to the GSMADMIN_ROLE role.
Set the XDB port for the Scheduler Agent using
If NULL the default port is 8080 which is why that value is used in this demo
dbms_gsm_xdb.setXDBport(agent_port IN NUMBER DEFAULT NULL);
SQL> / as sysdba
SQL> sho user
USER is "SYS"
SQL> sho con_id
SQL> exec gsmadmin_internal.dbms_gsm_xdb.setXDBport(8080);
BEGIN gsmadmin_internal.dbms_gsm_xdb.setXDBport(8080); END;
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_XDB", line 14
ORA-06512: at line 1
SQL> grant gsmadmin_role to system;