When I have multiple instances on the same server, I create the mount points similar to the following:
Then in each mount point, I create a subdirectory simply named by the ORACLE_SID. So if I have two instances named TEST and ORCL, I would have the following:
It should be obvious which directory contains files for which instance.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.