Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [oracle@stormking cdb12102 multitenant]$ lsnrctl status | grep -i pdb
- Service "pdbl" has 1 instance(s).
- [oracle@stormking cdb12102 multitenant]$ sqlplus /nolog
- SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 12 19:42:22 2015
- Copyright (c) 1982, 2014, Oracle. All rights reserved.
- SQL> conn bf/bf@//stormking:1521/pdbl as sysdba
- Connected.
- SQL> set linesize 400
- SQL> set trimspool on
- SQL> select con_id, dbid, name, open_mode, restricted, create_scn, total_size, con_uid, guid
- 2 from v$containers
- 3 order by con_id;
- CON_ID DBID NAME OPEN_MODE RES CREATE_SCN TOTAL_SIZE CON_UID GUID
- ---------- ---------- ------------------------------ ---------- --- ---------- ---------- ---------- --------------------------------
- 4 284904620 PDBL READ WRITE NO 12610387 912261120 284904620 1159F1AAA078680BE0537901A8C0C06B
- SQL> alter pluggable database rename global_name to pdbm;
- alter pluggable database rename global_name to pdbm
- *
- ERROR at line 1:
- ORA-65045: pluggable database not in a restricted mode
- SQL> alter pluggable database close;
- Pluggable database altered.
- SQL> alter pluggable database open restricted;
- Pluggable database altered.
- SQL> alter pluggable database rename global_name to pdbm;
- Pluggable database altered.
- SQL> alter pluggable database close;
- Pluggable database altered.
- SQL> alter pluggable database open;
- Pluggable database altered.
- SQL> select con_id, dbid, name, open_mode, restricted, create_scn, total_size, con_uid, guid
- 2 from v$containers
- 3 order by con_id;
- CON_ID DBID NAME OPEN_MODE RES CREATE_SCN TOTAL_SIZE CON_UID GUID
- ---------- ---------- ------------------------------ ---------- --- ---------- ---------- ---------- --------------------------------
- 4 284904620 PDBM READ WRITE NO 12610387 912261120 284904620 1159F1AAA078680BE0537901A8C0C06B
- SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
- With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
- and Real Application Testing options
- [oracle@stormking cdb12102 multitenant]$ lsnrctl status | grep -i pdb
- Service "pdbm" has 1 instance(s).
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement