Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parameter to change ORACLE_HOME/dbs

Franck PachotAug 19 2016 — edited Aug 19 2016

The working directory of oracle processes is ORACLE_HOME/dbs ('database' on Windows) and this is where we find spfile, passwordfile and several other files.

It's not a good idea to save keep those files here. Better to separate binaries (read only, not to backup often, size do not increase) and configuration/variable files that have nothing to do there. There are several means to do it: symbolic links, ifile, parameter for specific files, etc

However, it would be nice to have a simple environment variable for that, such as ORACLE_DBS for example. Somethin similar to TNS_ADMIN we use to put sqlnet configuration files in a different place.

Comments
Post Details
Added on Aug 19 2016
7 comments
3,449 views