This discussion is archived
1 Reply Latest reply: Nov 7, 2012 11:05 AM by maxijazz RSS

ORA-12705 when trying to connect database from R client

maxijazz Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

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