NLS_CHARACTERSET - UTF8 Client was set NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
changed to UTF8 and now ok
Tony -- -- Original Message -- -- From: t_adolph@(protected) To: ORACLE-L Sent: Monday, October 17, 2005 3:04 PM Subject: problems after installing 10g R2 on win2000
Hi all,
I recently installed 10g rel 2 on my win 2000 box. Since the have had a battle to run any 9i stuff, eg dbca and pl/sql Developer.
I've fixed the dbca problem thanks for posts on this forum (thanks), but my pl/sql Developer is not very happy:
Almost all queries cause the following error : "ORA-01460 (See ORA-01460.ora-code.com): unimplemented or unreasonable conversion requested" From the sql window this is only annoying, but the GUI functionallity no longer works, e.g. to view/edit a table fails, to describe an table fails.... etc
So far I've tried:
1) The same fix as for the dbca, i.e. I've created a bat file that sets the environment before starting the GUI:
-- ---- ---- ----- bat file -- ---- ---- ---- --- set PATH=<removed all 10g components, only 9i components plus origonal PATH from before 10g> set ORACLE_BASE=D:\oracle set ORACLE_HOME=D:\oracle\ora92 set NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252 set LD_LIBRARY_PATH=%ORACLE_HOME%\lib d: cd "D:\PLSQL Developer" "D:\PLSQL Developer\PLSQLDev.exe" -- ---- -- end of bat file -- ---- ---- ---- ---
2) I've explicitly set the OCI library from within PL/SQL Developer : Tools->Preferences OCI Library = D:\oracle\ora92\bin\oci.dll and set the ORACLE_HOME as apposed to letting it be auto-detected.
But still no good. PL/SQL Dev still doesn't want to play the game.
Any ideas would be appreciated.
Cheers Tony
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2800.1515" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>Just for the record...</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>The problem was incompatible character sets:</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>NLS_CHARACTERSET - UTF8</FONT></DIV> <DIV><FONT face=Arial size=2>Client was set NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>changed to UTF8 and now ok</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Tony</FONT></DIV> <BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">-- -- Original Message -- -- </DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A title=t_adolph@(protected) href="mailto:t_adolph@(protected)">t_adolph@(protected)</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A title=oracle-l@(protected) href="mailto:oracle-l@(protected)">ORACLE-L</A> </DIV> <DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, October 17, 2005 3:04 PM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> problems after installing 10g R2 on win2000</DIV> <DIV><BR></DIV> <DIV><FONT face=Arial size=2>Hi all,</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>I recently installed 10g rel 2 on my win 2000 box. Since the have had a battle to run any 9i stuff, eg dbca and pl /sql Developer.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>I've fixed the dbca problem thanks for posts on this forum (thanks), but my pl/sql Developer is not very happy:</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Almost all queries cause the following error : "ORA-01460 (See ORA-01460.ora-code.com): unimplemented or unreasonable conversion requested"
