This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Dec 10, 2012 8:10 PM by Maahjoor RSS

NLS_LANG setting for scott schema

Maahjoor Newbie
Currently Being Moderated
Dear all ,

i have two questions. please guide me thoroughly.

1. i want to change the scott schema NLS_LANG to LatinArabic AR8ISO8859P6 ISO
2. i want to set my sga size to 1gb.

i have oracle database 10g release 2 installed on windows 7 32 bit.

I need your kind help.

Regards.
  • 1. Re: NLS_LANG setting for scott schema
    Maahjoor Newbie
    Currently Being Moderated
    i just try to update the registry key under oracle home NLS_LANG to LatinArabic AR8ISO8859P6 , but the database give the following error
    ora-12705: cannot access nls data files or invalid environment specified.

    any help?
  • 2. Re: NLS_LANG setting for scott schema
    Maahjoor Newbie
    Currently Being Moderated
    i realy need your kind help.
  • 3. Re: NLS_LANG setting for scott schema
    Paul M. Oracle ACE
    Currently Being Moderated
    i just try to update the registry key under oracle home NLS_LANG to LatinArabic AR8ISO8859P6 , but the database give the following error
    ora-12705: cannot access nls data files or invalid environment specified.
    Check out V$NLS_VALID_VALUES for possible values.
  • 4. Re: NLS_LANG setting for scott schema
    EdStevens Guru
    Currently Being Moderated
    Maahjoor wrote:
    i realy need your kind help.
    Patience, Grasshopper

    You posted this follow-up a mere 18 minutes after your previous post.

    This forum is not a chat line, and it is not paid support.

    No one is responsible for monitoring it and giving a quick response.

    Furthermore, it is a global forum. The person with the information you seek may very well live 20 time zones away from you and was going to bed just as you posted. He will not even see your post for several more hours.

    Your original post went up in the middle of the night for half the world.

    No one with the information you seek is deliberately withholding it until you sound sufficiently desperate.
  • 5. Re: NLS_LANG setting for scott schema
    EdStevens Guru
    Currently Being Moderated
    Maahjoor wrote:
    Dear all ,

    i have two questions. please guide me thoroughly.

    1. i want to change the scott schema NLS_LANG to LatinArabic AR8ISO8859P6 ISO
    2. i want to set my sga size to 1gb.

    i have oracle database 10g release 2 installed on windows 7 32 bit.
    "10g" is a marketing lable. What version of 10g - eg: 10.2.0.1.0 ?? we need all decimals
    and what edition of Windows 7. No oracle databases are certified on any "home" edition of windows.
    I need your kind help.

    Regards.
  • 6. Re: NLS_LANG setting for scott schema
    EdStevens Guru
    Currently Being Moderated
    Maahjoor wrote:
    i just try to update the registry key under oracle home NLS_LANG to LatinArabic AR8ISO8859P6 , but the database give the following error
    ora-12705: cannot access nls data files or invalid environment specified.

    any help?
    And what did you find when you googled "ora-12705"?
  • 7. Re: NLS_LANG setting for scott schema
    Maahjoor Newbie
    Currently Being Moderated
    i am sorry. i did'nt respond on timely manner.please accept my appology .

    at the time i am bussy with another team of DBA's and Developers. i will continue some next time.

    i am very very thankfull to you guys. you are very kind and help full.
  • 8. Re: NLS_LANG setting for scott schema
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Use
    Alter session
  • 9. Re: NLS_LANG setting for scott schema
    Maahjoor Newbie
    Currently Being Moderated
    thank you., but it is session level, ii need permanent changes to the schema.
  • 10. Re: NLS_LANG setting for scott schema
    orafad Oracle ACE
    Currently Being Moderated
    Your question does not make much sense.

    NLS_LANG is a client side setting. Its char set part is, or should be, used to indicate encoding of input and output required by OS/file/terminal etc. It does not change anything at database or schema level.

    Database Character set applies to whole database, the same for every schema.
    Changing character set could mean creating a new database with correct character set.

    Please explain the reason behind posting the question in the first place.

    Edited by: orafad on Dec 9, 2012 10:00 AM
  • 11. Re: NLS_LANG setting for scott schema
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Maahjoor wrote:
    thank you., but it is session level, ii need permanent changes to the schema.
    You need to change NLS_LANG just for one schema !!! Could you please explain why you want to do this
  • 12. Re: NLS_LANG setting for scott schema
    EdStevens Guru
    Currently Being Moderated
    Maahjoor wrote:
    thank you., but it is session level, ii need permanent changes to the schema.
    Sorry, but ALL NLS settings are really session settings. If they are set at the DB or OS, it is just to establish a default that can be inherited by the session. But in the end, it is the session that actually uses them.

    And it absolutely is NOT bound to a schema.
  • 13. Re: NLS_LANG setting for scott schema
    Maahjoor Newbie
    Currently Being Moderated
    okay,

    i am sorry, i was not clear ,

    i want to store arabic data in the database. for that i create a user. and that user would be doing arabic entries. and the user interface should be arabic.

    Regards.
  • 14. Re: NLS_LANG setting for scott schema
    sb92075 Guru
    Currently Being Moderated
    [oracle@localhost ~]$ oerr ora 12705
    12705, 00000, "Cannot access NLS data files or invalid environment specified"
    // *Cause: Either an attempt was made to issue an ALTER SESSION command
    //         with an invalid NLS parameter or value; or the environment
    //         variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was incorrectly
    //         specified, therefore the NLS data files cannot be located.
    // *Action: Check the syntax of the ALTER SESSION command and the NLS
    //          parameter, correct the syntax and retry the statement, or
    //          specify the correct directory path/values in the environment
    //          variables.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points