oracle新建表空间的shell脚本实例代码： #!/bin/bash#ocpyang@126.com#create tablespace if [ $# -ne 2 ]; then echo usage:
oracle新建表空间的shell脚本实例代码：
#!/bin/bash
#ocpyang@126.com
#create tablespace
if [ $# -ne 2 ]; then
  echo usage: $0 tablespace_name tablespace_size
  exit 1
fi
#configure oracle env:about oracle envs, username and password
oracle_home=/u01/app/oracle/product/11.2.0/db_1
oracle_sid=orcl
ora_data=/u01/app/oracle/product/11.2.0/db_1/dbs/
ora_user=sys
ora_pass=password
tablespace_name=$(echo $1 | tr '[a-z]' '[a-z]')
tablespace_size=$2
outfiletmp01=/tmp/createtpstmp01.txt  #specify the output file location
outfiletmp03=/tmp/createtpstmp03.txt  #specify the output file location
outfiletmp02=/tmp/createtpstmp02.txt  #specify the output file location
#check oracle instance is down or up
sqlplus -s ${ora_user}/${ora_pass} as sysdba /dev/null #禁止sqlplus执行结果回显
set heading off;
set feedback off;
set termout off;
set pagesize 0;
set verify off;
set echo off;
spool ${outfiletmp01}
select sysdate from dual;
spool off
exit;
!01
ins_jug=`grep -i ora-01034:  ${outfiletmp01} >${outfiletmp02} `
if [ -s ${outfiletmp02} ]; then
 echo -e \e[1;31m  ******************************************************************  \e[0m
 echo -e \e[1;31m  !!!!, oracle is down!  \e[0m
 echo -e \e[1;31m  ******************************************************************  \e[0m
 rm -rf ${outfiletmp01}
 rm -rf ${outfiletmp02}
 exit 1
fi
# 
sqlplus -s ${ora_user}/${ora_pass} as sysdba /dev/null #禁止sqlplus执行结果回显
set heading off;
set feedback off;
set termout off;
set pagesize 0;
set verify off;
set echo off;
spool $outfiletmp03
select tablespace_name from dba_tablespaces where tablespace_name='${tablespace_name}';
spool off
exit;
!01
tps_jug=`grep -i ${tablespace_name} ${outfiletmp03} `
if [ ${tps_jug} = ${tablespace_name} ]; then   
    echo -e \e[1;32m  the tablespace ${tablespace_name} exits! \e[0m 
    rm -rf ${outfiletmp03}
    exit 1 
else
 wind_var=$(
 sqlplus -s {ora_user}/${ora_pass} as sysdba  create tablespace ${tablespace_name}
 datafile '${ora_data}/${tablespace_name}.dbf'
 size $tablespace_size
 extent management local
 uniform size 128k
 segment space management auto;
 exit ;
 eof)
 echo -e \e[1;32m  ${wind_var} \e[0m  #direct display returns results
 rm -rf ${outfiletmp03}
 exit 1
fi
oracle 11g 在redhat linux 5.8_x64平台的安装手册
linux-6-64下安装oracle 12c笔记
在centos 6.4下安装oracle 11gr2(x64)
oracle 11gr2 在vmware虚拟机中安装步骤
debian 下 安装 oracle 11g xe r2
本文永久更新链接地址：
，