环境为一个CDB和两个PDB。
图片来源
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
4 ORCLPDB2 READ WRITE NO
查看容器数据库进程:
$ pgrep -lf orclcdb
$ pgrep -lf ORCLCDB
1171 ora_pmon_orclcd
1173 ora_clmn_orclcd
1175 ora_psp0_orclcd
1180 ora_vktm_orclcd
1184 ora_gen0_orclcd
1186 ora_mman_orclcd
1190 ora_scmn_orclcd
1194 ora_diag_orclcd
1197 ora_scmn_orclcd
1201 ora_dbrm_orclcd
1203 ora_vkrm_orclcd
1205 ora_svcb_orclcd
1207 ora_pman_orclcd
1209 ora_dia0_orclcd
1211 ora_dbw0_orclcd
1213 ora_lgwr_orclcd
1215 ora_ckpt_orclcd
1217 ora_lg00_orclcd
1219 ora_smon_orclcd
1221 ora_lg01_orclcd
1223 ora_smco_orclcd
1225 ora_reco_orclcd
1229 ora_lreg_orclcd
1231 ora_w001_orclcd
1233 ora_pxmn_orclcd
1238 ora_mmon_orclcd
1240 ora_mmnl_orclcd
1242 ora_d000_orclcd
1244 ora_s000_orclcd
1246 ora_tmon_orclcd
1620 ora_tt00_orclcd
1623 ora_tt01_orclcd
1631 ora_tt02_orclcd
1810 ora_imco_orclcd
1945 ora_aqpc_orclcd
2119 ora_p000_orclcd
2124 ora_p001_orclcd
2132 ora_p002_orclcd
2136 ora_p003_orclcd
2140 ora_p004_orclcd
2144 ora_p005_orclcd
2150 ora_p006_orclcd
2153 ora_p007_orclcd
2912 ora_cjq0_orclcd
3324 ora_qm02_orclcd
3336 ora_q002_orclcd
3361 ora_q004_orclcd
4471 ora_w002_orclcd
4543 ora_w003_orclcd
5059 ora_w004_orclcd
5123 ora_w005_orclcd
5188 ora_w006_orclcd
$ pgrep -lf ORCLPDB
注意,区分大小写,并且只有CDB有后台进程。
查看CDB信息(v$database 和 v$instance):
$ rlwrap sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Sep 2 20:07:58 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
-- CDB为YES表示是容器数据库,容器数据库包含PDB,而非容器数据库不能包含PDB。
SQL> SELECT name, cdb, con_id FROM v$database;
NAME CDB CON_ID
--------- --- ----------
ORCLCDB YES 0
-- 实例名称,状态和容器ID
SQL> SELECT instance_name, status, con_id FROM v$instance;
INSTANCE_NAME STATUS CON_ID
---------------- ------------ ----------
ORCLCDB OPEN 0
监听程序状态:
$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 02-SEP-2019 20:14:35
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 02-SEP-2019 19:28:12
Uptime 0 days 0 hr. 46 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/oracle-12201-vagrant/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=oracle-12201-vagrant)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/product/12.2.0.1/dbhome_1/admin/ORCLCDB/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "90e724bb8f647897e0530100007f48a8" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "90e725a8fbcc78ffe0530100007ff088" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "ORCLCDB" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "ORCLCDBXDB" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "orclpdb1" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "orclpdb2" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
The command completed successfully
服务详情:
$ lsnrctl services
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 02-SEP-2019 20:15:10
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "90e724bb8f647897e0530100007f48a8" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "90e725a8fbcc78ffe0530100007ff088" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "ORCLCDB" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "ORCLCDBXDB" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: oracle-12201-vagrant, pid: 1242>
(ADDRESS=(PROTOCOL=tcp)(HOST=oracle-12201-vagrant)(PORT=10185))
Service "orclpdb1" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "orclpdb2" has 1 instance(s).
Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
为每个容器创建的服务:
SQL> col name format A20
SQL> SELECT name, con_id FROM v$services;
NAME CON_ID
-------------------- ----------
ORCLCDBXDB 1
orclpdb2 4
SYS$BACKGROUND 1
SYS$USERS 1
ORCLCDB 1
orclpdb1 3
6 rows selected.
PDB状态:
SQL> SELECT con_id, name, open_mode FROM v$pdbs;
CON_ID NAME OPEN_MODE
---------- -------------------- ----------
2 PDB$SEED READ ONLY
3 ORCLPDB1 READ WRITE
4 ORCLPDB2 READ WRITE
显示当前容器和容器ID:
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
1
SQL> SELECT sys_context('userenv','CON_NAME') from dual;
SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------
CDB$ROOT
SQL> SELECT sys_context('userenv','CON_ID') from dual;
SYS_CONTEXT('USERENV','CON_ID')
--------------------------------------------------------------------------------
1
显示CDB_XXX视图(层级为CDB_XXX->DBA_XXX->ALL_XXX->USER_XXX):
SQL> col PDB_NAME format a8
SQL> col CON_ID format 99
SELECT pdb_id, pdb_name, dbid, guid, con_id "CID" FROM cdb_pdbs;
PDB_ID PDB_NAME DBID GUID CID
---------- -------- ---------- -------------------------------- ----------
3 ORCLPDB1 1923712247 90E724BB8F647897E0530100007F48A8 3
2 PDB$SEED 2276238845 90E716BB1B737121E0530100007FEFDA 2
4 ORCLPDB2 1286758071 90E725A8FBCC78FFE0530100007FF088 4
cdb_pdbs和v$pdbs非常类似。注意容器ID 1和2始终分配给CDB$ROOT和PDB$SEED. 而0始终分配给容器CDB。
查看CDB的重做日志文件:
SQL> col MEMBER format A40
SQL> SELECT group#, con_id, member FROM v$logfile;
GROUP# CON_ID MEMBER
---------- ------ ----------------------------------------
3 0 /opt/oracle/oradata/ORCLCDB/redo03.log
2 0 /opt/oracle/oradata/ORCLCDB/redo02.log
1 0 /opt/oracle/oradata/ORCLCDB/redo01.log
查看CDB的控制文件:
SQL> col NAME format A60
SQL> SELECT name, con_id FROM v$controlfile;
NAME CON_ID
------------------------------------------------------------ ------
/opt/oracle/oradata/ORCLCDB/control01.ctl 0
/opt/oracle/oradata/ORCLCDB/control02.ctl 0
查看CDB和PDB的数据文件:
set pages 100
col file_name format A60
col tablespace_name format A8
col file_id format 9999
col con_id format 999
set linesize 100
SELECT file_name, tablespace_name, file_id, con_id FROM cdb_data_files ORDER BY con_id ;
FILE_NAME TABLESPA FILE_ID CON_ID
------------------------------------------------------------ -------- ------- ------
/opt/oracle/oradata/ORCLCDB/system01.dbf SYSTEM 1 1
/opt/oracle/oradata/ORCLCDB/users01.dbf USERS 7 1
/opt/oracle/oradata/ORCLCDB/undotbs01.dbf UNDOTBS1 4 1
/opt/oracle/oradata/ORCLCDB/sysaux01.dbf SYSAUX 3 1
/opt/oracle/oradata/ORCLCDB/ORCLPDB1/system01.dbf SYSTEM 9 3
/opt/oracle/oradata/ORCLCDB/ORCLPDB1/sysaux01.dbf SYSAUX 10 3
/opt/oracle/oradata/ORCLCDB/ORCLPDB1/undotbs01.dbf UNDOTBS1 11 3
/opt/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf USERS 12 3
/opt/oracle/oradata/ORCLCDB/ORCLPDB2/system01.dbf SYSTEM 13 4
/opt/oracle/oradata/ORCLCDB/ORCLPDB2/users01.dbf USERS 16 4
/opt/oracle/oradata/ORCLCDB/ORCLPDB2/undotbs01.dbf UNDOTBS1 15 4
/opt/oracle/oradata/ORCLCDB/ORCLPDB2/sysaux01.dbf SYSAUX 14 4
12 rows selected.
只列出CDB的数据文件:
col file_name format A42
select FILE_NAME, TABLESPACE_NAME, FILE_ID from dba_data_files;
FILE_NAME TABLESPA FILE_ID
------------------------------------------ -------- -------
/opt/oracle/oradata/ORCLCDB/system01.dbf SYSTEM 1
/opt/oracle/oradata/ORCLCDB/sysaux01.dbf SYSAUX 3
/opt/oracle/oradata/ORCLCDB/undotbs01.dbf UNDOTBS1 4
/opt/oracle/oradata/ORCLCDB/users01.dbf USERS 7
使用 V$TABLESPACE 和 V$DATAFILE 视图:
col NAME format A12
select FILE#, ts.name, ts.ts#, ts.con_id
from v$datafile d, v$tablespace ts
where d.ts#=ts.ts#
and d.con_id=ts.con_id
order by 4,3;
FILE# NAME TS# CON_ID
---------- ------------ ---------- ------
1 SYSTEM 0 1
3 SYSAUX 1 1
4 UNDOTBS1 2 1
7 USERS 4 1
5 SYSTEM 0 2
6 SYSAUX 1 2
8 UNDOTBS1 2 2
9 SYSTEM 0 3
10 SYSAUX 1 3
11 UNDOTBS1 2 3
12 USERS 5 3
13 SYSTEM 0 4
14 SYSAUX 1 4
15 UNDOTBS1 2 4
16 USERS 5 4
15 rows selected.
临时文件:
col file_name format A55
select FILE_NAME, TABLESPACE_NAME, FILE_ID from cdb_temp_files;
FILE_NAME TABLESPA FILE_ID
------------------------------------------------------- -------- -------
/opt/oracle/oradata/ORCLCDB/ORCLPDB1/temp01.dbf TEMP 3
/opt/oracle/oradata/ORCLCDB/temp01.dbf TEMP 1
/opt/oracle/oradata/ORCLCDB/ORCLPDB2/temp01.dbf TEMP 4
确认 SYSTEM 用户已创建,COMMON=yes表示其为公共用户:
col username format A22
select username, common, con_id from cdb_users where username ='SYSTEM';
USERNAME COM CON_ID
---------------------- --- ------
SYSTEM YES 3
SYSTEM YES 1
SYSTEM YES 4
列出所有公共用户:
select distinct username from cdb_users where common ='YES';
USERNAME
----------------------
XS$NULL
DIP
OUTLN
CTXSYS
SYSBACKUP
SPATIAL_CSW_ADMIN_USR
SYSTEM
DVSYS
GGSYS
GSMADMIN_INTERNAL
ORDSYS
MDDATA
OJVMSYS
SYSDG
LBACSYS
C##IMADVISOR
DBSFWUSER
DVF
MDSYS
SYSKM
OLAPSYS
GSMUSER
SYSRAC
AUDSYS
ORACLE_OCM
DBSNMP
ORDPLUGINS
SYS$UMF
APPQOSSYS
ORDDATA
XDB
GSMCATUSER
SYS
ANONYMOUS
SI_INFORMTN_SCHEMA
WMSYS
REMOTE_SCHEDULER_AGENT
37 rows selected.
列出所有本地用户:
select distinct username, con_id from cdb_users
where common ='NO';
USERNAME CON_ID
---------------------- ------
PDBADMIN 3
D18 3
PDBADMIN 4
所有角色:
SQL> select role, common, con_id from cdb_roles;
ROLE COM CON_ID
------------------------------ --- ------
CONNECT YES 3
RESOURCE YES 3
DBA YES 3
PDB_DBA YES 3
AUDIT_ADMIN YES 3
AUDIT_VIEWER YES 3
SELECT_CATALOG_ROLE YES 3
EXECUTE_CATALOG_ROLE YES 3
CAPTURE_ADMIN YES 3
EXP_FULL_DATABASE YES 3
IMP_FULL_DATABASE YES 3
CDB_DBA YES 3
APPLICATION_TRACE_VIEWER YES 3
LOGSTDBY_ADMINISTRATOR YES 3
DBFS_ROLE YES 3
GSMUSER_ROLE YES 3
AQ_ADMINISTRATOR_ROLE YES 3
AQ_USER_ROLE YES 3
DATAPUMP_EXP_FULL_DATABASE YES 3
DATAPUMP_IMP_FULL_DATABASE YES 3
ADM_PARALLEL_EXECUTE_TASK YES 3
PROVISIONER YES 3
XS_SESSION_ADMIN YES 3
XS_NAMESPACE_ADMIN YES 3
XS_CACHE_ADMIN YES 3
XS_CONNECT YES 3
GATHER_SYSTEM_STATISTICS YES 3
GSM_POOLADMIN_ROLE YES 3
OPTIMIZER_PROCESSING_RATE YES 3
DBMS_MDX_INTERNAL YES 3
RECOVERY_CATALOG_OWNER YES 3
RECOVERY_CATALOG_OWNER_VPD YES 3
RECOVERY_CATALOG_USER YES 3
EM_EXPRESS_BASIC YES 3
EM_EXPRESS_ALL YES 3
SYSUMF_ROLE YES 3
SCHEDULER_ADMIN YES 3
HS_ADMIN_SELECT_ROLE YES 3
HS_ADMIN_EXECUTE_ROLE YES 3
HS_ADMIN_ROLE YES 3
GLOBAL_AQ_USER_ROLE YES 3
OEM_ADVISOR YES 3
OEM_MONITOR YES 3
GSMADMIN_ROLE YES 3
EJBCLIENT YES 3
GDS_CATALOG_SELECT YES 3
GGSYS_ROLE YES 3
XDBADMIN YES 3
XDB_SET_INVOKER YES 3
AUTHENTICATEDUSER YES 3
XDB_WEBSERVICES YES 3
XDB_WEBSERVICES_WITH_PUBLIC YES 3
XDB_WEBSERVICES_OVER_HTTP YES 3
SODA_APP YES 3
DATAPATCH_ROLE YES 3
WM_ADMIN_ROLE YES 3
JAVAUSERPRIV YES 3
JAVAIDPRIV YES 3
JAVASYSPRIV YES 3
JAVADEBUGPRIV YES 3
CSW_USR_ROLE YES 3
JMXSERVER YES 3
DBJAVASCRIPT YES 3
JAVA_ADMIN YES 3
JAVA_DEPLOY YES 3
CTXAPP YES 3
ORDADMIN YES 3
OLAP_XS_ADMIN YES 3
OLAP_DBA YES 3
OLAP_USER YES 3
SPATIAL_CSW_ADMIN YES 3
DV_SECANALYST YES 3
RDFCTX_ADMIN YES 3
LBAC_DBA YES 3
DV_REALM_OWNER YES 3
DV_MONITOR YES 3
DV_ADMIN YES 3
DV_OWNER YES 3
DV_ACCTMGR YES 3
DV_PUBLIC YES 3
DV_PATCH_ADMIN YES 3
DV_STREAMS_ADMIN YES 3
DV_GOLDENGATE_ADMIN YES 3
DV_XSTREAM_ADMIN YES 3
DV_GOLDENGATE_REDO_ACCESS YES 3
DV_AUDIT_CLEANUP YES 3
DV_DATAPUMP_NETWORK_LINK YES 3
DV_POLICY_OWNER YES 3
DV_REALM_RESOURCE YES 3
CONNECT YES 1
RESOURCE YES 1
DBA YES 1
PDB_DBA YES 1
AUDIT_ADMIN YES 1
AUDIT_VIEWER YES 1
SELECT_CATALOG_ROLE YES 1
EXECUTE_CATALOG_ROLE YES 1
ROLE COM CON_ID
------------------------------ --- ------
CAPTURE_ADMIN YES 1
EXP_FULL_DATABASE YES 1
IMP_FULL_DATABASE YES 1
CDB_DBA YES 1
APPLICATION_TRACE_VIEWER YES 1
LOGSTDBY_ADMINISTRATOR YES 1
DBFS_ROLE YES 1
GSMUSER_ROLE YES 1
AQ_ADMINISTRATOR_ROLE YES 1
AQ_USER_ROLE YES 1
DATAPUMP_EXP_FULL_DATABASE YES 1
DATAPUMP_IMP_FULL_DATABASE YES 1
ADM_PARALLEL_EXECUTE_TASK YES 1
PROVISIONER YES 1
XS_SESSION_ADMIN YES 1
XS_NAMESPACE_ADMIN YES 1
XS_CACHE_ADMIN YES 1
XS_CONNECT YES 1
GATHER_SYSTEM_STATISTICS YES 1
GSM_POOLADMIN_ROLE YES 1
OPTIMIZER_PROCESSING_RATE YES 1
DBMS_MDX_INTERNAL YES 1
RECOVERY_CATALOG_OWNER YES 1
RECOVERY_CATALOG_OWNER_VPD YES 1
RECOVERY_CATALOG_USER YES 1
EM_EXPRESS_BASIC YES 1
EM_EXPRESS_ALL YES 1
SYSUMF_ROLE YES 1
SCHEDULER_ADMIN YES 1
HS_ADMIN_SELECT_ROLE YES 1
HS_ADMIN_EXECUTE_ROLE YES 1
HS_ADMIN_ROLE YES 1
GLOBAL_AQ_USER_ROLE YES 1
OEM_ADVISOR YES 1
OEM_MONITOR YES 1
GSMADMIN_ROLE YES 1
EJBCLIENT YES 1
GDS_CATALOG_SELECT YES 1
GGSYS_ROLE YES 1
XDBADMIN YES 1
XDB_SET_INVOKER YES 1
AUTHENTICATEDUSER YES 1
XDB_WEBSERVICES YES 1
XDB_WEBSERVICES_WITH_PUBLIC YES 1
XDB_WEBSERVICES_OVER_HTTP YES 1
SODA_APP YES 1
DATAPATCH_ROLE YES 1
WM_ADMIN_ROLE YES 1
JAVAUSERPRIV YES 1
JAVAIDPRIV YES 1
JAVASYSPRIV YES 1
JAVADEBUGPRIV YES 1
CSW_USR_ROLE YES 1
JMXSERVER YES 1
DBJAVASCRIPT YES 1
JAVA_ADMIN YES 1
JAVA_DEPLOY YES 1
CTXAPP YES 1
ORDADMIN YES 1
OLAP_XS_ADMIN YES 1
OLAP_DBA YES 1
OLAP_USER YES 1
SPATIAL_CSW_ADMIN YES 1
DV_SECANALYST YES 1
RDFCTX_ADMIN YES 1
LBAC_DBA YES 1
DV_REALM_OWNER YES 1
DV_MONITOR YES 1
DV_ADMIN YES 1
DV_OWNER YES 1
DV_ACCTMGR YES 1
DV_PUBLIC YES 1
DV_PATCH_ADMIN YES 1
DV_STREAMS_ADMIN YES 1
DV_GOLDENGATE_ADMIN YES 1
DV_XSTREAM_ADMIN YES 1
DV_GOLDENGATE_REDO_ACCESS YES 1
DV_AUDIT_CLEANUP YES 1
DV_DATAPUMP_NETWORK_LINK YES 1
DV_POLICY_OWNER YES 1
DV_REALM_RESOURCE YES 1
CONNECT YES 4
RESOURCE YES 4
DBA YES 4
PDB_DBA YES 4
AUDIT_ADMIN YES 4
AUDIT_VIEWER YES 4
SELECT_CATALOG_ROLE YES 4
EXECUTE_CATALOG_ROLE YES 4
CAPTURE_ADMIN YES 4
EXP_FULL_DATABASE YES 4
IMP_FULL_DATABASE YES 4
CDB_DBA YES 4
APPLICATION_TRACE_VIEWER YES 4
LOGSTDBY_ADMINISTRATOR YES 4
DBFS_ROLE YES 4
GSMUSER_ROLE YES 4
ROLE COM CON_ID
------------------------------ --- ------
AQ_ADMINISTRATOR_ROLE YES 4
AQ_USER_ROLE YES 4
DATAPUMP_EXP_FULL_DATABASE YES 4
DATAPUMP_IMP_FULL_DATABASE YES 4
ADM_PARALLEL_EXECUTE_TASK YES 4
PROVISIONER YES 4
XS_SESSION_ADMIN YES 4
XS_NAMESPACE_ADMIN YES 4
XS_CACHE_ADMIN YES 4
XS_CONNECT YES 4
GATHER_SYSTEM_STATISTICS YES 4
GSM_POOLADMIN_ROLE YES 4
OPTIMIZER_PROCESSING_RATE YES 4
DBMS_MDX_INTERNAL YES 4
RECOVERY_CATALOG_OWNER YES 4
RECOVERY_CATALOG_OWNER_VPD YES 4
RECOVERY_CATALOG_USER YES 4
EM_EXPRESS_BASIC YES 4
EM_EXPRESS_ALL YES 4
SYSUMF_ROLE YES 4
SCHEDULER_ADMIN YES 4
HS_ADMIN_SELECT_ROLE YES 4
HS_ADMIN_EXECUTE_ROLE YES 4
HS_ADMIN_ROLE YES 4
GLOBAL_AQ_USER_ROLE YES 4
OEM_ADVISOR YES 4
OEM_MONITOR YES 4
GSMADMIN_ROLE YES 4
EJBCLIENT YES 4
GDS_CATALOG_SELECT YES 4
GGSYS_ROLE YES 4
XDBADMIN YES 4
XDB_SET_INVOKER YES 4
AUTHENTICATEDUSER YES 4
XDB_WEBSERVICES YES 4
XDB_WEBSERVICES_WITH_PUBLIC YES 4
XDB_WEBSERVICES_OVER_HTTP YES 4
SODA_APP YES 4
DATAPATCH_ROLE YES 4
WM_ADMIN_ROLE YES 4
JAVAUSERPRIV YES 4
JAVAIDPRIV YES 4
JAVASYSPRIV YES 4
JAVADEBUGPRIV YES 4
CSW_USR_ROLE YES 4
JMXSERVER YES 4
DBJAVASCRIPT YES 4
JAVA_ADMIN YES 4
JAVA_DEPLOY YES 4
CTXAPP YES 4
ORDADMIN YES 4
OLAP_XS_ADMIN YES 4
OLAP_DBA YES 4
OLAP_USER YES 4
SPATIAL_CSW_ADMIN YES 4
DV_SECANALYST YES 4
RDFCTX_ADMIN YES 4
LBAC_DBA YES 4
DV_REALM_OWNER YES 4
DV_MONITOR YES 4
DV_ADMIN YES 4
DV_OWNER YES 4
DV_ACCTMGR YES 4
DV_PUBLIC YES 4
DV_PATCH_ADMIN YES 4
DV_STREAMS_ADMIN YES 4
DV_GOLDENGATE_ADMIN YES 4
DV_XSTREAM_ADMIN YES 4
DV_GOLDENGATE_REDO_ACCESS YES 4
DV_AUDIT_CLEANUP YES 4
DV_DATAPUMP_NETWORK_LINK YES 4
DV_POLICY_OWNER YES 4
DV_REALM_RESOURCE YES 4
267 rows selected.