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

[support at pureview.com]

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,


> Support wrote:
>>
>>
>>
>> [root at 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
>
>