Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLnet trace

2670775Apr 18 2017 — edited Apr 20 2017

I have a sqlnet.ora like the following :

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/app/oracle

So is the trace enabled ?

Comments

Herald ten Dam
Hi,

welcome.

The user who made the index, does it have the role CTXAPP? Otherwise you need to grant this role to the user. 
grant CTXAPP to your_user;
Otherwise you need explicitly grant execute rights of the package CTX_DOC to this user.
The owner of the package is CTXSYS. 
grant execute on ctxsys.ctx_doc to your_user;
If there are still problems, it will be better to post in the TEXT forum.

Herald ten Dam
htendam.wordpress.com
776964
Unfortunately, that doesn't seem to work either:

grant execute on ctxsys.ctx_doc to sysadm
*
FOUT in regel 1:
.ORA-04042: procedure, function, package, or package body does not exist

Thanks for your reply. I will continue this in the right forum.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 18 2017
Added on Apr 18 2017
#general-database-discussions
15 comments
1,062 views