solaris下如何实现自动建立数据库 服务器:sun的工作站操作系统:soralis10oracle版本:11g我选择想写一个脚本,运行后就可以自动建立数据库。请明白的人指导以下。谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用DBCA导出创建数据库实例的脚本,最后在程序创建时,调用这个脚本,这个与界面上一步步设置创建数据库是一样的 今天群里的由迪哥们写的:你参考下,可以根据你自己的情况改改:#!/bin/bash#Scriptname:oracle11gr2ins.sh#Version:0.1#Todo:install oracle database 11g r2 at rhel 5 or centos #Usege:./oracle11gr2ins.sh#Anthor: Kevin.U (YOUDI)#License:GPL 3oraclesrc=/oraclesrccd $oraclesrcunzip linux.x64_11gR2_database_1of2.zip nowmem=`free -b |grep Mem: |awk '{print $2}'`if (($nowmem <= 2147483648 ))thenecho "2147483648" >/proc/sys/kernel/shmmaxecho "sysctl -q -w kernel.shmmax=2147483648" >>/etc/rc.localelseecho $nowmem >/proc/sys/kernel/shmmaxecho "sysctl -q -w kernel.shmmax=$nowmem" >> /etc/rc.localfiecho "250 32000 250 128">/proc/sys/kernel/semecho 'sysctl -q -w kernel.sem="250 32000 250 128"'>>/etc/rc.local echo "fs.file-max = 6815744">/proc/sys/fs/file-maxecho 'sysctl -q -w fs.file-max='6815744'>>/etc/rc.localecho "fs.aio-max-nr = 1048575">/proc/sys/fs/file-maxecho 'sysctl -q -w fs.aio-max-nr = 1048575'>>/etc/rc.localsysctl -q -w net.ipv4.tcp_rmem="4096 87380 8388608"echo 'sysctl -q -w net.ipv4.tcp_rmem="4096 87380 8388608"'>>/etc/rc.localsysctl -q -w net.ipv4.tcp_wmem="4096 87380 8388608"echo 'sysctl -q -w net.ipv4.tcp_mem="4096 87380 8388608"' >>/etc/rc.localsysctl -q -w net.core.optmem_max=20480echo 'sysctl -q -w net.core.optmem_max=20480' >>/etc/rc.localsysctl -q -w net.core.rmem_default=262144echo "sysctl -q -w net.core.rmem_default=262144" >>/etc/rc.localsysctl -q -w net.core.rmem_default=262144echo "sysctl -q -w net.core.rmem_default=262144" >>/etc/rc.localsysctl -q -w net.core.wmem_max=1073741823echo 'sysctl -q -w net.core.wmem_max=1073741823' >>/etc/rc.localsysctl -q -w net.core.wmem_max=1073741823echo 'sysctl -q -w net.core.wmem_max=1073741823' >>/etc/rc.localsysctl -q -w net.ipv4.tcp_max_syn_backlog=2048echo 'sysctl -q -w net.ipv4.tcp_max_syn_backlog=2048' >>/etc/rc.localsysctl -q -w net.ipv4.tcp_syncookies=1echo 'sysctl -q -w net.ipv4.tcp_syncookies=1' >>/etc/rc.localsysctl -q -w net.ipv4.tcp_synack_retries=3echo 'sysctl -q -w net.ipv4.tcp_synack_retries=3' >>/etc/rc.localsysctl -q -w net.ipv4.tcp_syn_retries=3echo 'sysctl -q -w net.ipv4.tcp_syn_retries=3' >>/etc/rc.localsysctl -q -w net.ipv4.ip_local_port_range='9000 65000'echo 'sysctl -q -w net.ipv4.ip_local_port_range="9000 65000"' >>/etc/rc.localcp /etc/security/limits.conf /etc/security/limits.conf.bakecho "oracle soft nofile 65536">>/etc/security/limits.confecho "oracle hard nofile 65536">>/etc/security/limits.confecho "oracle soft nproc 16384">>/etc/security/limits.confecho "oracle hard nproc 16384">>/etc/security/limits.confecho "session required">>/etc/pam.d/login yum -y install binutils compat-db control-center gcc gcc-c++ glibc gnome-libs libstdc++ libstdc++-devel make openmotif21 openmotif-devel setarch libaiolibXp compat-libstdc++ compat-gcc compat-gcc libgnome-devel compat-gcc-34-c++ libaio libaio-devel sysstat unixODBC-2.2.11-7.1.i386 unixODBC-devel-2.2.11-7.1.i386 unixODBC-devel-2.2.11-7.1.x86_64 unixODBC-2.2.11-7.1.x86_64#install group#yum -y groupinstall "Development Tools" "Development Libraries" "Legacy Software Development" "Legacy Software Support" groupadd dbagroupadd oinstallgroupadd operuseradd -c "Oracle software owner" -g oinstall -G dba oraclemkdir -p /u01/app/db11gchown -R oracle.oinstall /u01/echo 'ORACLE_BASE=/u01/app/oracle;export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1;export ORACLE_HOMEORACLE_TERM=xterm;export ORACLE_TERMPATH=$ORACLE_HOME/bin:$PATH;export PATHORACLE_OWNER=oracle;export ORACLE_OWNERORACLE_SID=YOUDI;export ORACLE_SIDLD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibCLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib;export CLASSPATHTMP=/tmp;export TMPTMPDIR=$TMP;export TMPDIR'>>/home/oracle/.bash_profilesu - oracle#cd $oraclesrc/database#./runInstaller -silent -responseFile response/enterprise.rsp使用方法:使用root用户,mkdir /oraclesrc 存放oracle 11g的安装包,chmod +x 脚本名,./脚本名 执行 ,passwd oracle 修改oracle 密码,su - oracle ,执行安装就可以了 EXECUTE IMMEDIATE中调用函数 急请高手路过帮忙看一下 求oracle的一条sql语句!!!! 在线等,请教一个SQL语句,立即给分! 统计问题的sql,辛苦赐教 Rman 为何不能显示帮助信息呢? 写一个作业,将一个数据库中几个用户的相关数据备份成DMP和SQL文件? group by语句 请问哪位知道JAWS是个什么东东,和Oracle什么关系,哪里有下载呀?谢谢 新手 写不出来了 IF 怎么嵌套啊 关于Oracle sequence的问题 oracle 9i使用rman迁移数据库遇到ORA-19505错误,怎么办?
#!/bin/bash
#Scriptname:oracle11gr2ins.sh
#Version:0.1
#Todo:install oracle database 11g r2 at rhel 5 or centos
#Usege:./oracle11gr2ins.sh
#Anthor: Kevin.U (YOUDI)
#License:GPL 3oraclesrc=/oraclesrc
cd $oraclesrc
unzip linux.x64_11gR2_database_1of2.zip nowmem=`free -b |grep Mem: |awk '{print $2}'`
if (($nowmem <= 2147483648 ))
then
echo "2147483648" >/proc/sys/kernel/shmmax
echo "sysctl -q -w kernel.shmmax=2147483648" >>/etc/rc.local
else
echo $nowmem >/proc/sys/kernel/shmmax
echo "sysctl -q -w kernel.shmmax=$nowmem" >> /etc/rc.local
fiecho "250 32000 250 128">/proc/sys/kernel/sem
echo 'sysctl -q -w kernel.sem="250 32000 250 128"'>>/etc/rc.local
echo "fs.file-max = 6815744">/proc/sys/fs/file-max
echo 'sysctl -q -w fs.file-max='6815744'>>/etc/rc.local
echo "fs.aio-max-nr = 1048575">/proc/sys/fs/file-max
echo 'sysctl -q -w fs.aio-max-nr = 1048575'>>/etc/rc.localsysctl -q -w net.ipv4.tcp_rmem="4096 87380 8388608"
echo 'sysctl -q -w net.ipv4.tcp_rmem="4096 87380 8388608"'>>/etc/rc.local
sysctl -q -w net.ipv4.tcp_wmem="4096 87380 8388608"
echo 'sysctl -q -w net.ipv4.tcp_mem="4096 87380 8388608"' >>/etc/rc.local
sysctl -q -w net.core.optmem_max=20480
echo 'sysctl -q -w net.core.optmem_max=20480' >>/etc/rc.local
sysctl -q -w net.core.rmem_default=262144
echo "sysctl -q -w net.core.rmem_default=262144" >>/etc/rc.local
sysctl -q -w net.core.rmem_default=262144
echo "sysctl -q -w net.core.rmem_default=262144" >>/etc/rc.localsysctl -q -w net.core.wmem_max=1073741823
echo 'sysctl -q -w net.core.wmem_max=1073741823' >>/etc/rc.local
sysctl -q -w net.core.wmem_max=1073741823
echo 'sysctl -q -w net.core.wmem_max=1073741823' >>/etc/rc.local
sysctl -q -w net.ipv4.tcp_max_syn_backlog=2048
echo 'sysctl -q -w net.ipv4.tcp_max_syn_backlog=2048' >>/etc/rc.local
sysctl -q -w net.ipv4.tcp_syncookies=1
echo 'sysctl -q -w net.ipv4.tcp_syncookies=1' >>/etc/rc.localsysctl -q -w net.ipv4.tcp_synack_retries=3
echo 'sysctl -q -w net.ipv4.tcp_synack_retries=3' >>/etc/rc.local
sysctl -q -w net.ipv4.tcp_syn_retries=3
echo 'sysctl -q -w net.ipv4.tcp_syn_retries=3' >>/etc/rc.localsysctl -q -w net.ipv4.ip_local_port_range='9000 65000'
echo 'sysctl -q -w net.ipv4.ip_local_port_range="9000 65000"' >>/etc/rc.local
cp /etc/security/limits.conf /etc/security/limits.conf.bak
echo "oracle soft nofile 65536">>/etc/security/limits.conf
echo "oracle hard nofile 65536">>/etc/security/limits.conf
echo "oracle soft nproc 16384">>/etc/security/limits.conf
echo "oracle hard nproc 16384">>/etc/security/limits.conf
echo "session required">>/etc/pam.d/login
yum -y install binutils compat-db control-center gcc gcc-c++ glibc gnome-libs libstdc++ libstdc++-devel make openmotif21 openmotif-devel setarch libaio
libXp compat-libstdc++ compat-gcc compat-gcc libgnome-devel compat-gcc-34-c++ libaio libaio-devel sysstat unixODBC-2.2.11-7.1.i386 unixODBC-devel-2.2.11-7.1.i386 unixODBC-devel-2.2.11-7.1.x86_64 unixODBC-2.2.11-7.1.x86_64
#install group#yum -y groupinstall "Development Tools" "Development Libraries" "Legacy Software Development" "Legacy Software Support" groupadd dba
groupadd oinstall
groupadd operuseradd -c "Oracle software owner" -g oinstall -G dba oraclemkdir -p /u01/app/db11g
chown -R oracle.oinstall /u01/echo 'ORACLE_BASE=/u01/app/oracle;export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1;export ORACLE_HOME
ORACLE_TERM=xterm;export ORACLE_TERM
PATH=$ORACLE_HOME/bin:$PATH;export PATH
ORACLE_OWNER=oracle;export ORACLE_OWNER
ORACLE_SID=YOUDI;export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib;export CLASSPATH
TMP=/tmp;export TMP
TMPDIR=$TMP;export TMPDIR
'>>/home/oracle/.bash_profile
su - oracle
#cd $oraclesrc/database
#./runInstaller -silent -responseFile response/enterprise.rsp使用方法:
使用root用户,mkdir /oraclesrc 存放oracle 11g的安装包,chmod +x 脚本名,./脚本名 执行 ,passwd oracle 修改oracle 密码,su - oracle ,执行安装就可以了