ORACLE DATABASE

How to Recover Agent Home on OMS got deleted accidentally Ensure that no agent java process is alive from the agent home 1. Rename agent_inst directory under agent base: /usr/oraoms/product/Agent12c/* --> You donot have agent_inst dir 2. Run the following command to reconfigure agent: NOTE: Replace all the required fields in the below command as per your environment $ cd /usr/oraoms/product/Agent12c/core/12.1.0.5.0/sysman/install $ agentDeploy.bat AGENT_BASE_DIR=/usr/oraoms/product/Agent12c AGENT_INSTANCE_HOME=/usr/oraoms/product/Agent12c/agent_inst AGENT_PORT=<Agent-Port> -configOnly OMS_HOST=<OMS HOSTNAME WITH DOMAIN> EM_UPLOAD_PORT=<OMS HTTPS UPLOAD PORT> AGENT_REGISTRATION_PASSWORD=<PROVIDE AGENT REGISTRATION PASSWORD> 3. If the above command completes successfully then follow the below steps: <AGENT_HOME>/BIN> ./emctl stop agent <AGENT_HOME>/BIN> ./emctl secure agent <AGENT_HOME>/BIN> ./emctl start agent ...

We are installing OEM13C in REDHAT 6.8 and pre-requisites are getting failed due to the non-certified version. The certification information on My Oracle Support lists Red Hat Enterprise Linux 6 as a certified platform for "Enterprise Manager Base Platform - OMS 13.1.0.0.0". The certification information does not list any specific version of Red Hat Enterprise Linux 6, such as 6.1, 6,2, 6,3, 6,4, 6.5, 6.6, 6.7, etc., it only says "Red Hat Enterprise Linux 6". However the EM 13.1 installation process doesn't recognize 6.8 as a certified version of RHEL 6. The error from the installer is shown below. The installer will not allow this to be skipped so the install can continue.   13.1 EM install does not support on RHEL6.8. This is taken care in next release of 13c OEM. For 13.1 EM the following documentation bug is logged to get the OTN document updated with this information: Bug 23328216 - 13c EM install on RHEL6.8 Fails Workaround: Once t...

When I am trying to access RC_BACKUP_FILES view from our RMAN Catalog database,  getting following error .. SQL> select count(*) from RC_BACKUP_FILES; select count(*) from RC_BACKUP_FILES * ERROR at line 1: ORA-20021: database not set ORA-06512: at "RCAT_EMB.DBMS_RCVMAN", line 26137 ORA-06512: at "RCAT_EMB.RC_LBRECSETIMPL_T", line 69 Workaround: It is usually more convenient to access this information using the LIST BACKUP and LIST COPY  commands from within RMAN. We must use DBMS_RCVMAN.SetDatabase to select a database from the recovery catalog schema before you can use this view. SQL> SELECT NAME,DBID FROM V$DATABASE; NAME            DBID --------- ---------- XXXXXX 3430087157                                ...