|
操作系统要求(OS requirement)：
# cat /proc/version
Asianux Server 3 SP2
Oracle Linux 4 Update 7
Oracle Linux 5 Update 2 (with Red Hat Compatible Kernel)
Oracle Linux 5 Update 5
Oracle Linux 6
Oracle Linux 6 (with Red Hat Compatible Kernel)
Red Hat Enterprise Linux 4 Update 7
Red Hat Enterprise Linux 5 Update 2
Red Hat Enterprise Linux 5 Update 5 (with the Oracle Unbreakable Enterprise Kernel for Linux)
Red Hat Enterprise Linux 6
Red Hat Enterprise Linux 6 (with the Oracle Unbreakable Enterprise Kernel for Linux)
SUSE Linux Enterprise Server 10 SP2
SUSE Linux Enterprise Server 11
内核需求(kernel requirements)：
# uname -r
On Oracle Linux 4 and Red Hat Enterprise Linux 4
2.6.9 or later
On Oracle Linux 5 Update 5
2.6.32-100.0.19 or later
On Oracle Linux 5 Update 2
2.6.18 or later (with Red Hat Compatible Kernel)
On Oracle Linux 6
2.6.32-100.28.5.el6.x86_64 or later
On Oracle Linux 6
2.6.32-71.el6.x86_64 or later (with Red Hat Compatible Kernel)
On Red Hat Enterprise Linux 5 Update 5 with the Oracle Unbreakable Enterprise Kernel for Linux
2.6.32 or later
On Red Hat Enterprise Linux 6 with the Oracle Unbreakable Enterprise Kernel for Linux
2.6.32-100.28.5.el6.x86_64 or later
On Red Hat Enterprise Linux 6
2.6.32-71.el6.x86_64 or later
On Asianux Server 3, Oracle Linux 5 Update 2, and Red Hat Enterprise Linux 5 Update 2
2.6.18 or later
On SUSE Linux Enterprise Server 10
2.6.16.21 or later
On SUSE Linux Enterprise Server 11
2.6.27.19 or later
Installation：
1.
修改sysctl.conf文件，在文件末尾插入
Edit sysctl.conf file，at the end of file add in
|
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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
2.
执行sysctl –p，确保输出结果与第一步的数据相同
Enter sysctl –p, make sure the output is the same as step 1
|
3.
修改limits.conf，在文件末尾插入
Edit limits.conf file，at the end of file add in
|
vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle hard stack 10241
|
4.
关闭selinux，把enforcing 改为disabled
Turn off selinux, change enforcing to disabled
|
vi /etc/sysconfig/selinux
selinux=disabled
|
5.
关闭linux防火墙
Turn off iptables
|
service iptables stop
chkconfig iptables off
|
6.
查看防火墙启动状态
Check iptables status
|
7.
配置yum
Yum configuration
|
mkdir /iso
umount /dev/sr0
mount /dev/sr0 /iso
vi /etc/yum.repos.d/local.repo
[server]
name=server
baseurl=file:///iso
enabled=1
gpgcheck=0
|
8.
Yum install
|
Create users and groups
|
groupadd dba
groupadd oinstall
groupadd oper
useradd oracle
创建oracle用户
/usr/sbin/useradd -g oinstall -G dba,oper oracle
usermod -g dba oracle
把oracle用户加到dba组里
passwd oracle
给oracle用户建密码
|
10.
给oracle建安装目录
Create install dirctory for oracle
|
mkdir -p /u01/app/oracle
chown -R oracle:dba /u01/app/oracle
把文件属主改为oracle
chmod -R 777 /u01/app/oracle
把文件权限改为777
|
11. 配置oracle用户环境变量（home、base、sid、path、umask）
Configure oracle
user's environment variable
|
su – oracle
vi /home/oracle/.bash_profile
ORACLE_BASE=/u01/app/oracle
ORACLE_SID=sales
ORACLE_HOME=$ORACLE_BASE/11.2.4/dbhome_1
export ORACLE_BASE ORACLE_SID ORACLE_HOME
export PATH=$ORACLE_HOME/bin:$PATH
|
(ORACLE_HOME路径跟安装路径一定要一致）
(ORACLE_HOME must be the same with install path)
12.
使新环境变量生效
Make new environment variables effective
|
13.
添加/etc/hosts
Edit /etc/hosts
|
su
vi /etc/hosts
(写本机ip和主机名)
（write your ip and username）
14.
Reboot
15. 上传oracle文件到/u01并解压
Upload oracle files to /u01 and unzip
16. 切换到oracle用户
Switch to oracle user
|
dbca
NEXT
NEXT
NEXT
SID与环境变量中的SID一致
SID here must be the same as SID in .bash_profile
不勾选
Do not tick
输入密码
Enter password
NEXT
NEXT
勾选
这个就会装练习用的表，不选就是空白数据库
Tick this will have sample schemas, otherwise is empty database
第
一个是内存分配，第二个是进程分配，第三个是字符集，第四个是pga运行方式
NEXT
NEXT
建监听（Listener configuration）
-
netca
-
NEXT
-
NEXT
-
NEXT
-
NEXT
-
NEXT
-
NEXT
【声明】：本博客不参与任何交易，也非中介，仅记录个人感兴趣的主机测评结果和优惠活动，内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客，即表示您已经知晓并接受了此声明通告。
| | | | | | | | 
