I wonder whether Personal Oracle can accept multiple connections. It's
meant for only one user and u might be able to connect to it from a
different machine....
Aj
Jack Burton wrote in message <369CCDCB.BDEFF67_at_ibm.net>...
>I'm getting an ORA-24365 (error in character conversion) trying to
>connect from a via SQL*Plus from a Sun running Solaris to a Win-NT
>machine running Oracle 8.0.3.
>
>More detail:
>
>I have the following systems
>
>1 - Dec Alpha running Digital Unix and Oracle 8.0.5
>
>2 - NT System running Personal Oracle 8.0.3
>
>3 - Sun Ultra 5 running Solaris 2.6
>
>4 - A couple of PCs
>
>---------------------------------------------------------------------------
>
>From the Dec Alpha
>Can connect via SQL*Plus to itself
>Can connect via SQL*Plus to Oracle 8.0.3 NT
>
>From any PC
>Can connect via SQL*Plus to Dec Alpha Oracle 8.0.5
>Can connect via SQL*Plus to Oracle 8.0.3 NT
>
>From NT
>Can connect via SQL*Plus to itself
>Can connect via SQL*Plus to Dec Alpha Oracle 8.0.5
>
>From * Sun *
>Can connect via SQL*Plus to Dec Alpha Oracle 8.0.5
>*** CAN NOT connect to Oracle 8.0.3 NT ***
>
>SQL*Plus: Release 3.3.3.0.0 - Production on Mon Jan 11 16:32:16 1999
>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>Enter user-name: jack_at_venus
>Enter password:
>ERROR: ORA-24365: error in character conversion
>
>Both the Sun and Alpha have identical tnsnames.ora files.
>From the Sun, tnsping to NT Oracle is OK.
>
>It's interesting that I can connect to the Alpha from the Sun, but not
>to the NT system.
>I checked the NT registry and saw NLS_LANG is set to
>AMERICAN_AMERICA.WE8ISO8859P1.
>Still don't know what it is set to on the Alpha and I'm not sure how to
>tell.
>
>I set the NLS_LANG environment on the Sun, but it didn't make a
>difference.
>setenv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1
>
>Does anyone have an answer to my problem?
>
>TIA,
>
>Jack
>
>
>
Received on Wed Jan 13 1999 - 18:03:28 CST
