Oracle DBMS_GSM_XDB
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"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
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 (new 12.2)
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 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved