Re: Two instances with same SID in a same machine

FM wrote:

>
> Maybe I misunderstood but this is a period where I have to test machine
> and features and I considered this a good challenge so I tried and here
> is the result:
>
> oracle 9938 1 0 10:39 ? 00:00:00 ora_pmon_TEST9I
> oracle 9943 1 0 10:39 ? 00:00:00 ora_dbw0_TEST9I
> oracle 9952 1 0 10:39 ? 00:00:00 ora_lgwr_TEST9I
> oracle 9954 1 0 10:39 ? 00:00:00 ora_ckpt_TEST9I
> oracle 9962 1 0 10:39 ? 00:00:00 ora_smon_TEST9I
> oracle 9967 1 0 10:39 ? 00:00:00 ora_reco_TEST9I
> oracle 9969 1 0 10:39 ? 00:00:00 ora_cjq0_TEST9I
> oracle 9972 1 0 10:39 ? 00:00:00 ora_qmn0_TEST9I
> oracle 9976 1 0 10:39 ? 00:00:00 ora_s000_TEST9I
> oracle 9981 1 0 10:39 ? 00:00:00 ora_d000_TEST9I
> oracle 10011 1 0 10:39 ? 00:00:00 ora_p000_TEST9I
> oraclet 13382 1 0 14:08 ? 00:00:00 ora_pmon_TEST9I
> oraclet 13384 1 0 14:08 ? 00:00:00 ora_mman_TEST9I
> oraclet 13386 1 0 14:08 ? 00:00:00 ora_dbw0_TEST9I
> oraclet 13388 1 0 14:08 ? 00:00:00 ora_lgwr_TEST9I
> oraclet 13390 1 0 14:08 ? 00:00:00 ora_ckpt_TEST9I
> oraclet 13392 1 0 14:08 ? 00:00:00 ora_smon_TEST9I
> oraclet 13394 1 0 14:08 ? 00:00:00 ora_reco_TEST9I
> oraclet 13396 1 0 14:08 ? 00:00:00 ora_cjq0_TEST9I
> oraclet 13398 1 0 14:08 ? 00:00:00 ora_d000_TEST9I
> oraclet 13400 1 0 14:08 ? 00:00:00 ora_s000_TEST9I
> oraclet 13402 1 0 14:08 ? 00:00:00 ora_p000_TEST9I
>
> 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...
>

Yes, that is the correct way to do it ...

These days, the typical scenario (especially since Oracle introduced the concept of ORACLE_HOME) is to use one *nix userid to install and manage _all_ instances.

If you want the confusion of two identically-named instances on the same server, you _must_ separate them by *nix userid.

I've not used this trick since Oracle8, late '90s, and had totally forgotten about it. DOH!

To express a concern - I hope you did not _need_ to do this because of hard-coded SID in the application! Received on Fri Aug 27 2004 - 07:51:57 CDT