Oracle DBMS_GSM_XDB
Version 19.3

General Information
Library Note Morgan's Library Page Header
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 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.0.1
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.

SQL> sho user
USER is "SYS"
SQL> 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.

Related Topics
Built-in Functions
Built-in Packages
DBMS_EPG
DBMS_GSM_DBADMIN
DBMS_XDB
DBMS_XDB_ADMIN
DBMS_XDB_CONFIG
DBMS_XDBREPOS
DBMS_XEVENT
What's New In 18cR3
What's New In 19cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
DBSecWorx