2 Replies Latest reply: May 3, 2013 7:30 AM by EmaxG RSS

    Override NLS_LANG in replicated environment

    EmaxG
      Hello,

      I am working on Version 11.1.1.1.2_03 , 11.2.0.3.6 DB .

      My DB is set to use the following:

      NLS_LANG = "AMERICAN_AMERICA.WE8ISO8859P15"
      NLS_LANGUAGE = "AMERICAN"
      NLS_TERRITORY = "AMERICA"
      NLS_CHARACTERSET = "WE8ISO8859P15"


      However, clients connecting to the database have been setting this for themselves for so long that its impossible to fix some characters in this huge database now :

      SPANISH_SPAIN.WE8ISO8859P15

      My question is, is there any way I can override GG from taking the DB settings without setting an env variable as $NLS_LANG like below:

      GGSCI (dbrep) 20> sh echo $NLS_LANG

      SPANISH_SPAIN.WE8ISO8859P15

      I took a look at the reference guide but couldn't come up with any parameter.

      Greetings,
      N K