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
该脚本内容可根据实际情况进行相关调整。
