Donald K. Burleson Oracle Tips

De-support for server manager

Over the past five years, Oracle has been slowly de-supporting the old server manager interface.  The old Oracle server manager provided a way to enter special database administration functions such as startup and shutdown commands for the Oracle server as well as special DBA commands such as oradebug and the display of internal block structures.

svrmgrl

connect internal

startup

Starting with Oracle9i, the server manager has been removed. 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 startup the database, shutdown the database, and perform other administrative tasks such as providing trace files and using the oradebug facility.

In the following examples we can see how Oracle is used in order to connect to the database and issue startup and shutdown commands:

sqlplus /nolog

connect / as sysdba

startup

sqlplus /nolog

connect system/manager as sysdba

oradebug ipc

These commands can also easily be placed inside shell script to perform routine database functions:

#!/bin/ksh

# First, we must set the environment . . . .

ORACLE_SID=mon1

export ORACLE_SID

ORACLE_HOME=`cat /etc/oratab|grep ^$ORACLE_SID:|cut -f2 -d':'`

export ORACLE_HOME

PATH=$ORACLE_HOME/bin:$PATH

export PATH

$ORACLE_HOME/bin/sqlplus /nolog<<!

connect system/manager as sysdba

select * from v\$database;

shutdown immediate

exit

!

If you like Oracle tuning, you might enjoy my latest book “Oracle Tuning: The Definitive Reference” by Rampant TechPress.  It’s only $41.95 (I don’t think it is right to charge a fortune for books!) and you can buy it right now at this link: