configure logminer

Posted on 2011-04-27
Medium Priority
Last Modified: 2012-05-11
was trying to configure logminer
also I set in the pfile
manually created the directory also in C:\log_sunu_miner
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..
Question by:nobleit
  • 3
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 1300 total points
ID: 35480337
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.
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35480351
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.
LVL 23

Assisted Solution

OP_Zaharin earned 700 total points
ID: 35481321
- here is a step by step to configure a logminer, if it helps:

LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35490964
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.

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses
Course of the Month15 days, 2 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question