ORA-24365 on 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-24365 on 9i

  1. #1
    Join Date
    Feb 2003
    Posts
    9

    ORA-24365 on 9i

    Actually, this is the question:

    $ sqlplus system/sysdev@dev

    SQL*Plus: Release 8.1.7.0.0 - Production on Mon Feb 10 22:10:56 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to:
    Oracle8i Release 8.1.7.4.0 - Production
    JServer Release 8.1.7.4.0 - Production

    SQL> select name from v$database;

    NAME
    ---------
    DEV

    SQL> create public database link ENKL.WORLD connect to SYSTEM identified by password using 'ENKLAV';

    Database link created.

    SQL> select name from v$database@enkl;
    select name from v$database@enkl
    *
    ERROR at line 1:
    ORA-02068: following severe error from ENKL
    ORA-24365: error in character conversion


    SQL>

    @enkl is a db link to 9.2.0.2 database.

    The best part is: when I tryed to do the same from 9i it silently killed listener on 8i database. Does anybody have a clue what is this all about? Brief search on Metalink gave no results...
    -----

    NLS_LANG=AMERICAN_AMERICA.UTF8 on all instances.

    8i was created as UTF8/UTF8, 9.2 was created as AL32UTF8/UTF8

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: ORA-24365 on 9i

    Hi,

    The problem is the AL32UTF8 CS of the 9i DB.

    The main workaround is to create the Oracle9i database with the CS of UTF8 which is recognized by Oracle 8i clients.

    About the LISTENER: is it meant for both 8i and 9i databases?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Feb 2003
    Posts
    9
    About listener - listener was OK on both systems.

    Then I executed query like :

    insert into remote_8i_schema.table@link
    insert * from local_9i_schema.table;

    as a result i got a message regarding not null constraint violation (as i discovered later it was due to wrong character set conversion - all varchar2 data were transformed into nulls) and as an additional effect listener on 8i dissapeared.
    No core file or trace or even record into any of log files were generated - listener just dissapeared like it was killed if kill -9.

    I tried to check docs yesterday regarding this AL32UTF8 - oracle recommends it as a default one - what is the actual differene between it an old 8i style UTF8 character set? What are the benefits of this new AL32UTF8 and why the hell it`s not compatible with old UTF8?
    I got a feeling that documentation says that this new crap was created to be compatible with everything one may have.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Oracle 8i is simply not aware of that new AL32UTF8. Someone told me that Oracle might give you a one time patch for that, you better open an iTar with Metalink.

    UTF8 is not 100% unicode compatible. It stores wrongly the surrogate pairs for example.

    UT8 will not be supported in 10i. That is Oracle suggests that all new databases be AL32UTF8.

    I did make one new DB AL32UTF8 :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width