Oracle connection problem
Peter Bateman
pfbcs at hotmail.com
Fri Jul 7 11:06:15 CDT 2006
Hi All:
I was wondering what was the resolution to this problem.
Regards,
Peter
>
>Hi All:
>
>
>The character set WE8ISO8859P1 is very similiar to
> Dec supplemental. There is a gap in the character set
>I believe from character with decimal code 128 to 160.
>This gap is where control characters live.
>
>Whereas WE8MSWIN125x uses the whole spectrum. I did a search for
>WE8MSWIN125 on the Oracle web and did not get a hit.
>
>It could be that a valid character in WE8MSWIN125x is being eaten
>by the network.
>
>If you need the euro character ISO8859P15 has it.
>
>Regards,
>Peter
>
>
>
>
>
>
>>This environment has worked without issue until we migrated the
>>characterset from WE8ISO8859P1 to WE8MSWIN125. After we migrated the
>>database to the new characterset, we receive the following error
>>message:
>>
>>
>
>
>>From: "Selch, Scott" <Scott.Selch at denverwater.org>
>>To: <powerh-l at lists.sowder.com>
>>CC: "Wasmuth, Jennifer" <Jennifer.Wasmuth at denverwater.org>
>>Subject: Oracle connection problem
>>Date: Fri, 2 Jun 2006 14:02:49 -0600
>>MIME-Version: 1.0
>>Received: from sowder.com ([207.210.77.31]) by
>>bay0-mc11-f7.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Fri,
>>2 Jun 2006 13:13:33 -0700
>>Received: from sowder.com (localhost [127.0.0.1])by sowder.com
>>(8.13.4/8.13.4/Debian-3sarge1) with ESMTP id k52K47iL013679for
>><pfbcs at hotmail.com>; Fri, 2 Jun 2006 15:14:08 -0500
>>Received: from postmaster2.denverwater.org
>>(machine3.denverwater.org[159.143.1.13])by sowder.com
>>(8.13.4/8.13.4/Debian-3sarge1) with ESMTP idk52K3r7E011724for
>><powerh-l at lists.sowder.com>; Fri, 2 Jun 2006 15:04:04 -0500
>>X-Message-Info: LsUYwwHHNt13j9/zVSrpbba7hwyw9uosGvV2mRnA7BA=
>>X-MimeOLE: Produced By Microsoft Exchange V6.5
>>Content-class: urn:content-classes:message
>>X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Oracle connection
>>problem
>>thread-index: AcaGf4Yi0OX7/GcBS/GcEO17jX8isg==
>>X-DRS-drsmilter-Version: drsmilter CVS $Id: drsmilter.py,v 1.82 2006/04/04
>>13:38:59 drsmilter Exp $
>>X-DRS-drsmilter-Version: drsmilter CVS $Id: drsmilter.py,v 1.82 2006/04/04
>>13:38:59 drsmilter Exp $
>>X-BeenThere: powerh-l at lists.sowder.com
>>X-Mailman-Version: 2.1.5
>>Precedence: list
>>List-Id: Cognos PowerHouse 4GL <powerh-l.lists.sowder.com>
>>List-Unsubscribe:
>><http://lists.sowder.com/mailman/listinfo/powerh-l>,<mailto:powerh-l-request at lists.sowder.com?subject=unsubscribe>
>>List-Archive: <http://lists.sowder.com/pipermail/powerh-l>
>>List-Post: <mailto:powerh-l at lists.sowder.com>
>>List-Help: <mailto:powerh-l-request at lists.sowder.com?subject=help>
>>List-Subscribe:
>><http://lists.sowder.com/mailman/listinfo/powerh-l>,<mailto:powerh-l-request at lists.sowder.com?subject=subscribe>
>>Errors-To: powerh-l-bounces+pfbcs=hotmail.com at lists.sowder.com
>>Return-Path: powerh-l-bounces+pfbcs=hotmail.com at lists.sowder.com
>>X-OriginalArrivalTime: 02 Jun 2006 20:13:33.0521 (UTC)
>>FILETIME=[05F0D410:01C68681]
>>
>>We are having a unique problem trying to establish a connection in the
>>following environment:
>>
>>
>>
>>OpenVMS
>>
>>Powerhouse 8.20.D
>>
>>Client: Oracle Rdb V7.0-72 (VMS)
>>
>>DB version: Oracle RDBMS 9.2.0.6 (located on an HP-UX 11.23)
>>
>>
>>
>>This environment has worked without issue until we migrated the
>>characterset from WE8ISO8859P1 to WE8MSWIN125. After we migrated the
>>database to the new characterset, we receive the following error
>>message:
>>
>>
>>
>>*W* SQL START DBE error (JDE)
>>
>>DMS-E-GENERAL, A general exception has occurred during operation 'attach
>>
>>
>>database'.
>>
>>ORA-03113: end-of-file on communication channel
>>
>>
>>
>>Upon reviewing an Oracle listener and sqlnet logs, powerhouse is making
>>a valid connection, but we still receive the error. It appears to be an
>>oracle type configuration problem, but are having problems determining
>>the origin.
>>
>>
>>
>>Has anyone experienced a similar situation - or maybe offer some
>>research tips or VMS logs to review?
>>
>>
>>
>>Thanks for your help!
>>
>>
>>
>
>
>>--
>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>>Mailing list: powerh-l at lists.sowder.com
>>Subscribe: "subscribe" in message body to
>>powerh-l-request at lists.sowder.com
>>Unsubscribe: "unsubscribe <password>" in message body to
>>powerh-l-request at lists.sowder.com
>>http://lists.sowder.com/mailman/listinfo/powerh-l
>>This list is closed, thus to post to the list you must be a subscriber.
>>Add 'site:lists.sowder.com powerh-l' to your search terms to search the
>>list archive at Google.
>
>_________________________________________________________________
>Take charge with a pop-up guard built on patented Microsoft® SmartScreen
>Technology.
>http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
> Start enjoying all the benefits of MSN® Premium right now and get the
>first two months FREE*.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the
>list archive at Google.
_________________________________________________________________
Movies, Music & More! Visit Sympatico / MSN Entertainment
http://entertainment.sympatico.msn.ca/
More information about the powerh-l
mailing list