My Oracle Support Banner

Getting ORA-1403 , ORA-26753 or Interrogation Symbol "?" in Streams after Changing the Characterset (Doc ID 1403615.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.1.0.8 [Release 9.2 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

So it is not a db link issue it is only streams issue as streams not aware of the changing in CharacterSet.In a bi-directional Streams setup replication working fine.
But after changing the CharacterSet each database stores and shows the correct characters we can save any text and read it again without problems, but the whole text content, replicated by streams, goes corrupt.

print_lcr shows the line as "?"  and / or ORA-26753: Mismatched columns found. STREAMS error queue for apply process "APP_NAME" contains new transaction with ORA-1403


When updating site A with the select done from site B using database link, and the data is fine (remains fine for both sides).

 If creating new tables with Latin characters and streaming them , it works as expected.


Changes

The CharacterSet changed according to Oracle guideline (procedure, described in Oracle Globalization Guide, with CS-Scanner and CSALTER).
The streams were stopped before change and started again after change made. Also, verified that queues were empty before changing the CharacterSet.
This occurred and verified for the following changes :
Changing from WE8ISO8859P15 to EE8MSWIN1250
Changing from US7ASCII to WE8MSWIN1252
Changing from WE8MSWIN1252 to UTF8

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.