To monitor the Exadata cells Spotlight needs the connection to the OS, so check if the “Monitor OS” part is configured in the connection properties.
- Open Spotlight Client
- Open Connection Manager
- Right-click on RAC connection icon and select Properties...
- On Details tab in the Server connection details check if Monitor OS checkbox is checked and connect information are entered.
The Exadata icon is enabled by the query:
SELECT e.IP,
e.HOSTNAME,
ins.DOMAIN,
e.PORTNO
FROM (SELECT CELLNAME IP,
EXTRACTVALUE (xmltype (confval),
'/cli-output/cell/name/text()')
HOSTNAME,
22 PORTNO
FROM v$cell_config) e,
(SELECT SUBSTR (host_name, INSTR (host_name, '.')) DOMAIN
FROM v$instance) ins
WHERE e.hostname IS NOT NULL;
Run this query and check if it returns any rows.
- Connect to Exadata connection.
- Make a screenshot of Spotlight Client and attach it to Service Request.
- Close the Exadata connection.
- Go to View | Option... | Troubleshooting | Tracing and check the checkbox "Turn client tracking on" and "Turn server tracing on".
- Restart Spotlight Client
- Open Exadata Connection
- Click on Help | Support Bundle...
- Attach Support Bundle and result of the query above to Service Request.