ORA-65011: Pluggable database does not exist.
2 min readBelow is the error while I was upgrading my test environment.
SQL> alter pluggable database application CODDY begin upgrade '1.3' to '1.4'; alter pluggable database application CODDY begin upgrade '1.3' to '1.4' ORA-65011: Pluggable database F3094217277_21_4 does not exist. ORA-65169: error encountered while attempting to copy file /opt/app/oracle/prd/coddy/users.dbf ORA-19502: write error on file "/opt/app/oracle/prd/coddy/datafile/o1_mf_users_gc8xyz9o_.dbf", block number 2445132 (block size=8192) ORA-27072: File I/O error Additional information: 4 Additional information: 2445132 Additional information: 589824 I had upgraded my application from 1.0 to 1.1 and 1.1 to 1.2 and 1.2 to 1.3 But now while upgrading application from 1.3 to 1.4, it is not allowing. And ORA-27072: File I/O error is the trigger point for me to look into the storage side. This error comes when something happens with storage. So very first I checked the free space available on my disk.
$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 15G 0 15G 0% /dev
tmpfs 30G 79M 30G 1% /dev/shm
/dev/mapper/DomUVol12-mnt 684G 639G 9.6G 99% /opt
/export/local/x86_64/redhat/70_prod/packages 5.0T 4.3T 726G 86% /usr/local/remote/packages
/export/home1/chandan 4.5T 540G 4.0T 12% /home/chandan
So in above output it is showing that /opt mount point have only 9.6gb free and my database size is approx 15-20gb.
Now, question is; who is occupying space on this disk? Why all of sudden disk space issue arise?
MUST NOTE When we upgrade our application, Oracle Database automatically clones the application root. At the time of upgrade, application PDBs point to the clone. Due to this applications continue to run during the upgrade also. Here it is recommended to SYNC your application PDB with your application root. If application PDBs are not SYNC with root, PDBs will still point to the clone. Now Clone PDBs will occupy your disk space because those are copy of your application root PDB. Here in my case I have deleted unnecessary file and logs and free up some disk space to accommodate my next application root version. After free up space command ran successfully. SQL> alter pluggable database application CODDY begin upgrade '1.3' to '1.4'; Pluggable database altered.