Installing DBD::Oracle on Cygwin/Windows XP 32 bit. Make test not resolving TNS

------=_Part_130920_12738537.1173125388114
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

I have the ORACLE_USER var set to a real DB that I normally connect to, and
I have ORACLE_HOME set to my Oracle client (of course, or it wouldn't have
compiled.)

Any tips appreciated.

Thanks

------=_Part_130920_12738537.1173125388114--

RE: Installing DBD::Oracle on Cygwin/Windows XP 32 bit. Make test not resolving TNS

April Blumenstiel wrote:
> Hello,
>=20
> 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

Re: Installing DBD::Oracle on Cygwin/Windows XP 32 bit. Make test not resolving TNS

------=_Part_131570_31919276.1173126872018
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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)
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
>

------=_Part_131570_31919276.1173126872018--

Re: Installing DBD::Oracle on Cygwin/Windows XP 32 bit. Make test not resolving TNS

------=_Part_131630_18860659.1173127024546
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 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)
> 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
> >
>
>

------=_Part_131630_18860659.1173127024546--

RE: Installing DBD::Oracle on Cygwin/Windows XP 32 bit. Make test not resolving TNS

------_=_NextPart_001_01C75F66.9B095C30
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Have you set TWO_TASK or ORACLE_SID? What's the exact error you're
getting from the test suite?


________________________________

From: April Blumenstiel [mailto:aprilmb@gmail.com]=20
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
=09
=09
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.
=09
=09
On 3/5/07, April Blumenstiel wrote:=20

That was a good tip, because I just tried sqlplus and I
get 'ORA-12560: TNS: protocol adapter error"=20
=09
So there's a clue.
=09
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...=20
=09
=09
=09
On 3/5/07, Garrett, Philip (MAN-Corporate) <
Philip.Garrett@manheim.com > wrote:=20

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=20
> var to the location of the file. I know it's a
good TNS file, because
> it works fine on my old system.
=09
Does SQL*Plus work? If not, get that working
first, then try
DBD::Oracle.
=09
If I recall correctly, you can't use an
environment variable for Oracle=20
stuff on Windows -- you have to use a registry
setting instead. But
don't have any facts to back that up :-)
=09
- Philip
=09




------_=_NextPart_001_01C75F66.9B095C30--

Re: Installing DBD::Oracle on Cygwin/Windows XP 32 bit. Make test not resolving TNS

------=_Part_131939_11496335.1173127765876
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I set ORACLE_USER and it seems to be using that. Here is anerror:

t/40ph_type.............DBI connect('','ork_xxx/xxxxx@DIAMONDS',...) 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)
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:aprilmb@gmail.com]
> *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 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) < Philip.Garrett@manheim.com>
> > 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
> > >
> >
> >
>

------=_Part_131939_11496335.1173127765876--

Re: Installing DBD::Oracle on Cygwin/Windows XP 32 bit. Make test not resolving TNS

------=_Part_133224_1965229.1173130999119
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 wrote:
>
> I set ORACLE_USER and it seems to be using that. Here is anerror:
>
> t/40ph_type.............DBI connect('','ork_xxx/xxxxx@DIAMONDS',...)
> 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) < Philip.Garrett@manheim.com>
> 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:aprilmb@gmail.com]
> > *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 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)
> > > 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
> > > >
> > >
> > >
> >
>

------=_Part_133224_1965229.1173130999119--