Oracle | DBMS_GSM

Oracle DBMS_GSM_XDB Version 23c

General Information

Library Note

Morgan's Library Page Header

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_GSM_CURUSER

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.

      

      SQL> conn system/N0Way!

      Connected.

      

      SQL> exec gsmadmin_internal.dbms_gsm_xdb.setXDBport(8080);

      

      PL/SQL procedure successfully completed.

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx