SQL*Plus: Release 12.1.0.2.0 Production on Fri Mar 4 08:41:43 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> ALTER PLUGGABLE DATABASE REPOSORCL OPEN READ WRITE;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 REPOSORCL READ WRITE NO
SQL> alter pluggable database REPOSORCL save state;
Pluggable database altered.
SQL> select con_name,state from dba_pdb_saved_states;
CON_NAME STATE
--------------- -------------
REPOSORCL OPEN
SQL> shutdown immediate;
Pluggable Database closed.
SQL> startup
Pluggable Database opened.
SQL> select con_name,state from dba_pdb_saved_states;
CON_NAME STATE
--------------- -------------
REPOSORCL OPEN
SQL> exit
Per eliminare lo startupt automatico occorre effettuare la DISCARD dello stato del Pluggable.
DISCARD STATO
alter pluggable database REPOSORCL DISCARD state;
