From oracle-l-bounce@freelists.org Mon Oct 17 08:05:49 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9HD5nP8005004 for ; Mon, 17 Oct 2005 08:05:49 -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 j9HD5jvX004862 for ; Mon, 17 Oct 2005 08:05:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 87EDB200F86; Mon, 17 Oct 2005 08:05:42 -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 17133-03; Mon, 17 Oct 2005 08:05:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0403D200A8E; Mon, 17 Oct 2005 08:05:41 -0500 (EST) Message-ID: X-Originating-IP: [83.129.172.47] X-Originating-Email: [t_adolph@hotmail.com] X-Sender: t_adolph@hotmail.com From: To: "ORACLE-L" Subject: problems after installing 10g R2 on win2000 Date: Mon, 17 Oct 2005 15:04:10 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01BE_01C5D32C.07624670" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-OriginalArrivalTime: 17 Oct 2005 13:03:31.0442 (UTC) FILETIME=[2C850520:01C5D31B] X-archive-position: 27061 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: t_adolph@hotmail.com Precedence: normal Reply-To: t_adolph@hotmail.com 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=-1.1 required=5.0 tests=AWL,BAYES_00, FORGED_HOTMAIL_RCVD2,HTML_MESSAGE,NO_REAL_NAME autolearn=no version=2.63 ------=_NextPart_000_01BE_01C5D32C.07624670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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_01BE_01C5D32C.07624670 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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.... = 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 = 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 within=20 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 be=20 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_01BE_01C5D32C.07624670-- -- http://www.freelists.org/webpage/oracle-l