本space搜集和整理各种环境下的Oracle 安装与参数调整和设置技术文章
如何在redhat 9,redhat ELAS 3/2.1,redat FC1 上安装oracle 10g(2)
上一篇 /
下一篇 2008-07-21 11:44:51
/ 个人分类:Oracle10g安装
#cat > /etc/redhat-release << EOF
#Red Hat EnterpriseLinuxAS release 3 (Taroon)
#EOF
记得安装完Oracle10g要还原该文件内容:
$su - root
#cp /etc/redhat-release.backup /etc/redhat-release
好了,做完以上的準备工作,我们该开始令人激动的Oracel10g安装! 安装前我们还需设定一下与Oracle相关的内核参数
先看看所有内核参数:
$su - root
#sysctl -a
安装执行指令在/tmp/Disk1下,我们不建议直接执行
runInstaller -ignoreSysPrereqs
对於Oracle10g, 需要设定为以下参数值,可以设定更大一点的值:
查核结果可执行右边括号中内容
shmmax = 2147483648 (cat /proc/sys/kernel/shmmax)
这意味着系统的共享内存达到4G,这是不合适的。一般,SHMMAX的设置可略大于本机内存配置。
事实上,缺省安装的RedHat 6.0核心运行Oracle 8.0.5是没有问题的,一般情况下可不对这些参数作出调整。
如确需调整,在完成修改后,要按文档要求重生成核心,并用lilo命令指定用新的核心进行引导。
shmmni = 4096 (cat /proc/sys/kernel/shmmni)
shmall = 2097152 (cat /proc/sys/kernel/shmall)
shmmin = 1 (ipcs -lm |grep "min seg size")
shmseg = 10 (被硬编码在kernel中,缺省值更高)
semmsl = 250 (cat /proc/sys/kernel/sem | awk '{print $1}')
semmns = 32000 (cat /proc/sys/kernel/sem | awk '{print $2}')
semopm = 100 (cat /proc/sys/kernel/sem | awk '{print $3}')
semmni = 128 (cat /proc/sys/kernel/sem | awk '{print $4}')
file-max = 65536 (cat /proc/sys/fs/file-max)
ip_local_port_range = 1024 65000
(cat /proc/sys/net/ipv4/ip_local_port_range)
NOTE: Do not change the value of any kernel parameter on a system where it is already higher than listed as minimum requirement.
On RHELAS3, RHELAS2.1, RH9, and on FC1 I had to increase the kernel parameters shmmax, semopm, and filemax to meet the minimum requirement.
Oracle also recommends to set the local port range ip_local_port_range for outgoing messages to "1024 65000" which is needed for high-usage systems. This kernel parameter defines the local port range for TCP and UDP traffic to choose from.
I added the following lines to the /etc/sysctl.conf file which is used during the boot process:
kernel.shmmax=2147483648
kernel.sem=250 32000 100 128
fs.file-max=65536
net.ipv4.ip_local_port_range=1024 65000
Adding these lines to the /etc/sysctl.conf file will cause the system to change these kernel parameters after each boot using the /etc/rc.d/rc.sysinit script. which is invoked by /etc/inittab. But in order that these new added lines or settings in /etc/sysctl.conf become effective immediately, execute the following command:
su - root
sysctl -p
For more information on shmmax, shmmni, shmmin, shmseg, and shmall, see Setting Shared Memory.
For more information on semmsl, semmni, semmns, and semopm, see Setting Semaphores.
For more information on filemax, see Setting File Handles.
-------------------
<在/oracle/10.1.0/bin/dbshut 加入>
##自动关闭Listner
if [ -f $ORACLE_HOME/bin/lsnrctl ] ; then
$ORACLE_HOME/bin/lsnrctl stop
fi
##自动关闭OracleApache Jserv
if [ -f $ORACLE_HOME/Apache/Apache/bin/httpdsctl ] ; then
$ORACLE_HOME/Apache/Apache/bin/httpdsctl stop
fi
36.完成後请测试
$/oracle/10.1.0/bin/dbstart
$/oracle/10.1.0/bin/dbshut
37.开机自动启动 Oracle
请将oracle10g这个script. cp至/etc/rc.d/init.d
$cp oracle10g /etc/rc.d/init.d
再加入开机服务程序中
#chkconfig --add oracle10g
#linuxconf
用linuxconf即可控制启动的层次.
************
***oracle10g 执行档
#!/bin/sh
#
# chkconfig: 345 51 49
# description: starts the oracle dabase de
#
echo "Oracle 10g auto start/stop"
ORA_OWNER=oracle
ORA_HOME=/oracle/10.1.0/db
case "$1" in
'start')
echo -n "Starting Oracle10g: "
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
touch /var/lock/subsys/oracle10g
echo
;;
'stop')
echo -n "Shutting Oracle10g: "
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
rm -f /var/lock/subsys/oracle10g
echo
;;
'restart')
echo -n "Restarting Oracle10g: "
$0 stop
$0 start
echo
;;
*)
echo "Usage: oracle10g {start | stop | restart }"
exit 1
esac
exit 0
*********************oracle10g************
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
elas
fc1
oracle10g
redhat
安装