[rt-users] Desperately ned Oracle help

[Baytalskiy, Sal]

Update:

I tried getting DBA permissions temporarily but the DBAs won't do it for me.
Too risky they say.
So they granted the CREATE USER permission to the existing user id they gave
me.
That got me a bit farther than yesterday.

Here's the output:

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
[Fri May 18 14:55:38 2007] [crit]: Connect 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 390
(/usr/local/rt3_ora/lib/RT.pm:346)

Stack trace:
        RT::__ANON__() called at /usr/perl5/5.8.4/lib/Carp.pm:191
        Carp::croak() called at
/usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm:106
        DBIx::SearchBuilder::Handle::Connect() called at
/usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle/Oracle.pm:46
        DBIx::SearchBuilder::Handle::Oracle::Connect() called at
/usr/local/rt3_ora/lib/RT/Handle.pm:98
        RT::Handle::Connect() called at
//usr/local/rt3_ora/sbin/rt-setup-database:390
        main::insert_initial_data() called at
//usr/local/rt3_ora/sbin/rt-setup-database:149
Connect 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 390
make: *** [initialize-database] Error 29

So at this point I really need your help on getting past the Line 390
problem (sub insert_initial_data)
What do I need to do to make it connect to my DB? I've been hardcoding the
DBI:Oracle:CLORAD1 everywhere else it was failing to connect.
But I don't know how to do it in this sub. Here's how its trying to connect
now:

	    #connect to the db, for actual RT work
	    require RT::Handle;
	    $RT::Handle = RT::Handle->new();
Line 390)  $RT::Handle->Connect();

Is there anything I can set to make it connect to my DB like this? I don't
care if I hardcode it like I did before, just as long as its able to finally
finish initializing the DB.

I think I'm real close now...


-----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