oracleoracle-18c
I have installed Oracle 18c XE and was wondering what benefits/disadvantages would come from seperating the data that is stored inside the databases managed by the dbms and the actual Oracle installation (Oracle_Home).
I ask this because it is possible to move Redologs, Datafiles and Controlfiles. I just don't have an idea why anybody would do that.
Just guesswork, but do you select "Upgrade an existing database" early on:
and "advanced install" later on:
The docs do look as if they are referring to the 10g installer.
Thanks to the link provided by Jack Douglas, I found the solution.
I needed to create a login.sql file in the same folder as sqlplus.exe and I had to set the SQLPATH environment variable to this path.
From the article I got the impression, that setting the variable was not necessary.
Best Answer
Seperate locations may have different performance characteristics or high availability or other properties.
For example you may use slower and cheaper storage for data that is rarely accessed, or a location with lower redundancy settings for temporary files.
To be honest, we rarely ever bother with this.
In a clustered environment, the data is stored in a shared location, but the Oracle database software is typically stored on some local storage location.