RelationalDBDesign RelationalDBDesign

DB Creation   «Prev 

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
  1. startup and
  2. shutdown
commands for the Oracle server as well as special DBA commands such as
  1. oradebug and
  2. the display of internal block structures.

connect internal

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
  1. SQL*Plus AS SYSDBA or

Once connected to the database, the Oracle DBA can
  1. startup the database,
  2. shutdown the database, and
  3. provide trace files, and
  4. use the oradebug facility.
In the following examples, one sees how Oracle is used in order to connect to the database and issue startup and shutdown commands:
sqlplus /nolog
connect / as sysdba
sqlplus /nolog
connect system/manager as sysdba
oradebug ipc
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':'`
export PATH
$ORACLE_HOME/bin/sqlplus /nolog<

Used to connect your Server Manager session to an Oracle instance, so that you can issue commands that operate on that instance.

Used to start an Oracle instance, and open a database for use.

Used to close a database and stop an instance.

Common Server Manager Commands, used to execute a script file.

Spool: Used to copy Server Manager output to a file. This is often used to capture any error messages that may result from running a long script.

Archive Log: Used to start, stop, and display the status of archive logging.

Show parameters: Used to display the values for various database parameter settings.

Show SGA: Used to display information about how Oracle is using memory

Help: Used to get a short summary of Server Manager commands.

Exits Server Manager