Multiple things in one machine
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Multiple things in one machine

  1. #1
    Join Date
    Nov 2000
    Posts
    416
    Can you highlight what extra care and/or extra conflict will happen when :

    1. I install secoond oracle server software in same machine with different home address
    2. I create second database in same machine with different Oracle SID

    Common troubleshooting will be much appreciate


    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    There should be little conflict when installing two versions of oracle on the same machine. Make sure you use different ORACLE_HOMEs for each version. When installing two versions, I typically use the listener with the HIGHER version to listen for both databases.

    Creating two databases (SIDs) on the same box is also no problem. You have to watch out to make sure you have enough physical resources (memory, mount points, etc) and that your kernal parameters are configured such that you can use enough resources. Other than that, it's common practice and will allow you to maximize your oracle license.
    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."

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Originally posted by marist89
    Other than that, it's common practice and will allow you to maximize your oracle license.

    Could you be more specific on what you mean by this?? Just curious ...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    By "maximize your oracle license" I mean hosting multiple databases on the same box. Early in the sales cycle, a lot of management types are lead to believe that you must have a seperate server for each database you are running.

    Since you license Oracle by CPU (either contrived or directly), you save licensing costs by utilizing more processor per box. Of course, this doesn't make much sense if your application is already CPU bound, but on a system with idle CPU, you can add a second database to the same box without worrying about licensing costs.
    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."

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