Top 60 Oracle Blogs

Recent comments

Standard Edition

Moving SYSAUX from one diskgroup to another


This is another of the posts on how I did something to remind me how to do it again, when next the need arises. </p />

    	  	<div class=

What Happens When I Add Datafiles to a Manual Standby Primary in Standard Edition?


One of the customers I’ve been working closely with over the past few months is running Standard Edition (SE) (yes, I know they should upgrade but that’s coming further down the road). Recently, we moved their database to another, much larger ASM diskgroup (that’s the subject of another post that I haven’t written yet), so we now have the opportunity to add some more space to their existing tablespaces, which were mostly running close to full (as was the original diskgroup, for that matter). Now my experience of SE has not been particularly long, and I knew they were running a manual standby configuration like people used to use before Data Guard came around. Data Guard, of course, is an Enterprise Edition feature, so that’s not an option for this particular customer. I wondered what would happen to the standby when I added new datafiles.

Max PDBs in Standard Edition

Here is a small warning. In Standard Edition, you may expect that the features that are not available for your edition are blocked, but in 12.2 you can create more than one PDB in Standard Edition, and you should set MAX_PDBS to prevent that.


In 12.1 Standard Edition, when you try to create more than one PDB (i.e with CON>ID > 3) you get an error:

ORA-65010: maximum number of pluggable databases created


But it seems that this has been lost in 12.2: