Error After upgrading from MySQL to Oracle DB

[nmz]

I'm planning to use OTRS with oracle. I have already running test otrs server with MySQL. I migrated data to Oracle from MySQL. But I can't create a new ticket when I'm using with OTRS. There's you can check it out about error log.

ORA-00932: inconsistent datatypes: expected CHAR got BLOB (DBD ERROR: error possibly near <*> indicator at char 119 in '
SELECT user_id, preferences_value
FROM user_preferences
WHERE preferences_key = :p1 AND LOWER(<*>preferences_value) LIKE LOWER(:p2)'), SQL: '
SELECT user_id, preferences_value
FROM user_preferences
WHERE preferences_key = ? AND LOWER(preferences_value) LIKE LOWER(?)'

PS : I used this links http://www.oracle.com/technetwork/datab ... 93223.html as ref to migrate data.

[root]

Wrong tool, try the add on OTRSCloneDB

[nmz]

I got another when trying with CloneDB. Error is Could not generate structure in target database! Please make sure the target database is empty.
I'm pretty sure I'm using with Fresh database. I'm using otrs version 5.0.9 and CloneDB version is 5. Too band I can't attach image file.

[root]

Drop database and recreating solves this

[nmz]

Drop database and recreating solves this

Thanks for you reply. I did it and still doesn't work.

[root]

What permissions did you gave to the mysql user OTRS is using?

[nmz]

What permissions did you gave to the mysql user OTRS is using?

MySQL user have full privileges to use OTRS.