Svrmgrl

Svrmgrl is an old utility shipped with Oracle 8i and lower releases (ORACLE_HOME\bin directory). Server manager commands are now available in SQL*Plus. Prior to svrmgrl, DBAs used the SQL*DBA command.

Svrmgrl was used to perform functions like database creation, startup, shutdown, recovery, oradebug, etc.

Connecting

The INTERNAL user was used to connect to the local instance as defined by the ORACLE_HOME and ORACLE_SID environment variables.

In later releases, the INTERNAL user was replaced with "SYS AS SYSDBA".

Examples

Example to shutdown the database:

$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SVRMGR> connect internal
Connected.
SVRMGR> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> exit
Server Manager complete.

Take a systemstate dump:

$ svrmgrl
Oracle Server Manager Release 3.0.4.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.4.2.1 - Production
With the Partitioning option
PL/SQL Release 8.0.4.2.1 - Production

SVRMGR> connect internal
Connected.
SVRMGR> oradebug setmypid
Statement processed.
SVRMGR> oradebug unlimit
Statement processed.
SVRMGR> oradebug dump systemstate 1
Statement processed.
SVRMGR> exit;
Server Manager complete.

Also see, Enterprise Manager for GUI and Web-based management interfaces.