Orace 10g - multiple instances

Posted on 2013-01-09
Last Modified: 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?
Question by:joaotelles
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 500 total points
ID: 38758615
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.

Author Comment

ID: 38758886
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...

LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 38759845
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.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 38759960
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?

LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 38759999
>>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:

Author Closing Comment

ID: 38760327

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question