Trying this :
create index doc_index ON tbltestintermediatextsearch(Business_Name)
indextype is ctxsys.context;

Telling me this:
ORA-29925: cannot execute CTXSYS.TEXTINDEXMETHODS.ODCIINDEXCREATE

Apparently because the appropriate system-defined role (CTXSYS or CTXAPP) is not set up.

I am just trying to index a field for a text search what or where are "CTXSYS or CTXAPP". How can I set them up ?

Thanks
Conor.