-
创建Oracle数据库的脚本
资源介绍
oracle数据库创建脚本
#!/bin/sh
OLD_UMASK=`umask`
umask 0027
mkdir -p /oradata
mkdir -p /u01/app/oracle/admin/tdrb/adump
mkdir -p /u01/app/oracle/admin/tdrb/dpdump
mkdir -p /u01/app/oracle/admin/tdrb/pfile
mkdir -p /u01/app/oracle/cfgtoollogs/dbca/tdrb
mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1/dbs
umask ${OLD_UMASK}
ORACLE_SID=tdrb; export ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH; export PATH
echo You should Add this entry in the /etc/oratab: tdrb:/u01/app/oracle/product/11.2.0/dbhome_1:Y
/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus /nolog @/u01/app/oracle/admin/tdrb/scripts/tdrb.sql