ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Executable by GSM admins in order for GDSCTL to set the XDB port during 'create shardcatalog'.
Used by CREATE SHARDCATALOG -agent_port.
AUTHID
CURRENT_USER
Dependencies
DBMS_XDB_CONFIG
DUAL
Documented
No
Exceptions
Error Code
Reason
ORA-06598
Insufficient INHERIT PRIVILEGES privilege
First Available
12.2
Security Model
Owned by GSMADMIN_INTERNAL with EXECUTE granted to the GSMADMIN_ROLE role.
Source
{ORACLE_HOME}/rdbms/admin/dbmsgwmcl.sql
SETXDBPORT
Set the XDB port for the Scheduler Agent using
DBMS_XDB_CONFIG.SETHTTPPORT()
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
Connected.
sho user USER is "SYS"
sho con_id
CON_ID
------
1
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;
Grant succeeded.
