venerdì 4 marzo 2022

ORA 12c - Oracle Pluggable Database 12c Automatic Startup

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;

Nessun commento:

Posta un commento