asked on

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..

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

slightwv (䄆 Netminder)

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.

SOLUTION

OP_Zaharin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

slightwv (䄆 Netminder)

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.