RE: [External] : Re: Oracle 21c
Date: Thu, 12 May 2022 13:36:12 +0000
Message-ID: <SJ0PR10MB4686A0FC9735EA9AD14E4C05A3CB9_at_SJ0PR10MB4686.namprd10.prod.outlook.com>
That’s not the idea, at all.
You consolidate instances of similar workloads, requirements into a CDB. You could still have multiple CDBs for each Application.
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Noveljic Nenad
Sent: Thursday, May 12, 2022 9:31 AM
To: andrew.kerber_at_gmail.com; Tim Gorman <tim.evdbt_at_gmail.com>; oracle-l_at_freelists.org
Cc: jt2354_at_gmail.com; Gerald Venzl <gerald.venzl_at_oracle.com>; weber08weber_at_gmail.com; puravc_at_gmail.com; Mark J. Bobak <mark_at_bobak.net>; Scott Canaan <srcdco_at_rit.edu>
Subject: RE: [External] : Re: Oracle 21c
I wouldn’t dare using Oracle multi-tenant as a consolidation strategy, i.e. putting databases of different applications into the same CDB. The main reason is that, unlike in MS SQL Server, PDBs share the redo log.
Best regards,
Nenad
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> On Behalf Of Andrew Kerber
Sent: Donnerstag, 12. Mai 2022 15:19
To: Tim Gorman <tim.evdbt_at_gmail.com<mailto:tim.evdbt_at_gmail.com>>
Cc: jt2354_at_gmail.com<mailto:jt2354_at_gmail.com>; Gerald Venzl <gerald.venzl_at_oracle.com<mailto:gerald.venzl_at_oracle.com>>; weber08weber_at_gmail.com<mailto:weber08weber_at_gmail.com>; puravc_at_gmail.com<mailto:puravc_at_gmail.com>; Mark J. Bobak <mark_at_bobak.net<mailto:mark_at_bobak.net>>; Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
Subject: Re: [External] : Re: Oracle 21c
- E-Mail from outside Vontobel: Do not click on links or open attachments unless you know the content is safe. *** Definitely. On the other hand (does that make three hands?) adding the additional management complexities also keeps us DBAs in business
On Thu, May 12, 2022 at 8:16 AM Tim Gorman <tim.evdbt_at_gmail.com<mailto:tim.evdbt_at_gmail.com>> wrote: Agreed! The major problem is that, at a list price of US$17500/core, it is a little difficult to ignore unless you have a ULA. It is possible to provision several substantial VMs in public cloud and still have change.
Infra costs are a fraction of Oracle licensing costs, never mind the non-discountable annual support subscriptions that nobody seems to want to bring up in TCO discussions.
I think Oracle is worth it, and so apparently do most of its customers, but additional licensing for the multi-tenant option is hard to justify without a ULA.
On 5/12/2022 6:03 AM, John Thomas wrote: There is one "big picture" selling point for CDBs.
It allows you to share one large SGA on a server amongst a number of databases. Could save a fair bit of infrastructure costs if you ignore the mutli-tenant licence cost :-(
Regards,
John Thomas
On Thu, 12 May 2022 at 13:24, Andrew Kerber <andrew.kerber_at_gmail.com<mailto:andrew.kerber_at_gmail.com>> wrote: So as with the entire concept of CDB's, another solution in search of a problem.
On Wed, May 11, 2022 at 3:56 PM Gerald Venzl <gerald.venzl_at_oracle.com<mailto:gerald.venzl_at_oracle.com>> wrote: Read-Only Oracle Homes were introduced in 18c<https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/understanding-read-only-oracle-homes.html#GUID-D848002A-DBAD-48FA-8467-E849630B8E42> and made the default in 21c. Thanks to this change, the Oracle software installation itself can be image-based.<https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/image-based-oracle-database-installations.html#GUID-0315AA15-1C03-4E96-B801-3A8E5F5D4B39>
There are a lot of benefits with ROOH and not tying the database configuration files to a particular OH location. For those of you on 19c, we highly encourage you to check this feature out and perhaps already make the move, as you will have to eventually anyway.
Thx,
Gerald Venzl | Distinguished Product Manager
Email: gerald.venzl_at_oracle.com<mailto:gerald.venzl_at_oracle.com>
Oracle ST & Database Development
400 Oracle Parkway | Redwood Shores | 94065 | USA
On May 11, 2022, at 12:11, Franky Weber Faust <weber08weber_at_gmail.com<mailto:weber08weber_at_gmail.com>> wrote:
All the config files moved to $ORACLE_BASE mainly because of the ROOH (read only Oracle Home) feature and that is the way 21c behaves. 21c OH is read only by default afaik.
Regards,
[LORE DATA]Franky Weber Faust
Consultor de Banco de Dados | LORE DATA Oracle ACE ♠️
Fone: 47 99125 2714
Email: franky_at_loredata.com.br<mailto:franky_at_loredata.com.br> loredata.com.br<https://urldefense.com/v3/__http:/loredata.com.br/__;!!ACWV5N9M2RV99hQ!NFb1CShoVdnaTM0sbiGEBm7A_bMa64dGe-tBQ7a1ZFUevjSrQ3vM6kNgHipISqAbuE6bA7NY4RZHMjqe9NFk8T1z$>
On Wed, May 11, 2022 at 12:20 AM P C <puravc_at_gmail.com<mailto:puravc_at_gmail.com>> wrote: Me too!
So I read a little to understand why this change amd it is to separate the installation from configuration…. makes sense!
Looks like a step towards cloud….
On Wed, 11 May 2022 at 6:04 AM, Mark J. Bobak <mark_at_bobak.net<mailto:mark_at_bobak.net>> wrote: Interesting...I had no idea! :-)
On Tue, May 10, 2022 at 3:12 PM Andrew Kerber <andrew.kerber_at_gmail.com<mailto:andrew.kerber_at_gmail.com>> wrote: Oracle home is not writable under 21c. https://docs.oracle.com/en/database/oracle/oracle-database/21/ladbi/file-path-directory-changes-read-only-oracle-home.html#GUID-695D5458-A4AF-4F2A-AE4B-FB1062CF6014
I discovered it the same way you just did.
On Tue, May 10, 2022 at 2:09 PM Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> wrote: I’m trying to create my first database in Oracle 21c. I want to do it manually the first time. I’m following the steps I’ve used in the past when creating an Oracle 19c container database, but I’m having a strange issue that I’ve never run into before.
When I try to create the database, it says it can’t find the init.ora file. The file is in the $ORACLE_HOME/dbs (/oracle/app/product/21.0.0.0/dbs<https://urldefense.com/v3/__http:/21.0.0.0/dbs__;!!ACWV5N9M2RV99hQ!NFb1CShoVdnaTM0sbiGEBm7A_bMa64dGe-tBQ7a1ZFUevjSrQ3vM6kNgHipISqAbuE6bA7NY4RZHMjqe9K2UVi34$>) directory, as it always has been, but it is looking for it in the $ORACLE_BASE/dbs (/oracle/app/dbs) directory instead. Is this a change with 21c? The environment is configured the same as in the past. How do I fix it?
Scott Canaan ‘88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659
CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Please consider the environment before printing this e-mail. Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
Important Notice
This message is intended only for the individual named. It may contain confidential or privileged information. If you are not the named addressee you should in particular not disseminate, distribute, modify or copy this e-mail. Please notify the sender immediately by e-mail, if you have received this message by mistake and delete it from your system.
Without prejudice to any contractual agreements between you and us which shall prevail in any case, we take it as your authorization to correspond with you by e-mail if you send us messages by e-mail. However, we reserve the right not to execute orders and instructions transmitted by e-mail at any time and without further explanation.
E-mail transmission may not be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also processing of incoming e-mails cannot be guaranteed. All liability of Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively referred to as "Vontobel Group") for any damages resulting from e-mail use is excluded. You are advised that urgent and time sensitive messages should not be sent by e-mail and if verification is required please request a printed version.
Please note that all e-mail communications to and from the Vontobel Group are subject to electronic storage and review by Vontobel Group. Unless stated to the contrary and without prejudice to any contractual agreements between you and Vontobel Group which shall prevail in any case, e-mail-communication is for informational purposes only and is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction.
The legal basis for the processing of your personal data is the legitimate interest to develop a commercial relationship with you, as well as your consent to forward you commercial communications. You can exercise, at any time and under the terms established under current regulation, your rights. If you prefer not to receive any further communications, please contact your client relationship manager if you are a client of Vontobel Group or notify the sender. Please note for an exact reference to the affected group entity the corporate e-mail signature. For further information about data privacy at Vontobel Group please consult www.vontobel.com<https://urldefense.com/v3/__https:/www.vontobel.com__;!!ACWV5N9M2RV99hQ!LKG9zavY7qaS3uHwxyejwuw3cQalVlwJAWVOFeI6mtehcLCRLYrT-Dcq_g1SjXSEM-mJ2QOntGrTesykLPhG1IJ514i3tQ$>.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 12 2022 - 15:36:12 CEST