Oracle Tools or Useful Utilities

Oracle Tools or Useful Utilities	Description	Purpose
adrci	Automatic Diagnostic Repository	ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database Release 11g. ADRCI enables you to: ·         View diagnostic data within the Automatic Diagnostic Repository (ADR). ·         View Health Monitor reports. ·         Package incident and problem information into a zip file for transmission to Oracle Support.
asmca	ASM Configuration Assistance	Oracle ASM Configuration Assistant (ASMCA) supports installing and configuring ASM instances, disk groups, volumes, and Oracle Automatic Storage Management Cluster File System (Oracle ACFS).
asmcmd		ASMCMD is a command-line utility that you can use to easily view and manipulate files and directories within Automatic Storage Management (ASM) disk groups. It can list the contents of disk groups, perform searches, create and remove directories and aliases, display space utilization, and more.
cluufy	Cluster verification utility	Oracle provides Cluster Verification Utility (CVU) to perform system checks in preparation for installation, patch updates, or other system changes. Learning how to use CVU can ensure that you have completed the required system configuration and preinstallation steps so that your installation, update, or patch operation completes successfully
crsctl		CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects. Oracle Clusterware 11g release 2 (11.2) introduces cluster-aware commands with which you can perform check, start, and stop operations on the cluster
dbca	Database Configuration  Assistant	To create and configure a database
dgmgrl	Data Guard command-line interface	Data Guard command-line interface (CLI) to create, manage, and monitor a broker configuration.
emca	Enterprise Manager  Configuration Assistant	Oracle Enterprise Manager Configuration Assistant (EMCA) provides a command-line interface for configuring Database Control
emctl	Enterprise Manager  Command line Utility
expdp	Oracle data pump export	Data Pump Export (hereinafter referred to as Export for ease of reading) is a utility for unloading data and metadata into a set of operating system files called a dump file set.
impdp	Oracle data dump import	Data Pump Import (hereinafter referred to as Import for ease of reading) is a utility for loading an export dump file set into a target system
gridcontrol	Oracle Grid Control	Enterprise Manager Grid Control is Oracle's single, integrated solution for managing all aspects of the Oracle Grid and the applications running on it. Enterprise Manager also allows you to manage single instances of Oracle Database, Application Server, or Collaboration Suite using standalone consoles.
dbcontrol	Oracle database control	The Web-based Database Control serves as the primary tool for managing your Oracle database and sets a new standard in ease-of-use. It is installed with the database.
Lsnrctl	Oracle Listener Control	Start, stop and configure listeners
Netca	Net Configuration Assistant	Utility for configuring SQL*Net.
netmgr	Net Manager	A tool that combines configuration abilities with component control to provide an integrated environment for configuring and managing Oracle Net Services
oifcfg	Oracle Interface Configuration  tool	The Oracle Interface Configuration Tool (OIFCFG) command-line interface helps you to define and administer network interfaces
OS utilities - ssh	Secure Shell	Used to connect to servers
Utilities – vncviewer	Utility	Viewer/client for Virtual Network Computing
oui	Oracle Universal Installer	Used to install Oracle Products
rman	Oracle Recovery Manager	Oracle Recovery Manager satisfies the most pressing demands of performant, manageable backup and recovery, for all Oracle data formats
sqldeveloper	Dev environment	Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle
Sqlldr	SQL loader	SQL loader used to load data into Oracle object
Sqlplus	SQLplus	SQLPLUS client is used to connect to database
Srvctl
tkprof	Program	The TKPROF program converts Oracle trace files into a more readable form.
vi/gedit	Editor	vi is editor used in Unix