1 Reply Latest reply: Nov 7, 2012 1:05 PM by maxijazz RSS

    ORA-12705 when trying to connect database from R client

    maxijazz
      Hi,
      This is fresh, default installation of R 2.13.2 on W2003 SP2 x86 with ORE 1.1.
      When trying to connect to database:
      ore.connect(user="r_test", sid="TEST", host="dbtest1", password="password", port=1521, all = TRUE)
      Error in .oci.Connect(...) :
      ORA-12705: Cannot access NLS data files or invalid environment specified

      There is "old" oracle 9.2 client installed on the same server, if it matters.

      Please help.
        • 1. Re: ORA-12705 when trying to connect database from R client
          maxijazz
          I used workaround for this. I just added correct NLS_LANG setting in definition of shortcut used for launching the R client:
          C:\R\bin\i386\Rgui.exe NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
          and it works fine now.

          I know something is messed up in Windows registry and R client cannot correctly read that NLS_LANG from.
          I don't want to deal with the registry to fix root cause as there is plenty other Oracle software installed and working proper on that host.
          Hopefully it will help others.

          Regards