oracle administrator

oracle study list

1.start oracle

#set oracle enviroment
. /usr/local/bin/oraenv

#/etc/oratab

#stop Oracle Database or Automatic Storage Management Instance
$ sqlplus /nolog
SQL> CONNECT SYS/sys_password as SYSDBA
SQL> SHUTDOWN NORMAL

#start Oracle Database or Automatic Storage Management Instance
SQL>startup

2.start Oracle Cluster Services Synchronization (CSS) daemon

On AIX and Mac OS X:

/etc/init.cssd stop

On other platforms:

/etc/init.d/init.cssd stop

To start the CSS daemon, run the following command:

$ORACLE_HOME/bin/localconfig reset         

This command stops the Oracle CSS daemon and then restarts it.

3.Stopping and Starting an Oracle Net Listener

$ ORACLE_HOME=oracle_home1
$ export ORACLE_HOME

$ORACLE_HOME/bin/lsnrctl start [listenername]

4.Stopping and Starting iSQL*Plus

$ORACLE_HOME/bin/isqlplusctl start

5.Stopping and Starting Oracle Ultra Search
$ORACLE_HOME/bin/searchctl [start|stop]

6.Stopping and Starting Oracle Enterprise Manager Database Control
$ORACLE_HOME/bin/emctl start dbconsole

7.Stopping and Starting Oracle Management Agent
$ORACLE_HOME/agent/bin/emctl [start|stop] agent

8.Automating Shutdown and Startup

cat > dbora < 
#! /bin/sh  -x
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for your installation.

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
#
# Change the value of ORACLE to the login name of the
# oracle owner at your site.
#
ORACLE=oracle

PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
if [ ! "$2" = "ORA_DB" ] ; then
   if [ "$PLATFORM" = "HP-UX" ] ; then
      remsh $HOST -l $ORACLE -n "$0 $1 ORA_DB"
      exit
   else
      rsh $HOST -l $ORACLE  $0 $1 ORA_DB
      exit
   fi
fi
#
case $1 in
'start')
        $ORACLE_HOME/bin/dbstart $ORACLE_HOME &
        ;;
'stop')
        $ORACLE_HOME/bin/dbshut $ORACLE_HOME &
        ;;
*)
        echo "usage: $0 {start|stop}"
        exit
        ;;
esac
#
EOF

# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora

exit