You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

change LOB_SIGNATURE_ENABLE parameter on ATP database 19c

Question
13
Views
0
Comments
edited Apr 16, 2022 7:55AM in Autonomous Database

Summary

ADMIN user cant do this?

Content

Hello,

I have one ATP always free DB  version 19c with small APEX application. This Cloud  ATP database gets data from onpremise database via dblink.

Im inserting records with BLOB to store file contents and show it in APEX application. Everything works fine until last week, when inserting LOB started to fail with error ORA-64219: invalid LOB locator encountered.  I tried to solve it with SR over oracle support. I got advice - try  to change  database parameter LOB_SIGNATURE_ENABLE from FALSE to TRUE. The problem is how to do it.  This can do only SYSKM user which is locked and to unlock it I need sys as sysdba login, that I havent.  I have only ADMIN user to Cloud ATP database.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!