Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 8C033196037C for ; Tue, 8 Aug 2017 18:34:44 +0200 (CEST) Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Tue, 8 Aug 2017 18:34:44 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1648AA0E5; Tue, 8 Aug 2017 12:33:39 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1502210019; bh=6IuBXHa8BjphYrW/Gw3AULquYA+oSpzSdEtWrWQk100=; h=From:To:Subject:Date:In-Reply-To:References:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=QoeQ89KUkqRJQ+TycOpg9c/LCfIFj31+hD3KDzdpHKlHhHk92/mKQBFtzuuAtlf8n 2WJY1w6bh8c/9KUdWmolyHYzURpghrO1DYA8tYO7m3u4BTuRklmkF/S52N9hoRlSst qmabffAAeqHMKgKI1xRUqGPhROIkgeoN5TvuKLhk= X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id t7XhFpVtRLpW; Tue, 8 Aug 2017 12:33:39 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 52B829382; Tue, 8 Aug 2017 12:33:26 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1502210018; bh=6IuBXHa8BjphYrW/Gw3AULquYA+oSpzSdEtWrWQk100=; h=From:To:Subject:Date:In-Reply-To:References:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=wA1ou2HIxERCT18Ay9yzUfnhuC0RcNSwpLQwzpQwl/82TAexxmOIDUUR0P2pVOkas 40zp9n9eryIInOwAGp7ZXQpkOCJqPf54lscYE7g3I/BPRaTp6wfm6+dHXNKIn7CuIT 1ygsJpLrRH974Vk+RjY7hCnMqn+HbgOFh5CEKtew= Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2017 12:32:04 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7932BEE60 for ; Tue, 8 Aug 2017 12:32:04 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id pbg3Wt_dF2eF for ; Tue, 8 Aug 2017 12:32:04 -0400 (EDT) Received: from mout.web.de (mout.web.de [212.227.15.14]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 0ACDAEE5B for ; Tue, 8 Aug 2017 12:32:03 -0400 (EDT) Received: from [212.28.39.160] by 3capp-webde-bs45.server.lan (via HTTP); Tue, 8 Aug 2017 18:32:01 +0200 MIME-Version: 1.0 Message-ID: From: rogel@web.de To: oracle-l@freelists.org Subject: Aw: Comparison of long Strings - Bug? Content-Type: text/html; charset=UTF-8 Date: Tue, 8 Aug 2017 18:32:01 +0200 Sensitivity: Normal In-Reply-To: References: X-UI-Message-Type: mail X-Provags-ID: V03:K1:sxZxmGwPJjcQjOXjhz3+3qZXeZL7r4j72VjSYfJknNe ffJJgYqHZreDLrDqtKuUxFCXw+stMEos2v8SvlRicJoROUk1Kw dw2cmUa8gZbK6khTsM6G8g1I462pGfnLKys2j9ElDaggdVkiPP EOdq1qRx9x0KbUr3DcrR0Fn1JtNSrHxrBPasVZwT7+rIFJZwCi piCwRpfCZcwdfkp97oC2VLo+1u/NDV60mqdyMD2ZOJ0Jdku4Yo eXIRRIlYmgpzgsofGqSkCva5ypnntiDr9zUVZi1wnEnGxPlPfd SmMhcg= X-UI-Out-Filterresults: notjunk:1;V01:K0:f4hRkVxBsnY=:txjG3WZmSqzcQRmDJQjj+C gFziqcccpe66byKHpXz+uMmHzJn17d6Unc8DBqUy0hT6l2JSFqpEg5QOFBQaiHEv//NyBiMz/ QXjFFaBD0UPfUb8iafE/oUX+IRa/o5hGWX9Op6qAC5AQ8pvwjCqC8ZAYu9usaCH4JE0sgGDUC k4QAJJ6Q2UskHDcMgJFqjXmuvUMi+8XmyhEQ9W1mb8P4AvZQ08z2vJeQzRLLI/rkT11ilFiHR CBRft1IEfCPV1avGBQOn9fgra8lGiOZ7hmI4TxTyBWHndlc6PLNi6KCPP2yS5eQ7quiYgh43H zKn56NNYmcQfc9P9IA0pPD3iCjZcYwEdI5+jghdgJT7gRG0phH3a/1/+4rqJ4A9RPwzMQe//V XSMOuRZelS4uneignBc0mZqX6pZrJ+hdis+KzUgXNtwKQiaGrqxw/ZEusZItgZ56bkyLgU+GX Gcf2ujrArQ4VODiQz5O1l+kTbOC0YbhVXsnFH8vlllZGhZWSXUTK X-archive-position: 68918 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: rogel@web.de Precedence: normal Reply-To: rogel@web.de List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l
Hi Ingrid,
 
definitely a "Go-Open-a-SR-Bug".
I really enjoy it.
 
Regards,
Matthias
 
Gesendet: Dienstag, 08. August 2017 um 15:56 Uhr
Von: "Ingrid Voigt" <giantpanda@gmx.net>
An: oracle-l@freelists.org
Betreff: Comparison of long Strings - Bug?
Hi everybody,
 
the following produces reproducible crashes of Oracle instances on a customer's
and our systems (test and dev, no production involved so far):
 
OS:   Windows 2012 R2
Oracle:   11.2, 12.1 and 12.2   
 
NLS_CHARACTER_SET:   AL32UTF8
NLS_NCHAR_CHARACTERSET:   AL16UTF16
NLS_LANG:   GERMAN_GERMANY.WE8MSWIN1252   (our system)
   AMERICAN_AMERICA.AL32UTF8   (customer system)
NLS_COMP:   LINGUISTIC
NLS_SORT:   GERMAN   (AMERICAN)
 
 
select hu from (select 'ääää....äää' as hu from dual) where hu likec '%a%');
with 334 or more 'ä'
or
select hu from (select 'zzzz....zzz' as hu from dual) where hu likec '%s%');
with 1001 or more 'z'
 
 
This causes the instance to go down and the Windows service to crash.
Nothing in alertlog, no trace files, but the Windows event log has
Pfad der fehlerhaften Anwendung: c:\oracle\product\12.1.0\dbhome_1\bin\ORACLE.EXE
Pfad des fehlerhaften Moduls: c:\oracle\product\12.1.0\dbhome_1\bin\orasnls12.dll
(or orasnls11.dll for Oracle 11).
 
 
No crashes if the comparison character is contained in the string. No crashes for
like, like2, like4. No changes with max_string_size=extended.
No crashes for NLS_CHARACTERSET=WE8MSWIN1252.
 
 
Has anybody seen something like this before or is this a Go-Open-a-SR-Bug?
 
 
Thanks for your assistence
Ingrid
 
-- http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-l