Welcome 微信登录

首页 / 数据库 / MySQL / Linux下Oracle 10g 安装环境配置

linux下Oracle10g 安装里用的是RedHat linux as 5 和oracle10g
1、先打系统补丁
[root@oracle rpm]# rpm -ivh libXp-*warning: libXp-1.0.0-8.i386.rpm: Header V3DSA signature: NOKEY, key ID 82fd17b2Preparing...               ########################################### [100%]  1:libXp                 ########################################### [ 50%]  2:libXp-devel           ########################################### [100%][root@oracle rpm]# 2、修改操作系统核心参数
vi /etc/sysctl.conf
kernel.msgmax = 65536# Controls the maximum shared segment size,in byteskernel.shmmax = 536870912# Controls the maximum number of sharedmemory segments, in pageskernel.shmall = 2097152kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range =1024 65000net.core.rmem_default = 1048576net.core.rmem_max = 1048576net.core.wmem_default = 262144net.core.wmem_max = 262144
用下面这个命令就不需要重启了
/sbin/sysctl -p
设置shell调用限制
vi/etc/security/limits.conf
*       soft    nproc           2047*       hard    nproc           16384*       soft    nofile           1024*       hard    nofile           65536vi /etc/pam.d/login
session   required     pam_limits.so
下面来建组建用户
[root@oracle rpm]# groupadd oinstall[root@oracle rpm]# groupadd dba[root@oracle rpm]# useradd -g oinstall -gdba -m oracle[root@oracle rpm]# passwd oracleChanging password for user oracle.New UNIX password: BAD PASSWORD: it does not contain enoughDIFFERENT charactersRetype new UNIX password: passwd: all authentication tokens updatedsuccessfully.
[root@oracle rpm]# mkdir /opt/ora10g[root@oracle rpm]# mkdir/opt/ora10g/product[root@oracle rpm]# mkdir/opt/ora10g/oradata
[root@oracle rpm]# chown -R oracle:oinstall/opt/ora10g[root@oracle rpm]# su - oracle
[oracle@oracle ~]$ vi .bash_profile
PATH=$PATH:$HOME/bin
export TMP=/tmpexport TMPDIR=$TMPexport ORACLE_BASE=/opt/ora10gexportORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORACLE_SID=orcl
export ORACLE_TERM=xtermexport PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/x11R6/lib64exportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport LD_ASSUME_KERNEL=2.6.18export NLS_LANG="SIMPLIFIEDCHINESE_CHINA.UTF8"umask 022if [ $USER = "oracle" ]; then   if [ $SHELL = "/bin/ksh" ]; then      ulimit -p 16384      ulimit -n 65536
else       ulimit –u 16384 –n 65536   fifi  # modify /etc/redhat-releaseecho "#Red Hat Enterprise Linux Server release 5.3 (Tikanga)redhat-4" > /etc/redhat-release
[oracle@oracle ~]$ source .bash_profile
然后把软件拷贝到我门建的目录/opt/appxhost +su - oracle[oracle@oracle database]$ LANG=C[oracle@oracle database]$ ./runInstaller  Oracle手工建库Oracle 行级锁与表级锁相关资讯      Oracle基础教程 
  • Oracle块编程返回结果集详解  (11/10/2013 10:45:58)
  • Oracle基础教程之设置系统全局区  (08/22/2013 14:24:00)
  • Oracle基础教程知识点总结  (06/18/2013 07:43:32)
  • Oracle基础教程之tkprof程序详解  (10/22/2013 11:49:50)
  • Oracle基础教程之sqlplus汉字乱码  (07/18/2013 16:30:00)
  • Oracle 管理之 Linux 网络基础  (02/16/2013 18:37:35)
本文评论 查看全部评论 (0)
表情: 姓名: 字数