Introduction to Oracle System utilities

1, Application development (application Development)

Sql*plus E:\Oracle\Ora81\BIN\SQLPLUSW. Exe

2. Database management (DB administration)

DB Configuration Assistant Database Configuration Assistant: Creating, configuring, and deleting Databases

DBA Studio merges multiple database tools into one application. DBA Studio manages the following objects:

Routines: Includes startup, shutdown, and routine routines.

Scenario: Includes tables, indexes, and Oracle8 objects.

Security: Includes user accounts, roles, and permissions.

Storage: Includes table spaces, data files, and fallback segments.

Tools for Sqlplus Worksheet class Sql*plus

E:\Oracle\Ora81\bin\oemapp.bat Worksheet

3. Enterprise Manager (Enterprise Manager)

Configuration Assistant Oracle Enterprise Manager configuration aids to manage the server data archive

Console Login OEM Manager (Oracle Enterprise Manager)

4, the Transplant tool (migration Utilities)

Oracle Data Migration Assistant porting Oracle7 database, upgrading Oracle8 to Oracle8i

5, network Management (network administration)

NET8 Assistant Configuration Network section (connection description tnsnames.ora, listener Listener.ora)

Net8 Configuration Assistant functions are basically the same, provide basic configuration, to obtain advanced configuration operations, or to configure other parts of Net8 that are not included in this tool, use Net8 Assistant Oracle ODBC Test Connection, Tools for testing Oracle ODBC

6, the DOS window of the utility program

SVRMGRL Oracle Server Management: Oracle Servers Manager

E:\Oracle\Ora81\BIN\SVRMGRL. Exe

Sql*plus used under Sql*plus dos windows

E:\Oracle\Ora81\BIN\SQLPLUS. Exe

LSNRCTL Listener Management Program

E:\Oracle\Ora81\BIN\LSNRCTL. Exe

Exp/imp logical Backup, Recovery tool

E:\Oracle\Ora81\BIN\EXP. EXE, E:\Oracle\Ora81\BIN\IMP. Exe

Sql*loader a large number of data insertion tools

E:\Oracle\Ora81\BIN\SQLLDR. Exe

Orapwd to modify the SYS or internal password tool

E:\Oracle\Ora81\BIN\ORAPWD. Exe

Ocopy Oracle Copy Tool

E:\Oracle\Ora81\BIN\OCOPY. Exe