How to install another Oracle instance in the same home?
Hi,
I want to install another Oracle Instance in the same home, so that I will have two instances running. Both instances will be using Oracle Database 11.2.0.4 Enterprise Edition on Redhat Linux. So I assume I can use the same ORACLE_HOME?
I already have a set of database creation scripts that I used to create the initial instance, so am I correct to assume I can create a copy of these scripts and update the SID and the relevant paths to point to the new location of the database data files, as well as updating the init.ora to point to the new locations?