AIX/Oracle11g/ARF - shared ORACLE_HOME using OEM

Hi

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 "

Other related posts: