EM console setup in SAP environment
This document should explain how to configure Oracle EM console in SAP environment, because there is one big issue with ORACLE_HOME environment variable.
As in SAP installation on Linux (or other unix OS), normally installation is done into /oracle/<SID>/11203 or /oracle/<SID>/112_64 directory, but ORACLE_HOME is set to /oracle/<SID>/112, which is soft link, there is a problem with configuration of EM.
In Oracle notes 1106623.1 and 550484.1 it is described that ORACLE_HOME should be set to physical directory, not to linked one.
Solution is to change scripts emca and emctl which are located in /oracle/<SID>/112/bin directory and replace physical directory with linked one and then start command for configuration:
emca -config dbcontrol db -repos create
Also for RAC database there is two other prerequisites:
1. parameter remote_listener must be set to scan VIP
2. password files for all instances must exists in /oracle/<SID>/112/dbs directory
Then you can start configuration:
emca -config dbcontrol db -repos create -cluster
Thank you for the post!