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.
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