DB Creation   «Prev  Next»

Lesson 1

Oracle Shared Server Database Architecture

SQL*Plus is a command-line tool that provides access to the Oracle RDBMS. SQL*Plus enables you to:
  1. Enter SQL*Plus commands to configure the SQL*Plus environment.
  2. Startup and shutdown an Oracle database.
  3. Connect to an Oracle database.

Oracle's Shared Server Database Architecture

This module teaches you about Oracle's Shared Server Database Architecture, which was the successor to Oracle Server Manager, a utility that was formally used to manage Oracle databases. When you are finished with this module, you will understand how SQL*Plus allows you to interact with Oracle tables.
  1. Start SQL*Plus and connect to a database
  2. Get help for Shared Server commands
  3. List the columns in a table or a view
  4. Use SQL *Plus to select data from a database
  5. Write output to a file

Managing Databases in the cloud with Enterprise Manager Cloud Control 12c

Oracle Enterprise Manager is Oracle's integrated enterprise information technology (IT) management product line, which provides the industry's only complete, integrated, and business-driven enterprise cloud management solution. Oracle Enterprise Manager creates business value for IT by leveraging the built-in management capabilities of the Oracle stack for traditional and cloud environments, enabling customers to achieve unprecedented efficiency gains while dramatically increasing service levels. The key capabilities of Enterprise Manager include: (See Figure 2 below)
  1. A complete cloud lifecycle management solution enabling you to quickly set up, manage, and support enterprise clouds and traditional Oracle IT environments from applications to disk
  2. Maximum return on IT management investment through the best solutions for intelligent management of the Oracle stack and engineered systems with real-time integration of Oracle's knowledge base with each customer environment
  3. Best service levels for traditional and cloud applications through business-driven application management

Oracle Enterprise Manager
Figure 2 Enterprise Manager Cloud Control