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
