《管理信息化安装后总结.》由会员分享,可在线阅读,更多相关《管理信息化安装后总结.(10页珍藏版)》请在金锄头文库上搜索。
1、.linux 安装oracle 总结: Redhat5.4 x64安装ORACLE10G修改 /etc/vsftpdftpusers and user_ 开启FTP.首先安装以下包:rpm -q glibc glibc-common glibc-devel libXp binutils binutils compat-db control-enter gcc gcc-c+ libstdc+ libstdc+-devel make ksh sysstat gnome-screensaver libaio-devel libaio openmotif22用以下命令检查是否全部成功:$ rpm -q
2、a |grep glibc-2glibc-2.3.4-2.13compat-glibc-2.3.2-95.30compat-glibc-2.3.2-95.30glibc-2.3.4-2.13$ rpm -qa |grep glibc-develglibc-devel-2.3.4-2.13glibc-devel-2.3.4-2.13 32(32位)rpm -qa -queryformat %NAME-%VERSION-%RELEASE (%ARCH)n|grep 终极查看法.以root用户身份执行,在两节点上做如下配置。编辑/etc/sysctl.conf文件# vi /etc/sysctl.c
3、onf在文件尾部添加下述内容kernel.shmall = 2097152kernel.shmmax = 4294967297/ 物理内存的一半kernel.shmmni = 4096kernel.sem = 250 32000 100 128vm.min_free_kbytes=409600vm.vfs_cache_pressure=200vm.swappiness =40fs.file-max = 101365net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 1048576/ 256Knet.core.rmem
4、_max = 1048576/ 1Mnet.core.wmem_default = 262144net.core.wmem_max = 1048576Sysctl -p生效.为 oracle 用户设置 Shell 限制.Oracle 建议对每个 Linux 帐户可以使用的进程数和打开的文件数设置限制,ROOT登录.(/etc/profile file (or the file on SUSE systems)/etc/profile.local:if $USER = oracle ; thenif $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n
5、 65536elseulimit -u 16384 -n 65536fifi For the C shell (csh or tcsh), add the following lines to the/etc/csh.login file (or the file on SUSEsystems)/etc/csh.login.local:if ( $USER = oracle ) thenlimit maxproc 16384limit descriptors 65536endifAdd the following lines to the /etc/security/limits.conf f
6、ile:oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536修改/etc/pam.d/login,增加以下内容session required /lib/security/pam_limits.so配置hangcheck-timer内核模块以root用户身份执行,在两节点上做如下配置。查看模块是否存在# find /lib/modules -name hangcheck-timer.ko编辑/etc/modprobe.conf# vi /etc/modprobe.
7、conf在文件的末尾加入一行options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180配置为自启动vi /etc/rc.d/rc.local在文件的末尾加入一行/sbin/modprobe hangcheck_timer启动hangcheck# modprobe hangcheck_timer检查hangcheck是否成功启动# grep hangcheck /var/log/messages | tail -2如果显示下述信息说明已经成功启动hangcheckMar 16 12:52:32 node2 kernel: Hang
8、check: starting hangcheck timer 0.5.0 (tick is 180 seconds, margin is 60 seconds).创建ORACLE用户及文件夹权限等新增组和用户:groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oraclepasswd oracle 创建Oracle的安装目录,并把权限付给oracle用户:mkdir oracle chown -R oracle:oinstall /oracle解压database修改database目录权限,用户和用户组chown -R orac
9、le:oinstall database/chmod -R 775 database/. 修改/etc/hosts文件及oracle用户里的.bash_profile文件# Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbinexport PATHunset USE
10、RNAMEORA_CRS_BASE=/oracle/crsORA_CRS_HOME=$ORA_CRS_BASE/product/10.2.0/crs_1ORACLE_BASE=/oracle/app#ORACLE_BASE=$ORA_CRS_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1#ORACLE_HOME=$ORA_CRS_HOMEORACLE_SID=oradb1PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/usr/local/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME
11、/lib:$ORACLE_HOME/lib32:$ORA_CRS_HOME/lib:$ORA_CRS_HOME/lib32NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORA_CRS_BASE ORA_CRS_HOME PATH NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH. 安装一些RAC_的必要包compat-binutils215-2.15.92.0.2-24.i386.rpmoracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpmoracl
12、easm-2.6.18-164.el5debug-2.0.5-1.el5.x86_64.rpmoracleasm-2.6.18-164.el5-debuginfo-2.0.5-1.el5.x86_64.rpmoracleasm-2.6.18-164.el5xen-2.0.5-1.el5.x86_64.rpmoracleasmlib-2.0.4-1.el5.x86_64.rpmoracleasm-support-2.1.3-1.el5.x86_64.rpm.配置SSH 用ORACLE用户执行分别在2台机上运行mkdir /.sshchmod 700 /.sshcd .ssh/usr/bin/ss
13、h-keygen -t rsa (回车就OK)#/usr/bin/ssh-keygen -t dsa (回车就OK) 这可以不做在RAC1 机上运行ssh name1 cat /home/oracle/.ssh/id_rsa.pubauthorized_keys#ssh name1 cat /home/oracle/.ssh/id_dsa.pubauthorized_keys这可以不做ssh name2 cat /home/oracle/.ssh/id_rsa.pubauthorized_keys#ssh name2 cat /home/oracle/.ssh/id_dsa.pubauthor
14、ized_keys这可以不做把authorized_keys cp 到RAC2中/home/oracle/.ssh/scp authorized_keys rac2:/home/oracle/.ssh/(分别在2台机上运行)chmod 600 authorized_keysssh rac2 dateexec /usr/bin/ssh-agent $SHELL /usr/bin/ssh-add 确定ForwardX11置为no 编辑或创建 $ vi oracle/.ssh/config 内容如下: Host * ForwardX11 no 8.Ntpdate . IP 时间同步Vi /etc/ntp.conf服务端restrict 0.0.0.0 mask 0.0.0.0 nomodifyserver 127.127.1.0fudge 127.127.1.0 stratum 10driftfile /var/lib/ntp/driftbroadcastdelay 0.008authenticate no keys /etc/ntp/keys运行 chkconfig ntp on /etc/init.d/ntpd restart客务端restrict 0.0.0.0 mask 0.0.0.0 nomodifyserver 127