Re: [External] : Re: Oracle 21c

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> 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>
> 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
>> 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>
>> 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,
>>
>> [image: LORE DATA]
>> Franky Weber Faust
>>
>> Consultor de Banco de Dados | LORE DATA
>> Oracle ACE ♠️
>> Fone: *47 99125 2714*
>> Email: 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> 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> wrote:
>>>
>>>> Interesting...I had no idea! :-)
>>>>
>>>> On Tue, May 10, 2022 at 3:12 PM Andrew Kerber <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> 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 <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.'
>

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