ORACLE INSTANCE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORACLE INSTANCE

  1. #1
    Join Date
    Jul 2002
    Posts
    8
    Knowledge Base

    1.I want to know that in How maney instances can be created in one Physical Server?
    2.How maney Databases can be created in one instance?

    Thanks
    Mohammed A.Musaddique
    SAudi Arabia

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi;
    I know that the ORACLE_SID contains 4 Letters
    Probably with 8i/9i there are even more.
    With Combination of 4 Letters you can theoretically create 27^4 Instances and even more when you use digits 0-9

    One Instance can only connect to one physical Database.

    Orca


  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    1. unlimited provided you have enough resources.
    2. 1
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by mamdba
    2.How maney Databases can be created in one instance?
    Instance means the collection of all structures of the database server running together. Structures means all kinds of memories, resources, processes, etc.

    One database can be associated with several instances, i.e., you can mount and open the same databases on physically different nodes. This was possible since 1989 and is known before 9i as OPS and in 9i as RAC.

    Back to your question: you do not create databases in an intstance. Rather the database is part of the instance.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Jul 2002
    Posts
    8

    THANKS

    Thank you very much
    Mohammed A.Musaddique
    SAudi Arabia

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