Showing posts with label EM12c. Show all posts
Showing posts with label EM12c. Show all posts

Monday, 22 June 2015

The Oracle HTTP Server instance is down- WEBSERVER (OHS) 12.1.0.1.0 service is up on host but target shows down in EM12c (Agent & OMS version 12.1.0.4.0)

The Oracle HTTP Server instance is down- WEBSERVER (OHS) 12.1.0.1.0 service is up on host but target shows down in EM12c (Agent & OMS version 12.1.0.4.0)

OHS Target shows down in EM12c console whereas the service is up on the 
node.

Agent Version          : 12.1.0.4.0
OMS Version (EM12c)    : 12.1.0.4.0


Target Details
-------------------
Target type=Oracle HTTP Server
Target name=/SID_host_port_base_domain/sid_host/ohs1
Categories=Availability
Message=The Oracle HTTP Server instance is down

Host = localhost.domain.com
Admin url = http://localhost:port/console

OHS Target shows down in EM12c console whereas the service is up on the 
node as shown below.


cd /sid/admin/sid_host/bin

$ ./opmnctl status -l

Processes in Instance: sid_hostname

ias-component  status
-------------  ------
ohs1           alive   


cd /sid/fmw/product/111/ohs_111/opmn/bin


ias-component  status
-------------  ------
ohs1           alive 


$./opmnctl status

Processes in Instance: sid_host
                

This may be a bug & possible issue may be with the JMX connections as observed from error messages like below in the logs

Caused by: java.io.IOException: Failed attempting connection on serviceURL 

service:jmx:t3://host.domain.com:port/jndi/weblogic.management.mbeanservers.domainruntime

Sunday, 5 January 2014

Deploying latest Database Plugin to the OMS and Agent in EM 12C Cloud Control

Deploying latest Database Plugin to the OMS and Agent in EM 12C Cloud Control

To deploy the latest database Plug-in on the OMS and the Agent, perform steps as below. Please note, the Admin server should be up and running when deploying plugins to the management server.

a. Acquire the latest database Plug-in software using Self Update

I) Using Online mode:

1. Login to 12C Cloud Control
2. Navigate to Setup --> Extensibility
3. Select the option Self Update
4. In the page displayed, Select Plugins and Click on "Check Updates"
    This will execute a job, Once the job is finished, go back to the Self Update Page.
    Click on "Plug-in" to navigate to Plugin home page.
5. Choose the Plugin "Oracle Database" and Click on "Download"

II) Using Offline mode:

1. Login to 12C Cloud Control
2. Navigate to Setup --> Extensibility
3. Select the option Self Update
4. In the page displayed, Select Plugins and Click on "Check Updates"
   This will give a pop-up with set of emcli commands to download the required updates.
5. Choose the Plugin "Oracle Database" and Click on "Download", this will give a pop up with set of emcli commands to download the software.

b. Deploy the Plug-in to the Management Server

To deploy to the database plugin to OMS,ensure that the required patches are applied to OMS HOME and PLUGIN HOME

Follow the below mentioned steps to deploy plugin to OMS:

1. Login to 12C Cloud Control
2. Navigate to Setup --> Extensibility
3. Select the option Plugins
4. Expand the option "Databases"
5. Select "Oracle Database"
6. Expand the option "Deploy On" and Choose "Management Servers"
7. In the page displayed, provide the SYS user password
8. The deployment performs the following:
     Step 1: Following validations are performed:
                    - Initialize the plugin
                    - Validate plug-in home
                    - Check mandatory patches
                   Once the above three steps are done, Click on next
     Step 2: In the Review page, it gives warning as below. Click on "Deploy" to proceed with deployment.
                  "Plugin-in revision deployment only updates metadata in the repository. Oracle Home updates are not needed."
     Step 3: Confirmation message about deployment of database plugin on Management Server.

This will complete the deployment of database plugin to management server.

c. Deploy the Plug-in to the Management Agent

Its a prerequisite to deploy the latest database plugin to OMS before deploying to Agent.
Ensure the plugin deployment to OMS is successful and then perform the following to deploy plugin to agent:

1. Login to 12C Cloud Control
2. Navigate to Setup --> Extensibility
3. Select the option Plugins
4. Expand the option "Databases"
5. Select "Oracle Database"
6. Expand the option "Deploy On" and Choose "Management Agent"
7. In the page displayed, Click on "Add" to add the Agent on which plugin needs to be deployed.
8. After adding the agent name, it will run the prerequisite check, after successful completion of prerequisite check, click on Next.
9. A Confirmation message about deployment of database plugin on Management Agent will be displayed.

This will complete the deployment of database plugin to management agent.

Sunday, 6 October 2013

Unable to see data for Oracle Database Monthly Space Usage report for all Databases in Oracle Enterprise Manager 12c

Unable to see data for Oracle Database Monthly Space Usage report for all Databases in Oracle Enterprise Manager 12c


Trying to get a report on Oracle Database Space Usage but databases listed in "Outstanding Tablespace Full Alerts by Databases" were not appearing in "Allocated Space Usage by Database.

Digging deep found out that the Tablespace Allocation metric was disabled for some databases!

So tried below in Enterprise Manager:

Target > Databases > Choose Database with Metrics issue > Menu > Monitoring > All Metrics > Click "Tablespace Allocation"

Click Enable

  • For single database
Targets > Databases > Choose Database with Metrics issue > Menu > Monitoring > All Metrics > Click "Tablespace Allocation"

Click Enable

  • For Multiple Databases
-- Create Template with this metric enabled and push the template to multiple databases

UI > Enterprise > Monitoring > Monitoring Templates > Click Create and add the metric


Wait at-least 72 hours and check the status again. It should show data now.

Tuesday, 9 April 2013

How to check Oracle HTTP Server (OHS) component version?


How to check Oracle HTTP Server (OHS) component version?

Below are a couple of ways to check with Oracle HTTP Server (OHS) version used. There may be more ways to check it.

1) Go to $OHS_HOME/bin

Run ./httpd -version

It should return result as below based on the version of OHS


$ ./httpd -version
Server version: Oracle-HTTP-Server/2.2.15 (Unix)
Server built:   Apr  2 2011 23:51:27
Server label:   APACHE_11.1.1.5.0_LINUX.X64_110325.2001

Please note:

Ensure LD_LIBRARY_PATH variable is set and libaprutil-1.so.0 is present in that location.

Else you will get error as below when running httpd -version command.


./httpd: error while loading shared libraries: libaprutil-1.so.0: cannot open shared object file: No such file or directory

2) Check in Enterprise Manager

- Login to Enterprise Manager console /em.
- Select ohs component (eg: ohs1, ohs2 ....)
- Right click on it and select General Information
- You will see the version of OHS
- However this version info may not be reliable as it may show you can incorrect version in EM specially after upgrades if all upgrade steps are not correctly followed.


Even if you have run below commands after OHS upgrade, sometimes incorrect version may show up in EM.

 ./opmnctl unregisterinstance

 ./opmnctl redeploy

 ./opmnctl registerinstance