From oracle-l-bounce@freelists.org Tue Oct 18 08:33:33 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9IDXW36013986 for ; Tue, 18 Oct 2005 08:33:33 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9IDXTvX013964 for ; Tue, 18 Oct 2005 08:33:29 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 40EA22073BD; Tue, 18 Oct 2005 08:33:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01791-10; Tue, 18 Oct 2005 08:33:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B0DA1207224; Tue, 18 Oct 2005 08:33:24 -0500 (EST) Message-ID: <0ab401c5d3f0$b8430960$6401a8c0@tonypc> From: "NEW pop.tiscali.de" To: "ORACLE-L" References: Subject: Re: problems after installing 10g R2 on win2000 Date: Tue, 18 Oct 2005 15:32:07 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0AAE_01C5D3F9.198A0400" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-archive-position: 27123 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: adolph.tony@tiscali.de Precedence: normal Reply-To: adolph.tony@tiscali.de X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.8 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_NextPart_000_0AAE_01C5D3F9.198A0400 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Just for the record... The problem was incompatible character sets: NLS_CHARACTERSET - UTF8 Client was set NLS_LANG=3DAMERICAN_AMERICA.WE8MSWIN1252 changed to UTF8 and now ok Tony ----- Original Message -----=20 From: t_adolph@hotmail.com=20 To: ORACLE-L=20 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: = 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=3D set ORACLE_BASE=3DD:\oracle set ORACLE_HOME=3DD:\oracle\ora92 set NLS_LANG=3DAMERICAN_AMERICA.WE8MSWIN1252 set LD_LIBRARY_PATH=3D%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 =3D 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. =20 Any ideas would be appreciated. Cheers Tony ------=_NextPart_000_0AAE_01C5D3F9.198A0400 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Just for the record...
 
The problem was incompatible character=20 sets:
 
NLS_CHARACTERSET - UTF8
Client was set=20 NLS_LANG=3DAMERICAN_AMERICA.WE8MSWIN1252
 
changed to UTF8 and now ok
 
Tony
----- Original Message -----
From:=20 t_adolph@hotmail.com
Sent: Monday, October 17, 2005 = 3:04=20 PM
Subject: problems after = installing 10g R2=20 on win2000

Hi all,
 
I recently installed 10g rel 2 on my = win 2000=20 box.  Since the have had a battle to run any 9i stuff, eg dbca = and pl/sql=20 Developer.
 
I've fixed the dbca problem thanks = for posts on=20 this forum (thanks), but my pl/sql Developer is not very = happy:
 
Almost all queries cause the = following error :=20 "ORA-01460: unimplemented or unreasonable conversion requested"  = >From the=20 sql window this is only annoying, but the GUI functionallity no longer = works,=20 e.g. to view/edit a table fails, to describe an table fails....=20 etc
 
So far I've tried:
 
1)  The same fix as for the = dbca, i.e. I've=20 created a bat file that sets the environment before starting the=20 GUI:
 
------------------ bat file=20 ---------------------
set PATH=3D<removed all 10g = components, only 9i=20 components plus origonal PATH from before 10g>
set ORACLE_BASE=3DD:\oracle
set=20 ORACLE_HOME=3DD:\oracle\ora92
set=20 NLS_LANG=3DAMERICAN_AMERICA.WE8MSWIN1252
set=20 LD_LIBRARY_PATH=3D%ORACLE_HOME%\lib
d:
cd "D:\PLSQL Developer"
"D:\PLSQL=20 Developer\PLSQLDev.exe"
---------- end of  bat file=20 ---------------------
 
 
2) I've explicitly set the OCI = library from=20 within PL/SQL Developer :
    = Tools->Preferences OCI=20 Library =3D D:\oracle\ora92\bin\oci.dll
and set the ORACLE_HOME as apposed to = letting it=20 be auto-detected.
 
But still no good.  PL/SQL Dev = still doesn't=20 want to play the game. 
 
Any ideas would be = appreciated.
 
Cheers
Tony
 
 
------=_NextPart_000_0AAE_01C5D3F9.198A0400-- -- http://www.freelists.org/webpage/oracle-l