12c gotcha



We've been working on a number of 12c upgrades recently but today was the first time we hit this particular issue.

The developers contacted me with the following screenshot






This had never happened before in 11.2 - and this had been a straight upgrade with no changes.

So what happening here?

Well a quick check shows resource_limit is set to TRUE - which it wasn't previously. In fact it's not defined at all in the spfile - so it seems the default has changed.



And indeed it has

https://docs.oracle.com/database/121/UPGRD/deprecated.htm#BABICDCC

A minor thing that could catch you out - something to be aware of!

Comments