[rt-users] Desperately ned Oracle help

[Baytalskiy, Sal]

I tried replacing 

$RT::Handle->Connect();  (line 390)

with

$RT::Handle = DBI->connect("dbi:Oracle:host=clorad1.aig.com;sid=CLORAD1",
"mwpoc", "mwpoc"); 

Not sure if this is correct but that got me even farther:

Password: 
Now creating a database for RT.
Creating Oracle database CLORAD1.
Done setting up database ACLs.
Now populating database schema.
Creating database schema.
Done setting up database schema.
Now inserting database ACLs
Now inserting RT core system objects
Checking for existing system user...Can't locate object method "Rollback"
via package "DBI::db" at /usr/local/rt3_ora/lib/RT.pm line 345.
make: *** [initialize-database] Error 255

I can actually see that it created the user id that I specified as $RTUser
in my SiteConfig.pm file.

Please tell me what I'm doing wrong and how can I make this line 390 work.

Thanks in advance,
Sal.

-----Original Message-----
From: Joop van de Wege [mailto:JoopvandeWege at mococo.nl] 
Sent: Friday, May 18, 2007 6:04 AM
To: Baytalskiy, Sal
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Desperately ned Oracle help

Baytalskiy, Sal wrote:
> Hey guys!
> A little update:
> i've been looking at the rt-setup-database script trying to figure out 
> how to get around the issues i'm having.
> So the very first error mentioned this: at 
> //usr/local/rt3_ora/sbin/rt-setup-database line 103 which is this 
> *$dbh = DBI->connect( get_system_dsn(), $args{'dba'}, 
> $args{'dba-password'} )* So i replaced that with: $dbh = DBI->connect( 
> "DBI:Oracle:", $args{'dba'}, $args{'dba-password'} )
>  
> That seemed to get me a bit farther as i got this output:
> Now creating a database for RT.
> ...skipped as mwpoc is not mwpoc or we're working with Oracle.
> 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 138 *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 138, <STDIN> line 1.
> make: *** [initialize-database] Error 255
I'm using Oracle too and it should not matter whether the database is on
  the localhost or a remote one, so I would go back and do the following:
- drop the schema of RT on the remote server
- add the RT user or grant DBA role to it (temporarily)
- configure RT again with the correct parameters these are mine adjust
accordingly:
   -- export ORACLE_HOME=/your/oracle/home
   -- export ORACLE_SID=YOURSID
   -- (else the following line will barf)
   -- ./configure --with-db-type=Oracle --with-db-dba=rt_user
      --with-db-database=XE

  (if XE is in your tnsnames.ora then everything should work doesn't matter
where that db is)
- make initialize-database

As to the 32/64bit problem that used to be an issue but since I haven't done
a clean install in a while I don't  know if current DBD::Oracle still has
problems. The way I fixed this once, from memory, is that I did edit the
make file to use $ORACLE_HOME/lib32 instead of $ORACLE_HOME/lib which is
since 10g 64bit instead of 32 as is used to be in pre 10g.
But you should get a error from making DBD::Oracle which should be rather
clear on  this issue since it complains about elf64 problems.

Hope this helps, either contact me offlist, I might be able to help.

Joop