准备工作:
修改启动项
/etc/inittab
创建组,用户
groupadd oinstall
groupadd dba
mkdir -p /u01
useradd -g oinstall -G dba -d /u01/oracle oracle
passwd oracle
chown -R oracle:oinstall /u01
实现sqlplus 记忆
tar zxvf rlwrap-0.37.tar.gz
cd rlwrap-0.37
./configure && make install
编辑profile文件
vi .bash_profile
ORACLE_SID=orcl
ORACLE_BASE=/u02
ORACLE_HOME=/$ORACLE_BASE/oracle
LD_LIBRARY_PATH=$ORACLE_HOME/lib;$LD_LIBRARY_PATH
PATH=$ORACLE_HOME/bin;$path
DISPLAY=192.168.59.129:0.0
export ORACLE_SID ORACLE_BASE ORACLE_HOME LD_LIBRARY_PATH PATH DISPLAY
stty erase ^h
alias sqlplus = "rlwrap sqlplus"
alias rman="rlwrap rman"
保存,并退出oracle,然后登陆生效
检查环境变量:
env | grep ORA
检查包:
rpm -qa | grep binutils
rpm -ivh * --force --nodeps
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
vi /etc/pam.d/login
session required pam_limits.so
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
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
执行以下命令 使其生效
sysctl -p
解压zip包,并执行安装脚本
解决sqlplus报错:./sqlplus: error while loading shared libraries:
/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot
restore segment prot after reloc: Permission denied
root用户登录
使用cd命令切换当前目录到 /etc/selinux
使用vim打开config文件
找到里面的SELINUX条目,设置成disabled
重启系统