ORA-00600: [Qersqrfc-1], [Invalid Handle], [], [], [], [] Using a Sequence Over Dblink (Doc ID 854552.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 10.2.0.4
This problem can occur on any platform.

Symptoms

An ORA-00600 is being generated when retrieving a sequence's nextval over a DBLINK.


The SQL Statement in the trace file(s) should contain reference to:

<sequence_name>.NEXTVAL

The sequence will be a sequence over a DBLINK possibly referenced by a synonym.

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