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%"

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

}

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

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

}

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

}

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

}

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

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

}

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

该脚本内容可根据实际情况进行相关调整。

标题名称：Oracle11g自动化建库及调整相关参数
当前链接：http://myzitong.com/article/jpgshh.html

Oracle11g自动化建库及调整相关参数

其他资讯