Dbd Error Ocisessionbegin At T/10general.t Line 22
| View Threaded tapio.tirkkola at csolutor Feb12,2011,1:35PM Post #1 of 2 (2452 views) Permalink make fixdeps unable to fix DBD::Oracle ...MISSING. Fails with ORA-24327 Hi all As a background, I'm quite familiar with Oracle and mostly know my way with Linux, too, but I've no experience on PERL nor RT before. What I'm trying to do is install RT 3.8.8 on Oracle Linux 5.5 and configure it to use an existing remote Oracle 10g database. I've used this installation document http://requesttracker.wikia.com/wiki/CentOS5InstallPlusSome as my guideline, with minor differences in versions etc, and the biggest difference probably is trying to use Oracle DB instead of MySQL, as that's my and the company's clear preference. README.Oracle says "You don't need to create anything beforehead." It seems to be partly true as there should be nothing that needs to be created in the database before installing RT. But for using remote database it seems that Oracle client setup needs to be done on the RT host. Unfortunately I haven't found instructions for that, so I've been trying to figure out the steps myself. So far I've tried several Oracle client configurations. Each time I've prepared the environment so that I could successfully tnsping the target database and connect using sqlplus. However, no success with make fixdeps yet: - First tried a light Oracle client version, Oracle Instant Client v10.1 and 11.2 (11g chosen because it installs more cleanly on Oracle Linux 5.5). Failed with missing .mk files. - Then I tried with normal Oracle Client 11.2 with same problem. - Then I figured out from the error messages that more Oracle SW is needed and found out that to get suitable .mk files installes I must install either whole Oracle database locally or install Oracle demo stuff. - So I installed Oracle DB demo stuff in the Instant Client home first. The .mk problem disappeared, but still it didn't look good because of several errors. - I decided to try the same with stand
install the DBD::Oracle module for the Perl 5.8.8 I justinstalled on Solaris9/Sparc. The 'perl Makefile.PL' and the 'make'part looks fine, because I saw this following message:Checking if your kit is complete...Looks goodLD_RUN_PATH=/u01/oracle/product/10.2.0/lib32:/u01/oracle/product/10.2.0/rdbms/lib32Using DBD::Oracle 1.19.Using DBD::Oracle 1.19.Using DBI 1.56 (for perl 5.008008 on sun4-solaris) installed in /usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI/Writing Makefile for DBD::OracleBUT, when I do 'make http://www.gossamer-threads.com/lists/rt/users/99816 test', it seems to be failed start from thebeginning of the test. The ORA-28000 error means the accountpermission denied or locked. I'm confused, I'm running the make underroot account.Could anybody point out what I could do to fix this?TIA,AlanThe following is the test result:# http://grokbase.com/t/perl/dbi-users/076cez3re1/dbd-oracle-installation-make-test-failed-ora-28000-accout-locked make testPERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e""test_harness(0, 'blib/lib', 'blib/arch')" t/*.tt/01base................okt/10general.............DBI connect('','scott/tiger',...) failed:ORA-28000: the account is locked (DBD ERROR: OCISessionBegin) at t/10general.t line 18Undefined subroutine &main::BAILOUT called at t/10general.t line 21.# Looks like your test died before it could output anything.t/10general.............dubiousTest returned status 255 (wstat 65280, 0xff00)DIED. FAILED tests 1-33Failed 33/33 tests, 0.00% okayt/15nls.................DBI connect('','scott/tiger',...) failed:ORA-28000: the account is locked (DBD ERROR: OCISessionBegin) at t/15nls.t line 19t/15nls.................ok9/9 skipped: Unable to connect to Oracle (ORA-28000: theaccount is locked (DBD ERROR: OCISessionBegin))t/20select..............Unable to connect to Oracle (ORA-28000: theaccount is locked (DBD ERROR: OCISessionBegin))Tests skiped.skippedall skipped: no reason givent/21nchar...............DBI connect('','scott/tiger',...) failed:ORA-28000: the account is locked (DBD ERROR: OCISessionBegin) at t/nchar_test_lib.pl line 156skippedall skipped: Not connected to oraclet/22nchar_al32utf8......DBI connect('','scott/tiger',...) failed:ORA-28000: the account is locked (DBD ERROR: OCISessionBegin) at t/nchar_test_lib.pl line 156skippedall skipped: Not connected to oraclet/22nchar_utf8..........DBI connect('','scott
from GoogleSign inHidden fieldsSearch for groups or messages