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