Introduction to Oracle system utilities

Source: Internet
Author: User
1. Application Development SQL * PlusE: OracleOra81BINSQLPLUSW. EXE2 and database administration DatabaseConfigurationAssistant Database Configuration ASSISTANT: Create, configure, and delete databases. DBAStudio integrates multiple database tools into one application. DBAStud

1. Application Development SQL * PlusE: \ Oracle \ Ora81 \ BIN \ SQLPLUSW. EXE 2. Database Management DatabaseConfigurationAssistant Database Configuration ASSISTANT: Create, configure, and delete databases. DBAStudio integrates multiple database tools into one application. DBAStud

1. Application Development)

SQL * Plus E: \ Oracle \ Ora81 \ BIN \ SQLPLUSW. EXE

2. Database Administration)

Database Configuration Assistant: Create, configure, and delete Databases

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

Examples: including startup, shutdown, and routine routines.

Solution: includes tables, indexes, and Oracle8 objects.

Security: includes user accounts, roles, and permissions.

Storage space: Includes tablespaces, data files, and rollback segments.

SQLPlus Worksheet SQL * Plus Tool

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

3. Enterprise Manager)

Configuration Assistant Oracle Enterprise Manager Configuration auxiliary tools to manage the archives

Console logon to the OEM Manager (Oracle Enterprise Manager)

4. Migration tool (Migration Utilities)

Oracle Data Migration Assistant Port Oracle7 database and upgrade Oracle8 to Oracle8i

5. Network Administration)

Net8 Assistant network configuration section (connection description TNSNAMES. ORA, LISTENER. ORA)

The Net8 Configuration Assistant function is similar to the preceding one. It provides basic configurations. For advanced Configuration operations, or for details about configuring other parts of Net8 not included in this tool, use Net8 Assistant Oracle ODBC Test to connect to and Test Oracle ODBC

6. DOS window utilities

SVRMGRL Oracle Server Management: Oracle Server Manager

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

SQL * Plus used in the SQL * Plus DOS window

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

LSNRCTL listener Management Program

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

EXP/IMP logical backup and recovery tools

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

SQL * Loader large data insertion Tool

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

ORAPWD tool for changing sys or internal passwords

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

OCOPY Oracle copy Tool

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.