In my OEM environment, I have a single OMS console connecting to a 2-node RAC database (let's call it OEMDB).
I had installed the db straight out of the box, so it has a default service and nothing else. For example, see my listener output:
[grid@prod-oem-db-02 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-NOV-2015 11:20:16
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/oem-db-02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.152.122.21)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.152.122.121)(PORT=1521)))
Services Summary...
Service "OEMDB.domain.com" has 1 instance(s).
Instance "OEMDB2", status READY, has 1 handler(s) for this service...
Service "OEMDBXDB.domain.com" has 1 instance(s).
Instance "OEMDB2", status READY, has 1 handler(s) for this service...
The command completed successfully
.. the OEM 12cR5 is basically a weblogic app running over weblogic 11g, so can I setup a separate database service for OEM to connect to?
I'm thinking:
srvctl add service -d oemdb -s oemdb_svc.domain.com -r oemdb1,oemdb2 -P basic -e select -w 120 -z 3 -m basic
srvctl config service -d oemdb -s oemdb_svc.lululemoninternal.com
srvctl status service -d oemdb -s oemdb_svc.lululemoninternal.com
Service oemdb_svc.domain.com is running on instance(s) oemdb1,oemdb2
srvctl start service -d oemdb -s oemdb_svc.lululemoninternal.com
..which would make it possible to RELOCATE services when i'm doing a planned outage (ie. grid/Db home patching).
srvctl relocate service -d oemdb -s oemdb_svc.domain.com -i oemdb1 -t oemdb2
does this make sense? should I be doing something different that's weblogic specific (ie. handling FAN events or using gridlink?) for higher availabilty of the OMS console? what is everybody else doing with their OEM installs?