Oracle Errors

RT Users
1

I have been trying to install RT the past few days and have run into
a few issues with it and Oracle. I am installing it on CentOS 4.1,
and Oracle 10G release1, and RT 3.5.7. The software installed just
fine but when I run the intialize DB step I get this error.

[root@node86 rt3]# sbin/rt-setup-database --action init --dba rt –
prompt-for-dba-password
In order to create or update your RT database,this script needs to
connect to your Oracle instance on localhost as rt.
Please specify that user’s database password below. If the user has
no database
password, just press return.

Password:
Now creating a database for RT.
…skipped as rt is not rt or we’re working with Oracle.
Now populating database schema.
Creating database schema.
Problem with statement:

CREATE SEQUENCE OBJECTCUSTOMFIELDS_seq
ORA-00955: name is already used by an existing object (DBD ERROR:
error possibly near <*> indicator at char 18 in ’

CREATE SEQUENCE <*>OBJECTCUSTOMFIELDS_seq’) at sbin/rt-setup-database
line 212.

Looking at the database reveals it has created some entries up to
this error…

So, I read in the archives this entry http://lists.bestpractical.com/
pipermail/rt-users/2005-October/034857.html
. It suggested running the create schema manually which I did. But
that gives some errors too.

CREATE SEQUENCE OBJECTCUSTOMFIELDS_seq
ERROR at line 1:
ORA-00955: name is already used by an existing object

CREATE TABLE ObjectCustomFields (
ERROR at line 1:
ORA-00955: name is already used by an existing object

CREATE SEQUENCE OBJECTCUSTOMFIELDVALUES_seq
ERROR at line 1:
ORA-00955: name is already used by an existing object

SP2-0734: unknown command beginning “Content V…” - rest
of line ignored.
SP2-0734: unknown command beginning “LargeConte…” - rest of line
ignored.
SP2-0734: unknown command beginning “ContentTyp…” - rest of line
ignored.
SP2-0734: unknown command beginning “ContentEnc…” - rest of line
ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning “Creator N…” - rest
of line ignored.
SP2-0734: unknown command beginning “Created D…” - rest
of line ignored.
SP2-0734: unknown command beginning “LastUpdate…” - rest of line
ignored.
SP2-0734: unknown command beginning “LastUpdate…” - rest of line
ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning “Disabled N…” - rest of line
ignored.
SP2-0042: unknown command “)” - rest of line ignored.
CREATE INDEX ObjectCustomFieldValues1 ON ObjectCustomFieldValues
(Content)
ERROR at line 1:
ORA-00942: table or view does not exist

CREATE INDEX ObjectCustomFieldValues2 ON ObjectCustomFieldValues
(CustomField,ObjectType,ObjectId)
ERROR at line 1:
ORA-00942: table or view does not exist

Can I just ignore these errors? are they indicative of some other
larger issue?

Thanks for any help!

Shawn Plummer
Systems Manager
CIT SUNY Geneseo
“The mind can make substance, and people planets of its own with
beings brighter than have been, and give a breath to forms which can
outlive all flesh.” -Lord Byron

smime.p7s (2.42 KB)

2

I have been trying to install RT the past few days and have run into
a few issues with it and Oracle. I am installing it on CentOS 4.1,
and Oracle 10G release1, and RT 3.5.7. The software installed just
fine but when I run the intialize DB step I get this error.
There is atleast one problem that I have spotted and that is that
schema.Oracle contains two empty lines in CREATE TABLE
ObjectCustomFieldValues which don’t belong there.
That is the second set of errors you get. The first is an indication
that an sequence with that name already exists in the schema of that
Oracle users you’re RT installing in.

What I have done with all my Oracle installations is to create a rt_user
and grant resouce,connect,dba to it, install RT and revoke the DBA right
is needed.
This way you don’t need to know the password of the system account and
don’t have problems system creating tables for rt_user.
So, if something goes wrong during populating/making the Oracle schema,
drop the user and start all over again with a fresh empty user.

Joop

PS:
Will try, later today or tomorrow, latest release on a OracleXE db just
for fun :wink:

Joop van de Wege JoopvandeWege@mococo.nl

3

There is atleast one problem that I have spotted and that is that
schema.Oracle contains two empty lines in CREATE TABLE
ObjectCustomFieldValues which don’t belong there.
That is the second set of errors you get. The first is an indication
that an sequence with that name already exists in the schema of that
Oracle users you’re RT installing in.

Oracle can’t handle newlines in schema definitions? Or is it something
else choking? Regardless, I’ve removed them. Thanks.

Jesse

4

There is atleast one problem that I have spotted and that is that
schema.Oracle contains two empty lines in CREATE TABLE
ObjectCustomFieldValues which don’t belong there.
That is the second set of errors you get. The first is an indication
that an sequence with that name already exists in the schema of that
Oracle users you’re RT installing in.

Oracle can’t handle newlines in schema definitions? Or is it something
else choking? Regardless, I’ve removed them. Thanks.
No not Oracle itself but SQLPlus is the culprit. Just tried it and
ofcourse used my favourite tool, which isn’t SQLPlus, and it worked with
newlines in the create table statement. SQLPlus certainly doesn’t.

Joop

Joop van de Wege JoopvandeWege@mococo.nl

5

Oracle can’t handle newlines in schema definitions? Or is it something
else choking? Regardless, I’ve removed them. Thanks.

No not Oracle itself but SQLPlus is the culprit. Just tried it and
ofcourse used my favourite tool, which isn’t SQLPlus, and it worked with
newlines in the create table statement. SQLPlus certainly doesn’t.

Joop

But. But. We’re not using SQLPlus. Anyway. I’ve patched the schema file.

Thanks.

Jesse

signature.asc (189 Bytes)