Error message ORA-12705

Posted on 2004-11-10
Last Modified: 2012-06-27
Dear All,

My company run a HACMP in IBM AIX 5L. When I tried the HACMP function (it means second server tooks over the database from primary server), the database shows the followsing error message:

12705 ORA-12705 invalid or unknown NLS parameter value specified.

Would you please tell me how can I do for this.

Thank you very much!

Best Regards,
Jaff Chen
Question by:jaffchen
    LVL 22

    Accepted Solution

    This is a description of error (, I hope it will help you:

    ORA-12705 invalid or unknown NLS parameter value specified

        Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.

        Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.
    LVL 4

    Expert Comment

    Check seting for NLS_LANG env. variable for oracle account on both servers. If NLS_LANG is the same, then try running locale command on both servers and looking in /usr/lib/nls/README for more information.
    LVL 4

    Expert Comment

    When you start instance on the other node it uses env for oracle user on that node.
    LVL 4

    Expert Comment

    also check values for ORA_NLSxx env.var. (UNIX)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now