For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
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;