Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    China
    Posts
    5

    Question Unanswered: How to solve ORA-06553: PLS-561 error?

    When I run exp command and want to export a db, there are some errors

    infomations displayed is below:
    . exporting synonyms
    EXP-00008: ORACLE error 6553 encountered
    ORA-06553: PLS-561: character set mismatch on value for parameter
    'SHORTNAME'
    EXP-00000: Export terminated unsuccessfully
    Could you tell me why?
    Thank you very much.

  2. #2
    Join Date
    Sep 2002
    Location
    Israel
    Posts
    6
    You have to check if your environment settings are correct.
    set the NLS_LANG parameter to the database NLS parameters and issue export again.

    to detrmine the NLS_LANG parameter, use this query:
    select PARAMETER, VALUE from nls_database_parameters
    where PARAMETER in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET' ,'NLS_NCHAR_CHARACTERSET');

    to set the NLS_LANG parameter in you environment:
    unix - setenv <NLS_LANGUAGE>_<NLS_TERRITORY>.<NLS_CHARACTERSET >
    (simply replace the <> with values you got from query,

    windows - registry HKEY_LOCAL_MACHINE/SOFTWARE/Oracle/NLS_LANG

    cheers,
    R.

  3. #3
    Join Date
    Sep 2002
    Location
    China
    Posts
    5

    Question

    Originally posted by rotem_fo
    Thanks for you kindly helps. I can ensure the NLS_LANG setting is right when error occurs. I use oracle 8.1.7. NLS_LANG is AMERICAN_AMERICA.UTF8. windows - registry HKEY_LOCAL_MACHINE/SOFTWARE/Oracle/NLS_LANG is same as above. Can you deliver me from the trouble. Parameters setting below:

    SQL> select * from v$nls_parameters
    NLS_LANGUAGE AMERICAN
    NLS_TERRITORY AMERICA
    NLS_CURRENCY $
    NLS_ISO_CURRENCY AMERICA
    NLS_NUMERIC_CHARACTERS .,
    NLS_CALENDAR GREGORIAN
    NLS_DATE_FORMAT DD-MON-RR
    NLS_DATE_LANGUAGE AMERICAN
    NLS_CHARACTERSET UTF8
    NLS_SORT BINARY
    NLS_TIME_FORMAT HH.MI.SSXFF AM
    NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
    NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
    NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
    NLS_DUAL_CURRENCY $
    NLS_NCHAR_CHARACTERSET UTF8
    NLS_COMP BINARY


    Another question: What is nls_nchar_characterset meaning? and what is its relationship with nls_characterset?

    Example:
    NLS_CHARACTERSET WE8ISO8859P1
    NLS_SORT BINARY
    NLS_NCHAR_CHARACTERSET US7ASCII

    Thank you very much.

  4. #4
    Join Date
    Sep 2002
    Location
    China
    Posts
    5

    Exclamation

    Somebody help me!!

Posting Permissions

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