oracle-ol6.9安装oracle11gr2

发表于 更新于 阅读次数：

下载

oracle linux操作系统下载：http://www.linuxdown.net/OracleLinux/2014/1209/3658.html
oracle 11g下载：https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

linux主机名设置

1
2
/etc/sysconfig/network
/etc/hosts

安装依赖

本地yum库配置

1
2
3
4
5
6
7
8
[root@ht01 yum.repos.d]# mkdir -p /mnt/cdrom/
[root@ht01 yum.repos.d]# mount /dev/sr0 /mnt/cdrom
[root@ht01 yum.repos.d]# cat local.repo
[Server]
name=Server
baseurl=file:///mnt/cdrom
enabled=1
gpgcheck=0

安装依赖

1
# yum install gcc* binutils* compat* glibc* ksh* libgcc* libstdc* libaio* make* sysstat* unixODBC* -y

修改limits参数

1
2
3
4
5
6
#vim /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240

修改内核参数

1
2
3
4
5
6
7
8
9
10
11
12
13
# cp /etc/sysctl.conf /etc/sysctl.conf.bak
#vim /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
net.core.wmem_max = 1048576

#reboot

创建oracle用户及组及安装路径

1
2
3
4
5
6
7
8
9
10
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba,oper oracle

passwd oracle

mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01
chmod -R 775 /u01/app/oracle

设置oracle用户环境变量

1
2
3
4
5
6
7
8
$vi .bashrc
unset TNS_ADMIN
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/bin:$PATH

$ source .bashrc

上传oracle.zip并安装

unzip ‘*.zip’
./runInstaller

启动与关闭

netca 配置监听

dbca 配置数据库

1
2
3
4
5
安装字符集选择
SIMPLIFIED CHINESE_CHINA.AL32UTF8

select * from nls_database_parameters;
select userenv('language') from dual;

其他

在线安装

oracle官方如何简单在线安装的说明

1
yum -y install oracle-rdbms-server-11gR2-preinstall

SQLplus中del键失效的问题

安装rlwrap插件

1
2
3
4
5
6
7
#vim /etc/yum.repo.d/epel.repo
[epel]
name=Extra Packages for Enterprise Linux 6 - $basearch
baseurl=https://mirrors.aliyun.com/epel/6/$basearch
gpgcheck=0

#yum install rlwrap readline readline-devel

设置sqlplus的系统别名：

1
2
3
4
5
6
在头部或尾部添加：
$ vim ~/.bashrc
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'

$source ~/.bashrc

安装Oracle的时候报SWAP空间不足的处理方法

https://blog.51cto.com/dbaway/1685300

centos7 安装oracle11

https://cloud.tencent.com/developer/article/1122919

缺少pdksh-5.2.14-1.i386.rpm

Oracle 11g RHEL 6.3 http://blog.itpub.net/31397003/viewspace-2135180/

centos7缺少包时./runInstaller -ignorePrereq跳过检查安装

Linux7安装11g Error in invoking target ‘agent nmhs’ of makefile

http://blog.itpub.net/29475508/viewspace-2120836/

开机启动配置

  1. 修改/etc/oratab

    1
    sysware:/u01/app/oracle/product/11.2.0/dbhome_1:Y

  2. 修改dbstart和dbshut脚本

    1
    2
    ORACLE_HOME_LISTNER=$1 修改为
    ORACLE_HOME_LISTNER=$ORACLE_HOME

  3. 添加开机脚本
    [root@ol6 ~]# vim /etc/rc.local 

    1
    su - oracle -c "lsnrctl start && dbstart"

su命令用法