I got it working. Thanks for reading my question.

I actually just skipped the test and did a force install. It looked as if
one of the connect parameters was getting blanked out by the test script, so
I figured I'd just skip it.

That got me closer. Then I was getting an error about my NLS_LANG val from
my calling script, which I fixed in regedit. It had defaulted to 'NA' which
is apparently invalid. I put a valid lang code in there. Now my application
is working.


On 3/5/07, April Blumenstiel <[EMAIL PROTECTED]> wrote:

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); [email protected]
> *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
> > >
> >
> >
>

Reply via email to