Orace 10g - multiple instances
Hi,
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?
Tks,
Joao
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?
Tks,
Joao
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks for the reply... The username will be the same, oxuser. So, I will go with the two instances approach...
The communication between two instances, in order for me to migrate data from the OX1 to OX2.. is there any special requirement for this communication to occur?
Tks,
Joao
The communication between two instances, in order for me to migrate data from the OX1 to OX2.. is there any special requirement for this communication to occur?
Tks,
Joao
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks.
ASKER
Actually with time the OX1 instance will be deleted but for now they will both work together...
Tks,
Joao