[rt-users] oracle setup

[Jim Meyer]

Added this email as "Raw Notes" to the bottom of:

 http://wiki.bestpractical.com/index.cgi?OracleSetup

Seemed useful to keep it in the same place.

Cheers!

--j

On Wed, 2005-10-26 at 07:58, Myers, Adam wrote:
> Craig,
> 
> I am running Oracle 9g. What I did was use the Oracle.schema file to
> create the database. Then followed the instruction in the Oracle.README
> file (all provided in the RT package).  Then run the configure command
> with all the options for your database (make sure to use
> --with-db-type=Oracle).  When running 'initialize-database', I commented
> out line 136 that calls insert_schema() since I already created the
> schema. The database should be initialized fine. The command I used for
> this is: $ /pathto/rt/sbin/rt-setup-database --action init --dba
> password --prompt-for-dba-password.
> 
> As for seeing 'Preferences' on the GUI, make sure the group of people
> you want to have this option has the right 'ModifySelf'.  That will
> toggle the 'Preferences' link.
> 
> ** Adam
> 
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Jesse
> Vincent
> Sent: Wednesday, October 26, 2005 7:15 AM
> To: Craig Stevenson
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] oracle setup
> 
> 
> 
> 
> On Tue, Oct 25, 2005 at 05:10:11PM -0500, Craig Stevenson wrote:
> > Hi:
> > 
> > I have been working for a few days on getting RT installed on my
> system.
> > 
> > My system: redhat, oracle 10g, latest perl, and latest apache
> > 
> > The install scripts seem to balk on the oracle stuff.
> > --- I would appreciate any pointers incorporating Oracle to play with 
> > RT ---
> > 
> > I can drop and schema using sqlplus.  I cannot run the 
> > rt-setup-database on 'acl' or 'insert' option options.  I can do 
> > partial inserts of the tables.
> 
> How does setting up the tables fail?  What happens if you create the
> tables by hand?
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Buy your copy of our new book, RT Essentials, today! 
> 
> Download a free sample chapter from http://rtbook.bestpractical.com
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Buy your copy of our new book, RT Essentials, today! 
> 
> Download a free sample chapter from http://rtbook.bestpractical.com
-- 
Jim Meyer, Geek at Large                  jmeyer at dreamworksanimation.com