Hi Ray,
First, it is an excellent forum whatever be one's queries or doubts!
You can have multiple Oracle homes and setup both Oracle 10gR1 and 10gR2
on an AIX server and both installs can be under same oracle account.
After you are finished with installing say 10gR1, rename the
/etc/oraInst.loc file to something like /etc/oraInst.loc.10gR1. Now you
can start installation of 10gR2 with
ORACLE_HOME=/u01/oracle/product/10gR2.... Oracle will again create
/etc/oraInst.loc. This file will now point to oraInventroy of 10gR2
installation.
You can have ORACLE_SID upto 8 characters long, starting with a
character.
Rajesh
-----Original Message-----
From: RLam
[mailto:db2udbdba-ezmlmshield-x57183483.[Email address protected]
Sent: Thursday, March 30, 2006 6:34 AM
To: LazyDBA Discussion
Subject: Can Oracle 10g R1 and R2 coexist in the same AIX server?
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
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page