Orace 10g - multiple instances


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?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

slightwv (䄆 Netminder)Connect With a Mentor Commented:
As long as you have the memory and disk space, two databases are fine.

Are the databases related?
Do they need to be physically seperated or will a logical seperation work?

You could just create another schema in the same OX1 database.

The issue with this approach is if the database goes down, both schemas will be unavailable.

The upside is only one database to maintain.

I'm not sure what you are asking about RAC.
joaotellesAuthor Commented:
The DB will not be related but I may have to get some data from OX1 to OX2 in the beggining... would it be a problem?

Actually with time the OX1 instance will be deleted but for now they will both work together...

slightwv (䄆 Netminder)Connect With a Mentor Commented:
Will the database users be the same?  If so, you will probably have to go with two instances.

If the OX1 apps use a different username thant the OX2 apps, then I might be inclined to go with a single instance.  Then when it is time to 'retire' OX1, just drop a user.

A lot depends on if one system can be down while the other system has to be up.

Either approach is good and each has it's own list of pros and cons.
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

joaotellesAuthor Commented:
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?

slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>is there any special requirement for this communication to occur?

No.  Just create a database link between them.

You might want to pay attention what username is used to create the link.  For example if you don't want the OX2 user to be able to perform DML(insert/delete/etc...) on the OX1 tables, you will need to create a new database user in OX1 that has select only on the tables.  Then create a synonym for the user.

Sort of a 'readonly' user.

The docs about creating/using links:
joaotellesAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.