Infrastructure at your Service

multitenant Archives - Blog dbi services

Franck Pachot

Oracle 12cR2, RAC, Cloud, ACFS, PDB thin clones and asmadmin

By | Cloud, Database Administration & Monitoring | No Comments

In the Oracle Public Cloud, fast provisioning gets all its meaning when creating a RAC database service: in one hour you can get an operational highly available multitenant database. You can even create it in Data Guard for Disaster Recovery. Now, Oracle is pushing ACFS to store the datafiles rather than direct ASM. Especially in multitenant because a great feature is thin cloning: CREATE PLUGGABLE DATABASE AS SNAPSHOT COPY. However, I encountered an error when…

 
Read More
Franck Pachot

12cR2: Upgrade by remote clone – workaround ORA-17630 in DBaaS

By | Database Administration & Monitoring | No Comments

Easier than unplug/plug, you can move pluggable databases with remote cloning. It’s the same idea but you don’t have to manage the files yourself: the are shipped through database link. However, this uses the ‘remote file protocol’ and it fails with version mismatch: ORA-17628: Oracle error 17630 returned by remote Oracle server ORA-17630: Mismatch in the remote file protocol version client server  

 
Read More
Franck Pachot

12cR2: CREATE_FILE_DEST for PDB isolation

By | Database Administration & Monitoring | No Comments

Two years ago I filled an OTN idea to ‘Constrain PDB datafiles into specific directory’ and made it an enhancement request for 12c Release 2. When you provision a PDB, the PDB admin can create tablespaces and put datafiles anywhere in your system. Of course this is not acceptable in a cloud environment. 12.1 has a parameter for directories (PATH_PREFIX) and 12.2 brings CREATE_FILE_DEST for datafiles.  

 
Read More