Monitor the progress of Oracle session

Monitor the progress of Oracle session

Some of my fun tools I have created during my free time. :)

Progress Monitor a monitoring tool for monitor long running processes like RMAN backup, export, statistics gathering.

• bakstatus.exe is the main executable file
• bakstatus.exe.config – configuration file. Key1 is the sys password, Key2 is the connection string
• Oracle.DataAccess.dll – the required oracle ddl file
• Inprt : program : Enter the name of the program (eg RMAN for RMAN backup, EXP for export, GATHER for statistics)
• 2 progress bar indicating the amount of percentage to be complete.

 

 

Download Files
bakstatus.exe
bakstatus.exe.config

Dataguard Monitor (tool)

Dataguard Monitor

Some of my fun tools I have created during my free time. :)

Dataguard Monitor a monitoring tool for monitor the log shipping to dataguard server. It will auto upgrade every minute. The status show the current status of the recovery process and the archive log number/instance node currently applied. The log not apply show the number of archive log waiting to be apply.

• DGcheck.exe is the main executable file
• Dgcheck.exe.config – configuration file. Key1 is the sys password, Key2 is the connection string
• Oracle.DataAccess.dll – the required oracle ddl file

Setup

1. Download oracle odp.net ODAC1120320Xcopy_32bit from Oracle website
2. Extract the zip file to c:\temp
3. Install using the command
1.  install.bat odp.net20 c:\oracle\odp odp
2. (to uninstall uninstall all c:\oracle\odp)
4. Unzip to the dataguard_status.zip
5. Execute the DGcheck.exe

Download Files

DGcheck.exe

DGCheck.config