[otrs] Installation on Oracle 9.2

EXT / CAP GEMINI LEBLANC Bastien ext.cap-gemini.leblanc at sncf.fr
Tue Oct 17 12:40:54 CEST 2006

Just resolved the issue on my own for the installation!

The constraints were created before the insert. Then we tried several times the insert, so the sequence were not initialised.

After a re_run of:
1) otrs-schema.oracle.sql
2) initial_insert.sql
2) otrs-schema-post.oracle.sql

All the data and structure is inserted fine.

But my second question is still to be answered, does someone allready running OTRS 2.x on Oracle with Success, what are the things to care about?

Thank you!

Bastien Leblanc - Administrateur Peoplesoft
int: 30 01 69
ext: 01 56 33 01 69
-----Message d'origine-----
De : otrs-bounces at otrs.org [mailto:otrs-bounces at otrs.org] De la part de EXT / CAP GEMINI LEBLANC Bastien
Envoyé : lundi 16 octobre 2006 18:01
À : otrs at otrs.org
Objet : [otrs] Installation on Oracle 9.2


I am trying to install OTRS 2.1 for my client under Oracle 9.2.
The problem comes with the initial insert script.
All the insert statements are based on the "AUTO_INCREMENT" status of the tables. But this doesn't exist in Oracle.
I found one mail in the mailing list archives about someone writing a patch.

My question is, is there someone who allready wrote a patch for these insert (and maybe also for the rest of the code?)

Second question, do you recommand using Oracle anyway?

Thank you for your answer
Bastien Leblanc - Peoplesoft Administrator


More information about the otrs mailing list