Lesson 1

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

1. Locate the Server Manager executable file
2. Start the Server Manager tool and connect to a database
3. Get help for Server Manager commands
4. List the columns in a table or a view
5. Use Server Manager to select data from a database
6. 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)

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