configure logminer

was trying to configure logminer
also I set in the pfile
utl_file_dir='C:\log_sunu_miner'
manually created the directory also in C:\log_sunu_miner
but.....
SQL> alter system set utl_file_dir='C:\log_sunu_miner' scope=spfile;

System altered.
ISQL> show parameter utl_file_dir;

NAME                                 TYPE        VALUE                          
------------------------------------ ----------- ------------------------------
utl_file_dir                         string                                    
no value it is supposed to show the value..
nobleitAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
You specified 'scope=spfile'. Yopu need to bounce the instance so the spfile is read.

Some parameters can be set with 'scope=both' which is memory and spfile.
0
 
slightwv (䄆 Netminder) Commented:
On mobile right now so cannot look it up but utl_file_dir is being phased out.  Not sure if it is still needed for logminer in newer versions.

Please confirm this is necessary for your version.
0
 
OP_ZaharinConnect With a Mentor Commented:
- here is a step by step to configure a logminer, if it helps:

http://oracle-tns.com/step-by-step-logminer/
0
 
slightwv (䄆 Netminder) Commented:
Can I ask why you selected the answer you did?

The question asked was why you cannot see the value of utl_file_dir.  That was answered in http:#a35480337.

If you wanted a step-by-step guide on how to set up log miner, you should have asked that.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.