Some common Server Manager Commands
Since the year 2000, Oracle has been slowly de-commisioning the old server manager interface
The old Oracle server manager provided a way to enter special database administration functions such as
- startup and
commands for the Oracle server as well as special DBA commands such as
- oradebug and
- the display of internal block structures.
Server Manager not supported in Oracle9i
Server Manager is not supported in Oracle9i, and the DBA must use SQL*Plus instead. Most Server Manager scripts should work in a SQL*Plus environment, but some scripts may need to be modified.
The Oracle professional must understand how to use server manager commands within the
Oracle SQL*Plus product.
In order to connect to SQL*Plus and issue DBA commands, Oracle allows you to connect to
- SQL*Plus AS SYSDBA or
- AS SYSOPER.
Once connected to the database, the Oracle DBA can
In the following examples, one sees how Oracle is used in order to connect to the database and issue startup and shutdown commands:
- startup the database,
- shutdown the database, and
- provide trace files, and
- use the oradebug facility.
connect / as sysdba
connect system/manager as sysdba
These commands can also easily be placed inside shell script to perform routine database functions:
Shell Script Commands
# First set the environment
ORACLE_HOME=`cat /etc/oratab|grep ^$ORACLE_SID:|cut -f2 -d':'`