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
  • 3
  • 3
LVL 76

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 76

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.
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.


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 76

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Retrieve Values 4 66
Need a replacement data type in Oracle 6 77
Maintaining Oracle Managed Accounts 2 37
Export table into csv file in oracle 10 74
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
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.

813 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now