Database Reference
In-Depth Information
[-conn_desc [<jdbc connect descriptor>]]
Update Connect Descriptor with value if specified,
else from value stored in emoms.properties
[-ignore_timeskew] ignores timeskew on agent
The monitoring configuration for the OMS and repository target should also be updated by using this command:
emctl config emrep [-sysman_pwd <sysman password>]
[-agent <new agent>] Specify new destination agent for emrep target
[-conn_desc [<jdbc connect descriptor>]]
Update Connect Descriptor with value if specified,
else from value stored in emoms.properties
[-ignore_timeskew] ignores timeskew on agent
After the database has been recovered and reconfiguration performed, the next step would be to log in to the
Enterprise Manager Cloud Control console and verify that all operations have been restored.
Oracle Management Service Recovery
Recovering an OMS requires recovery of both the software homes (Fusion Middleware) and the instance homes
(
gc_inst
). The software homes can either be recovered from a filesystem backup or be reinstalled using the Install
Software Only option on the same or a different host using the Enterprise Manager Cloud Control 12c installer. The
OMS home must be in the same location as the OMS home being recovered.
All plug-ins that existed in the OMS are required to be installed for the recovery to succeed. The following SQL
query should be run as the
SYSMAN
user:
SELECT epv.display_name, epv.plugin_id, epv.version, epv.rev_version,decode(su.aru_file,
null, 'Media/External', '
https://updates.oracle.com/Orion/Services/download/
'
||aru_file||'?aru='||aru_id||chr(38)||'patch_file='||aru_file) URL
FROM em_plugin_version epv, em_current_deployed_plugin ecp, em_su_entities su
WHERE epv.plugin_type NOT IN ('BUILT_IN_TARGET_TYPE', 'INSTALL_HOME')
AND ecp.dest_type='2'
AND epv.plugin_version_id = ecp.plugin_version_id
AND su.entity_id = epv.su_entity_id;
The following example output shows the plug-ins, versions, revisions, and URLs. The URL will display if
downloaded via Self Update. Otherwise, the status will be Media/External.
SQL>
DISPLAY_NAME PLUGIN_ID VERSION REV_VERSION URL
------------------------------ ------------------ ----------- ------------ ----------------
Oracle MOS (My Oracle Support) oracle.sysman.mos 12.1.0.2.0 0 Media/External
Oracle Fusion Middleware oracle.sysman.emas 12.1.0.3.0 0 Media/External
Oracle Database oracle.sysman.db 12.1.0.2.0 20120804 Media/External
Oracle Exadata oracle.sysman.xa 12.1.0.3.0 0 Media/External
If any additional plug-ins are listed, they should be downloaded into a single directory; then rename the
extensions from
.zip
to
.opar
. Use the Install Software Only option to install the Middleware and OMS Oracle home
components if not restoring from a filesystem backup. After the software has been reinstalled or restored, the next
step is to install the additional plug-ins (if any). Execute the
PluginInstall.sh
script located in
