How to install Oracle logminer

Oracle logminer is a very effective log analysis tool provided by Versions later than 8i. It can obtain the specific content of the log file, such as the DML operation of Oracle, and possibly obtain the SQL statement for transaction rollback, this is sometimes very useful.

Logminer must be installed as SYS:

SQL> Conn/As sysdba
Connected.

The logminer installation package is stored in rdbms/admin/dbmslm. SQL and RDBMS/admin/dbmslmd. SQL. There are two files in total.

First execute the first one:

SQL> @? /Rdbms/admin/dbmslm

The package has been created.

Authorization successful.

This package is used to create the dbms_logmnr package for log analysis.

Then execute the second one:

SQL> @? /Rdbms/admin/dbmslmd

The process has been created.

No error.

Authorization successful.

This package is used to create the dbms_logmnr_d data dictionary package for log analysis;

So far, installation is complete!