?
Solved

Orace 10g - multiple instances

Posted on 2013-01-09
6
Medium Priority
?
288 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 2000 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 2000 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

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 2000 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to recover a database from a user managed backup
Suggested Courses

800 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