RT on Oracle Database

RT Users
1

All:

I am looking for the script which would create all the database objects of RT in Oracle. Can someone please tell me where can I find them.

Thanks!

2

Deepika Bhatia wrote:

All:

I am looking for the script which would create all the database objects
of RT in Oracle. Can someone please tell me where can I find them.
Its part of RT, you’ll need to add --with-db-type=Oracle to your
configure options.
The following, all on one line, is from my config.log:
./configure --with-web-user=www-data --with-web-group=www-data
–with-rt-group=rt3 --with-db-type=Oracle --with-db-dba=rt_user
–with-db-database=XE

The --with-rt-group is only needed if you don’t use the default of
‘rt’, the --with-db-database=XE is the tnsnames alias of your Oracle DB,
in my case it is XE because we use Oracle XE with RT, but it could be a
database on your company database farm and then you’ll need to point
your tnsnames.ora to it. Ask your Oracle DBA :wink:
The following is part of a document that I’m currently making for
installing a RT VirtualMachine using OracleXE

The following is needed because

  1. makes installing rt easier :wink:
  2. makes DBD::Oracle happy when installing, can be removed afterwards
    • sqlplus /nolog
    • connect system
    • create user rt_user identified by rt_pass
      default tablespace USERS
      temporary tablespace TEMP
      account unlock;
    • grant connect,resource,dba to rt_user;
    • create user scott identified by tiger
      default tablespace USERS
      temporary tablespace TEMP
      account unlock;
    • grant connect,resource,dba to scott;
    • exit sqlplus

== RT Installation ==
* adduser rt
( * su - rt)?
( * cd /home/rt)?
* wget http://download.bestpractical.com/pub/rt/release/rt-3.6.4.tar.gz
* wget
http://download.bestpractical.com/pub/rt/devel/RTIR_M3/RTFM-2.2.0RC6.tar.gz
* wget http://atwiki.chaka.net/at-1.2.3.tar.gz
* edit .bashrc and add Oracle ENV or source oracle_env.sh
(The VM is rather stripped thats why the aptitude installs)
* aptitude install make
* aptitude install gcc
* aptitude install automake
* aptitude install libgd2-noxpm-dev
* aptitude install man
* aptitude install libexpat1-dev
* run cpan
* answer the questions
* tar zxf rt-3.6.4.tar.gz
* cd rt-3.6.4
* ./configure --with-web-user=www-data --with-web-group=www-data
–with-rt-group=rt --with-db-type=Oracle --with-db-dba=rt_user
–with-db-database=XE
* make testdeps | grep MISSING ( a lot!)
* make fixdeps (Cancel on mod_perl-1.30 with CTRL-C)
* make fixdeps (Solved the MISSING)
* cpan Apache::DBI (is missed by make fixdeps)
* cpan Apache::DB (my extra for debugging RT with Komodo)
* make install
* make initdb
Finished!

Joop