# 若未注册可用我的，勿做修改

1161360442@qq.com

Oracle123

#!/bin/bash

#

# chkconfig:

# Description: This script is responsible for taking care of configuring the Oracle Database and its associated services.

#

# processname: oracledb_ORCLCDB-18c

# Red Hat or SuSE config: /etc/sysconfig/oracledb_ORCLCDB-18c

#

# Set path if path not set

case $PATH in

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

                 export PATH ;;

esac

# Check if the root user is running this script

if [ $(id -u) != "" ]

then

        echo "You must be root user to run the configurations script. Login as root user and try again."

        exit

fi

# Setting the required environment variables

export ORACLE_HOME=/opt/oracle/product/18c/dbhome_1

export ORACLE_VERSION=18c

export ORACLE_SID=ORCLCDB

export TEMPLATE_NAME=General_Purpose.dbc

export CHARSET=AL32UTF8

export PDB_NAME=ORCLPDB1

export LISTENER_NAME=LISTENER

export NUMBER_OF_PDBS=

export CREATE_AS_CDB=true

# General exports and vars

export PATH=$ORACLE_HOME/bin:$PATH

LSNR=$ORACLE_HOME/bin/lsnrctl

SQLPLUS=$ORACLE_HOME/bin/sqlplus

DBCA=$ORACLE_HOME/bin/dbca

ORACLE_OWNER=oracle

RETVAL=

CONFIG_NAME="oracledb_$ORACLE_SID-$ORACLE_VERSION.conf"

CONFIGURATION="/etc/sysconfig/$CONFIG_NAME"

# Commands

if [ -z "$SU" ];then SU=/bin/su; fi

if [ -z "$GREP" ]; then GREP=/usr/bin/grep; fi

if [ ! -f "$GREP" ]; then GREP=/bin/grep; fi

# To start the DB

start()

{

    check_for_configuration

    RETVAL=$?

    if [ $RETVAL -eq  ]

    then

        echo "The Oracle Database is not configured. You must run '/etc/init.d/oracledb_$ORACLE_SID-$ORACLE_VERSION configure' as the root user to configure the database."

        exit

    fi

    # Check if the DB is already started

    pmon=`ps -ef | egrep pmon_$ORACLE_SID'\>' | $GREP -v grep`

    if [ "$pmon" = "" ];

    then

        # Unset the proxy env vars before calling sqlplus

        unset_proxy_vars

        echo "Starting Oracle Net Listener."

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

        RETVAL=$?

        if [ $RETVAL -eq  ]

        then

            echo "Oracle Net Listener started."

        fi

        echo "Starting Oracle Database instance $ORACLE_SID."

        $SU -s /bin/bash  $ORACLE_OWNER -c "$SQLPLUS -s /nolog << EOF

                                                                connect / as sysdba

                                                                startup

                                                                alter pluggable database all open

                                                                exit;

                                                                EOF" > /dev/null 2>&1

        RETVAL1=$?

        if [ $RETVAL1 -eq  ]

        then

            echo "Oracle Database instance $ORACLE_SID started."

        fi

    else

        echo "The Oracle Database instance $ORACLE_SID is already started."

        exit

    fi

    echo

    if [ $RETVAL -eq  ] && [ $RETVAL1 -eq  ]

    then

        return

     else

        echo "Failed to start Oracle Net Listener using $ORACLE_HOME/bin/tnslsnr and Oracle Database using $ORACLE_HOME/bin/sqlplus."

        exit

    fi

}

# To stop the DB

stop()

{

    check_for_configuration

    RETVAL=$?

    if [ $RETVAL -eq  ]

    then

        echo "The Oracle Database is not configured. You must run '/etc/init.d/oracledb_$ORACLE_SID-$ORACLE_VERSION configure' as the root user to configure the database."

        exit

    fi

    # Check if the DB is already stopped

    pmon=`ps -ef | egrep pmon_$ORACLE_SID'\>' | $GREP -v grep`

    if [ "$pmon" = "" ]

    then

        echo "Oracle Database instance $ORACLE_SID is already stopped."

        exit

    else

        # Unset the proxy env vars before calling sqlplus

        unset_proxy_vars

        echo "Shutting down Oracle Database instance $ORACLE_SID."

        $SU -s /bin/bash $ORACLE_OWNER -c "$SQLPLUS -s /nolog << EOF

                                                                connect / as sysdba

                                                                shutdown immediate

                                                                exit;

                                                                EOF" > /dev/null 2>&1

        RETVAL=$?

        if [ $RETVAL -eq  ]

        then

            echo "Oracle Database instance $ORACLE_SID shut down."

        fi

        echo "Stopping Oracle Net Listener."

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

        RETVAL1=$?

        if [ $RETVAL1 -eq  ]

        then

            echo "Oracle Net Listener stopped."

        fi

    fi

    echo

    if [ $RETVAL -eq  ] && [ $RETVAL1 -eq  ]

    then

        return

    else

        echo "Failed to stop Oracle Net Listener using $ORACLE_HOME/bin/tnslsnr and Oracle Database using $ORACLE_HOME/bin/sqlplus."

        exit

    fi

}

# To call DBCA to configure the DB

configure_perform()

{

    # Unset the proxy env vars before calling dbca

    unset_proxy_vars

    echo "Configuring Oracle Database $ORACLE_SID."

    $SU -s /bin/bash  $ORACLE_OWNER -c "$DBCA -silent -createDatabase -gdbName $ORACLE_SID -templateName $TEMPLATE_NAME -characterSet $CHARSET -createAsContainerDatabase $CREATE_AS_CDB -numberOfPDBs $NUMBER_OF_PDBS -pdbName $PDB_NAME -createListener $LISTENER_NAME:$LISTENER_PORT -datafileDestination $ORACLE_DATA_LOCATION -sid $ORACLE_SID -autoGeneratePasswords -emConfiguration DBEXPRESS -emExpressPort $EM_EXPRESS_PORT"

    RETVAL=$?

    echo

    if [ $RETVAL -eq  ]

    then

        echo "Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user."

        return

    else

        echo "Database configuration failed."

        exit

    fi

}

# Enh  - Unsets the proxy env variables

unset_proxy_vars()

{

    if [ "$http_proxy" != "" ]

    then

        unset http_proxy

    fi

    if [ "$HTTP_PROXY" != "" ]

    then

        unset HTTP_PROXY

    fi

    if [ "$https_proxy" != "" ]

    then

        unset https_proxy

    fi

    if [ "$HTTPS_PROXY" != "" ]

    then

        unset HTTPS_PROXY

    fi

}

# Check if the DB is already configured

check_for_configuration()

{

    configfile=`$GREP --no-messages $ORACLE_SID:$ORACLE_HOME /etc/oratab` > /dev/null >&

    if [ "$configfile" = "" ]

    then

        return

    fi

    return

}

read_config_file()

{

    if [ -f "$CONFIGURATION" ]

    then

        . "$CONFIGURATION"

    else

        echo "The Oracle Database is not configured. Unable to read the configuration file '$CONFIGURATION'"

        exit ;

    fi

}

# Entry point to configure the DB

configure()

{

    check_for_configuration

    RETVAL=$?

    if [ $RETVAL -eq  ]

    then

        echo "Oracle Database instance $ORACLE_SID is already configured."

        exit

    fi

    read_config_file

    check_port_availability

    check_em_express_port_availability

    configure_perform

}

check_port_availability()

{

    port=`netstat -n --tcp --listen | $GREP :$LISTENER_PORT`

    if [ "$port" != "" ]

    then

        echo "Port $LISTENER_PORT appears to be in use by another application. Specify a different port in the configuration file '$CONFIGURATION'"

        exit ;

    fi

}

# Validation method to check for port availability for Oracle EM Express

check_em_express_port_availability()

{

    port=`netstat -n --tcp --listen | $GREP :$EM_EXPRESS_PORT`

        if [ "$port" != "" ]

    then

         echo "Port $EM_EXPRESS_PORT appears to be in use by another application. Specify a different Oracle EM Express port in the configuration file '$CONFIGURATION'"

         exit ;

    fi

}

restart()

{

    # Check if the DB is already stopped

    pmon=`ps -ef | egrep pmon_$ORACLE_SID'\>' | $GREP -v grep`

    if [ "$pmon" = "" ]

    then

        start

    else

        stop

        start

    fi

}

case "$1" in

    start)

        start

    ;;

    stop)

        stop

    ;;

    configure)

        configure

    ;;

    restart)

        restart

    ;;

    *)

        echo $"Usage: $0 {start|stop|restart|configure}"

        exit

    ;;

esac

exit