Re: Perl 5.8.9 DBI/DBD::Oracle make test error
Yeow Yiew Choong-PBKN64 wrote: ok you had these set before I just noticed you have TNS_ADMIN =/opt/instantclient_10_2/network/admin that should point to the dir where you TNSNAME.ORA file is. so I think it should be TNS_ADMIN =/opt/instantclient_10_2/ as well ass you have ORACLE_SID=CGISSRND TWO_TASK= zmy12sora02 set I would just drop those two and just use the following ORACLE_USERID=scott/ti...@zmy12sora02 Hope this helps John Scoles Hi all, I am using tnsnames.ora file in my Oracle Instantclient folder. The tnsnames.ora file content is listed below: zmy12sora02 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = 10.228.140.12) (Port = 1521) ) ) (CONNECT_DATA = (SID = CGISSRND) ) ) My remote database hostname is zmy12sora02 (IP address is 10.228.140.12). When I connect using SQLPlus, I am using the command below: # sqlplus scott/ti...@zmy12sora02 I can connect using another user/password with dba role too. However, in DBI/DBD make test, it cannot connect. Why? Thanks. Yeow -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Tuesday, June 22, 2010 6:44 PM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error How are you connecting with SQLPLus? Still failed with TNS_ADMIN configured exported. I tried another user with dba role but same error. sqlplus can connect but DBD::Oracle cannot, how to troubleshoot what is preventing it to connect? Thanks. Yeow -- -- *From:* John Scoles [mailto:sco...@pythian.com] *Sent:* Friday, June 18, 2010 7:36 PM *To:* Yeow Yiew Choong-PBKN64 *Subject:* Re: Perl 5.8.9 DBI/DBD::Oracle make test error last change TNS_ADMIN set this to the dir where you tnsnames.ora is located If all of these faile then there is something in your network that is prefenting DBD::Oracle from connecting. cheers John On Fri, Jun 18, 2010 at 6:27 AM, Yeow Yiew Choong-PBKN64 pbk...@motorola.com mailto:pbk...@motorola.com wrote: Hi, I set NLS_LANG=.WE8ISO8859P15 and scott/ti...@cgissrnd mailto:scott/ti...@cgissrnd, and tried scott/ti...@zmy12sora02 mailto:scott/ti...@zmy12sora02. All same error. Yeow *From:* John Scoles [mailto:sco...@pythian.com mailto:sco...@pythian.com] *Sent:* Friday, June 18, 2010 6:15 PM *To:* Yeow Yiew Choong-PBKN64 *Subject:* Re: Perl 5.8.9 DBI/DBD::Oracle make test error Aw well you might want to set the NLS_LANG=.WE8ISO8859P15 just in case as well On Fri, Jun 18, 2010 at 6:11 AM, John Scoles sco...@pythian.com mailto:sco...@pythian.com wrote: scott/tiger@( DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmy12s ora02)(PORT=1521))(CONNECT_DATA=(SID=CGISSRND) would not be a correct connection string give scott/ti...@cgissrnd a try On Thu, Jun 17, 2010 at 10:46 PM, Yeow Yiew Choong-PBKN64 pbk...@motorola.com mailto:pbk...@motorola.com wrote: Hi all, There is a user scott, otherwise I cannot logon manually using sqlplus. I am using the same username password to logon for my connection testing using sqlplus. I have set ORACLE_USERID but still no luck. What to do? Thanks. Yeow -Original Message- From: John Scoles [mailto:sco...@pythian.com mailto:sco...@pythian.com] Sent: Friday, June 18, 2010 12:04 AM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org mailto:dbi-users@perl.org Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error Yeow Yiew Choong-PBKN64 wrote: I really doubt there is a scott/tiger user on you Oracle box set the ORACLE_USERID to a value user and password sid combination and then come back to the list ie export ORACLE_USERID=my_user/my_passw...@my_id Hi, I have HP-UX 11.11(64bit PA-RISC) and Perl 5.8.9.(32bit 64bit) The Perl I installed from depot file from www.develooper.com http://www.develooper.com. I am using gcc 3.4.3 depot file from ftp.thewrittenword.com http://ftp.thewrittenword.com. I am new to Perl. I want to install DBD::Oracle 1.24 (from CPAN) so that I can connect to remote database Oracle 10g. I am using Oracle Instantclient 10.2 (32bit) from Oracle download.
RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Hi all, I am using tnsnames.ora file in my Oracle Instantclient folder. The tnsnames.ora file content is listed below: zmy12sora02 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = 10.228.140.12) (Port = 1521) ) ) (CONNECT_DATA = (SID = CGISSRND) ) ) My remote database hostname is zmy12sora02 (IP address is 10.228.140.12). When I connect using SQLPlus, I am using the command below: # sqlplus scott/ti...@zmy12sora02 I can connect using another user/password with dba role too. However, in DBI/DBD make test, it cannot connect. Why? Thanks. Yeow -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Tuesday, June 22, 2010 6:44 PM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error How are you connecting with SQLPLus? Still failed with TNS_ADMIN configured exported. I tried another user with dba role but same error. sqlplus can connect but DBD::Oracle cannot, how to troubleshoot what is preventing it to connect? Thanks. Yeow -- -- *From:* John Scoles [mailto:sco...@pythian.com] *Sent:* Friday, June 18, 2010 7:36 PM *To:* Yeow Yiew Choong-PBKN64 *Subject:* Re: Perl 5.8.9 DBI/DBD::Oracle make test error last change TNS_ADMIN set this to the dir where you tnsnames.ora is located If all of these faile then there is something in your network that is prefenting DBD::Oracle from connecting. cheers John On Fri, Jun 18, 2010 at 6:27 AM, Yeow Yiew Choong-PBKN64 pbk...@motorola.com mailto:pbk...@motorola.com wrote: Hi, I set NLS_LANG=.WE8ISO8859P15 and scott/ti...@cgissrnd mailto:scott/ti...@cgissrnd, and tried scott/ti...@zmy12sora02 mailto:scott/ti...@zmy12sora02. All same error. Yeow *From:* John Scoles [mailto:sco...@pythian.com mailto:sco...@pythian.com] *Sent:* Friday, June 18, 2010 6:15 PM *To:* Yeow Yiew Choong-PBKN64 *Subject:* Re: Perl 5.8.9 DBI/DBD::Oracle make test error Aw well you might want to set the NLS_LANG=.WE8ISO8859P15 just in case as well On Fri, Jun 18, 2010 at 6:11 AM, John Scoles sco...@pythian.com mailto:sco...@pythian.com wrote: scott/tiger@( DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmy12s ora02)(PORT=1521))(CONNECT_DATA=(SID=CGISSRND) would not be a correct connection string give scott/ti...@cgissrnd a try On Thu, Jun 17, 2010 at 10:46 PM, Yeow Yiew Choong-PBKN64 pbk...@motorola.com mailto:pbk...@motorola.com wrote: Hi all, There is a user scott, otherwise I cannot logon manually using sqlplus. I am using the same username password to logon for my connection testing using sqlplus. I have set ORACLE_USERID but still no luck. What to do? Thanks. Yeow -Original Message- From: John Scoles [mailto:sco...@pythian.com mailto:sco...@pythian.com] Sent: Friday, June 18, 2010 12:04 AM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org mailto:dbi-users@perl.org Subject: Re: Perl 5.8.9 DBI/DBD::Oracle make test error Yeow Yiew Choong-PBKN64 wrote: I really doubt there is a scott/tiger user on you Oracle box set the ORACLE_USERID to a value user and password sid combination and then come back to the list ie export ORACLE_USERID=my_user/my_passw...@my_id Hi, I have HP-UX 11.11(64bit PA-RISC) and Perl 5.8.9.(32bit 64bit) The Perl I installed from depot file from www.develooper.com http://www.develooper.com. I am using gcc 3.4.3 depot file from ftp.thewrittenword.com http://ftp.thewrittenword.com. I am new to Perl. I want to install DBD::Oracle 1.24 (from CPAN) so that I can connect to remote database Oracle 10g. I am using Oracle Instantclient 10.2 (32bit) from Oracle download. DBI is included in the perl 5.8.9. There is no issue on DBD compilation and make, the problem I have is when I run make test. The error is: # make test PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch')