ITPub博客

首页 > 数据库 > Oracle > 02_Getting Started with the Oracle Server

02_Getting Started with the Oracle Server

原创 Oracle 作者:一休哥哥哥哥哥 时间:2014-10-23 23:40:08 0 删除 编辑
这章实在是没什么好写的就直接扒联机文档上的内容了
主要介绍了:
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博客 ” ,链接:https://blog.itpub.net/29773696/viewspace-1308473/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-07-28

  • 博文量
    5
  • 访问量
    8347