Greetings,
we do have one big trouble with the following (rare?) combination:
Solaris 2.8/Intel
Oracle 8.1.5 (delivered with Solaris as evaluation version)
DBD::Oracle 1.08
Perl 5.6.1 (no-threads)
The problem is that nothihg does work. Namely, we already gave up trying to
get server running and now we are trying to set-up Oracle client + DBI to
access the database running on another Solaris/SPARC box.
The point is that connection from perl script failes whereas the connection
with SQLPLUS works OK. Surely the username/password and instance names are
the same. The error message follows:
DBI->connect(VENUS) failed: ORA-01017: invalid username/password; logon
denied (DBD ERROR: OCISessionBegin) at test.pl line 26
ORA-01017: invalid username/password; logon denied (DBD ERROR:
OCISessionBegin) at test.pl line 26.
The code snippet we use for testing:
my ($inst,$user,$pass);
$inst = 'VENUS';
$user='scott';
$pass='tiger';
use DBI;
DBI->trace(9,'trace.log');
my $dbh = DBI->connect( "dbi:Oracle:$inst", $user,$pass) or die
$DBI::errstr;
All the environment variables are set
(LD_LIBRARY_PATH,ORACLE_BASE,ORACLE_HOME).
The most important lines from trace.log are:
OCIInitialize(2,0,0,0,0)=SUCCESS
OCIEnvInit(81d3a08,0,0,0)=SUCCESS
OCIHandleAlloc(81e6004,8215210,2,0,0)=SUCCESS
OCIHandleAlloc(81e6004,8215214,8,0,0)=SUCCESS
OCIHandleAlloc(81e6004,8215218,3,0,0)=SUCCESS
OCIServerAttach(823d950, 823db0c, "VENUS", 5, 0)=SUCCESS
OCIAttrSet(823d8e8,3,823d950,0,6,823db0c)=SUCCESS
OCIHandleAlloc(81e6004,821521c,9,0,0)=SUCCESS
OCIAttrSet(8247fcc,9,820bbd8,5,22,823db0c)=SUCCESS
OCIAttrSet(8247fcc,9,820bbe0,5,23,823db0c)=SUCCESS
OCISessionBegin(823d8e8,823db0c,8247fcc,1,0)=ERROR
OCIErrorGet(823db0c,1,"<NULL>",8046e94,"ORA-01017: invalid
username/password; logon denied
",1024,2)=SUCCESS
OCIErrorGet after OCISessionBegin (er1:ok): -1, 1017: ORA-01017: invalid
username/password; log
on denied
OCIErrorGet(823db0c,2,"<NULL>",8046e94,"ORA-01017: invalid
username/password; logon denied
",1024,2)=NO_DATA
ERROR EVENT 1017 'ORA-01017: invalid username/password; logon denied
(DBD ERROR: OCISessionBegi
n)' on DBI::db=HASH(0x821dac0)
Final remark is that, Yes, I know that Oracle 8.1.5 is quite buggy but I
never thouth that it's so bad. JDBC doesn't work as well but the errors are
related somehow with shared libraries or something like that.
Any help would be appricated, event just the direction where to look
further...
Oleg
P.S. Forgot to say that to get to that point we had to recompile Perl and
DBI/DBD without threads support. Without that we saw just segmentation
faults...
