Getting error "ORA-00918" when seeing Top Sessions from Oracle database 12.2.0.1 (4334010)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting error "ORA-00918" when seeing Top Sessions from Oracle database 12.2.0.1
Description

Getting error below when seeing Top Sessions from Oracle database 12.2.0.1:

ORA-00918: column ambiguously defined in table TopSessionsWithoutEvent Source: "RACTopSessionsWithoutEvent" table
Cause

This version of Spotlight on RAC is not certified with Oracle 12.2 as it came out before 12.2 did.

We'll certify the next Spotlight on RAC release (10.4) with 12.2.
Resolution
WORKAROUND
1. Go to \Spotlight on Oracle \Plug-ins\SoO
2. Backup file sql12.dat
3. Replace it by the one attached at this KB
STATUS
Waiting for fix in a future release of Spotlight on RAC
Defect ID

SOO-2605
Attachments

sql12

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title