RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Hi all, My Oracle database NLS language is AMERICAN English. In DBD::Oracle, what variable/value should I set? Thanks. Yeow -Original Message- From: Yeow Yiew Choong-PBKN64 Sent: Thursday, June 24, 2010 11:00 AM To: 'John Scoles' Cc: dbi-users@perl.org Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error Hi all, Tried TNS_ADMIN =/opt/instantclient_10_2/ and ORACLE_USERID=scott/ti...@zmy12sora02 but still same error. I have set ORACLE_HOME=/opt/instantclient_10_2/ and many different settings combination for TNS_ADMIN and ORACLE_USERID but still not successful. I am wondering what DBD::Oracle needs. I set NLS_LANG=.WE8ISO8859P15 , tried different settings for NLS_LANG such as .UTF8, .AL32UTF8, .UTF_8 but all not successful. I set NLS_NCHAR = AL32UTF8 and not successful. What is other NLS related setting(s)? Thanks. Yeow -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Wednesday, June 23, 2010 7:19 PM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org Subject: 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]
RE: Perl 5.8.9 DBI/DBD::Oracle make test error
Hi all, Tried TNS_ADMIN =/opt/instantclient_10_2/ and ORACLE_USERID=scott/ti...@zmy12sora02 but still same error. I have set ORACLE_HOME=/opt/instantclient_10_2/ and many different settings combination for TNS_ADMIN and ORACLE_USERID but still not successful. I am wondering what DBD::Oracle needs. I set NLS_LANG=.WE8ISO8859P15 , tried different settings for NLS_LANG such as .UTF8, .AL32UTF8, .UTF_8 but all not successful. I set NLS_NCHAR = AL32UTF8 and not successful. What is other NLS related setting(s)? Thanks. Yeow -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Wednesday, June 23, 2010 7:19 PM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org Subject: 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
Re: Perl 5.8.9 DBI/DBD::Oracle make test error
Well not havening much luck are we. At this point I think you either have a bad Perl, DBI or DBD::Oracle installation and or a you have multiple installations of DBI and DBD::Oracle. So to see what you DBI can see give this a try use DBI; print available_drivers:\n; print $_\n foreach DBI-available_drivers; print \ndata_sources:\n; print $_\n foreach DBI-data_sources('Oracle'); and post the results here cheers John Scoles Hi all, My Oracle database NLS language is AMERICAN English. In DBD::Oracle, what variable/value should I set? Thanks. Yeow -Original Message- From: Yeow Yiew Choong-PBKN64 Sent: Thursday, June 24, 2010 11:00 AM To: 'John Scoles' Cc: dbi-users@perl.org Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error Hi all, Tried TNS_ADMIN =/opt/instantclient_10_2/ and ORACLE_USERID=scott/ti...@zmy12sora02 but still same error. I have set ORACLE_HOME=/opt/instantclient_10_2/ and many different settings combination for TNS_ADMIN and ORACLE_USERID but still not successful. I am wondering what DBD::Oracle needs. I set NLS_LANG=.WE8ISO8859P15 , tried different settings for NLS_LANG such as .UTF8, .AL32UTF8, .UTF_8 but all not successful. I set NLS_NCHAR = AL32UTF8 and not successful. What is other NLS related setting(s)? Thanks. Yeow -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Wednesday, June 23, 2010 7:19 PM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org Subject: 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
Re: Perl 5.8.9 DBI/DBD::Oracle make test error
this thread may help as well http://forums.oracle.com/forums/thread.jspa?threadID=872112 Hi all, My Oracle database NLS language is AMERICAN English. In DBD::Oracle, what variable/value should I set? Thanks. Yeow -Original Message- From: Yeow Yiew Choong-PBKN64 Sent: Thursday, June 24, 2010 11:00 AM To: 'John Scoles' Cc: dbi-users@perl.org Subject: RE: Perl 5.8.9 DBI/DBD::Oracle make test error Hi all, Tried TNS_ADMIN =/opt/instantclient_10_2/ and ORACLE_USERID=scott/ti...@zmy12sora02 but still same error. I have set ORACLE_HOME=/opt/instantclient_10_2/ and many different settings combination for TNS_ADMIN and ORACLE_USERID but still not successful. I am wondering what DBD::Oracle needs. I set NLS_LANG=.WE8ISO8859P15 , tried different settings for NLS_LANG such as .UTF8, .AL32UTF8, .UTF_8 but all not successful. I set NLS_NCHAR = AL32UTF8 and not successful. What is other NLS related setting(s)? Thanks. Yeow -Original Message- From: John Scoles [mailto:sco...@pythian.com] Sent: Wednesday, June 23, 2010 7:19 PM To: Yeow Yiew Choong-PBKN64 Cc: dbi-users@perl.org Subject: 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
Re: Perl 5.8.9 DBI/DBD::Oracle make test error
On 06/24/2010 05:52 AM, John Scoles wrote: Well not havening much luck are we. At this point I think you either have a bad Perl, DBI or DBD::Oracle installation and or a you have multiple installations of DBI and DBD::Oracle. ---deleted on purpose ;) Perhaps it might help to start over with a personal copy of perl? That is to say, build perl with prefix=some/dir, then add in only the DBI and DBD::Oracle. This might simplify things enough to be able to isolate the problem. -- Bob McGowan