Oracle DBMS_GSM_XDB
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
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