服务器:rhel-server-5.4-x86_64-dvd.iso
数据库:linux.x64_11gR2_database_1of2.zip,linux.x64_11gR2_database_2of2.zip
安装linux的时候,Servers定制包没选,开发包选择如下:
1.安装软件包:
rpm -Uvh libaio-devel-0.3.106-3.2.i386.rpm
rpm -Uvh libaio-devel-0.3.106-3.2.x86_64.rpm
rpm -Uvh unixODBC-2.2.11-7.1.i386.rpm
rpm -Uvh unixODBC-2.2.11-7.1.x86_64.rpm
rpm -Uvh unixODBC-devel-2.2.11-7.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-7.1.x86_64.rpm
2.创建用户和组:
- [root@localhost ~]# groupadd oinstall
- [root@localhost ~]# groupadd dba
- [root@localhost ~]# useradd -m -g oinstall -G dba oracle
- [root@localhost ~]# passwd oracle
- Changing password for user oracle.
- New UNIX password:
- BAD PASSWORD: it is too simplistic/systematic
- Retype new UNIX password:
- passwd: all authentication tokens updated successfully.
3.建立安装目录并设置相关权限:
- [root@localhost ~]# mkdir -p /opt/app/oracle/product/11.1.0/db_1
- [root@localhost ~]# chown -R oracle:oinstall /opt
- [root@localhost ~]# chmod -Rf ug+rwx /opt
4.vi /etc/sysctl.conf文件,添加如下语句(此参数有错误,正确参数在下面):
kernel.sem= 250 32000 100 128
fs.file-max=6815744
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 = 10488576
fs.aio-max-nr = 65536
使用sysctl -p立即生效
5.vi /etc/security/limits.conf
oracle soft memlock unlimited
oracle hard memlock unlimited
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
6.修改环境变量:vi /home/oracle/.bash_profile
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export LD_LIBRARY_PATH=/opt/app/oracle/product/11.1.0/db_1:$LD_LIBRARY_PATH
export PATH=/opt/app/oracle/product/11.1.0/db_1/bin:$PATH
export NLS_LANG=AMERICAN
umask 022
source /home/oracle/.bash_profile 而不用重启。
7.将安装介质上传至服务器/home目录下,并解压
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_1of2.zip
chown -R oracle:oinstall /home/database/
8.安装:
都是下一步。检查内核参数时,出现如下图错误:
vi /etc/sysctl.conf
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
sysctl -p,检查全通过,如下图:
看来步骤4是错误的,仔细想了下,那是安装oracle10g的参数。开始安装:
开始创建数据库实例:
安装完成。
用root用户执行:
/home/oracle/app/oraInventory/orainstRoot.sh
/home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh
执行完后点”OK“,然后点击下一步,安装完成。
再用sqlplus / as sysdba测试。