Re: DB12c in Production?

On the surface 12c seems to be the strongest release in a long time. I’m not just talking about new features such as Multi tenant and promised In Memory Database but also commitment to enhancing existing features such as Flex ASM, Online partition moves, dbms_redefinition enhancements, Online database file moves, etc.. These features really show Oracle’s commitment to not only grow there “pay for” options but also continue to add value to existing features.

The Multitenant option buys two things for my environment.

The first is a true multi tenant project in scope over the next 2 years where we are looking to isolate customers with a potential from a few dozen to over 2,000 separate databases. Multitenant seems to be a much more manageable and long term cost effective solution in comparison to Virtualizing the database stacks. The shared background processes and database memory pools makes the solution a much more efficient architecture.

I have 5 single instance servers today that have very large memory footprints with mismatched workloads with little abilities to share resources. Moving to a RAC architecture would require a many month effort of application and database tuning and I have yet to figure out how to do this without greatly impacting performance while trying to manage 10 busy instances on 5 nodes. Multitenant affords us the ability to cluster 1 CDB instance and plug all databases into it while application partitioning the database per node allowing us to gradually grow into RAC and balance our workloads.

Our first step would be 12c GI clustering with single instance 11gR2 databases on each node. We are upgrading our database servers to UCS blades which are an ideal hardware configuration for RAC and 12c seems pretty solid so far within that limited scope. The database upgrades, CDB with single PDB, would not be until early next year per our current plans and true Multitenant would follow that.

We have upgrade GI in a few environments so far and have ran into 0 issues.

Thanks,
Kenny

P.S.

We already have the RAC licenses that are not being used.

P.S.S.

Speaking of automobiles and enhancements I recently traded my 2005 Nissan Frontier in for a 2013 Nissan Leaf lease. Given Federal and State incentives, gas savings, maintenance savings and depreciation I’ll save $13k over 2 years. Certainly pros and cons to driving an electric eco-turd but so far it is living up to everything I could ask for with my 68 mile round trip commute.

On Apr 12, 2014, at 12:39 PM, Iggy Fernandez <iggy_fernandez_at_hotmail.com> wrote:

> re: adoption rate seems abnormally low
>
> What is the motivation to upgrade? I drove a 1986 Saturn SL1 from 1996 until 2013. It had close to 300,000 miles on it by the time I upgraded to a Prius hybrid with all the options including faux-leather seats. My "refresh cycle" was 17 years. For 17 years it took me everywhere I needed to go including long road trips.
>
> Pluggable databases are presumably the principal motivation to move to 12c but the pluggable database option is an extra-cost option. Besides, only enterprise-edition customers may license it. Since it's a new option, it won't be included in existing contracts. And, of course, you must be willing to go through all the testing and effort entailed by an upgrade.
>
> There are some backdoors as has been pointed out. For example, RMAN and Grid Control include a license for Oracle database. Off-the-shelf applications commonly include a license for Oracle Database but they need to justify the effort and expense just like everybody else.
>
> Kindest regards,
>
> Iggy
>
> P.S. The old car was still in good condition except that the driver-side window no longer worked. Even the paint was in good condition because I had always parked it in my garage. It's book value was less than $200 so I gave it to a student who happily continues to drive it and keeps it cleaner than I ever did. He even posted a picture of himself with the car on Facebook.
>
> --
> Iggy Fernandez
> Email: iggy_fernandez_at_hotmail.com
> Cellphone: (925) 478 3161
> Blog: So Many Manuals So Little Time
> Author of Beginning Oracle Database 11g Administration
> Editor of the NoCOUG Journal
> Lecturer at University of Washington Professional and Continuing Education
>
>
> From: cameron.hodge_at_amec.com
> To: k3nnyp_at_gmail.com; james.clarence.allen_at_census.gov
> CC: oracle-l_at_freelists.org
> Date: Sat, 12 Apr 2014 07:01:52 +0800
> Subject: RE: DB12c in Production?
>
> <114041200020801383.gif>
>
>
> Kenny,
> We’ve got 12c in Prod for our RMAN Catalogues. However most (all) of our 3rd Party applications are not yet certified with 12c and like most businesses we stay on a supported DB release so that the 3rd party companies cannot just turn around and say “it’s because you’re on 12c” if we run into any problems. I doubt we’d run into any issues on 12c as the majority of apps written for databases utilisze just the basics (tables, triggers, views, procedures/packages) but “just in case”.
>
>
>
>
>
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kenny Payton
> Sent: Saturday, 12 April 2014 1:25 AM
> To: james.clarence.allen_at_census.gov
> Cc: oracle-l_at_freelists.org
> Subject: Re: DB12c in Production?
>
> I asked a similar question a week ago on here and didn’t get any replies where they were actually in production.
>
> I’m at IOUG this week and out of all of the sessions I have attended not 1 person has raised their hand when this question has been asked to the audience. I’m sure they exist but adoption rate seems abnormally low. The dogma of R2 being the real R1 seems to be strong with this release.
>
> Kenny
>
>
>
>
> On Apr 11, 2014, at 10:45 AM, james.clarence.allen_at_census.gov wrote:
>
>
> Anyone,
>
> Is anyone (or know of anyone) currently using DB12c in production?
>
> I am having trouble finding shops using DB12c for production. I would
> like to read how things are going and if 12.1.0.1.0 is stable enough to
> be in production. I read where SAP is waiting for 12.1.0.2 before certifying
> it.
>
> Sincerely,
> Jim Allen
> Database Support Lead, MASSDB
> Tel: 301-763-7501
> Database Help Desk: X34944
> Support Email: James.Clarence.Allen_at_census.gov
> Website: http://epd.econ.census.gov/offices/massdb/
> -- http://www.freelists.org/webpage/oracle-l
>
>
>
> This email contains confidential information. The contents must
> not be disclosed to anyone else except with the authority of the sender.
> Unauthorised recipients are requested to maintain this confidentiality and
> immediately advise the sender of any error or misdirection in transmission.

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