hi there, (sorry if I've posted to the wrong forum as my email to
oracledba @ lazydba . com got bounced back for some reason).

I'm recently involved in an Oracle project to setup a new instance for our
development team. Our developers would like to try out their code in both
versions.

In my past oracle life, I've setup multiple ORACLE_HOMEs for different
versions such as v7.3 and v8.0.

So my plan is to install 10g with 2 different SID as follows:

First Instance: SID=DEV_R1
ORACLE_HOME=/u01/oracle/product/10gR1...

Second Instance: SID=DEV_R2
ORACLE_HOME=/u01/oracle/product/10gR2...

Database data and log files will be put inside the corresponding
$ORACLE_HOME/data and $ORACLE_HOME/logs respectively so I know which
database is created in which version.

I have some questions that need further clarification:

- should I keep both R1 and R2 under the same "oracle" account having 2
different profiles for R1 and R2? Or is it better to create 2 separate
accounts such as oracle_r1 and oracle_r2?
- is SID limited to 4 characters? Any problem with 6 characters?
- will AIX support multiple oracle homes of 10gR1 and 10gR2?

Thanks
Ray

DB2 & UDB email list listserv db2-l LazyDBA home page