Re: Create 12c or 18c database in traditional architecture

Hi.

I always do lone-PDB unless there is a reason not to, where the possible reasons are:

• The vendor of a 3rd party product doesn't support the multitenant architecture. We have one of these.
• Testing of the product proves something to be an issue. We have one application that has loads of shell scripts that would need modification, so we've delayed the move to the multitenant architecture for that DB.

So my assumption is it will be a PDB...

Buggy? I hear a lot of people with the "buggy" excuse, and I'm sure some have situations, but I've been using PDBs in production from the release of 12.1.0.2 onward and they've been fine. Mileage will vary of course.

Overhead? Of course there is additional code-path there, but I would doubt most users would see a difference.

Easier Management? When I first started looking at PDBs I hated them and thought it was pointless. As soon as committed to learning them I got used to them and now I prefer them to old style instances. In a day to day usage they are no different, but there are some really neat features that are useful even for lone-PDB. This is especially true in 12.2 onward.

I have a feeling I will be in the minority in this thread. :)

Cheers

Tim...
On Tue, Aug 28, 2018 at 5:00 PM Yong Huang <dmarc-noreply_at_freelists.org> wrote:
>
> When creating a 12c or 18c database without the multitenancy license, I can (1) create the database with one CDB and only one PDB, or (2) create the database in the traditional or non-CDB architecture. The advantage of (2) is possibly less buggy, less overhead (no mgmtdb on RAC for instance), and slightly easier management. But the disadvantage is that Oracle does not recommend it and that "(t)he non-CDB architecture was deprecated in Oracle Database 12c. It can be desupported and unavailable in a release after Oracle Database 19c."
>
> Short of a formal survey, I'd like to know which option you all have chosen. Thank you!
>
> Yong Huang

--
http://www.freelists.org/webpage/oracle-l