multiple instances for a database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: multiple instances for a database

  1. #1
    Join Date
    Jan 2003
    Posts
    38

    multiple instances for a database

    Hello,

    I am new to Oracle. I have created a database named sales. The oracle SID for this database is also sales. I want to know if I have to run multiple instances how do I do that. I mean do I have to create another database for each instance using dbassist or is there a way I can use the same database I created for other instances ie the same datafiles, redologs and all .. Please bear in mind that I am new to Oracle . Also I would appreciate if someone sends me a document about how to configure multiple instances.

    Thanks
    -K

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Yes, you will have to create new database for each instance.

    If you want to access one database from more than one instances you can make use of OPS,Oracle Parallel Server (Before 9i) or RAC Real Application cluster (9i)
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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