<DIV>
<DIV>Hi Steve,</DIV>
<DIV> </DIV>
<DIV>Im having same problem with Oracle, were you able to make a workaround. Btw, below is the setting under my RT_SiteConfig.pm. Would really appreciate some help Thanks.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Set($DatabaseType , 'Oracle');<BR>Set($DatabaseHost , 'localhost');<BR>Set($DatabaseRTHost , 'localhost');<BR>Set($DatabasePort , '1521');<BR>Set($DatabaseUser , 'test2');<BR>Set($DatabasePassword , 'tyson1');<BR>Set($DatabaseName , 'host=localhost; sid=RTDV2');<BR>$ENV{TWO_TASK}="LIVE";</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Erwin</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>.................................................................................</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>I'm having troubles getting RT 3.4.2 fully installed with an Oracle 10g <BR>database. Here's the software I'm using:<BR><BR>RT 3.4.2<BR>SuSE Linux 9<BR>DBD::Oracle 1.1.6<BR>Oracle client 10.1.0.3 <<A href="http://10.1.0.3/">http://10.1.0.3</A>><BR>Oracle 10g on a remote system<BR><BR>make test-deps checks ok out. The RT software itself installs fine and is <BR>working with fastcgi; the web site loads without any problems. The problem <BR>I'm having is with the make initialize-database part. Here are the details:<BR><BR>Create rt user with this command:<BR><BR>create user rt identified by rt default tablespace rt_d1 temporary<BR>tablespace temp;<BR>grant resource, connect, query rewrite to rt;<BR><BR>Then I run make initialize-database:<BR><BR># make initialize-database<BR>/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba rt <BR>--prompt-for-dba-password<BR>In order to create or update your RT database,this script needs to connect <BR>to your Oracle
instance on oracle.site.com <<A href="http://oracle.site.com/">http://oracle.site.com</A>> as rt.<BR>Please specify that user's database password below. If the user has no <BR>database<BR>password, just press return.<BR><BR>Password:<BR>Now creating a database for RT.<BR>...skipped as rt is not rt or we're working with Oracle.<BR>Now populating database schema.<BR>Creating database schema.<BR>Done setting up database schema.<BR>Now inserting database ACLs<BR>Now inserting RT core system objects<BR>Checking for existing system user...not found. This appears to be a new <BR>installation.<BR>Creating system user...[Thu Jun 30 09:31:20 2005] [warning]: DBD::Oracle::st <BR>execute failed: ORA-00600: internal error code, arguments: [kpofdr-long], <BR>[], [], [], [], [], [], [] (DBD ERROR: error possibly near <*> indicator at <BR>char 15 in 'SELECT * FROM <*>Principals WHERE id = :p1') [for Statement <BR>"SELECT * FROM Principals WHERE id = ?" with ParamValues: :p1='1']
at <BR>/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 480.<BR>(/opt/rt3/lib/RT.pm:277)<BR>[Thu Jun 30 09:31:20 2005] [warning]: RT::Handle=HASH(0x8cba890) couldn't <BR>execute the query 'SELECT * FROM Principals WHERE id = ?' at <BR>/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 494.<BR>(/opt/rt3/lib/RT.pm:277)<BR>[Thu Jun 30 09:31:20 2005] [warning]: Use of uninitialized value in hash <BR>element at /usr/lib/perl5/site_perl/5.8.3/Cache/Simple/TimedExpiry.pm line <BR>96.<BR>(/opt/rt3/lib/RT.pm:277)<BR>[Thu Jun 30 09:31:20 2005] [warning]: Use of uninitialized value in <BR>concatenation (.) or string at /opt/rt3/lib/RT/Principal_Overlay.pm line <BR>127.<BR>(/opt/rt3/lib/RT.pm:277)<BR>[Thu Jun 30 09:31:20 2005] [crit]: Found a principal () that was neither a <BR>user nor a group (/opt/rt3/lib/RT/Principal_Overlay.pm:127)<BR>[Thu Jun 30 09:31:20 2005] [crit]: Can't call method "Id" on an undefined <BR>value at /opt/rt3/lib/RT/Group_Overlay.pm line
573.<BR>(/opt/rt3/lib/RT.pm:285)<BR>make: *** [initialize-database] Error 255<BR>-----<BR><BR>Thoughts? All the tables seem to be created, including the Principals table, <BR>but there are no rows. <BR><BR>Steve<BR></DIV>
<DIV> </DIV></DIV><p>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com <p>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com