Re: Two instances with same SID in a same machine

From: FM <fabrizio.magni_at_mycontinent.com>
Date: Sat, 28 Aug 2004 08:51:35 GMT
Message-ID: <rIXXc.204393$5D1.9481188@news4.tin.it>

Howard J. Rogers wrote:

> FM wrote:
> [snip]
>
>

>>Two different DBs on the same host (a linux system).
>>I needed two different users and two different ORACLE_BASE.
>>
>>But maybe the main topic was another and my coompreension of the topic
>>was messy...

>
>
> Your comprehension was spot on, and you've proved it's possible, and
> accordingly I was 100% wrong. So my apologies for making a mistake, and
> congratulations for proving the point so nicely again. Once again,
> practical testing beats theorising, hands down.
> Regards
> HJR
Thank you. I feared to have completly misunderstood the subject of the discussion.

In my mind it was theoretically possible but I was quite unsure about the practical part.

I was lucky to have a test machine ready at the moment.

However, pondering, I believe possible to achieve the same result even with the one user and, likely, with the same oracle engine.

My idea is to keep the PATH variable pointing at the right binaries (where the oracle installation reside) and to change the ORACLE_HOME and ORACLE_BASE in the environment. Of course, you have to create the right directory trees:

$ORACLE_BASE/amind/<SID>/etc
$ORACLE_HOME/dbs
$ORACLE_HOME/network/etc

(Ok, I have doubts regarding libraries and messages files). I don't see any advantage to have a similar situation and it would be an administration hell.

I don't think I shall test it... at least not during the weekend.

On windows, I fear, the matter is much more complicated and I'm not a windows guru.
The most complicated part is the services part. Is it possible to rename a service? Does really the service name matter for oracle?

On this newsgroup there are tons of persons more skilled and able to answer accordingly.

I apologize for the lack of competencies.

Regards

-- 

Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe

Received on Sat Aug 28 2004 - 03:51:35 CDT