ERROR in alert log: Shared memory area is accessible to instance startup process prior to instance startup operation

Applicable to Oracle DB  Release 12.1.0.2.0.

Developer when connecting to a PDB service through SQLdeveloper may see the error startup shutdown in progress after restart of the Database in Oracle 12c or afterwards.

Issue applicable if we don't save the state of the DB.

Usually from Oracle 12c if we don't save the state of a PDB database after the restart PDB may not come up to the same state.

In that case we may face this issue.

Resolution:

SQL> connect to the DB.


Connected.

Check the status of the PDBs.

SQL> select con_id, name, open_mode, total_size from v$pdbs;

    CON_ID NAME                           OPEN_MODE  TOTAL_SIZE
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY   838860800
         3 PDBCR                          MOUNTED             0

SQL> alter pluggable database PDB$SEED CLOSE IMMEDIATE;
alter pluggable database PDB$SEED CLOSE IMMEDIATE
                         *
ERROR at line 1:
ORA-65017: seed pluggable database may not be dropped or altered

Open the PDB database

SQL> alter pluggable database PDBCR open;

Pluggable database altered.

Again check the PDB status

SQL> select con_id, name, open_mode, total_size from v$pdbs;

    CON_ID NAME                           OPEN_MODE  TOTAL_SIZE
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY   838860800
         3 PDBCR                          READ WRITE 4229955584