Oracle11g 自動化建庫及調整相關引數

  該指令碼適用於從模板克隆出的資料庫，包括建庫、調整引數、修改相關配置檔案、生產資料庫配置檔案。該指令碼目錄在suse 11、suse 12上測試透過。

  

#!/usr/bin/env bash

echo "========================================="

echo "This script is for install a test oracle db"

echo "Please use oracle user execute !!!!!!!!!!!"

echo "Execute this script about 5-10 mins "

echo "Script has been test on suse 11sp4 12sp3"

echo "========================================"

uid=`id -u`

uname=`cat /etc/passwd| grep $uid | awk -F ":" '{print $1}'`

function exit_script()

{

        exit 1

}

function crt_db()

{

  local mem=`free -g | grep Mem | awk {'print $2'}`

  local perc=30

  if [ "$mem" -lt 5 ]; then

    perc=50

    echo "Machine memory is $mem GB, Oracle mem percet is 50%"

  else

    echo "Machine memory is $mem GB, Oracle mem percet is 30%"

  fi

 echo "Begin create database ..."

  dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname gycdb -sid gycdb  -sysPassword gyc_pwd123 -systemPassword gyc_pwd123 -responseFile NO_VALUE  -characterSet ZHS16GBK -memoryPercentage $perc -emConfiguration NONE -datafileDestination /oradata/ -redoLogFileSize 500 -initParams processes=2000

 if [ $? -eq 0 ]; then

    echo "Create database has been completed!!!"

 else

    echo "Create database failed, Please connect to Oracle DBA"

    exit_script

 fi

}

function change_prm()

{

 local fname=/oracle/app/oracle/product/11.2.0/rdbms/admin/gyc_dev.sql

 if [  -f "$fname" ]; then

    echo "Parameter file is exits!, Begin change default parameters"

 else

    echo "Parameter file is not exits, Please connect to Oracle DBA"

    exit_script

 fi

 sed -i '1d' $fname

 echo "shutdown immediate" >> $fname

 echo "startup" >> $fname

 echo "exit" >> $fname

 export ORACLE_SID=gycdb

 sqlplus "/ as sysdba" @$fname

 if [ $? -eq 0 ]; then

   echo "Database has changed default parameters !!!!"

 else

    echo "Change paramter failed, Please connect to Oracle DBA"

    exit_script

 fi

}

function change_hostname()

{

  echo "Begin change hostname and oracle sid...."

  sed -i "s/GYCTEST/`hostname`/g"  $ORACLE_HOME/network/admin/listener.ora 

  lsnrctl start

  sed -i "s/icbcdb/gycdb/g" /home/oracle/.profile

 if [ $? -eq 0 ]; then

  echo "Listener has changed hostnane, Listener was started"

 else

    echo "Start listener failed, Please connect to Oracle DBA"

    exit_script

 fi

}

function db_info()

{

  echo "Begin create db info file...."

  local fname=/home/oracle/db_info.txt

  touch $fname

  echo "db_name:gycdb" >> $fname

  echo "port:1521" >> $fname

  echo "sys/system:gyc_pwd123" >> $fname

 if [ $? -eq 0 ]; then

    echo "Db_info file has been created!!"

 else

    echo "Db_info has failed, Please connect to Oracle DBA"

    exit_script

 fi

}

if [ "$uname" == "oracle" ]; then 

    echo "Begin execute script ......"

    crt_db

    change_prm

    change_hostname

    db_info

    echo "End execute script !!!!!!"

else

   echo "Current user is not oracle, Please change to oracle then execute this script"

   exit_script

fi

function db_info()

{

  echo "Begin create db info file...."

  local fname=/home/oracle/db_info.txt

  touch $fname

  echo "db_name:testdb" >> $fname

  echo "port:1521" >> $fname

  echo "sys/system:SysCs_100010" >> $fname

 if [ $? -eq 0 ]; then

    echo "Db_info file has been created!!"

 else

    echo "Db_info has failed, Please connect to Oracle DBA"

    exit_script

 fi

}

if [ "$uname" == "oracle" ]; then 

    echo "Begin execute script ......"

    crt_db

    change_prm

    change_hostname

    db_info

    echo "End execute script !!!!!!"

else

   echo "Current user is not oracle, Please change to oracle then execute this script"

   exit_script

fi

該指令碼內容可根據實際情況進行相關調整。