Advanced Oracle Utilities Windows Executables

Advanced Oracle Utilities: The Definitive Reference by Rampant TechPress is written by top Oracle database experts (Bert Scalzo, Donald Burleson, and Steve Callan).  The following is an excerpt from the book.

The following table lists the Windows executables provided by Oracle.   Many of the utilities provided in UNIX are also available in Windows.  This list has been restricted to those utilities that are only present on the Windows platform.

 

Executable	Description	First Available
dbsnmp.exe	Intelligent Agent	8.1.5
dbsnmpj.exe	Intelligent Agent Job Processor (nothing to do with Java or JRE)	8.1.5
encaps.exe	SNMP encapsulation agent	Default in 9.0.1 Custom in 8i and below
encsvc.exe	SNMP encapsulation service	Default in 9.0.1 Custom in 8i and below
launch.exe	Java code launcher	8.0
launchem.exe	Enterprise Manager Launcher	8.0
ocopy.exe	File copy utility	(7.3.4)
OMSNTsrv.exe	Oracle Management Server	9.2.0
omtsreco.exe	MTS Recovery	9.0.1
OO4OCODEWIZ.EXE	Oracle Objects for OLE Code Wizard	9.2.0
OracleAdNetConnect.exe	MFC Application	8.1.7
OracleAdNetTest.exe	MFC Application	9.0.1
oradim.exe	Manages oracle instances	(7.3.4)
orakill.exe	Process killer	(7.3.4)
oramts_deinst.exe	Unknown	9.2.0
Orastack.exe	Modifies stack RAM	(7.3.4)
Pagntsrv.exe	OEM Paging Server	9.0.1
tdvapp.exe	Trace Data Viewer	9.0.1
Selecthome.bat	Change oracle home	10gR2
Isqlpussvc	Isqlplus service startup	10gR2
VDOShell.exe	Oracle Expert	9.0.1
vmq.exe	SQL Analyze	9.0.1
Vtushell.exe	OEM Index Tuning Wizard	9.0.1
xpautune.exe	Oracle Expert	9.0.1
xpcoin.exe	Oracle Expert	9.0.1
xpksh.exe	Oracle Expert Command Shell	9.0.1
xpui.exe	Oracle Expert	9.0.1

Summary

This chapter defined a utility in terms relevant to an Oracle professional.  The DBA now has a list of available utilities, as well as a mechanism, the query above that uses a dblink, to discover them in the future - be it binary executables, supplied Oracle packages, new instance parameters, system events, or new v$ views. 

 

This chapter listed many potential Oracle utilities - those that reside in either the database itself or the $ORACLE_HOME/bin directory. The next chapter will begin the exploration and detailed analysis of the most useful Oracle utilities.  The journey starts by showing those utilities that the DBA can use for general administration functions. Not every available Oracle utility will be covered, but the most useful utilities for the Oracle developer and DBA will be reviewed.

---