02_Getting Started with the Oracle Server

最新推荐文章于 2025-12-04 15:25:15 发布

转载最新推荐文章于 2025-12-04 15:25:15 发布 · 168 阅读

文章标签：

本文介绍了Oracle提供的几种关键工具，包括Oracle Universal Installer (OUI)，用于安装和配置Oracle软件；SQL*Plus，一种交互式和批处理查询工具，允许用户执行SQL、PL/SQL等命令；以及Enterprise Manager (EM)，一种系统管理工具，提供集中化的数据库环境管理，帮助诊断、修改和调整数据库性能。

这章实在是没什么好写的就直接扒联机文档上的内容了
主要介绍了:
oracle universal installer(OUI)
sql*plus
enterprise manager(em)

SQL*plus
SQL*Plusis an interactive and batch query toolincluded in every Oracle Database
installation. It has a command-line user interface that acts as the client when
connecting to the database.
SQL*Plus has its own commands and environment. It enables you to enter and execute
SQL, PL/SQL, SQL*Plus and operating system commands to perform tasks such as:
■ Formatting, performing calculations on, storing, and printing from query results
■ Examining table and object definitions
■ Developing and running batch scripts
■ Administering a database
You can use SQL*Plus to generate reports interactively, to generate reports as batch
processes, and to output the results to text file, to screen, or to HTML file for browsing
on the Internet. You can generate reports dynamically using the HTML output facility.

具体使用方法: http://docs.oracle.com/cd/E11882_01/server.112/e16604/toc.htm

Enterprise manager
Oracle Enterprise Manager (Enterprise Manager)is a system management tool that
provides centralized management of a database environment. Combining a graphical
console, Oracle Management Servers, Oracle Intelligent Agents, common services, and
administrative tools, Enterprise Manager provides a comprehensive systems
management platform for Oracle products.
The Web-based Enterprise Manager Database Control (Database Control)is the
primary tool for managing an Oracle database. It is installed with Oracle Database.
You can use Database Control to perform administrative tasks such as:
■ Diagnosing, modifying, and tuning the database
■ Grouping related targets together to facilitate administration tasks, sharing tasks
with other administrators, and scheduling tasks at varying time intervals
■ Configuring and managing Oracle Net Services for an Oracle home(see
"Overview of Oracle Networking Architecture"on page 16-5)
■ Launching integrated Oracle and third-party tools
The following figure shows the Database Home page of Database Control. The
subpage links across the top of the page enable you to access performance, availability,
and other database administration pages. The subsections of the Database Home page
provide information about the environment and status of the database.

具体使用方法: http://docs.oracle.com/cd/E11882_01/timesten.112/e21649/toc.htm

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29773696/viewspace-1308473/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29773696/viewspace-1308473/