Re: Two Oracle owners on one box .....

This won't work ...
4b. edit /etc/oraInst.loc file to point to another directory - otherwise you won't be able to do your second install ...

5b. create 2 /etc/oratab files (/etc/oratab and /etc/oratab_2) and edit all oracle scripts of the second install to make use of /etc/oratab_2... for example
dbshut, dbstart ... enterprise manager and the intelligent agent are a bit more tricky (tcl scripting)

While performing future upgrades - always edit the /etc/oraInst.loc file first to make it point to the correct directory ... I have a customer with almost the same setup and
they never found any problems while migrating, upgrading etc ... it is of course a waste of resources ...
They also have a listener running for each oracle user so with HACMP you might want to double check your fail-over scripts so they use the correct environment...
The reason they did it because of different companies buying one cowabunga machine and for security reason the DBA for the one company may not have access
*at all* to the other company's environmnent ... it's ugly - but it works ...

kind regards,
Kurt

"NorwoodThree" <norwoodthree_at_my-deja.com> wrote in message news:ba03e2c.0205152101.adadb33_at_posting.google.com...
> Well to be honest, this is the most retarded technical requirement
> I've heard in a while. Standard case of not setting Oracle up
> correctly to meet a non-educated requirement. Anyhoo, not your fault,
> just ranting.
>
> There are many ways to go about this. However, given your situation,
> my suggestion would be to do the following since I have limited
> knowledge of your environment.
>
> 1. Set up 2 oracle users. Name them something intelligable like
> oracle1, oracle 2 with separate user id's. Now create groups dba1,
> and dba2.
>
> 2. Assign the oracle1 user with the dba1 user group. Assign the
> oracle2 user with the dba2 group.
>
> 3. Have 2 separate ORACLE_HOME directories:
> ...product/8173_ora1/... owned by oracle1, dba1
> ...product/8173_ora2/.... owned by oracle2 dba2
>
> 4. Follow the instruction guide. Log in as oracle1 and perform an
> install.
>
> 5. Follow the instruction manual. Log in as oracle2 and perform the
> second install.
>
> 6. Done.
>
> Hope this helps; comments are welcome. Many Oracle Financials
> environments on the same box are set up in this manner. I realize you
> arent running Financials here, but the execution still applies. This
> will give you separate listeners, etc.
>
> Comments always welcome.
Received on Thu May 16 2002 - 02:08:40 CDT