oracle靜默建庫刪庫

#!/bin/bash

###############################################

#

#silent install

#

###############################################

while read line

do

keys="`echo $line |awk -F= '{print $1}'`"

val="`echo $line |awk -F= '{print $2}'`"

case "${keys}" in

SID)

ORACLE_SID=${val}

;;

GLOBE_DBNAME)

ORACLE_GNAME=${val}

;;

SYSPASSWORD)

ORACLE_SYS_PWD=${val}

;;

SYSTEMPASSWORD)

ORACLE_SYSTEM_PWD=${val}

;;

MEMORY_TARGET_M)

MEMORY_TARGET_M=${val}

;;

esac

done < init.conf

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName $ORACLE_GNAME -sid $ORACLE_SID -SYSPASSWORD $ORACLE_SYS_PWD -SYSTEMPASSWORD $ORACLE_SYSTEM_PWD -characterSet ZHS16GBK -nationalCharacterSet AL16UTF16 -totalMemory $MEMORY_TARGET_M -INITPARAMS open_cursors=1000,db_keep_cache_size=300M,result_cache_max_size=300M -redoLogFileSize 512 -automaticMemoryManagement true

#!/bin/bash

###############################################

#

#silent uninstall

#

###############################################

while read line

do

keys="`echo $line |awk -F= '{print $1}'`"

val="`echo $line |awk -F= '{print $2}'`"

case "${keys}" in

SID)

ORACLE_SID=${val}

;;

GLOBE_DBNAME)

ORACLE_GNAME=${val}

;;

SYSPASSWORD)

ORACLE_SYS_PWD=${val}

;;

SYSTEMPASSWORD)

ORACLE_SYSTEM_PWD=${val}

;;

MEMORY_TARGET_M)

MEMORY_TARGET_M=${val}

;;

esac

done < init.conf

dbca -silent -deleteDatabase -sourceDB $ORACLE_GNAME -sid $ORACLE_SID -sysDBAUserName SYS -sysDBAPassword $ORACLE_SYS_PWD