Compiled OK on cygwin, but getting UNKNOWN OCI Status 1804

CPAN::Forum

Thread

DBD-Oracle [search.cpan.org] [Kobes search] [View and report bugs] [Ratings 3.5

(13) ]

[AnnoCPAN] [CPAN Tests results] [CPANTS]

Posted on Mon Nov 21 21:58:05 2005 by aprilmb

Compiled OK on cygwin, but getting UNKNOWN OCI Status 1804

Hi there,

I am trying to do a connection to a remote Oracle database from the following setup: cygwin on Windows, Perl 5.8.7, DBD-Oracle 1.16, Oracle client 9.

I've done all kinds of tests, using environmental variables (ORA_NLS33, ORACLE_HOME, TWO_TASK, tnsnames file), and also passing all the info (host, port, service name, username, and pass) to the DBI connect method explicitly. Every configuration I try, I get that OCIInitialization error. Any advice? I'm out of ideas.

I can connect fine via the Oracle client, independently of Perl and cygwin, so I don't think there's a problem with the overall Oracle DB/client setup.

Should I try Oracle Client 8?

Thanks, April

Direct Responses: 1372 | Write a response

Posted on Mon Nov 21 22:21:08 2005 by aprilmb in response to 1371

Re: Compiled OK on cygwin, but getting UNKNOWN OCI Status 1804

Well, I just found the solution somewhere out there, via google (thought I'd click through just one more page of search results). I was setting ORACLE_HOME via cygwin, using the UNIX path syntax, but Oracle wanted the Windows path syntax (c:\blah\blah) Thanks anyhow. Will post when I think I'm absolutely stuck again. --April

Direct Responses: 1373 | Write a response

Posted on Mon Nov 21 23:39:16 2005 by aprilmb in response to 1372

Re: Compiled OK on cygwin, but getting UNKNOWN OCI Status 1804

Actually, that didn't quite work, after all. I think the problem now is getting OCI to recognize the tnsnames.ora file. I've tried setting ORA_NLS33 to the file, TLZ_ADMIN to the path, NLS_LANG to American_America.WE8ISO8859P1. But, depending on how I do the connect string I get either 'could not resolve service name' or 'NLS parameter invalid or missing'

Direct Responses: 1374 | Write a response

Posted on Tue Nov 22 01:39:25 2005 by timbunce in response to 1373

Re: Compiled OK on cygwin, but getting UNKNOWN OCI Status 1804

You'll probably get more help by emailing the details to dbi-users@perl.org (See the HOW TO REPORT PROBLEMS section in http://search.cpan.org/src/TIMB/DBD-Oracle/README)

Direct Responses: 1381 | Write a response

Posted on Tue Nov 22 16:34:26 2005 by aprilmb in response to 1374

Re: Compiled OK on cygwin, but getting UNKNOWN OCI Status 1804

Thank you. I will do that. Seems like it might be more a problem I'm having with the Oracle Client, anyhow.

Write a response

Service launched on 2nd of February 2005.
Comments, and other submissions on CPAN Forum are Copyright 2005-2007, their respective owners.
Site maintainer is not responsible for content. Privacy Policy

Maintained and hosted by Gabor Szabo at Perl Training Israel