2 oracle_home on unix

[kukuluku]

Hello,

We have Oracle 9.2.0.3 installed on the server. I need to install 9.2.0.6 in the same server for new databases. We have /oracle file system for Oracle binary. The current Oracle was installed on /oracle/product/9.2.0 and I am thinking to install new version on /oracle/product/9.2.0.6. Also I have file systems /u01, /u02, etc for datafiles.

9.2.0.3 was installed as oracle user and dba group. I am thinking to create oracle2 and dba2 for the new version. Right now, /oracle, /u01, /u02 all belong to oracle/dba. Should I make the file systems 777 and then create sub-directories under them as oracle2/dba2 for 9.2.0.6?

Thank you in advance for you input. Any more information pertaining 2 ORACLE_HOMEs on the same machine is very appreciated.

 

[LKBrwnDBA]

No need to create another Oracle account on Unix -- use the same account to create the second Oracle home on /oracle/product/9.2.0.6 directory.

Make sure you choose "Custom Installation" and "Software only" to avoid making the mistake of creating a new database with dbca.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[sem]

And after all could you explain why you need to keep a database with lower patch level? Isn't it easier to apply patch to existing Oracle software and just create a new database?

Regards, Dima

http://seminihin.narod.ru

 

[kukuluku]

We are not planning to upgrade the existing systems. We are implementing new project (3rd party software - PeopleSoft to be exact) and it requires 9.2.0.6. For the old system, we'll just keep it on 9.2.0.3 (development and production).