Solved

Orace 10g - multiple instances

Posted on 2013-01-09
6
286 Views
Last Modified: 2013-01-09
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
0
Comment
Question by:joaotelles
[X]
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
6 Comments
 
LVL 77

Accepted Solution

by:
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.
0
 

Author Comment

by:joaotelles
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...

Tks,
Joao
0
 
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.
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

Author Comment

by:joaotelles
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?

Tks,
Joao
0
 
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:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/ds_admin002.htm#ADMIN12150
0
 

Author Closing Comment

by:joaotelles
ID: 38760327
Tks.
0

Featured Post

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!

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.

691 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