DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: multiple instances vs databases

  1. #1
    Join Date
    Nov 2000
    I am trying to understand this concept.

    What is meant by multiple instances?

    I have an 8.0.6 database already up. I need to create another (database? instance?) with 8i on the same machine. These two will not be connected at all. Am I creating another instance or another database or both?

    Thanks in advance

  2. #2
    Join Date
    Nov 1999
    Elbert, Colorado, USA
    An instance allows you to access a database. Consequently, you can have more than one instance per database (using the Oracle Parallel Server), but you can only have one database for any given instance. So if you want to have multiple instances on the same machine, you will also have to have multiple databases (and vice versa).

  3. #3
    Join Date
    Oct 2000
    But you can have multiple schemas in a database, which will allow for multiple applications to use the same instance/database.
    Whether or not this is appropriate for your situation is another question entirely.
    In reading your questions, if the two applications are unrelated, it would be best for them to have their own instance and database.

  4. #4
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    I thought this thread would help you to better undestand the concept:



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width