Support Migration Notice: To update migrated JIRA cases click here to open a new case use www.vmware.com/go/sr | vFabric Hyperic 5.7.0 is Now Available

Hyperic HQ

Oracle 11g plugin does not auto-discover newly created tablespaces or user instances

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Deferred
  • Affects Version/s: 4.3
  • Fix Version/s: None
  • Component/s: Plugins
  • Environment:
    HQ-server 4.3.0-EE-1433 running on CentOS 5.4
    HQ-agent 4.3.0-EE-1433 running on RHEL 5.4
     - Oracle DB 11gR2 running with HQ-agent
  • Case Links:
    none
  • Regression:
    No

Description

Oracle 11g plugin does not auto-discover newly created tablespaces or user instances.

Expected Result:
When a new tablespace or user instance is created on the database, it is auto-discovered.

Actual Result:
Newly created tablespaces and user instances are not auto-discovered.

Steps to reproduce:
1. On Oracle 11g DB Server, install hq-agent
2. Ensure hq-agent is running and Oracle is auto-discovered by HQ
3. Log into the HQ Server Dashboard
4. Browse and select the Oracle 11g DB platform
5. Select the Oracle 11g server from under the Deployed Servers Health section
6. Select the Oracle 11g Tablespace from under Services
7. Note the existing tablespaces listed
8. Go to Oracle 11g Server UI
9. Create a new tablespace
10. Wait 30 minutes to one hour for auto-discovery
11. Log back into the HQ Server Dashboard
12. Browse and select the Oracle 11g DB platform
13. Select the Oracle 11g server from under the Deployed Servers Health section
14. Select the Oracle 11g Tablespace from under Services
15. Note the newly created tablespaces is NOT listed
16. Repeat the same for User Instance

Work around:
Restarting the agent shows discovers the newly created tablespace and user instance.

Additional Notes:
1. Running 'New Auto-Discovery' on the Oracle 11g DB platform does not discover the new tablespace and user instance
2. The hq-agent is started as root but oracle .profile sourced; all ORACLE environment variables set for root user before starting hq-agent.
3. Restarting the hq-agent as same root user discovers new tablespace and user instance
4. Running command line discover as root shows the newly created tablespace

Issue Links

Activity

Hide
Todd Rader added a comment -

Not yet triaged into 4.3, but it might be soon.

Show
Todd Rader added a comment - Not yet triaged into 4.3, but it might be soon.
Hide
Yoav Epelman added a comment -

Bulk change to new components

Show
Yoav Epelman added a comment - Bulk change to new components
Hide
Idan Hod added a comment -

As part of our continuous effort to improve product quality, The Hyperic product team has decided to implement a "zero bug policy" methodology.

Following this methodology, only defects that are planned to be handled in the near future will remain open. Any other defect will be deferred, with the option to be reevaluated if the need arises, or if changes to the Hyperic road-map make such defect a candidate for a fix.

We believe this new process will help create clarity and focus in the Hyperic road-map and ultimately benefit our customer base.

This bug has been deferred as part of the new policy.

We appreciate your cooperation and continues contribution to the improvement of Hyperic.

Show
Idan Hod added a comment - As part of our continuous effort to improve product quality, The Hyperic product team has decided to implement a "zero bug policy" methodology. Following this methodology, only defects that are planned to be handled in the near future will remain open. Any other defect will be deferred, with the option to be reevaluated if the need arises, or if changes to the Hyperic road-map make such defect a candidate for a fix. We believe this new process will help create clarity and focus in the Hyperic road-map and ultimately benefit our customer base. This bug has been deferred as part of the new policy. We appreciate your cooperation and continues contribution to the improvement of Hyperic.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
    Last comment:
    42 weeks ago