Thanks for your responses !!! Nathan, i ran the script you provided and here's the output: hello Oracle DBD::Oracle::db selectrow_array failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 17 in 'select name from <*>v$database') [for Statement "select name from v$database"] at testOracle.pl line 20. 10.02.0300 name from v$database: It seems to be connecting to the DB just fine. I also went through this post: http://www.zorranlabs.com/articles/step-by-step-installation-dbd-oracle-1.16 -on-solaris-9-and-oracle-9-client.htm <http://www.zorranlabs.com/articles/step-by-step-installation-dbd-oracle-1.1 6-on-solaris-9-and-oracle-9-client.htm> And performed the modifications mentioned there. Rebuilt the DBD::Oracle using only the 32 bit libraries. And ran the test script at the end of that article. It worked fine. Here's the outpu: Running testDBDOracle.pl... (*) Attempting Oracle Login ... OK (*) Creating table TEST_DBI ... OK (*) Insert into TEST_DBI ... 1 rows inserted. 1 rows inserted. 1 rows inserted. OK (*) Select from TEST_DBI ... --> TEST_DBI_INTR_NO : 1000 --> TEST_DBI_NAME : Jeff Hunter --> TEST_DBI_INTR_NO : 1001 --> TEST_DBI_NAME : Melody Hunter --> TEST_DBI_INTR_NO : 1002 --> TEST_DBI_NAME : Alex Hunter OK (*) Delete from TEST_DBI ... 3 rows deleted. OK (*) Drop table TEST_DBI ... OK (*) Select USER and SYSTEM ... --> USER : MWPOC --> SYSDATE : 17-MAY-2007 16:45:59 OK (*) Attempting Oracle Logoff ... OK Ending testDBDOracle.pl... Judging by that output i think my setup is working fine. But the problem still persists: i'm still unable to run the 'make initialize-database' part of the install. Still getting the same old error: DSN component 'CLORAD1' is not in 'name=value' format at /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627 DBI connect('CLORAD1;port=1521','mwpoc',...) failed: Can't connect using this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103 Failed to connect to dbi:Oracle:CLORAD1;port=1521 as mwpoc: Can't connect using this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103, <STDIN> line 1. make: *** [initialize-database] Error 255 Something tells me that it may be an issue with the 'rt-setup-database' script itself? Is that a possibility?
_____ From: Vonnahme, Nathan [mailto:[EMAIL PROTECTED] Sent: Thursday, May 17, 2007 3:29 PM To: Baytalskiy, Sal; Justin Brodley; [email protected] Subject: RE: [rt-users] Desperately ned Oracle help _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baytalskiy, Sal Sent: Thursday, May 17, 2007 9:47 AM To: Justin Brodley; [email protected] Subject: RE: [rt-users] Desperately ned Oracle help The Oracle readme said that the DB needs to be prepared. So i ran the schema.Oracle file via the SQLPlus and it inserted all the tables and indexes. So i now have the database setup, just empty. No data. Then, while running the 'make initialize-database' there's a step in that script to insert the schema. Since i already did that - i commented it out, just like the Wiki suggests. So that step should be skipped and it should just try to insert the required data into the DB. And that's where i'm stuck at this point. After some googling i found that i might have a problem with the DBD::Oracle. Apparently it tried installing that module as a 64-bit. But my Perl is 32-bit. This seems to be a common occurence. It may help to narrow the problem by testing DBD::Oracle first. Try using the 'dbish' utility installed with DBI, or with a test script like this (copied and pasted from one I used a while back-- I had to mess with manually setting $ORACLE_HOME and $LIBPATH in some cases): #!/usr/local/bin/perl -w print "hello\n"; use DBI; #use DBD::Oracle; #print "ENV:\n", map {" $_: $ENV{$_}\n"} sort keys %ENV; if ($^O =~ m/aix/i) { $ENV{ORACLE_HOME} = '/usr/local/oracle/instantclient'; $ENV{LIBPATH} = $ENV{ORACLE_HOME}; } my $dbh = DBI->connect('dbi:Oracle:host=clorad1.aig.com;sid=clorad1', 'user', 'password'); print join "\n", $dbh->get_info(17), $dbh->get_info(18); print "\nname from v\$database: ", $dbh->selectrow_array("select name from v\$database"); print "\n\n"; I had trouble in the past with 64 / 32 bit perl and Oracle client libs, so if you do this and still think that may be the issue I can send you my notes on that, or you can probably google them up somewhere. -n
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
