Orace 10g - multiple instances
Posted on 2013-01-09
I have an environment like this:
1- I have Oracle 10g running in a Solaris OS machine (using Oracle RAC).
2- This Oracle SW already have an Instance created in it - OX1
3- I have a Linux OS machine running a SW that needs to have access to Oracle
4- This SW will create tables/indexes of the same names of the one´s in the instace OX1, they need to be separated, so my plan was to create an instance OX2 and let the SW to create whatever it needs to create in the OX2 without interferin in the OX1 tables... Would this be the best approach?
Of course the Linux machine will have access to the Solaris machine where Oracle is running. And the mount points necessary for Oracle are already set up as well in the Solaris machine.
The fact that is Oracle RAC interfere in something?