服务器:sun的工作站
操作系统:soralis10
oracle版本:11g我选择想写一个脚本,运行后就可以自动建立数据库。请明白的人指导以下。谢谢
操作系统:soralis10
oracle版本:11g我选择想写一个脚本,运行后就可以自动建立数据库。请明白的人指导以下。谢谢
解决方案 »
- 电脑断电之后,重启电脑,oracel连接不了?
- Linux下的oracle,要完成数据入库,该怎么进行着手呢?
- oracle 数据库,监听停了以后,直接就shutdown immediate,然后 数据库的服务器就再连不上了
- oracle 9.2.0.1 升级到9.2.0.8 后EXP IMP出错
- Pl/SQL写二进制文件
- Oracle数据库中多重Gruop By与Order by连接在一起怎么弄 ?怎么写,给个思路或者实例吧!
- Oracle 10g 客户端连接的问题。
- 这个过程(procedure ) declare 有问题,能帮我看看吗?
- 返回数据集的存储过程怎么写
- Oracle数据表出问题了
- 关于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 ,执行安装就可以了