Hi all.
I have this situation:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
Script:
Alter pluggable database pdb1 close immediate
/
shutdown immediate
exit
This has been working perfectly for months. Now suddenly for two days in a row, we are hitting errors ORA-0103, ORA-65020.
Issue query:
SELECT con_name, instance_name, state FROM dba_pdb_saved_states
and confirmed pdb1 is in open state.
Questions:
How can this worked for so long and suddenly not anymore?.
Where to look for findings?
Help will be greatly appreciated !!!