Re: oracle binaries and datafiles
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Wed, 28 Mar 2018 14:52:23 -0500
Message-ID: <48e511789726df8f598aa1b0eb193c65_at_society.servebeer.com>
Date: Wed, 28 Mar 2018 14:52:23 -0500
Message-ID: <48e511789726df8f598aa1b0eb193c65_at_society.servebeer.com>
On 2018/03/28 14:34, Jeffrey Beckstrom wrote:
How often do you need to modify anything in $ORACLE_HOME versus the path(s) where the datafiles are stored? Files in $ORACLE_HOME/dbs could be updated regularly. Modifications to datafiles will hopefully be never, or rare if an older version needs a file moved. Putting datafiles in the same relative path as files that need manual attention adds risk of accidents. Even the latest OFA suggests separating them: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwlin/optimal-flexible-architecture-file-path-examples.html
My vote is to separate them, not just on mount point, but the top-level directory.
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 28 2018 - 21:52:23 CEST