Multiple instances on a single database

Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)?

There is an architecture issue that has been nagging me for a long time: is it possible for Oracle to have parallel servers (single database, multiple instances)?

Is it impossible to have the inverse? (That is, multiple databases, single instance.) This worries me because in our company we have several databases, most of them not actively used. I wonder if it's possible for me to have one instance where several of my databases could attach.

Using Oracle's Parallel Server (OPS), which was renamed to Oracle's Real Application Clusters (RAC), you can have multiple instances connected to the same database.

On the surface, it appears as though the inverse is not true. It appears as though you cannot have multiple databases running under one instance. Without OPS or RAC, you must have one instance for each database if you want to access data in that database. However, it is possible to access another database's data through an instance by using Database Links. With DB Links, you can connect to remote instances without signing off of your current instance. In this manner, you can access data in multiple instances all from the same Oracle session!

Dig Deeper on Oracle database administration

Data Management
Business Analytics
SearchSAP
TheServerSide.com
  • The 3 daily Scrum questions

    The 2020 Scrum Guide removed all references to the three daily Scrum questions, but does that mean you shouldn't ask them anymore?

  • Why WebAssembly? Top 11 Wasm benefits

    Latency and lag time plague web applications that run JavaScript in the browser. Here are 11 reasons why WebAssembly has the ...

  • Why Java in 2023?

    Has there ever been a better time to be a Java programmer? From new Spring releases to active JUGs, the Java platform is ...

Data Center
Content Management
HRSoftware
Close