2 databases but one oracle home
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: 2 databases but one oracle home

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    2 databases but one oracle home

    is it possible to have 2 databases that shared one oracle home?

    so in this case, only the oracle binaries are the same whereas the rest of the files are different?

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Yes, it is.
    Set a new ORACLE_SID, create a new parameter file, create database, adjust listener.ora and so on.
    Change ORACLE_SID to switch databases.
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  3. #3
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Yes, this is very much possible. The Oracle binaries are shared but each database will have their own set of datafiles, controlfiles, passwords files, init.ora files etc.

    You can create subdirectories for instance specific files

    e.g:

    /u01/oradata/DB01

    /u01/oradata/DB02

    Do some reading on the Oracle Optimal Flexible Architecture (OFA) here . This provides a standard for easily implementing multiple instances on a single machine/oracle home.

  4. #4
    Join Date
    Oct 2002
    Posts
    391
    the port number in listener for these 2 sids can be either the same and not, right?

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    yes
    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."

  6. #6
    Join Date
    Oct 2002
    Posts
    391
    what i understand is that if 2 sids share a given port number, then they will have to contest for the right to communicate.

    so its of advantage to have 2 different ports for 2 different sids , hence exclusive rights to a port number?

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    if I were thinking like you I would have had to install 100 ORACLE_HOMEs LOL

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    dont forget the 100 different listener ports

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