oracle linux 5.8安裝oracle 10資料庫

標籤：oracle   linux   防火牆   資料庫軟體   

1.下載oracle luinux 5.8和oracle 10g資料庫軟體

2.作業系統安裝

  (1).圖形化介面安裝

  (2).系統磁碟分割

     /       根分區(9G)

     /home    安裝oracle分區(10G)

     swap     交換分區(1G)

  (3).禁用防火牆

  (4).禁用Selinux

3.搭建yum網路源

[[email protected] Server]# cd /etc/yum.repos.d/

[[email protected] yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo

[[email protected] yum.repos.d]# vim public-yum-el5.repo

[ol5_u8_base]

name=Oracle Linux $releasever Update 8 installation media copy ($basearch)

baseurl=http://yum.oracle.com/repo/OracleLinux/OL5/8/base/$basearch/

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

gpgcheck=1

enabled=1     --開啟

[[email protected] yum.repos.d]# yum repolist

4.安裝系統依賴包

[[email protected] ]# yum install 

binutils

compat-*

gcc-*

glibc-*

libXp

libXt

libXtst

libaio*

libgcc

libstdc++-*

libgomp

make

numactl-devel

sysstat -y

5.修改核心參數

[[email protected] ~]# vim /etc/sysctl.conf 

kernel.shmall = 2097152

kernel.shmmax = 2147483648

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 = 262144

net.core.rmem_max = 262144

net.core.wmem_default = 262144

net.core.wmem_max = 262144

[[email protected] ~]# sysctl -p      --添加的參數生效

6.使用者對系統的限制

[[email protected] ~]# vim /etc/security/limits.conf 

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft nofile 65536

oracle hard nofile 65536

[[email protected] ~]#

7.使用者對shell的限制

[[email protected] ~]# vim /etc/profile

if [ $USER = "oracle" ]; then

   if [ $SHELL = "/bin/ksh" ]; then

      ulimit -p 16384

      ulimit -n 65536

   else

   ulimit -u 16384 -n 65536

   fi

fi

[[email protected] ~]# . /etc/profile

8.使用者登陸驗證模組

[[email protected] security]# vim /etc/pam.d/login 

session   required     /lib/security/pam_limits.so

session   required     pam_limits.so

[[email protected] security]#

9.主機各與IP位址解析,修改系統版本

[[email protected] ~]# vim /etc/hosts

192.168.2.143  oracle1

[[email protected] ~]# vim /etc/redhat-release 

Red Hat Enterprise Linux Server release 4 (Tikanga)

[[email protected] ~]# vim /etc/oracle-release 

Oracle Linux Server release 4

[[email protected] ~]#

10.建立使用者和使用者組

[[email protected] ~]# groupadd  -g 500 oinstall

[[email protected] ~]# groupadd  -g 501 dba

[[email protected] ~]# useradd  -g oinstall -G dba oracle -d /home/oracle

[[email protected] ~]# chown -R oracle:oinstall /home/oracle

[[email protected] ~]# password oracle    --設定密碼

11.用oracle使用者登陸設定環境變數

[[email protected] ~]# su - oracle

[[email protected] ~]$ vim ~/.bash_profile 

export ORACLE_BASE=/home/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0.1/db_1

export ORACLE_SID=orcl10

export PATH=$ORACLE_HOME/bin:$PATH

[[email protected] ~]$

12.解壓oracle 10g軟體並安裝

[[email protected] ~]# zcat 10201_database_linux_x86_64.cpio.gz  | cpio  -idvm

[[email protected] ~]# xhost +

[[email protected] ~]# su - oracle

[[email protected] ~]# cd database/

[[email protected] database]# ./runInstaller 

650) this.width=650;" src="http://s2.51cto.com/wyfs02/M01/84/7A/wKiom1eRvYfjVbk2AAMK3HjTtD8443.png-wh_500x0-wm_3-wmp_4-s_3589438642.png" style="float:none;" title="10.png" alt="wKiom1eRvYfjVbk2AAMK3HjTtD8443.png-wh_50" />

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M00/84/7A/wKiom1eRvYnj3M7iAAMgvtZ3l7A626.png-wh_500x0-wm_3-wmp_4-s_3639049349.png" style="float:none;" title="11.png" alt="wKiom1eRvYnj3M7iAAMgvtZ3l7A626.png-wh_50" />

650) this.width=650;" src="http://s1.51cto.com/wyfs02/M01/84/79/wKioL1eRvYqSs3v5AAMoQuwf8mE686.png-wh_500x0-wm_3-wmp_4-s_2080719592.png" style="float:none;" title="12.png" alt="wKioL1eRvYqSs3v5AAMoQuwf8mE686.png-wh_50" />

650) this.width=650;" src="http://s4.51cto.com/wyfs02/M01/84/79/wKioL1eRvYzAgvspAAMPwVnW7vE698.png-wh_500x0-wm_3-wmp_4-s_674862338.png" style="float:none;" title="13.png" alt="wKioL1eRvYzAgvspAAMPwVnW7vE698.png-wh_50" />

650) this.width=650;" src="http://s3.51cto.com/wyfs02/M01/84/7A/wKiom1eRvY7A8BnmAAJH3WFDCEw561.png-wh_500x0-wm_3-wmp_4-s_3497632816.png" style="float:none;" title="14.png" alt="wKiom1eRvY7A8BnmAAJH3WFDCEw561.png-wh_50" />

650) this.width=650;" src="http://s1.51cto.com/wyfs02/M02/84/7A/wKiom1eRvY-Rll6PAAMx7f8KD0k557.png-wh_500x0-wm_3-wmp_4-s_3407517229.png" style="float:none;" title="15.png" alt="wKiom1eRvY-Rll6PAAMx7f8KD0k557.png-wh_50" />

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M02/84/79/wKioL1eRvZGxjRLxAAM0WXOegyg977.png-wh_500x0-wm_3-wmp_4-s_303947833.png" style="float:none;" title="16.png" alt="wKioL1eRvZGxjRLxAAM0WXOegyg977.png-wh_50" />

650) this.width=650;" src="http://s3.51cto.com/wyfs02/M00/84/7A/wKiom1eRvZLQNGsKAAM3DFNsrR0969.png-wh_500x0-wm_3-wmp_4-s_2964051944.png" style="float:none;" title="17.png" alt="wKiom1eRvZLQNGsKAAM3DFNsrR0969.png-wh_50" />

650) this.width=650;" src="http://s3.51cto.com/wyfs02/M02/84/7A/wKioL1eRvZTB8SVnAAMItfER8w0796.png-wh_500x0-wm_3-wmp_4-s_3757287795.png" style="float:none;" title="18.png" alt="wKioL1eRvZTB8SVnAAMItfER8w0796.png-wh_50" />

650) this.width=650;" src="http://s3.51cto.com/wyfs02/M02/84/7A/wKiom1eRvZbAsZnbAAMsBddjc4w860.png-wh_500x0-wm_3-wmp_4-s_2339134147.png" style="float:none;" title="19.png" alt="wKiom1eRvZbAsZnbAAMsBddjc4w860.png-wh_50" />

650) this.width=650;" src="http://s2.51cto.com/wyfs02/M00/84/7A/wKioL1eRvZjBqFolAAMkC8DQbYE289.png-wh_500x0-wm_3-wmp_4-s_757858793.png" style="float:none;" title="20.png" alt="wKioL1eRvZjBqFolAAMkC8DQbYE289.png-wh_50" />

650) this.width=650;" src="http://s1.51cto.com/wyfs02/M00/84/7A/wKiom1eRvZnwPLCuAAJn_ukg2EM977.png-wh_500x0-wm_3-wmp_4-s_2325116745.png" style="float:none;" title="21.png" alt="wKiom1eRvZnwPLCuAAJn_ukg2EM977.png-wh_50" />

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M00/84/7A/wKioL1eRvZqzwgukAAFaVaH5uxs294.png-wh_500x0-wm_3-wmp_4-s_2242574379.png" style="float:none;" title="22.png" alt="wKioL1eRvZqzwgukAAFaVaH5uxs294.png-wh_50" />

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M02/84/7A/wKioL1eRvbzggJjRAAFVWqpbrqU332.png-wh_500x0-wm_3-wmp_4-s_2308503253.png" title="23.png" alt="wKioL1eRvbzggJjRAAFVWqpbrqU332.png-wh_50" />

650) this.width=650;" src="http://s3.51cto.com/wyfs02/M01/84/7A/wKiom1eRv1KRgas5AADx6_Pwf0Q468.png-wh_500x0-wm_3-wmp_4-s_3466511671.png" style="float:none;" title="24.png" alt="wKiom1eRv1KRgas5AADx6_Pwf0Q468.png-wh_50" />

650) this.width=650;" src="http://s3.51cto.com/wyfs02/M02/84/7A/wKioL1eRv1PxC2ZOAADwkpP_AIw487.png-wh_500x0-wm_3-wmp_4-s_4165540961.png" style="float:none;" title="25.png" alt="wKioL1eRv1PxC2ZOAADwkpP_AIw487.png-wh_50" />

650) this.width=650;" src="http://s5.51cto.com/wyfs02/M00/84/7A/wKiom1eRv1XSKwe8AAEFzSDnMRU131.png-wh_500x0-wm_3-wmp_4-s_2754322756.png" style="float:none;" title="26.png" alt="wKiom1eRv1XSKwe8AAEFzSDnMRU131.png-wh_50" />

650) this.width=650;" src="http://s1.51cto.com/wyfs02/M00/84/7A/wKioL1eRv1aQ1u0AAAGQG8OrdsI498.png-wh_500x0-wm_3-wmp_4-s_992156499.png" style="float:none;" title="27.png" alt="wKioL1eRv1aQ1u0AAAGQG8OrdsI498.png-wh_50" />

13.登陸oracle資料庫

[[email protected] ~]# su - oracle

[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 22 14:41:09 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> show user;

USER is "SYS"

SQL>

本文出自 “一起走過的日子” 部落格，請務必保留此出處http://tongcheng.blog.51cto.com/6214144/1828676

oracle linux 5.8安裝oracle 10資料庫