甜橘子，专注成都网站制作网站设计与营销型网站建设与优化
QQ :532337155
电话：028-86922220
OS安装，RHEL6.5默认安装即可，关闭iptables，关闭selinux，修改本地hosts文件
~]# service iptables stop ~]# chkconfig --del iptables ~]# vim /etc/selinux/config #配置重启后永久有效 SELINUX=disabled ~]# vim /etc/hosts
制作本地yum仓库，oracle11gR2所依赖包安装
~]# cd / /]# mkdir local.repo ~]# cd /media/RHEL_6.5\ x86_64\ Disc\ 1/ cp -rf * /localrepo/ ~]# vim /etc/yum.repos.d/localrepo [localrepo] name=localrepo baseurl=file:///localrepo gpgcheck=0 enabled=1 ~]# yum repolist Loaded plugins: product-id, refresh-packagekit, security, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. localrepo | 3.9 kB 00:00 ... localrepo/primary_db | 3.1 MB 00:00 ... repo id repo name status localrepo localrepo 3,690 repolist: 3,690
安装所依赖包：
yum install binutils-2.* compat-libstdc++-33* elfutils-libelf-0.* elfutils-libelf-devel-* gcc-4.* gcc-c++-4.* glibc-2.* glibc-common-2.* glibc-devel-2.* glibc-headers-2.* ksh-2* libaio-0.* libaio-devel-0.* libgcc-4.* libstdc++-4.* libstdc++-devel-4.* make-3.* sysstat-7.* unixODBC-2.* unixODBC-devel-2.* pdksh* -y 注意：还有一个包需要单独安装 rpm -ivh pdksh-5.2.14-30.x86_64.rpm warning: pdksh-5.2.14-30.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 73307de6: NOKEY error: Failed dependencies: pdksh conflicts with ksh-20120801-10.el6.x86_64 先要对ksh-20120801-10.el6.x86_64进行卸载处理 rpm -e ksh-20120801-10.el6.x86_64 rpm -ivh pdksh-5.2.14-30.x86_64.rpm warning: pdksh-5.2.14-30.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 73307de6: NOKEY Preparing... ########################################### [100%] 1:pdksh ########################################### [100%]
~]# groupadd -g 1000 oinstall ~]# groupadd -g 1100 dba ~]# useradd -m -g oinstall -G dba -u 1200 oracle ~]# id oracle uid=1200(oracle) gid=1000(oinstall) groups=1000(oinstall),1100(dba) ~]# passwd oracle [oracle@~]$ vim .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export ORACLE_SID=***** export ORACLE_HOME=/home/u01/app/oracle/product/11.2.0/db_1 export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi export PATH
~]# mkdir -p /home/u01/app/oracle/product/11.2.0/db_1 ~]# chown -R oracle:oinstall /home/u01
~]# vim /etc/sysctl.conf #添加如下 # Controls the maximum size of a message, in bytes kernel.msgmax = 65536 # Controls the maximum shared segment size, in bytes kernel.shmmax = 32000000000 # Controls the maximum number of shared memory segments, in pages kernel.shmall = 8388608 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 = 4194304 net.core.wmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_max = 262144 kernel.msgmnb = 65536 kernel.msgmax = 65536 fs.aio-max-nr = 262144 sysctl -p ~]# vim /etc/security/limits.conf #添加如下 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 ~]# vim /etc/pam.d/login #添加如下 session required pam_limits.so ~]# vim /etc/security/limits.d/90-nproc.conf # Default limit for number of user's processes to prevent # accidental fork bombs. # See rhbz #432903 for reasoning. * - nproc 16384 root soft nproc unlimited
授权oracle权限 tmp]# chmod 777 -R oracle/ [root tmp]# chown -R oracle.oinstall oracle/ 进入oracle用户进行解压 oracle]$ unzip p13390677_112040_Linux-x86-64_1of7.zip oracle]$ unzip p13390677_112040_Linux-x86-64_2of7.zip root用户下进行桌面共享xhost+ 进入oracle用户进行安装 oracle]# cd /tmp/oracle/database/ database]# ./runInstaller 注意安装路径要和之前配置的环境变量路径一致,安装时选择仅安装software，安装验证时报的swap空间错误可以忽略 后续建库可用通过dbca完成，配置监听通过netca
另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。