Datafiles are outside the Oracle_Base

User_RAWL8

Hi, Oracle community,

Is there any impact on the normal function of the database when/if the datafiles are outside the $ORACLE_BASE. This is due to the fact that I had a space constraint on the directories holding the ORACLE_HOME and ORACLE_BASE ,

Kindly advise

EdStevens

None at all. In fact, I think it is preferable for the data files to be outside of the $ORACLE_BASE. It doesn't matter for performance, but it does for administration. I (and many others) go a step further, and put the data files on a separate mount point so that they are not only logicaly outside of the $ORACLE_BASE. The problem you faced is one of the primary reasons to do exactly that.

On a *nix system, I put $ORACLE_BASE on /u01, and the data files either under ASM or under /u02.

Consider if you were using ASM. Then the data files would very much be outside of the installation directories.

saratpvv

Its a best practice to keep datafile outside the ORACLE_BASE.

EdStevens

None at all. In fact, I think it is preferable for the data files to be outside of the $ORACLE_BASE. It doesn't matter for performance, but it does for administration. I (and many others) go a step further, and put the data files on a separate mount point so that they are not only logicaly outside of the $ORACLE_BASE. The problem you faced is one of the primary reasons to do exactly that.

On a *nix system, I put $ORACLE_BASE on /u01, and the data files either under ASM or under /u02.

Consider if you were using ASM. Then the data files would very much be outside of the installation directories.

saratpvv

Its a best practice to keep datafile outside the ORACLE_BASE.