cx-oracle-users

[cx-oracle-users] DLL Error - python 2.4, Oracle 8.1.7, cx_Oracle 4.1.2, Win XP SP2

[JP G. <jpg...@gm...>]

I am having the same problem loading the ori.dll that some other people hav=
e
mentioned on various lists, but I have not seen a solution anywhere. I have
Oracle SQL Plus installed on this PC (I didn't install it myself, it came t=
o
me second hand), and the ori.dll is in C:\orant\BIN, which is also on the
path.

When I import cx_Oracle I get this error:

"ImportError: DLL load failed: No se encontr=F3 el proceso especificado." (=
the
computer is mostly Spanish, but it says it has not found the specified
process).

I have seen comments that this is due to a mismatch in the versions of
Oracle or Python which the module is compiled against, but the only thing
that I see that could be the problem is the dll itself. This may be stupid
question, but is there a way to check the version of the dll? The file was
created on 11/11/1999.

SQL Plus connects to the Oracle server without problems. It seems to be a
problem between cx_Oracle and the ori.dll.

Any help appreciated!

JP

Re: [cx-oracle-users] DLL Error - python 2.4, Oracle 8.1.7, cx_Oracle 4.1.2, Win XP SP2

[Anthony T. <ant...@gm...>]

No specific help but find out what Oracle client version you are using
and then download a version of cx_Oracle that corresponds to it. That
will elminate the problems with version mismatches. As for determining
what client version a particular version of cx_Oracle was compiled
against -- that's not possible because Oracle doesn't provide this
information. And, if you can't import the module at all you definitely
can't get any information from it.... :-) That problem is part of
another thread which has not yet been resolved.

On 2/7/06, JP Glutting <jpg...@gm...> wrote:
> I am having the same problem loading the ori.dll that some other people h=
ave
> mentioned on various lists, but I have not seen a solution anywhere. I ha=
ve
> Oracle SQL Plus installed on this PC (I didn't install it myself, it came=
 to
> me second hand), and the ori.dll is in C:\orant\BIN, which is also on the
> path.
>
> When I import cx_Oracle I get this error:
>
> "ImportError: DLL load failed: No se encontr=F3 el proceso especificado."=
 (the
> computer is mostly Spanish, but it says it has not found the specified
> process).
>
> I have seen comments that this is due to a mismatch in the versions of
> Oracle or Python which the module is compiled against, but the only thing
> that I see that could be the problem is the dll itself. This may be stupi=
d
> question, but is there a way to check the version of the dll? The file wa=
s
> created on 11/11/1999.
>
> SQL Plus connects to the Oracle server without problems. It seems to be a
> problem between cx_Oracle and the ori.dll.
>
> Any help appreciated!
>
> JP
>

Re: [cx-oracle-users] DLL Error - python 2.4, Oracle 8.1.7, cx_Oracle 4.1.2, Win XP SP2

[Amaury F. d'A. <ama...@gm...>]

2006/2/7, JP Glutting <jpg...@gm...>:
> I am having the same problem loading the ori.dll that some other people h=
ave
> mentioned on various lists, but I have not seen a solution anywhere.

BTW, the file is named oci.dll.

> I have
> Oracle SQL Plus installed on this PC (I didn't install it myself, it came=
 to
> me second hand), and the ori.dll is in C:\orant\BIN, which is also on the
> path.
>
> When I import cx_Oracle I get this error:
>
> "ImportError: DLL load failed: No se encontr=F3 el proceso especificado."=
 (the
> computer is mostly Spanish, but it says it has not found the specified
> process).
>

Did you try running "import cx_Oracle" from the command line? Usually
you get a window showing the exact problem.
A cause could be that you installed a cx_Oracle compiled for Oracle
9i. Then the error is something like "could not find entry point xxx",
where xxx is a 9i-only feature.

> SQL Plus connects to the Oracle server without problems.
sql*plus does not use the OCI.dll library. It directly links to lower
level files (such as oraclient9.dll)

--
Amaury Forgeot d'Arc

Re: [cx-oracle-users] DLL Error - python 2.4, Oracle 8.1.7, cx_Oracle 4.1.2, Win XP SP2

[JP G. <jpg...@gm...>]

Thanks for the response. I am using the correct version of cx_Oracle, I saw
in some earlier posts that the 9i version makes calls to different features=
.
That is why I was surprised by the error - I guess the dll could be from an
even earlier version of Oracle. The information about oraclient9.dll is
interesting. Do you know of any way of testing the oci.dll (not ori.dll)
file independently of python, to see if it is the right version to connect
to the Oracle server?

And I did the import from the command line. I am not sure what you mean by
"a window" showing the problem, but here is the traceback:

>>> import cx_Oracle
Traceback (most recent call last):
  File "<interactive input>", line 1, in ?
ImportError: DLL load failed: No se encontr=F3 el proceso especificado.
>>>

Cheers,
JP

On 2/7/06, Amaury Forgeot d'Arc <ama...@gm...> wrote:
>
> 2006/2/7, JP Glutting <jpg...@gm...>:
> > I am having the same problem loading the ori.dll that some other people
> have
> > mentioned on various lists, but I have not seen a solution anywhere.
>
> BTW, the file is named oci.dll.
>
> > I have
> > Oracle SQL Plus installed on this PC (I didn't install it myself, it
> came to
> > me second hand), and the ori.dll is in C:\orant\BIN, which is also on
> the
> > path.
> >
> > When I import cx_Oracle I get this error:
> >
> > "ImportError: DLL load failed: No se encontr=F3 el proceso especificado=
."
> (the
> > computer is mostly Spanish, but it says it has not found the specified
> > process).
> >
>
> Did you try running "import cx_Oracle" from the command line? Usually
> you get a window showing the exact problem.
> A cause could be that you installed a cx_Oracle compiled for Oracle
> 9i. Then the error is something like "could not find entry point xxx",
> where xxx is a 9i-only feature.
>
> > SQL Plus connects to the Oracle server without problems.
> sql*plus does not use the OCI.dll library. It directly links to lower
> level files (such as oraclient9.dll)
>
> --
> Amaury Forgeot d'Arc
>
>

Re: [cx-oracle-users] DLL Error - python 2.4, Oracle 8.1.7, cx_Oracle 4.1.2, Win XP SP2

[JP G. <jpg...@gm...>]

Thanks Anthony!

The problem is that I don't have the versions mismatched, as far as I can
tell. We are running Oracle 8i, specifically version 8.1.7. So my cxOracle
version matches the server version perfectly. The problem seems to be that
it does not match the oci.dll file, which may be out of date (it is from
1999, and I am not sure when version 8.1.7 of Oracle came out).

Is there any way to run a test against the oci.dll file? Using a different
program? TOAD, or something?

Thanks,
JP

On 2/7/06, Anthony Tuininga <ant...@gm...> wrote:
>
> No specific help but find out what Oracle client version you are using
> and then download a version of cx_Oracle that corresponds to it. That
> will elminate the problems with version mismatches. As for determining
> what client version a particular version of cx_Oracle was compiled
> against -- that's not possible because Oracle doesn't provide this
> information. And, if you can't import the module at all you definitely
> can't get any information from it.... :-) That problem is part of
> another thread which has not yet been resolved.
>
> On 2/7/06, JP Glutting <jpg...@gm...> wrote:
> > I am having the same problem loading the ori.dll that some other people
> have
> > mentioned on various lists, but I have not seen a solution anywhere. I
> have
> > Oracle SQL Plus installed on this PC (I didn't install it myself, it
> came to
> > me second hand), and the ori.dll is in C:\orant\BIN, which is also on
> the
> > path.
> >
> > When I import cx_Oracle I get this error:
> >
> > "ImportError: DLL load failed: No se encontr=F3 el proceso especificado=
."
> (the
> > computer is mostly Spanish, but it says it has not found the specified
> > process).
> >
> > I have seen comments that this is due to a mismatch in the versions of
> > Oracle or Python which the module is compiled against, but the only
> thing
> > that I see that could be the problem is the dll itself. This may be
> stupid
> > question, but is there a way to check the version of the dll? The file
> was
> > created on 11/11/1999.
> >
> > SQL Plus connects to the Oracle server without problems. It seems to be
> a
> > problem between cx_Oracle and the ori.dll.
> >
> > Any help appreciated!
> >
> > JP
> >
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=103432&bid#0486&dat=121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] DLL Error - python 2.4, Oracle 8.1.7, cx_Oracle 4.1.2, Win XP SP2

[Anthony T. <ant...@gm...>]

NOTE: the __server__ version is not relevant! You need to make sure
that your __client__ Oracle version matches your cx_Oracle. This issue
seems to be a regular source of confusion.... :-)

On 2/8/06, JP Glutting <jpg...@gm...> wrote:
> Thanks Anthony!
>
> The problem is that I don't have the versions mismatched, as far as I can
> tell. We are running Oracle 8i, specifically version 8.1.7. So my cxOracl=
e
> version matches the server version perfectly. The problem seems to be tha=
t
> it does not match the oci.dll file, which may be out of date (it is from
> 1999, and I am not sure when version 8.1.7 of Oracle came out).
>
> Is there any way to run a test against the oci.dll file? Using a differen=
t
> program? TOAD, or something?
>
> Thanks,
> JP
>
>
> On 2/7/06, Anthony Tuininga <ant...@gm...> wrote:
> >
> > No specific help but find out what Oracle client version you are using
> > and then download a version of cx_Oracle that corresponds to it. That
> > will elminate the problems with version mismatches. As for determining
> > what client version a particular version of cx_Oracle was compiled
> > against -- that's not possible because Oracle doesn't provide this
> > information. And, if you can't import the module at all you definitely
> > can't get any information from it.... :-) That problem is part of
> > another thread which has not yet been resolved.
> >
> > On 2/7/06, JP Glutting <jpg...@gm...> wrote:
> > > I am having the same problem loading the ori.dll that some other peop=
le
> have
> > > mentioned on various lists, but I have not seen a solution anywhere. =
I
> have
> > > Oracle SQL Plus installed on this PC (I didn't install it myself, it
> came to
> > > me second hand), and the ori.dll is in C:\orant\BIN, which is also on
> the
> > > path.
> > >
> > > When I import cx_Oracle I get this error:
> > >
> > > "ImportError: DLL load failed: No se encontr=F3 el proceso especifica=
do."
> (the
> > > computer is mostly Spanish, but it says it has not found the specifie=
d
> > > process).
> > >
> > > I have seen comments that this is due to a mismatch in the versions o=
f
> > > Oracle or Python which the module is compiled against, but the only
> thing
> > > that I see that could be the problem is the dll itself. This may be
> stupid
> > > question, but is there a way to check the version of the dll? The fil=
e
> was
> > > created on 11/11/1999.
> > >
> > > SQL Plus connects to the Oracle server without problems. It seems to =
be
> a
> > > problem between cx_Oracle and the ori.dll.
> > >
> > > Any help appreciated!
> > >
> > > JP
> > >
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> > for problems?  Stop!  Download the new AJAX search engine that makes
> > searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> >
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=103432&bid#0486&dat=121642
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> >
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
>