Harvest

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

TECH TIP: Oracle Error DBMS_LOB.GETLENGTH:invalid identifier

  • 1.  TECH TIP: Oracle Error DBMS_LOB.GETLENGTH:invalid identifier

    Posted Jan 13, 2016 10:24 AM

    Environment: Oracle 12C R2 (12.1.0.2)  Harvest R12.6

     

    Problem: Attempt to login to Harvest administrator GUI results in an Oracle error:

    AdminGUIOracleLoginError.png

     

    Possible solution:

    Have the DBA grant execute privileges to the harvest schema owner, example:

    grant execute on dbms_lob to cascm;

    grant execute on dbms_lob to harvest;