一:设置
1.将oracle文件放到/home/database目录下,解压缩
cd /home/database
unziplinux.x64_11gR2_database_1of2.zip
unziplinux.x64_11gR2_database_2of2.zip
2.创建用户
groupadd dba
groupadd oinstall
useradd -g oinstall-g dba -m oracle
passwd oracle
oracel用户密码为:password
3.创建安装目录
mkdir -p/opt/oracle/product/11.2/db_1
mkdir -p/opt/oraInventory
mkdir -p/opt/oracle/oradata
mkdir -p/var/opt/oracle
4.设置目录的所有者、所属组和权限
chown -Roracle.oinstall /opt/oracle
chown -Roracle.oinstall /opt/oracle/oradata
chown -Roracle.oinstall /opt/oracle/product/11.2/db_1
chown -R oracle.dba/opt/oraInventory
chown oracle.dba/var/opt/oracle
chmod -R 775/opt/oracle
chmod -R 755/var/opt/oracle
5.设置用户oracle的环境变量
su oracle
vim/home/oracle/.bash_profile
在文件中添加如下:
exportORACLE_BASE=/opt/oracle
exportORACLE_HOME=$ORACLE_BASE/product/11.2/db_1
exportORACLE_SID=orcl
exportORACLE_OWNER=oracle
exportORACLE_TERM=vt100
exportPATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
exportPATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
exportLD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH
PATH=$PATH:/usr/sbin;export PATH
PATH=$PATH:/usr/bin;export PATH
ORA_NLS33=$ORACLE_HOME/nls/admin/data
保存退出,执行以下命令使得配置立刻生效或使用Oracle重登陆系统
source$HOME/.bash_profile
二: 开始安装
1. 以root用户进入database文件夹所在目录授权
chmod -R 777database
切换到oracle用户,使用oracle重登陆或使用下面命令切换用户
su - oracle
进入database目录,运行安装文件开始安装
./runInstaller
如果遇到错误:
Checking monitor:must be configured to display at least 256 colors
>>> Could not execute auto checkfor display colors using command /usr/bin/xdpyinfo. Check if the DISPLAYvariable is set.
执行以下命令后再安装:
1、root下执行(如果不行,重启系统)
DISPLAY=:0.0;exportDISPLAY
echo $DISPLAY
xhost
xhost +
2、
su - oracle
DISPLAY=:0.0;exportDISPLAY
echo $DISPLAY
cd/home/database/database
./runInstaller
root用户
修改进程数和最大会话数的设置,执行
# vi/etc/security/limits.conf
(在该文件的最后追加下面四行)
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
系统内核参数设置
# vi/etc/sysctl.conf
(在该文件后追加以下内容)
kernel.sem = 25032000 100 128
net.ipv4.ip_local_port_range= 9000 65500
fs.file-max =6815744
net.core.rmem_default= 262144
net.core.rmem_max =4194304
net.core.wmem_default= 262144
net.core.wmem_max =1048576
fs.aio-max-nr =1048576
保存退出,立即生效执行:
# cd /etc
# sysctl -p
-------------------
新建数据库
orcl/orcl
用户
sys/orcl as sysdba
Zhangsan/zhangsan
------------------------------------
---------------------------
内存大小
grep MemTotal/proc/meminfo
whoami查看当前登录用户名
cat/etc/group文件包含所有组
查看用户
cat /etc/passwd
删除用户
userdel -r oracle
---------------------------
yum installcompat-libcap1-1.10-1
yum installcompat-libstdc++-33-3.2.3-69.el6
yum installcompat-libstdc++-33-3.2.3-69.el6.i686
yum installgcc-4.4.4-13.el6
yum installgcc-c++-4.4.4-13.el6
yum installglibc-devel-2.12-1.149.el6_6.9.i686
yum installlibstdc++-4.4.7-11.el6.i686
yum installlibaio-0.3.107-10.el6.i686
yum installlibaio-devel-0.3.107-10.el6.i686
yum installlibaio-devel-0.3.107-10.el6.x86_64
yum installgcc-4.4.7-11.el6.x86_64
yum installgcc-c++-4.4.7-11.el6.x86_64
yum installksh-20120801-21.el6.x86_64
解决oracle11ins-20802 oracle net configuration失败
unzipp8670579_112010_LINUX.zip
cd 8670579
$ORACLE_HOME/OPatch/opatchapply -invPtrLoc $ORACLE_HOME/oraInst.loc
点击安装程序的retry,继续安装即可。