Multitenant

How to Resolve ORA-65011: Pluggable database does not exist

by Ed Chen
August 23, 2021October 4, 2022
2 Comments

ORA-65011 There're several use cases that may throw ORA-65011. 1. Set PDB as Session Container Tried to set a PDB as the current session container,… Read More »

How to Resolve ORA-65118: operation affecting a pluggable database cannot be performed from another pluggable database

by Ed Chen
August 11, 2021March 14, 2022

ORA-65118 When we tried to close a pluggable database (PDB), we got ORA-65118. SQL> alter pluggable database FINPDB close; alter pluggable database FINPDB close *… Read More »

DBA_TEMP_FREE_SPACE Might be Incorrect in Multitenant Environment

by Ed Chen
July 24, 2021April 13, 2022
2 Comments

I consistently get the wrong figures about free space of temporary tablespace in database tools, so I made a research. First of all, it's a… Read More »

How to Resolve ORA-01109: database not open

by Ed Chen
June 5, 2021December 24, 2022
2 Comments

ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »

How to Create Pluggable Database (PDB)

by Ed Chen
May 29, 2021February 19, 2022

There're several ways that can create a PDB. Create a PDB by using SQL*Plus Create a PDB by using DBCA Create a PDB by cloning… Read More »

How to Drop Pluggable Database (PDB)

by Ed Chen
May 26, 2021January 12, 2022

DROP PLUGGABLE DATABASE Since Pluggable Database (PDB) becomes more flexible than dedicated databases, we may create a PDB for some specific purpose, use it for… Read More »

How Oracle Rename PDB

by Ed Chen
May 24, 2021December 24, 2022

Rename Pluggable Database After creating a new PDB or cloning a remote PDB, you might want to change its name for your own purpose. In… Read More »

How to Resolve ORA-65025: Pluggable database is not closed on all instances.

by Ed Chen
May 22, 2021May 17, 2022

ORA-65025 ORA-65025 means that the pluggable database should be closed completely for further operations like dropping. Let's see some cases about this error. Drop PDB… Read More »

How to Resolve ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

by Ed Chen
May 22, 2021March 28, 2021

ORA-65179 Let's see a unsuccessful case of dropping a pluggable database (PDB). SQL> drop pluggable database orclpdb2; drop pluggable database orclpdb2 * ERROR at line… Read More »

How to Backup PDB Tablespace

by Ed Chen
March 17, 2021February 1, 2021

Backup Tablespace Normally Since tablespace is a logical set of data files, it's allowable to have same name tablespaces in different pluggable databases (PDB). Therefore,… Read More »