Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I recently tried installing Oracle 11g on a server already running 10g. Each would run independently with no problem, but 10g refused to run simultaneously with 11g. Can this be done? I don't need a solution so much as confirmation that it is indeed possible.

share|improve this question
1  
Not 100% certain, but this wasn't possible with previous versions of Oracle. I believe it is related to how Oracle allocates shared memory, but I could be wrong about that. –  duffbeer703 Dec 5 '09 at 17:14
    
What "previous versions" are you talking about? Prior to 8i, Oracle didn't explicitly support multiple Oracle Homes which just meant that you had to pick one of a handful of different approaches to run multiple versions of Oracle on the same server. –  Justin Cave Dec 6 '09 at 21:04

4 Answers 4

up vote 2 down vote accepted

Yes, you can have different versions of Oracle installed and running on the same server. I'd probably go with different listeners on different ports. And you wouldn't want two instances with the same name running. There's plenty of other areas you'd want to be sure they don't bump into each other (mostly disk locations).

That said, running two instances (other than dev/test) on one server isn't generally recommended. If they are small, you'd probably get better performance as separate schemas in one instance, and if they are big then go for separate servers. Also consider virtualization as an option.

share|improve this answer

You can always have multiple oracle accounts; the oracle account does not need to be named oracle. For example, you can have an oracle10 and an oracle11 user. This is more straightforward than a single 'oracle' user and multiple ORACLE_HOMEs.

The listeners can also be on different ports (eg, 1521 and 1523).

share|improve this answer

It is certainly possible. You do need to ensure that the different versions are installed in different Oracle Homes, but other than that, you can have as many versions of Oracle as you'd like.

Caveat: Technically, multiple home support was introduced in 8.1.5-- if you're using earlier versions, the answer changes a bit. You can still generally do it, just not as simple.

share|improve this answer
    
doesn't the oracle user only have one $ORACLE_HOME, though? –  warren Dec 6 '09 at 10:47
    
You can only set the $ORACLE_HOME environment variable to one value at a time, yes. That doesn't affect the number of Oracle Homes you can have on the server or the number of different versions of Oracle you can run. It does generally require that a human logging in to the oracle operating system account has to specify which Oracle Home they want to work with. –  Justin Cave Dec 6 '09 at 20:57

We do it around here all the time.

I would suggest if you decide to run 1 listener to service multiple homes/versions (like all on port 1521) that you run the listener from the highest version of Oracle that is in the group being serviced. I don't have any specific issues to cite but we have seen more reliability when we have say a 10g listener servicing 9i and 10g databases rather than a 9i listener trying to service 9oi and 10g databases.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.