oracle 新建用户shell脚本实例代码： #!/bin/bash#ocpyang@126.com#create user if [ $# -ne 4 ]; then echo -e \e[1;32m ***
oracle 新建用户shell脚本实例代码：
#!/bin/bash
#ocpyang@126.com
#create user
if [ $# -ne 4 ]; then
  echo -e \e[1;32m  ********************************************************************************* \e[0m
  echo -e \e[1;32m  usage: $0 username password default_tablespace index_tablespace \e[0m
  echo -e \e[1;32m  ********************************************************************************* \e[0m
  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
outfiletmp01=/tmp/createusertmp01.txt  #specify the output file location
outfiletmp02=/tmp/createusertmp02.txt  #specify the output file location
outfiletmp03=/tmp/createusertmp03.txt  #specify the output file location
cre_user=$1
chk_user=$(echo $1 | tr '[a-z]' '[a-z]')
cre_user_pwd=$2
def_tbsp=$3
def_idx_tbsp=$4
def_temp_tbsp=temp
smk_test_table=t1
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 username from dba_users where username='${chk_user}';
spool off
exit;
!01
##check oracle instance is down or up
ins_jug=`grep -i ora-01034:  ${outfiletmp01} >${outfiletmp03} `
if [  -s ${outfiletmp03} ]; 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
 exit 0
fi
tps_jug=`grep -i ${chk_user} ${outfiletmp01} `
if [ ${tps_jug} = ${chk_user} ]; then
 echo -e \e[1;31m  sorry, the username ${cre_user} exits!  \e[0m
 exit 0
else
 wind_crtusr=$(
 sqlplus -s ${ora_user}/${ora_pass} as sysdba /dev/null #禁止sqlplus执行结果回显
 spool ${outfiletmp02}
 create user ${cre_user} identified by ${cre_user_pwd}
 default tablespace ${def_tbsp}
 temporary tablespace ${def_temp_tbsp};
grant create session to ${cre_user};
 grant create table  to ${cre_user};
 grant create index  to ${cre_user};
alter user ${cre_user} quota unlimited on ${def_tbsp};
 alter user ${cre_user} quota unlimited on ${def_idx_tbsp};
-- smoke test
 conn ${cre_user}/${cre_user_pwd}
 create table ${smk_test_table}(tid number) tablespace ${def_tbsp};
 create index ${smk_test_table}.idx1 on ${cre_user}.${smk_test_table}(tid) tablespace ${def_idx_tbsp};
 insert into ${smk_test_table} values(1);
 drop table ${smk_ttbl};
 spool off
 exit;
 !01)
# execute the variable $wind_crtusr
 if [  ${wind_crtusr} =   ];then
  echo -e \e[1;32m  ok, the create user ${cre_user} success!  \e[0m
 else
  echo -e \e[1;31m  ${wind_crtusr}  \e[0m
 fi
rm -rf ${outfiletmp01}
 rm -rf ${outfiletmp02}
 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
本文永久更新链接地址：
，