Database Administration (MOSC)

MOSC Banner

sys.service$ in 12c does not show the infomation for pluggable database

edited Oct 29, 2013 4:24AM in Database Administration (MOSC) 1 commentAnswered
---Before the pdb is opened query on the cdb:

SQL> select * from sys.service$;
SERVICE_ID NAME NAME_HASH NETWORK_NAME CREATION_DATE CREATION_DATE_HASH DELETION_DATE FAILOVER_METHOD FAILOVER_TYPE FAILOVER_RETRIES FAILOVER_DELAY MIN_CARDINALITY MAX_CARDINALITY GOAL FLAGS EDITION PDB RETENTION_TIMEOUT REPLAY_INITIATION_TIMEOUT SESSION_STATE_CONSISTENCY SQL_TRANSLATION_PROFILE MAX_LAG_TIME GSM_FLAGS PQ_SVC
1 SYS$BACKGROUND 165959219  2013/5/24 11:52:07 3260059285         8  CDB$ROOT       
2 SYS$USERS 3427055676  2013/5/24 11:52:07 3260059285         8  CDB$ROOT       
3 seeddataXDB 3949691161 seeddataXDB 2013/5/24 11:52:07 3260059285 2013/10/14 21:34:12        8  CDB$ROOT       
4 seeddata 828820148 seeddata 2013/5/24 11:52:07 3260059285 2013/10/14 21:34:12        8  CDB$ROOT       
5 ora12cXDB 176818013 ora12cXDB 2013/10/14 21:33:56 2627730677         8  CDB$ROOT       
6 ora12c 1321784467 ora12c 2013/10/14 21:33:56 2627730677         8  CDB$ROOT       

SQL>select * from v$pdbs
CON_ID DBID CON_UID GUID NAME OPEN_MODE RESTRICTED OPEN_TIME CREATE_SCN TOTAL_SIZE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center