环境:
虚拟机 --> VMware12.0
OS --> OEL5.6 (Linux安装可参考:Oracle Linux5.6安装)
DB --> Oracle11.0.2.4
shell工具 --> Xshell
1.创建组、用户及目录并设置权限
[root@itkaifang ~]# groupadd -g 1000 oinstall [root@itkaifang ~]# groupadd -g 1001 dba [root@itkaifang ~]# groupadd -g 1002 oper [root@itkaifang ~]# useradd -u 1001 -d /home/oracle -g oinstall -G dba,oper oracle [root@itkaifang ~]# mkdir -p /soft [root@itkaifang ~]# chown -R oracle:oinstall /soft [root@itkaifang ~]# chmod -R 755 /soft [root@itkaifang ~]# mkdir -p /u01/app/oracle [root@itkaifang ~]# chown -R oracle:oinstall /u01 [root@itkaifang ~]# chmod -R 755 /u01
2.为Oracle用户设置密码
[root@itkaifang ~]# passwd oracle Changing password for user oracle. New UNIX password: BAD PASSWORD: it is based on a dictionary word Retype new UNIX password: passwd: all authentication tokens updated successfully.
3.修改内核参数
[root@itkaifang ~]# 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 [root@itkaifang ~]# /sbin/sysctl -p
4.修改限制
[root@itkaifang ~]# vi /etc/security/limits.conf (在配置文件下方添加如下信息) oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240
5.YUM安装软件包
挂载光盘映像
[root@itkaifang ~]$ mount /dev/cdrom /mnt [root@itkaifang ~]$ vi /etc/yum.repos.d/public-yum-el5.repo (配置YUM源,添加如下信息) [oel5] name = Enterprise Linux 5.6 DVD baseurl=file:///mnt/Server/ gpgcheck=0 enabled=1 [root@itkaifang ~]$ yum install oracle-validated
6.打开新会话以oracle用户登录配置环境变量
[root@itkaifang ~]# su - oracle [oracle@itkaifang ~]$ vi .bash_profile (修改环境变量,添加如下信息) export PATH export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 export ORACLE_SID=itkaifang (此处SID自定义) export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin [oracle@itkaifang ~]$ . .bash_profile (从新加载环境变量)
7.上传oracle安装介质并修改介质权限
[oracle@itkaifang ~]$ cd /soft [oracle@itkaifang soft]$ ll -rw-r--r-- 1 oracle oinstall 1239269270 01-31 15:00 linux.x64_11gR2_database_1of2.zip -rw-r--r-- 1 oracle oinstall 1111416131 01-31 15:01 linux.x64_11gR2_database_2of2.zip
8.解压缩安装介质:
[oracle@itkaifang soft]$ unzip linux.x64_11gR2_database_1of2.zip [oracle@itkaifang soft]$ unzip linux.x64_11gR2_database_2of2.zip [oracle@itkaifang soft]$ ll 总计 4 drwxr-xr-x 8 oracle oinstall 4096 2009-08-21 database
9.安装Oracle软件
[oracle@itkaifang soft]$ cd /soft/database/ [oracle@itkaifang database]$ ./runInstaller (启动图形安装界面)
10.创建监听
[oracle@itkaifang soft]$ netca (创建监听)
11.创建数据库
[oracle@itkaifang soft]$ dbca (创建数据库)