SQL Performance (MOSC)

MOSC Banner

SQLT XECUTE error out

edited Mar 25, 2014 12:00PM in SQL Performance (MOSC) 2 commentsAnswered

Hello,

We have a Oracle 11.2.0.1.0 RAC DB on Linux 5.3. I need to update SR and in this environment, I have trouble with SQLT. I have installed it latest but when I try to use it (XECUTE) getting this error:

SQL> grant SQLT_USER_ROLE to NPCDB;

Grant succeeded.

SQL> START run/sqltxecute.sql input/upd_bad.sql

BEGIN

*

ERROR at line 1:

ORA-20110: User "NPCDB" lacks required "SQLT_USER_ROLE" role or SQLT is not properly installed.

Review installation NN_*.log files.

ORA-06512: at line 6

----

I uploaded install logs for your review.

Thanks in advance for your help.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center