Installing RT with Oracle 11g: ERROR: as user 'rt': ORA-01017

RT Users
1

I need help installing RT with Oracle 11g as a backend database. Also I have
set the env for oracle.

I was able to to logon to Oracle using sqlplus using rt user name and rt
password. Any one can help me to initialize rt with oracle.

ERROR: Failed to connect to dbi:Oracle:sid=rt;host=IP Address;port=1530 as
user ‘rt’: ORA-01017: invalid username/password; logon denied (DBD ERROR:
OCISessionBeg

I know I testedfd the user fine and logon to sqlplus fine.

Thanks

My Server Info

RH 6 64bit

RT-4.2.1

–with-db-type=Oracle \

–with-db-database=rt \

–with-db-host=IP Address \

–with-db-port=1530 \

–with-db-dba=system \

–with-db-rt-user=rt \

–with-db-rt-pass=password@rt \

–with-web-user=apache \

–with-web-group=apache \

–with-rt-group=rt \

–prefix=/opt/rt4 \

–enable-graphviz \

–enable-gd \

–enable-gpg

[root@toldav:rt-4.2.1]# make initialize-database

/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database
–action init --prompt-for-dba-password

In order to create or update your RT database, this script needs to connect
to your Oracle instance on IP Adddress (port ‘1530’) as rt

Please specify that user’s database password below. If the user has no
database

password, just press return.

Password:

Working with:

Type: Oracle

Host: IP address ( Also I have try with localhost, fqdn and no host and it
did not work)

Port: 1530

Name: rt

User: rt

DBA: rt

Failed to connect to dbi:Oracle:sid=rt;host=IP Address;port=1530 as user
’rt’: ORA-01017: invalid username/password; logon denied (DBD ERROR:
OCISessionBeg

2

Support wrote:

[root@toldav:rt-4.2.1]# make initialize-database

/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib
sbin/rt-setup-database --action init --prompt-for-dba-password

In order to create or update your RT database, this script needs to
connect to your Oracle instance on IP Adddress (port ‘1530’) as rt

Please specify that user’s database password below. If the user has no
database

password, just press return.

Password:

Working with:

Type: Oracle

Host: IP address ( Also I have try with localhost, fqdn and no host
and it did not work)

Port: 1530

Name: rt

User: rt

DBA: rt

Failed to connect to dbi:Oracle:sid=rt;host=IP Address;port=1530 as
user ‘rt’: ORA-01017: invalid username/password; logon denied (DBD
ERROR: OCISessionBeg

From this I suspect that RT wants the system account and pw to create
the rt user.
Could you try and see if that works?

Joop

3

Joop,

Thanks for the replay. I already created the user in Oracle like this:
CREATE USER rt IDENTIFIED BY rtpassword
DEFAULT TABLESPACE rtdata
TEMPORARY TABLESPACE temp
QUOTA 0 ON system
PROFILE default;
GRANT CONNECT,RESOURCE TO rt;
GRANT ALL PRIVILEGES TO rt;

See the error below:
ERROR: Couldn’t create user RT identified by password.
Error: ORA-01920: user name ‘RT’ conflicts with another user or role name
(DBD ERROR: error possibly near <> indicator at char 12 in 'CREATE USER
<>RT IDENTIFIED BY password default tablespace USERS temporary tablespace
TEMP quota unlimited on USERS’)

Could I still install with rt Oracle user in place already. If that is
true what would be the new configuration file? What options should I
omit…!

Thank you,

4

Could I still install with rt Oracle user in place already. If that is
true what would be the new configuration file? What options should I
omit…!

sbin/rt-setup-database --action init --skip-create

  • Alex
5

Alex,

It works!!

Thanks a lot.
-David> On Sat, 2013-12-14 at 18:43 -0500, support@pureview.com wrote:

Could I still install with rt Oracle user in place already. If that is
true what would be the new configuration file? What options should I
omit…!

sbin/rt-setup-database --action init --skip-create

  • Alex