AIX/Oracle11g/ARF - shared ORACLE_HOME using OEM

I am trying to configure an AIX server with Oracle 11g which supports multiple databases that need to be able to move independently from this server to another. We are using a high-availability management tool called ARF to automate fail-over. We have built one ORACLE_BASE/ORACLE_HOME per server to reduce the management overhead and footprint of many copies of the software.

We need to use OEM to manage the database (currently exploring DBCONTROL) and have successfully set the ORACLE_HOSTNAME=srvtech variable to cause OEM to configure around 'srvtech' rather than the 'real hostname' of the server and this establishes the following 2 directories in the ORACLE_HOME (where QLTECH1 is the ORACLE_SID):

/u01/app/oracle/product/srvtech_QLTECH1

/u01/app/oracle/product/11.2.0.2/oc4j/j2ee/kk

These two directories would not move to the fail-over server as they are resident in the local ORACLE_HOME. We have successfully moved the first of these (srvtech_QLTECH1) to a database file system and created a symbolic link, and this has worked successfully. Unfortunately this is not the case for the second directory as OEM looks for other files in the targeted file system.

Does anyone know how we can successfully configure the software to solve the above problem; or are there any other approaches which would support our requirement of managing our databases using OEM with a shared ORACLE_HOME but moveable databases. We are tied to using AIX/Oracle11g/ARF.

Thanks for any suggestions.

Niki Tragen
Oracle DBA/Technical Team Leader
Planning and Management Information
Manchester Metropolitan University

"Before acting on this email or opening any attachments you should read the Manchester Metropolitan University email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer "

--
http://www.freelists.org/webpage/oracle-l