RE: Perl 5.8.9 DBI/DBD::Oracle make test error

Hi,
 
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:[email protected]] 
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
<[email protected]> wrote:


	Hi,
	 
	I set NLS_LANG=.WE8ISO8859P15 and scott/tiger@CGISSRND, and
tried scott/tiger@zmy12sora02.
	All same error.
	 
	Yeow

________________________________

	
	From: John Scoles [mailto:[email protected]] 
	
	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
<[email protected]> 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/tiger@CGISSRND  a try 



		On Thu, Jun 17, 2010 at 10:46 PM, Yeow Yiew
Choong-PBKN64 <[email protected]> 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:[email protected]]
			
			Sent: Friday, June 18, 2010 12:04 AM
			To: Yeow Yiew Choong-PBKN64
			Cc: [email protected]
			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_password@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. I am using
			> gcc 3.4.3 depot file from
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')"
t/*.t
			> t/01base................# Test loading DBI,
DBD::Oracle and version
			> t/01base................ok
t/10general.............DBI
			>
connect('','scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zmy1
			> 2s
			>
ora02)(PORT=1521))(CONNECT_DATA=(SID=CGISSRND)))',...) failed: ERROR
			> OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env
var or PATH (Windows)
			> and or NLS settings, permissions, etc. at
t/10general.t line 35
			> Bailout called. Further testing stopped:
Unable to connect to Oracle
			> (ERROR OCIEnvNlsCreate. Check ORACLE_HOME
(Linux) env var or PATH
			> (Windows) and or NLS settings, permissions,
etc.)
			> *** Error exit code 1
			>
			> I can connect to Oracle using sqlplus
manually.
			> DBD make test failed to connect to Oracle.
			> I have set ORACLE_HOME, LD_LIBRARY_PATH &
SHLIB_PATH to my Oracle
			> Instantclient folder at
/opt/instantclient_10_2. I have changed
			> t/10general.t under DBD setup folder to
include the environment
			> variables but still failed. The variables are
:
			> $ENV{ORACLE_HOME} = '/opt/instantclient_10_2';
$ENV{NLS_LANG} =
			> '.WE8ISO8859P15'; #$ENV{NLS_LANG} =
'en_US.UTF8'; #$ENV{NLS_LANG} =
			> 'AMERICAN_AMERICA.UTF8'; #$ENV{ORACLE_USERID}
= 'scott/tiger';
			> $ENV{ORACLE_SID} = 'CGISSRND';
$ENV{LD_LIBRARY_PATH} =
			> '/opt/instantclient_10_2'; $ENV{SHLIB_PATH} =
			> '/opt/instantclient_10_2'; $ENV{LD_RUN_PATH} =
			> '/opt/instantclient_10_2'; $ENV{TNS_ADMIN} =
			> '/opt/instantclient_10_2/network/admin';
			> $ENV{LD_PRELOAD} =
'/opt/java1.5/jre/lib/PA_RISC2.0/libjava.sl';
			> #$ENV{TWO_TASK} = 'zmy12sora02';
			>
			> I manually set $dbh as listed below:
			>
			> my $dbh = DBI->connect('dbi:Oracle:',
			> q{scott/tiger@(DESCRIPTION=(ADDRESS=(PROTO
			>
COL=TCP)(HOST=zmy12sora02)(PORT=1521))(CONNECT_DATA=(SID=CGISSRND)))},
			> "");
			>
			> I can ping my server's IP address.
			> I tried different variable settings that I can
find from other threads
			
			> in Internet but failed.
			> Please help. Thanks.
			>
			> regards,
			> Yeow
			>
			>
			
			



	--
	Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1. 
	Hear Sheeri speak or email [email protected] to meet with
Pythian.
	


--
Catch Alex & Sheeri at ODTUG/Kaleidoscope - June 27 - July 1. 
Hear Sheeri speak or email [email protected] to meet with Pythian.