ORA-12705 NLS_LANG error

[PaulSchofield]

I am getting an error when trying to open a PL/SQL Developer session:
ORA-12705: invalid or unknown NLS parameter value specified

I can connect using C:\oracle\ora81\bin\SQLPLUSW.EXE

Thanks
Paul

Info below......

PL/SQL Developer
Version 5.1.0.662 (MBCS)
86.14206 - 5 user license
Windows 2000 version 5.0 (build 2195) Service Pack 4

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
ARSC
BS8DW2_VIDEV
DB01
DB02
DB03
DB04
DVSC
ETB_DEV
ETB_DEV2
FIN
FIND
HR11
HRLV
HRPD
HRTT
ODW1F1_VIDEV01
OPO1F1_VIDEV01
OPO1P1_172.21.64.95
OPO1P1_VIPROD01
OTB1P1_VIPROD01
OTB1U1_VIDEV01
PROD1
PROD2
RMANCAT_VIDEV01
TTSC
VCCP01
VCCP03
VCPORTU1
VICP1_DB_VIPROD01
VICU1_DB_VIDEV01
VICU2_DB_VIDEV01
VICU3_DB_VIDEV01
VIDT_PRD_VIDEV01
VIMC_DEV_VIDEV01
VIWP1_DB_VIPROD01
VIWS1_DB_VIDEV01

Homes
OraHome81 (C:\oracle\ora81)
OraHomeDisc (C:\OracleDiscoverer)

DLLs
C:\OracleDiscoverer\bin\oci.dll
C:\OracleDiscoverer\bin\ORA803.DLL
C:\OracleDiscoverer\bin\ORA804.DLL
C:\OracleDiscoverer\bin\ORA805.DLL

TNS File
C:\OracleDiscoverer\Net80\Admin\tnsnames.ora

Using
Home: OraHomeDisc
DLL: C:\OracleDiscoverer\bin\oci.dll
OCI: Version 8.0

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = c:\Oracle\ora81
ORACLE_HOME_NAME = OraHomeDisc
API = C:\OracleDiscoverer\DBS
ORACLE_GROUP_NAME = Oracle for Windows NT
OLEDB = C:\oracle\ora81\oledb\mesg
VOBHOME2.0 = C:\oracle\ora81
OO4O = C:\oracle\ora81\oo4o\mesg
SHARED_ORACLE_HOME = C:\OracleDiscoverer
COMPANY_NAME = CPQ
MM60 = C:\OracleDiscoverer\TOOLS\COMMON60
TK60 = C:\OracleDiscoverer\TOOLS\COMMON60
UI60 = C:\OracleDiscoverer\TOOLS\COMMON60
RDBMS80 = C:\OracleDiscoverer\RDBMS80
PLSQL80 = C:\OracleDiscoverer\PLSQL80
CORE40 = C:\OracleDiscoverer\CORE40
NLSRTL33 = C:\OracleDiscoverer\NLSRTL33
ORA_NLS33 = C:\OracleDiscoverer\NLSRTL33\DATA
PRO80 = C:\OracleDiscoverer\PRO80
OTRACE80 = C:\OracleDiscoverer\OTRACE80
NET80 = C:\OracleDiscoverer\NET80
DISCVR4_ADMIN_MANUAL_PATH = C:\OracleDiscoverer\DOC\DISCVR4\ADMIN
DISCVR4 = C:\OracleDiscoverer\DISCVR4

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 2
DEFAULT_HOME = OraHome81
LAST_HOME = 1

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome81
PATH = C:\oracle\ora81
NLS_LANG = NA

SOFTWARE\ORACLE\ALL_HOMES\ID1
NAME = OraHomeDisc
PATH = C:\OracleDiscoverer
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

SOFTWARE\ORACLE\AUTOTUNE2.2.0
help_path = ${vobhome2.0}bin/
debug_flags =
startlog = ${home}autotune/%1.log
trace_report = 0
trace_data = 0
collect_int_in_min = 15
analyze_int_in_hrs = 24
max_errors_allowed = 5
wip_batch = 0
wip_window = 0
wip_logfile = 0
wip_logtable = 0

SOFTWARE\ORACLE\EXPERT2.2.0
home = ${vobhome2.0}sysman/expert
help_path = ${vobhome2.0}bin/
xpcoin = ${vobhome2.0}bin/xpcoin
default_rule_file = xpo000
debug_flags =
sample = ${home}sample/
sample_xdl = ${sample}xppso.xdl
startlog = ${vobhome2.0}sysman/temp/xpexpert.log
trace_report = 0
trace_data = 0
max_orphan_txn_reqs = 100
max_cache_txn_reqs = 50
extract_explain_plan = 0
create_tmp_plan_table = 0
tmp_plan_table = xp_tmp_plan
wip_batch = 0
wip_window = 1
wip_logfile = 0
wip_logtable = 0
quicktour_start = ${vobhome2.0}sysman/qtour/tune/us/tune.htm
report_viewer = write
startup_wizard = 1
collect_trace_stats = 1
standalone_mode = 0

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome81
ORACLE_HOME_NAME = OraHome81
ORACLE_HOME = C:\oracle\ora81
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_HOME_KEY = Software\ORACLE\HOME0
SQLPATH = C:\oracle\ora81\dbs

SOFTWARE\ORACLE\HOME1
ID = 1
ORACLE_HOME = C:\OracleDiscoverer
ORACLE_HOME_NAME = OraHomeDisc
SHARED_ORACLE_HOME = C:\OracleDiscoverer
API = C:\OracleDiscoverer\DBS
COMPANY_NAME = CPQ
ORACLE_GROUP_NAME = Oracle for Windows NT - OraHomeDisc
D2K60_DRIVERS = DataDirect ODBC Drivers
D2K60_GROUP = DataDirect ODBC Group
ORACLE_HOME_SERVICE = OraHomeDisc
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

SOFTWARE\ORACLE\JInitiator
Java Runtime = Default
JIT Enabled = 1
JIT path = symcjit
Java Runtime Parameters = -mx64m -Dcache.size=50000000
Show Console = 0

SOFTWARE\ORACLE\JInitiator\1.1

SOFTWARE\ORACLE\JInitiator\1.1.8

SOFTWARE\ORACLE\JInitiator\1.1.8.16
Home = C:\PROGRA~1\Oracle\JINITI~1.16

SOFTWARE\ORACLE\JInitiator\Default
Home = C:\PROGRA~1\Oracle\JINITI~1.16

SOFTWARE\ORACLE\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRSet = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0

SOFTWARE\ORACLE\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\ora81\MSHELP\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\ora81\oo4o

SOFTWARE\ORACLE\ORACLE_HOMES

SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE1
ORACLE_HOME = C:\OracleDiscoverer
ORACLE_HOME_NAME = OraHomeDisc
SHARED_ORACLE_HOME = C:\OracleDiscoverer
API = C:\OracleDiscoverer\DBS
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
COMPANY_NAME = CPQ
ORACLE_GROUP_NAME = Oracle for Windows NT - OraHomeDisc
ORACLE_HOME_SERVICE = OraHomeDisc

SOFTWARE\ORACLE\Workflow
Icon Directory = C:\oracle\ora81\WF\ICON
Level = 100
Version = 2.5.2.16.14

SOFTWARE\ORACLE\Workflow\Languages

--- Path ---

C:\OracleDiscoverer\bin
C:\Program Files\CA\Dcs\DMScripting\
C:\PROGRA~1\Merant\vm\win32\bin
C:\PROGRA~1\Merant\vm\common\bin\win32
C:\oracle\ora81\bin
C:\Program Files\Oracle\jre\1.1.7\bin
C:\Program Files\CA\DCS\CAWIN\
C:\WINNT\system32
C:\WINNT
C:\WINNT\System32\Wbem
C:\WINNT\system32\nls
C:\WINNT\system32\nls\ENGLISH
C:\Program Files\CA\SharedComponents\CAM\bin
C:\EMS\CA_APPSW
C:\Program Files\Microsoft SQL Server\80\Tools\BINN
C:\EMS\TNG\BIN
C:\Program Files\Hummingbird\Connectivity\8.00\Accessories\
C:\PROGRA~1\CA\Common\SCANEN~1
C:\ems\ETrust
C:\EMS\CA_APPSW\Framework\bin
C:\EMS\TNG\GCU
C:\EMS\TNG\services\biS\TNG\services\bin
C:\EMS\TNG\agents\bin
C:\EMS\TNG\services\tools
C:\EMS\TNG\help
C:\Program Files\CA\SharedComponents\DTS\bin
C:\EMS\CA_APPSW\
c:\ems\tngsd\BIN
C:\EMS\TNGAM\Console

 

[Marco Kalter]

What happens if you try to connect with C:\OracleDiscoverer\bin\sqlplus.exe?

You should probably use the Oracle Home Selector (a standard Oracle utility) to set the Primary Oracle Home to OraHome81. That should fix it.

 

[PaulSchofield]

Discoverer doesn't come with sqlplus.

Also there is no Oracle Home Selector installed and this is a customer pc without admin rights so can't install it. I also don't have the rights to change PATH in system.

Rather limits things somewhat.. Any other suggestions?

 

[PaulSchofield]

Found a solution to this;

Open PL/SQL Developer, click cancel on the Oracle logon screen (so's not to connect to a database).

Hit Tools > Preferences and in the first tab 'Options' select the Oracle home you want to connect to in the 'Oracle Home' dropdown (bottom left on the screen).

Should fix the connection problem.

Regards
Paul