Skip to Content
avatar image
Former Member

Database <SID>_XXXX is not in Landscape DB

Dear Experts,

We are encountering an error monitoring an Oracle database metric. We are using Solution Manager 7.1 with SP08. Below is the detail of the error. Is there anyone who encountered the same error message and may I ask how did you resolve the issue?

Problem Detail

The metric "Oracle Tablespace Status" is greyed out and is displaying

this message:"No Metric Delivered". An error message- "Database

<SID>_XXXX not in Landscape DB"- was displayed when the Metric

Troubleshooting option was clicked from the context menu. However, upon

checking LMDB and the SolMan System Landscape, the aforementioned

database is not configured.       

Steps for Reconstruction    

1. Logon to Solution Manager

2. Go to Solution Manager Workcenter (SOLMAN_WORKCENTER/SM_WORKCENTER).

3. Under the Technical Monitoring tab, choose System Monitoring.

4. Choose <SID> from the System List and choose System Monitoring>New

Window.

5. Under database object, choose Database Exception>Oracle Space

Management.

6. Select the metric "Oracle Tablespace Status".

7. Click the small arrow beside the metric to display context menu.

8. Choose Metric Troubleshooting.

9. This error message can be found in the list: "Error while checking

database connection; check connection parameters".

10. Click on the icon beside the said error.

I appreciate your help.

Respectfully yours,

Monique

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 07, 2013 at 10:10 AM

    Hi,

    have you completed the managed system configurartion from solman_setup, if not please do that,

    may i ask the status of Database extractor in step x in Managed sytem configuration of solman_setup.

    Please update.

    Thanks

    Jansi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jansi,

      Yes, we have already completed the Managed System Configuration.

      Also, database extractor status is green. Screenshot below.

      Thanks!

      DB.PNG (2.4 kB)
  • avatar image
    Former Member
    Apr 13, 2014 at 12:56 PM

    Hi Monique,

    Did you get the problem fixed?  I have solman7.1 SPS08, for ALL managed systems, i have the same problem as follows.

    All other Metrics of Oracle Tablespace are Green, except these two in Gray, implemented the note 1807168 to both Solman and managed system, but did not fix the problem.

    Could someone share with me how to fix the gray issue?

    oracle release: 11.2.0.3.0

    Thanks.


    oracle.png (3.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 14, 2014 at 06:00 AM

    Dear Experts,

    Is there anyone provide any idea on this case?

    Thanks for your help.

    Add comment
    10|10000 characters needed characters exceeded