安装oracle 脚本

最新推荐文章于 2024-10-06 21:49:48 发布

cuanzhuang1647

最新推荐文章于 2024-10-06 21:49:48 发布

阅读量209

点赞数

文章标签：数据库

#!/bin/bash
groupadd -g 1001 oinstall
groupadd -g 1002 dba
useradd -u 1001 -m -g oinstall -G dba oracle
id oracle
a=oracle
echo oracle:$a|chpasswd

mkdir -p /u01/app/oracle
mkdir -p /u02/oradata/
mkdir -p /u02/oracrs
chown -R oracle:oinstall /u01
chmod -R 775 /u02 /u01

cat >> /etc/sysctl.conf <kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=3262144
net.core.wmem_max=3262144
EOF

cat >> /etc/security/limits.conf <oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 65536
oracle hard nofile 65536
EOF

cat >> /etc/pam.d/login <session required /lib/security/pam_limits.so
EOF

cat >> /etc/profile <if [ \$USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF

cat >> /etc/csh.login <if ( \$USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
umask 022
endif
EOF

cat >> /etc/rc.d/rc.local<modprobe hangcheck-timer hangcheck_tick=30 hangcheck_margin=180
EOF

cat >>/home/oracle/.bash_profile<unset USERNAME
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/10.2.0.1/db
export ORA_CRS_HOME=\$ORACLE_BASE/product/10.2.0.1/crs
export ORA_DB_HOME=\$ORACLE_BASE/product/10.2.0.1/db
export ORACLE_SID=HASB
export PATH=\$PATH:\$HOME/bin:\$ORACLE_HOME/bin:\$ORA_CRS_HOME/bin:\$ORACLE_BASE/common/oracle/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
export ORACLE_PATH=\$ORACLE_BASE/common/oracle/sql:\$ORACLE_HOME/rdbms/admin
export ORACLE_TERM=xterm
export TNS_ADMIN=\$ORACLE_HOME/network/admin
export ORA_NLS10=\$ORACLE_HOME/nls/data
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib
export LD_LIBRARY_PATH=\${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=\$ORACLE_HOME/JRE
export CLASSPATH=\${CLASSPATH}:\$ORACLE_HOME/jlib
export CLASSPATH=\${CLASSPATH}:\$ORACLE_HOME/rdbms/jlib
export CLASSPATH=\${CLASSPATH}:\$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
umask=022
EOF