Database-Oracle [Introduction to Oracle system utilities]

Source: Internet
Author: User

1. Application Development)

SQL * Plus E: \ oracle \ ora81 \ bin \ sqlplusw. exe

2. database administration)

Database Configuration assistant database configuration ASSISTANT: Create, configure, and delete Databases

DBA studio integrates multiple database tools into one applicationProgram. 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 server 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.