Database Administration (MOSC)

MOSC Banner

Trouble connecting pluggable database

edited Jun 6, 2017 3:14AM in Database Administration (MOSC) 22 commentsAnswered ✓

Hello expert,

                     I am facing trouble in connecting a pluggable database.I have created like following

SQL>  CREATE PLUGGABLE DATABASE salespdb ADMIN USER salesadm IDENTIFIED BY welcome1 FILE_NAME_CONVERT = ('/oradata/ccbx12c/pdbseed/','/oradata/ccbx12c/salespdb/');

Pluggable database created.

SQL>  select name,BYTES/(1024*1024*1024) GB,STATUS,ENABLED,PLUGGED_IN,CON_ID from v$datafile;

NAME                                             GB STATUS  ENABLED    PLUGGED_IN     CON_ID
---------------------------------------- ---------- ------- ---------- ---------- ----------
/oradata/ccbx12c/system01.dbf             .76171875 SYSTEM  READ WRITE          0          1
/oradata/ccbx12c/sysaux01.dbf            .732421875 ONLINE  READ WRITE          0          1
/oradata/ccbx12c/undotbs01.dbf           .190429688 ONLINE  READ WRITE          0          1
/oradata/ccbx12c/pdbseed/system01.dbf    .244140625 SYSTEM  READ WRITE          0          2

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