SQL Performance (MOSC)

MOSC Banner

SQLT install db 12.2.0.1.0

edited Sep 16, 2018 9:15AM in SQL Performance (MOSC) 4 commentsAnswered

Getting dreaded

BEGIN

  IF ^^role_count. < 1 THEN

    RAISE_APPLICATION_ERROR(-20109, 'User "'||USER||'" lacks required "^^role_name." role. Request to your DBA: "GRANT ^^role_name. TO '||USER||';".');

  END IF;

  IF ^^lib_count. < 17 THEN

    RAISE_APPLICATION_ERROR(-20110, 'User "'||USER||'" lacks required "^^role_name." role or SQLT is not properly installed. Review installation NN_*.log files.');

  END IF;

END;

Error report -

ORA-20110: User "ATEA_SCM" lacks required "SQLT_USER_ROLE" role or SQLT is not properly installed. Review installation NN_*.log files.

chnaged ORA_STIG_PROFILE as per other thread to NULL

select profile, limit from dba_profiles where resource_name = 'PASSWORD_VERIFY_FUNCTION';

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