| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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 |
|
| 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
exec gsmadmin_internal.dbms_gsm_xdb.setXDBport(8080);
*
ORA-06598: insufficient INHERIT PRIVILEGES privilege
GRANT gsmadmin_role TO system;
Grant succeeded.
conn system/N0Way!
Connected.
exec gsmadmin_internal.dbms_gsm_xdb.setXDBport(8080);
PL/SQL procedure successfully completed. |