ORA-12705 NLS_LANG error

N

nperron

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

Oracle support points to the NLS_LANG registry items, which I've tried updating, with no success.
 
Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?
 
--- Info ---

PL/SQL Developer

Version 6.0.5.931 (MBCS)

01.28361 - 1 user license

Windows 2000 version 5.0 (build 2195) Service Pack 4

Physical memory : 261,532 kB (10,084 available)

Paging file : 632,560 kB (384,336 available)

Virtual memory : 2,097,024 kB (2,008,444 available)

Parameters

C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences

Session mode: Multi

OCI Library:

Use OCI7: False

Plug-Ins

Aliases

FNDFS_MDSXAWO9F

TRUE_DEV

TRUE_TST

TRUE_VIS

Homes

OUIHome (C:\OraHome1)

DLLs

C:\OraHome1\bin\oci.dll

C:\OraHome1\bin\ORA73.DLL

C:\OraHome1\bin\ORA803.DLL

C:\OraHome1\bin\ORA804.DLL

C:\OraHome1\bin\ORA805.DLL

TNS File

C:\OraHome1\Network\Admin\tnsnames.ora

Using

Home: OUIHome

DLL: C:\OraHome1\bin\oci.dll

OCI: version 9.2

--- Registry ---

SOFTWARE\ORACLE

inst_loc = C:\Program Files\Oracle\Inventory

ORACLE_HOME = C:\OraHome1

ORACLE_HOME_NAME = OUIHome

API = C:\OraHome1\DBS

ORACLE_GROUP_NAME = Oracle for Windows NT

NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

SHARED_ORACLE_HOME = C:\OraHome1

COMPANY_NAME = Neil R. Perron & Associates, Inc.

OI_NLS32 = C:\OraHome1\orainst\NLB

RDBMS80 = C:\OraHome1\RDBMS80

PLSQL80 = C:\OraHome1\PLSQL80

CORE40 = C:\OraHome1\CORE40

NLSRTL33 = C:\OraHome1\NLSRTL33

ORA_NLS33 = C:\OraHome1\NLSRTL33\DATA

PRO80 = C:\OraHome1\PRO80

OTRACE80 = C:\OraHome1\OTRACE80

NET80 = C:\OraHome1\NET80

OO4O = C:\OraHome1\OO4O\mesg

RDBMS73 = C:\OraHome1\RDBMS73

OTRACE73 = C:\OraHome1\OTRACE73

PLSQL23 = C:\OraHome1\PLSQL23

PRO18 = C:\OraHome1\PRO18

NLSRTL32 = C:\OraHome1\NLSRTL32

ORA_NLS32 = C:\OraHome1\NLSRTL32\DATA

SOFTWARE\ORACLE\ADI

SOFTWARE\ORACLE\ADI\HELP

HELPBASEURL =

SOFTWARE\ORACLE\ADI\Languages

SOFTWARE\ORACLE\ALL_HOMES

HOME_COUNTER = 1

DEFAULT_HOME = OUIHome

LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0

NAME = OUIHome

PATH = C:\OraHome1

NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

SOFTWARE\ORACLE\GLDI

New Install = False

SOFTWARE\ORACLE\GLDI\GLDI90

Application Path = C:\OraHome1\GLDI90

Application EXE = GLDI9032.EXE

Applications Executable = AIAP45.EXE

CORE Version = 3

FND = FND75

NET = NET23

Setup Shared Install = false

Shared Install = false

SOFTWARE\ORACLE\HOME0

ID = 0

ORACLE_GROUP_NAME = Oracle for Windows NT

ORACLE_HOME_NAME = OUIHome

ORACLE_HOME = C:\OraHome1

NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

ORACLE_BUNDLE_NAME = Enterprise

ORACLE_HOME_KEY = Software\ORACLE\HOME0

SHARED_ORACLE_HOME = C:\OraHome1

API = C:\OraHome1\DBS

COMPANY_NAME = Neil R. Perron & Associates, Inc.

OI_NLS32 = C:\OraHome1\orainst\NLB

SOFTWARE\ORACLE\JInitiator

SOFTWARE\ORACLE\JInitiator\1.3.1.18

JavaHome = C:\Program Files\Oracle\JInitiator 1.3.1.18

SOFTWARE\ORACLE\OO4O

CacheBlocks = 20

FetchLimit = 100

FetchSize = 4096

HelpFile = C:\OraHome1\MSHELP\oracleo.hlp

PerBlock = 16

SliceSize = 256

TempFileDirectory = c:\temp

OO4O_HOME = C:\OraHome1\oo4o

SOFTWARE\ORACLE\ORACLE_HOMES

SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE0

ORACLE_HOME = C:\OraHome1

ORACLE_HOME_NAME = OUIHome

SHARED_ORACLE_HOME = C:\OraHome1

API = C:\OraHome1\DBS

NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

COMPANY_NAME = Neil R. Perron & Associates, Inc.

ORACLE_GROUP_NAME = Oracle for Windows NT

SOFTWARE\ORACLE\Workflow

Icon Directory = C:\OraHome1\WF\ICON

Level = d Version = 2.6.3.0.1

SOFTWARE\ORACLE\Workflow\Font

SOFTWARE\ORACLE\Workflow\Languages

--- Path ---

C:\OraHome1\bin

C:\Program Files\Oracle\jre\1.1.8\bin

C:\WINNT\system32

C:\WINNT

C:\WINNT\System32\Wbem

--- TNS names ---

# TNSNAMES.ORA Network Configuration File: C:\OraHome1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

TRUE_VIS=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=mdsxawo9f.truemfg.com)(PORT=1521))

(CONNECT_DATA=

(SERVER = DEDICATED)

(SID=VIS)

)

)

TRUE_DEV=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=MDSXAOR0C.truemfg.com)(PORT=1524))

(CONNECT_DATA=

(SID=DEV)

)

)

TRUE_TST=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=MDSXAOR0C.truemfg.com)(PORT=1522))

(CONNECT_DATA=

(SID=TST)

)

)

FNDFS_MDSXAWO9F=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=MDSXAWO9F.truemfg.com)(PORT=1629))

(CONNECT_DATA=

(SID=FNDFS)

)

)
 
I have uninstalled PL/SQL Developer and re-installed. Now getting ORA-12705: invalid or unknown NLS parameter value specified.

New info:

--- Info ---

PL/SQL Developer
Version 6.0.5.931 (MBCS)
01.28361 - 1 user license
Windows 2000 version 5.0 (build 2195) Service Pack 4

Physical memory : 261,532 kB (47,212 available)
Paging file : 632,560 kB (429,556 available)
Virtual memory : 2,097,024 kB (2,032,696 available)

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

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

Plug-Ins

Aliases
FNDFS_MDSXAWO9F
TRUE_DEV
TRUE_TST
TRUE_VIS

Homes
OUIHome (C:\OraHome1)

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

TNS File
C:\OraHome1\Network\Admin\tnsnames.ora

Using
Home: OUIHome
DLL: C:\OraHome1\bin\oci.dll
OCI: version 9.2

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = C:\OraHome1
ORACLE_HOME_NAME = OUIHome
API = C:\OraHome1\DBS
ORACLE_GROUP_NAME = Oracle for Windows NT
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
SHARED_ORACLE_HOME = C:\OraHome1
COMPANY_NAME = Neil R. Perron & Associates, Inc.
OI_NLS32 = C:\OraHome1\orainst\NLB
RDBMS80 = C:\OraHome1\RDBMS80
PLSQL80 = C:\OraHome1\PLSQL80
CORE40 = C:\OraHome1\CORE40
NLSRTL33 = C:\OraHome1\NLSRTL33
ORA_NLS33 = C:\OraHome1\NLSRTL33\DATA
PRO80 = C:\OraHome1\PRO80
OTRACE80 = C:\OraHome1\OTRACE80
NET80 = C:\OraHome1\NET80
OO4O = C:\OraHome1\OO4O\mesg
RDBMS73 = C:\OraHome1\RDBMS73
OTRACE73 = C:\OraHome1\OTRACE73
PLSQL23 = C:\OraHome1\PLSQL23
PRO18 = C:\OraHome1\PRO18
NLSRTL32 = C:\OraHome1\NLSRTL32
ORA_NLS32 = C:\OraHome1\NLSRTL32\DATA

SOFTWARE\ORACLE\ADI

SOFTWARE\ORACLE\ADI\HELP
HELPBASEURL =

SOFTWARE\ORACLE\ADI\Languages

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = OUIHome
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OUIHome
PATH = C:\OraHome1
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

SOFTWARE\ORACLE\GLDI
New Install = False

SOFTWARE\ORACLE\GLDI\GLDI90
Application Path = C:\OraHome1\GLDI90
Application EXE = GLDI9032.EXE
Applications Executable = AIAP45.EXE
CORE Version = 3
FND = FND75
NET = NET23
Setup Shared Install = false
Shared Install = false

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle for Windows NT
ORACLE_HOME_NAME = OUIHome
ORACLE_HOME = C:\OraHome1
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_BUNDLE_NAME = Enterprise
ORACLE_HOME_KEY = Software\ORACLE\HOME0
SHARED_ORACLE_HOME = C:\OraHome1
API = C:\OraHome1\DBS
COMPANY_NAME = Neil R. Perron & Associates, Inc.
OI_NLS32 = C:\OraHome1\orainst\NLB

SOFTWARE\ORACLE\JInitiator

SOFTWARE\ORACLE\JInitiator\1.3.1.18
JavaHome = C:\Program Files\Oracle\JInitiator 1.3.1.18

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

SOFTWARE\ORACLE\ORACLE_HOMES

SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE0
ORACLE_HOME = C:\OraHome1
ORACLE_HOME_NAME = OUIHome
SHARED_ORACLE_HOME = C:\OraHome1
API = C:\OraHome1\DBS
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
COMPANY_NAME = Neil R. Perron & Associates, Inc.
ORACLE_GROUP_NAME = Oracle for Windows NT

SOFTWARE\ORACLE\Workflow
Icon Directory = C:\OraHome1\WF\ICON
Level = d Version = 2.6.3.0.1

SOFTWARE\ORACLE\Workflow\Font

SOFTWARE\ORACLE\Workflow\Languages

--- Path ---

C:\OraHome1\bin
C:\Program Files\Oracle\jre\1.1.8\bin
C:\WINNT\system32
C:\WINNT
C:\WINNT\System32\Wbem

--- TNS names ---

# TNSNAMES.ORA Network Configuration File: C:\OraHome1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TRUE_VIS=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=mdsxawo9f.truemfg.com)(PORT=1521))
(CONNECT_DATA=
(SERVER = DEDICATED)
(SID=VIS)
)
)

TRUE_DEV=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=MDSXAOR0C.truemfg.com)(PORT=1524))
(CONNECT_DATA=
(SID=DEV)
)
)

TRUE_TST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=MDSXAOR0C.truemfg.com)(PORT=1522))
(CONNECT_DATA=
(SID=TST)
)
)
FNDFS_MDSXAWO9F=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=MDSXAWO9F.truemfg.com)(PORT=1629))
(CONNECT_DATA=
(SID=FNDFS)
)
)
 
You must log in or register to reply here.

Similar threads

B
  • Discussion Discussion
Unicode Support in PLSQL Developer
Replies
7
Views
6K
Benjamin
B
Claus Pedersen
  • Discussion Discussion
Execute SQL in debug window can fail and can end in a state where session can not be terminated
Replies
1
Views
639
Marco Kalter
Marco Kalter
Claus Pedersen
  • Discussion Discussion
Execute SQL in debug window can easily fail and ends in a state where session can not be terminated
Replies
7
Views
2K
Claus Pedersen
Claus Pedersen
M
  • Discussion Discussion
TOracleDirectPathLoader ORA-01722 Invalid Number
Replies
3
Views
7K
Funter
F
I
  • Discussion Discussion
ora-00942 table or view does not exist
Replies
1
Views
4K
Marco Kalter
Marco Kalter
Back
Top