Database Solutions

 In this blog , We will list down the steps to clone a OEM agent from an existing host.  Step 1) Create agent Base directory and provide required permission. mkdir -k /u01/app/oracle/agent_base_13 Step 2) On OEM Console, navigate to the "Add targets Manually."  screen. Setup->Add target->Add Targets Manually  Step 2) On next screen click Ïnstall Agent on Host" Step 3) On Host and platform page. Give unique session and click +Add button and enter fully qualified name and select the platform for the host. Step 4)    On the Installation Details page, In the Deployment Type section, select Clone Existing Agent. Then, for Select Target, click the torch icon and select the Management Agent you want to clone From the table, select the first row that indicates the hosts grouped by their common platform name Enter the installation details and click the "Next" button Installation Base Directory : /u01/app/oracle/agent_base_13 Instance Directory Named Credenti...

In this blog , we will list down all the steps to install or push the OEM agent to target host. Step 1) Create agent Base directory and provide required permission. mkdir -k /u01/app/oracle/agent_base_13 Step 2) On OEM Console, navigate to the "Add targets Manually."  screen. Setup->Add target->Add Targets Manually  Step 2) On next screen click Ïnstall Agent on Host" Step 3) On Host and platform page. Give unique session and click +Add button and enter fully qualified name and select the platform for the host. Step4) Enter Installation details and click "Next"button Installation Base Directory : /u01/app/oracle/agent_base_13 Instance Directory Named Credential : /u01/app/oracle/agent_base_13/agent_inst (default) : (click the "+" button and add the credentials of the "oracle" user) Privileged Delegation Setting: (leave blank) Port : 3872 Step 6) Check information on the review screen and click "Deploy Agent"Button. Step 7) Re...

 In this blog, we will highlight and list down step to apply patch to OEM agent from OMS.  NOTE: If you have not added OTN credential on OMS server, then we need to use offline mode. In this blog, we will use offline mode.  Step 1) Upload patch to software library. You can upload patch from any host where OEM agent is installed.  emcli upload_patches -patch_files="<Location of Patch> -from_host=<hostname from where patch is uploaded> -cred_name=<preferred host credential > -cred_owner=<owner of the credential> Step 2) Verify patch from software library Enterprise-> provisioning and patching -> software Library On next page click Patch Components -> oracle software updates will list down the uploaded patch.  Step 2) Create patch Plan  Enterprise-> provisioning and patching -> Patches & Updates Under search -> search the patch needed to be applied. Highlight the patch and click Create Plan Next, Add target server ...

 In this blog, we will list down the steps to download the OEM 13C agent.  1) Trigger AgentDEinstall.pl script to delete agent and remove agent base directory. <Agent_home>/perl/bin/perl <Agent_home>/sysman/install/AgentDEinstall.pl -agentHome <Agent_home> 2) Manually remove the targets, which were monitored by the agent from OEM Console.  Or invoke below command from oms host to delete manually.  emcli delete_target -name="<host_name>:<agent_port>" -type="oracle_emd" -delete_monitored_targets  You can learn more about oracle RAC using below books: Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting Expert Oracle RAC 12c ========================================================== Please check our other blogs for  OEM  &  OMS . 

In order to get the alert from the OMS/OEM, DBA need to enable alert notification. In this blog, we will discuss steps to perform the same. => Create the Notification Method           =>  Click on the “Setup” à “Notifications” à “Notification Method” => Click on “Go”. We are using the shell scripts to generate an email notification     => Enter these details and Click on the “ok” => Create the Rules to get the EMAIL Alerts          =>   Click on the Setup à Incidents à Incident Rules => Click on “ Create Rule Set ” => Give a name to this Rule Click on the Target tab and Radio button “ All Targets of types ” and select the  targets => Click on the tab - Rules     =>Click on “ Create ”   =      => Select the Radio button “ All new incidents and updated incidents ” and Click “ Next ”     =>  Click on the “ Add ”      ...

  DBAs need to install OEM agent on daily basic in order to promote/discover target server or related targets.       (1)     Login to the OEM 12C server and follow the below steps -      (A) Setup the “.profile_oms” it will setup the environment variables for the OEM 12C      (B) Login to the sysman account with the “emcli” utility      (C) Synchronized the OMS 12C       (D) Verify the Supported Versions in our OMS 12C.We can configure other Agents as well like Hp UNIX etc but in our Cummins environment, we are only using the Solaris, LINUX, AIX and Windows. With this reason, these Agents are configured on the OMS 12C.            (1)   To install the OEM 12C, we have to download the software from the OEM 12C console with the help of “emcli” utility              (2)   SCP this file “ 12.1.0.2.0_AgentCore_23.z...