Top Sessions Fails When Database is on zOS (Doc ID 945302.1)

Last updated on APRIL 24, 2017

Applies to:

Enterprise Manager for RDBMS - Version: 10.2.0.4
IBM z/OS (OS/390)

Symptoms

-- Problem Statement:
The Grid Control Top Sessions link fails when the Oracle Database is on Z/Os platform.
The GC screen shows the error :
ERROR:
java.sql.SQLException: Fail to convert to internal representation

-- Steps To Reproduce:
From Grid control screen click on the Database name which runs on zOS. Then DATABASE INSTANCE--> PERFORMANCE --> TOP CONSUMERS --> TOP SESSIONS

If the database is version 9.2.0.8 the link to follow is DATABASE INSTANCE --> PERFORMANCE
--> TOP SESSIONS


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms