I set ORACLE_USER and it seems to be using that. Here is anerror:
t/40ph_type.............DBI connect('','ork_xxx/[EMAIL PROTECTED]',...) failed:
ORA-12154: TNS:could not resolve the connect identifier specified (DBD
ERROR: OCIServerAttach) at t/40ph_type.t line 29
Unable to connect to Oracle (ORA-12154: TNS:could not resolve the connect
identifier specified (DBD ERROR: OCIServerAttach))
Tests skipped.
Unable to connect to Oracle (ORA-12154: TNS:could not resolve the connect
identifier specified (DBD ERROR: OCIServerAttach))
I x'd out some of the connection info here... just to be nice and paranoid.
On 3/5/07, Garrett, Philip (MAN-Corporate) <[EMAIL PROTECTED]>
wrote:
Have you set TWO_TASK or ORACLE_SID? What's the exact error you're
getting from the test suite?
------------------------------
*From:* April Blumenstiel [mailto:[EMAIL PROTECTED]
*Sent:* Monday, March 05, 2007 3:37 PM
*To:* Garrett, Philip (MAN-Corporate); dbi-users@perl.org
*Subject:* Re: Installing DBD::Oracle on Cygwin/Windows XP 32 bit. Make
test not resolving TNS
Oh, actually, just tried it again and sqlplus is working fine. I just had
to pass it the connection string to the remote DB when I ran it.
On 3/5/07, April Blumenstiel <[EMAIL PROTECTED]> wrote:
>
> That was a good tip, because I just tried sqlplus and I get 'ORA-12560:
> TNS: protocol adapter error"
>
> So there's a clue.
>
> The client is working, and I tried tnsping and it was fine. It used the
> TNS file that I have in my TNS_ADMIN var. And I've been using Toad. So it's
> intersting that slqplus and OCI don't seem to be working. Still hunting...
>
> On 3/5/07, Garrett, Philip (MAN-Corporate) < [EMAIL PROTECTED]>
> wrote:
> >
> > April Blumenstiel wrote:
> > > Hello,
> > >
> > > I have downloaded the instant client and the header files for Oracle
> > > 10g, and DBD::Oracle is compiling without error, but the make tests
> > > are failing. The TNS is failing to resolve. I have set my TNS_ADMIN
> > > var to the location of the file. I know it's a good TNS file,
> > because
> > > it works fine on my old system.
> >
> > Does SQL*Plus work? If not, get that working first, then try
> > DBD::Oracle.
> >
> > If I recall correctly, you can't use an environment variable for
> > Oracle
> > stuff on Windows -- you have to use a registry setting instead. But
> > don't have any facts to back that up :-)
> >
> > - Philip
> >
>
>
