RelationalDBDesign RelationalDBDesign


DB Creation   «Prev 

Server Manager has been replaced with extended SQL*Plus implementation in Oracle 9i

Locating the Server Manager executable file is only possible if you are using Oracle 8, which is more than likely not the case.

Server Manager has been replaced with extended SQL*Plus implementation

The SQL*Plus program allows users to access SQL and the Oracle SQL extensions. This combination of commands, SQL, and the Oracle SQL extensions enable users and the DBA
  1. to access the database by means of standard SQL and
  2. to format input and output using the SQL*Plus extensions to the language.
In Oracle9i, the Server Manager (SVRMGR) program has been completely eliminated in favor of an extended SQL*Plus implementation.

SQL*Plus has a command buffer that stores the current command and allows the user to edit the command using the native system editor or via command-line input. SQL*Plus also allows the user to
  1. store,
  2. retrieve, and
  3. execute
SQL/SQL*Plus command scripts, as well as PL/SQL command scripts. In SQL*Plus, local variables can be assigned as well as providing control of system variables used for format and display control.
SQL*Plus can also be used to dynamically create command scripts that can then be used to perform changes to users, tables, or other Oracle objects. If DBAs are not familiar with SQL*Plus, it is suggested they review the SQL*Plus reference guide.
SQL*Plus can be accessed once the user has set the appropriate system variables and path, which is done using the
?.oraenv? 
command on UNIX and Linux; in some environments the ORACLE_SID variable may have to be set to point to your database. On Windows Server, the user must either set some environmental variables or use connect aliases.

Finding Server Manager under Unix
Finding Server Manager under Unix

Finding Server Manager under Windows NT
Finding Server Manager under Windows NT