Introduction to Oracle Server Manager and Database Creation Architecture
Note: Oracle Server Manager has been deprecated since Oracle 9i, and you need to use SQL*Plus instead.
Server Manager is not supported in Oracle9i release 9.0.1 and later.
If you run SQL scripts using Server Manager line mode, then you will need to change these scripts so that they are compatible with SQL*Plus,
and then run them using SQL*Plus.
Companies that use Oracle typically continue to use SQL*Plus scripts for batch updating or simple reports.
This module teaches you about Oracle Server Manager (a technology which has been deprecated since Oracle 9i).
Server Manager is a utility that was formally used to manage Oracle databases.
When you are finished with this module, you will be able to understand how Oracle Server Manager was the predecessor to SQL*Plus.
Locate the Server Manager executable file
Start the Server Manager tool and connect to a database
Get help for Server Manager commands
List the columns in a table or a view
Use Server Manager to select data from a database
Write output to a file
Server Manager was an important part of your toolkit for managing an Oracle database and
was worth learning prior to the release of Oracle 9i.
About 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)
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
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
Best service levels for traditional and cloud applications through business-driven application management