oracle安装-简介

2024-08-29 13:54:29

字体：大中小

来源：转载

供稿：网友

3.调整linux系统：关闭防火墙：

service iptables stop

service ip6tables stop

chkconfig iptables off

chkconfig ip6tables off

管理工具中disabled防火墙关闭selinux：

vi /etc/selinux/config SELINUX=disabled

配置yum：

4.确认root身份:

id

5.硬件配置：

6.rpm检查并安装：

# cat /etc/redhat-release -----一般支持系统rhel4.5 以下# uname -r# rpm -qa | grep glibc# yum install -y glibc

yum install -y glibc.i686

yum install -y binutils-2.20.51.0.2-5.11.el6 (x86_64) compat-libcap1-1.10-1 (x86_64) yum install -y compat-libstdc++-33-3.2.3-69.el6 (x86_64) yum install -y compat-libstdc++-33-3.2.3-69.el6.i686 yum install -y gcc-4.4.4-13.el6 (x86_64) yum install -y gcc-c++-4.4.4-13.el6 (x86_64) yum install -y glibc-2.12-1.7.el6 (i686) yum install -y glibc-2.12-1.7.el6 (x86_64) yum install -y glibc-devel-2.12-1.7.el6 (x86_64) yum install -y glibc-devel-2.12-1.7.el6.i686 yum install -y ksh yum install -y libgcc-4.4.4-13.el6 (i686) yum install -y libgcc-4.4.4-13.el6 (x86_64) yum install -y libstdc++-4.4.4-13.el6 (x86_64) yum install -y libstdc++-4.4.4-13.el6.i686 yum install -y libstdc++-devel-4.4.4-13.el6 (x86_64) yum install -y libstdc++-devel-4.4.4-13.el6.i686 yum install -y libaio-0.3.107-10.el6 (x86_64) yum install -y libaio-0.3.107-10.el6.i686 yum install -y libaio-devel-0.3.107-10.el6 (x86_64) yum install -y libaio-devel-0.3.107-10.el6.i686 yum install -y make-3.81-19.el6 yum install -y sysstat-9.0.4-11.el6 (x86_64) ============================================直接安装以下============================

yum install glibc.i686 binutils-2.20.51.0.2-5.11.el6(x86_64) compat-libcap1-1.10-1(x86_64) ompat-libstdc++-33-3.2.3-69.el6(x86_64) compat-libstdc++-33-3.2.3-69.el6.i686 gcc-4.4.4-13.el6 (x86_64) gcc-c++-4.4.4-13.el6(x86_64) glibc-2.12-1.7.el6(i686) glibc-2.12-1.7.el6(x86_64) glibc-devel-2.12-1.7.el6(x86_64) glibc-devel-2.12-1.7.el6.i686 Ksh libgcc-4.4.4-13.el6(i686) libgcc-4.4.4-13.el6(x86_64) libstdc++-4.4.4-13.el6(x86_64) libstdc++-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6(x86_64) libstdc++-devel-4.4.4-13.el6.i686 libaio-0.3.107-10.el6 (x86_64) libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6(x86_64) libaio-devel-0.3.107-10.el6.i686 make-3.81-19.el6 sysstat-9.0.4-11.el6(x86_64)

7.创建用户：

# groupadd -g 1000 oinstall# groupadd -g 1001 dba# groupadd -g 1002 oper# useradd -u 1000 -g oinstall -G dba,oper Oracle# passwd oracle

8.修改内核参数：

# vi /etc/sysctl.conf

fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576

# sysctl -p

9.修改资源限制：

# vi /etc/security/limits.conforacle soft nofile 1024oracle hard nofile 65536oracle soft nPRoc 2047oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768

10.创建目录：

# mkdir -p /u 01/app/oracle# chown -R oracle:oinstall /u01# chmod -R 775 /u01

11.修改概要文件：

# vi ~oracle/.bash_profileexport ORACLE_SID=orclexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1#export ORACLE_HOSTNAME=node1.test.comexport ORACLE_UNQNAME=orclexport PATH=$PATH:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport NLS_LANG=american_america.AL32UTF8export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'export EDITOR=vi#export LANG=C

12.使用hosts文件解析主机名：

# hostnamenode1.test.com# vi /etc/hosts192.168.0.1 node1.test.com node1# ping node1# ping node1.test.com

13.解压缩安装包：

# cd /installation# unzip p10404530_112030_Linux-x86-64_[12]of7.zip

图形界面下，root注销，以oracle身份登录

$ cd /installation/database/$ ./runInstaller

14.图形界面安装： ——百度安装图形界面略以root身份执行两个脚本 15.创建监听和数据库： —–监听可以先不配置图形界面下创建监听，oracle执行：

$ netca$ lsnrctl status$ netstat -tlnp | grep 1521

图形界面创建db，oracle执行：

$ dbca

16.测试：

sqlplus测试：$ sqlplus sys/sys@orcl as sysdba$ sqlplus / as sysdbaSQL> show userSQL> select count(*) from hr.employees;SQL> exit