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?
3
-
From the 'PC' reference you seem to be running Oracle on Windows; so does this answer your question?Alex Poole– Alex Poole2022-06-06 08:17:56 +00:00Commented Jun 6, 2022 at 8:17
-
Yes I am running oracle in windows 10Arifullah– Arifullah2022-06-06 09:12:01 +00:00Commented Jun 6, 2022 at 9:12
-
The above link didn't solve my problem. Is there another way to do that.Arifullah– Arifullah2022-06-06 09:42:29 +00:00Commented Jun 6, 2022 at 9:42
Add a comment
|
1 Answer
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.
