Search code examples
oracle19c

How to set oracle 19c database to be always in open mode?

I am using oracle 19c enterprise edition and configure a pdb by the name of orclpdb. So when I restart the computer or when it gets shutdowned after that the instance orlcpdb is not in open mode and it needs to be opened but the cdb is always in open mode. So I want that instance to be always in open mode even if I restart the pc. Is there any solution for that?

Solution

  • Pluggable databases always start in MOUNTED mode by default. Try the following solution, with the CDB open and your PDB mounted:

    SQL> alter pluggable database orclpdb open;

SQL> alter pluggable database orclpdb save state;

    Now when you restart your instance, the pluggable database should open in READ WRITE mode automatically. To return it to manual startup, do the following when everything is open:

    SQL> alter pluggable database orclpdb discard state;

    Now the PDB will start in 'MOUNTED' mode again.