Using Server Manager in Line Mode

This chapter describes how to use Server Manager in line mode. Line mode is useful for performing unattended operations, such as running nightly batch jobs or scripts. In addition, you can use line mode when a graphical device is unavailable.

Note:

Server Manager Line Mode is available on Windows NT and Motif platforms.

Starting Server Manager in Line Mode

You start up Server Manager in line mode by typing the appropriate command at the operating system prompt. For example, on some systems the command svrmgrl starts up Server Manager in line mode.

You can also start up Server Manager in line mode and execute a script. For example, to execute the script SMSTART.SQL, enter the following at the operating system prompt.

> svrmgrl command=@smstart

Note:

The exact command for starting up Server Manager in line mode depends on your platform. For information about starting up Server Manager in line mode, see your operating system-specific Oracle documentation.

Using Server Manager in Line Mode

In line mode you can execute the Server Manager commands described in Appendix B, "DBA Command Reference". In addition, you can execute SQL statements and PL/SQL code.

Entering Server Manager Commands

Single-line Server Manager commands do not require punctuation or terminators. A Server Manager command may span more than one line if you use a backslash (\) at the end of each line to indicate a continuation.

Entering SQL or PL/SQL Code

You can enter single-line or multiple-line SQL statements in line mode. Continuation characters are not needed in multiple-line SQL statements. To end a SQL statement and execute it, either type a semicolon (;) at the end of the statement or type a slash (/) by itself on the last input line.

To execute PL/SQL code, type a slash (/) by itself on the last input line.

Running Scripts

In line mode you can also run scripts using the @ command. For example, to run the script TEST.SQL, issue the statement @test. If you do not specify a script name, Server Manager prompts you for one, as in the following example:

SVRMGR> @
Name of script file: test