LINUX上启动ORACLE

LINUX下启动ORACLE

手动启动：

用 oracle用户登录（或su - oracle)

lsnrctl start

sqlplus / as sysdba

  startup

  exit

自动启动，要编写一个启动脚本，用root用户拷到/etc/init.d下，取名叫oracle

然后, chkconfig oracle on，即可加入服务列表

/etc/init.d/oracle start   #启动

/etc/init.d/oracle stop  #停止

脚本的示例(里面的变量要按实际情况修改)：

#!/bin/bash

#

# chkconfig:  345 99 01

# description: This is a program that is responsible for taking care of

# configuring the Oracle Database 11g Stardard/Enterprise Edition and its associated

# services.

#
# Source fuction library

if [ -f /lib/lsb/init-functions ]

then

	. /lib/lsb/init-functions

elif [ -f /etc/init.d/functions ]

then

	. /etc/init.d/functions

fi
# Set path if path not set (if called from /etc/rc)

case $PATH in

    "") PATH=/bin:/usr/bin:/sbin:/etc

        export PATH ;;

esac
# Save LD_LIBRARY_PATH

SAVE_LLP=$LD_LIBRARY_PATH
RETVAL=0
ORACLE_OWNER=oracle

ORACLE_OWNER_HOME=/opt/oracle

ORACLE_BASE=$ORACLE_OWNER_HOME/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

ORACLE_SID=orcl

ORACLE_UNQNAME=$ORACLE_SID

LSNR=$ORACLE_HOME/bin/lsnrctl

SQLPLUS=$ORACLE_HOME/bin/sqlplus

STARTDB_SQL=$(mktemp /tmp/start.XXXXXX)

echo -e "startup;\nquit;\n" > $STRTDB_SQL

STOPDB_SQL=$(mktemp /tmp/stop.XXXXXX)

echo -e "shutdown immediate;\nquit;\n" > $STOPDB_SQL

SU=/bin/su

export ORACLE_HOME

export ORACLE_SID

export PATH=$ORACLE_HOME/bin:$PATH

LOG="$ORACLE_HOME_LISTNER/listener.log"
export LC_ALL=C
if [ $(id -u) != "0" ]

then

    echo "You must be root to run the configure script.  Login as root and then run the

configure script."

    exit 1

fi
if [ -f /etc/redhat-release ]

then

    . /etc/init.d/functions
    init_status()

    {

	return 0

    }

    exit_status()

    {

	exit $?

    }

    success_status()

    {

	success

	echo

    }

    failure_status()

    {

	failure $?

	echo

    }
elif [ -f /etc/SuSE-release ]

then

    . /etc/rc.status
    init_status()

    {

	rc_reset

    }

    success_status()

    {

	echo "OK"

	return 0

    }

    failure_status()

    {

	echo "Failed"

	return 1

    }

    exit_status()

    {

	exit $?

    }
else

    if [ -d /etc/default ]

    then

        CONFIGURATION="/etc/default/$CONFIG_NAME"

    fi
    init_status()

    {

        return 0

    }
    success_status()

    {

        echo "OK"

        return 0

    }
    failure_status()

    {

        echo "Failed"

        return 0

    }
    exit_status()

    {

        exit $?

    }

fi
init_status
start() {
	status=`ps -ef | grep tns | grep oracle`

	if [ "$status" == "" ]

	then

		if [ -f $ORACLE_HOME/bin/tnslsnr ]

	        then

		     	echo "Starting Oracle Net Listener."

        		$SU -s /bin/bash $ORACLE_OWNER -c "$LSNR  start" # > /dev/null 2>&1

		fi

	fi

	echo "Starting Oracle Database 11g Instance."

	$SU -s /bin/bash  $ORACLE_OWNER -c "$SQLPLUS -s /nolog @${STARTDB_SQL}" # > /dev/null 2>&1

    RETVAL=$?

    if [ $RETVAL -eq 0 ]

    then

        echo

    else

        echo Failed to start Oracle Net Listener using $ORACLE_HOME/bin/tnslsnr\

 	      and Oracle Database using $ORACLE_HOME/bin/sqlplus.

        RETVAL=1

	return $RETVAL

    fi
}
startconsole() {
    $SU -s /bin/bash  $ORACLE_OWNER -c "$ORACLE_HOME/bin/emctl start dbconsole &" # > /dev/null 2>&1

    RETVAL=$?

    return $RETVAL

}
stop() {
    # Stop Oracle 11g  Database and Listener

    $SU -s /bin/bash  $ORACLE_OWNER -c "$ORACLE_HOME/bin/emctl stop dbconsole &" # > /dev/null 2>&1
    echo Shutting down Oracle Database 11g Instance.

	$SU -s /bin/bash $ORACLE_OWNER -c "$SQLPLUS -s /nolog @${STOPDB_SQL}" # > /dev/null 2>&1

	echo Stopping Oracle Net Listener.

    $SU -s /bin/bash  $ORACLE_OWNER -c "$LSNR stop" # > /dev/null 2>&1

    RETVAL=$?

    echo

    if [ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/$LSNR

    then

        return $RETVAL

    fi

}
stopconsole() {

    # Stop Oracle 11g  Database and Listener

    $SU -s /bin/bash  $ORACLE_OWNER -c "$ORACLE_HOME/bin/emctl stop dbconsole &"