ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10758: index owner does not have the privilege to use file or URL datastore

 Oracle was upgraded from 12c to 19c.

When creating index using Oracle Text, it gave the followings:

ERROR [com.n.oss.server.scontainer.persistence.schemagen.PersistenceSchemaManager] Error in amendAfter class com.n.secureaccess.server.migration.all_versions.SecureAccessAmender

SQL problem: java.sql.SQLException: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-20000: Oracle Text error:

DRG-10758: index owner does not have the privilege to use file or URL datastore

ORA-06512: at "CTXSYS.DRUE", line 186

ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 320

Solution:

Note, beginning 18.1, instead of setting the FILE_ACCESS_ROLE no longer exists.  Instead grant TEXT DATASTORE ACCESS role to the user that needs to use FILE or URL datastore:

-- For example:

grant TEXT DATASTORE ACCESS to myuser;

grant TEXT DATASTORE ACCESS to scott;