RHEL6.9静默安装Oracle11204

Linux系统版本信息

[root@localhost ~]# cat /proc/version

Linux version 2.6.32-696.el6.x86_64 (mockbuild@x86-027.build.eng.) (gcc version 4.4.7 0313 (Red Hat 4.4.7-18) (GCC) ) #1 SMP Tue Feb 21 00:53:17 EST

##Linux内核版本号：Linux version 2.6.32-696.el6.x86_64

##gcc版本号：4.4.7 0313 (Red Hat 4.4.7-18)

Linux发行版本ID及描述信息

[root@localhost ~]# lsb_release -id

Distributor ID: RedHatEnterpriseServer

Description: Red Hat Enterprise Linux Server release 6.9 (Santiago)

关闭防火墙

[root@localhost ~]# service iptables stop

[root@localhost ~]# chkconfig iptables off

[root@localhost ~]# setenforce 0

[root@localhost ~]# vi /etc/sysconfig/selinux

修改为SELINUX=disabled

[root@localhost ~]# getenforce

Permissive

selinux配置后需要重启，等后面统一重启，这里暂不重启

设置主机名

[root@localhost ~]# hostname rac01

[root@localhost ~]# vi /etc/sysconfig/network

[root@localhost ~]# cat /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=rac01

[root@localhost ~]# vi /etc/hosts

[root@localhost ~]# cat /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.72.101 rac01

cat /proc/version

lsb_release -id

df -h

mkdir -p /media/cdrom

mount /dev/cdrom /media/cdrom/

vi /etc/yum.repos.d/rhel.repo

设置yum源

查看镜像是否挂载

[root@localhost ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda3 281G 6.0G 261G 3% /

tmpfs 2.0G 72K 2.0G 1% /dev/shm

/dev/sda1 9.8G 61M 9.2G 1% /boot

新建挂载目录

[root@localhost ~]# mkdir -p /media/cdrom

将镜像挂载到目录

[root@localhost ~]# mount /dev/cdrom /media/cdrom/

mount: block device /dev/sr0 is write-protected, mounting read-only

编辑yum源配置文件

[root@localhost ~]# vi /etc/yum.repos.d/rhel.repo

[rhel]

name=rhel

baseurl=file:///media/cdrom

enabled=1

gpgcheck=0

保存

清空并重新加载yum仓库

[root@localhost ~]# yum clean all

[root@localhost ~]# yum repolist all

yum clean all

yum repolist all

安装软件包

[root@localhost ~]# yum install -y binutils* compat-lib* gcc* glibc* ksh* libgcc* libstdc* libaio* make* sysstat*

新建组

[root@localhost ~]# /usr/sbin/groupadd oinstall

新建dba、oper组并赋予组id

[root@localhost ~]# /usr/sbin/groupadd -g 502 dba

[root@localhost ~]# /usr/sbin/groupadd -g 503 oper

新建用户oracle并赋予用户id，并将oinstall组设置为初始组、dba和oper为附加组

[root@localhost ~]# /usr/sbin/useradd -u 502 -g oinstall -G dba,oper oracle

/usr/sbin/groupadd oinstall

/usr/sbin/groupadd -g 502 dba

/usr/sbin/groupadd -g 503 oper

/usr/sbin/useradd -u 502 -g oinstall -G dba,oper oracle

用户设置密码

[root@localhost ~]# passwd oracle

设置oracle的软限制和硬限制

[root@localhost ~]# 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

设置内核参数

[root@localhost ~]# 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

内核生效

[root@localhost ~]# /sbin/sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 68719476736

kernel.shmall = 4294967296

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

创建数据库目录

[root@localhost ~]# mkdir -p /u01/app/oracle

变更目录的所有者及所属组

[root@localhost ~]# chown -R oracle:oinstall /u01/app

变更目录权限

[root@localhost ~]# chmod -R 775 /u01/app/oracle

mkdir -p /u01/app/oracle

chown -R oracle:oinstall /u01/app

chmod -R 775 /u01/app/oracle

配置oracle用户环境

[root@localhost ~]#su - oracle

[oracle@localhost~]$vi /home/oracle/.bash_profile

加入下列内容

export ORACLE_SID=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_TERM=xterm

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

export CLASSPATH=$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

将oracle安装包拷贝至RHEL6.9，root用户解压

[root@localhost u01]# unzip p13390677_112040_Linux-x86-64_1of7.zip

[root@localhost u01]# unzip p13390677_112040_Linux-x86-64_2of7.zip

安装数据库软件

编辑数据库软件静默应答文件db_install.rsp

[root@localhost u01]# cd /u01/app/oracle/database/response/

[root@localhost response]# ls

dbca.rsp db_install.rsp netca.rsp

[root@localhost response]# vi db_install.rsp

修改一下行号的信息

oracle.install.option=INSTALL_DB_SWONLY---只安装数据库软件

ORACLE_HOSTNAME=db ---主机名

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/home/oraInventory

SELECTED_LANGUAGES=en,zh_CN---系统字符

ORACLE_HOME=/home/oracledb/11g

ORACLE_BASE=/home/oracledb

oracle.install.db.InstallEdition=EE---安装企业版

oracle.install.db.DBA_GROUP=dba

oracle.install.db.OPER_GROUP=dba

DECLINE_SECURITY_UPDATES=true

Oracle用户切换目录至database

[root@localhost response]# su - oracle

[oracle@db ~]$ cd /u01/app/oracle/database/

[oracle@db database]$ unset DISPLAY

[oracle@db database]$ ./runInstaller -force -silent -noconfig -responseFile /u01/app/oracle/database/response/db_install.rsp

Please check '/u01/app/oraInventory/logs/silentInstall-02-19_11-06-24PM.log' for more details.

As a root user, execute the following script(s):

1. /u01/app/oraInventory/orainstRoot.sh

2. /u01/app/oracle/product/11.2.0/db_1/root.sh

Successfully Setup Software.

切换到root用户

[root@localhost tmp]# /u01/app/oraInventory/orainstRoot.sh

[root@localhost tmp]# /u01/app/oracle/product/11.2.0/db_1/root.sh

安装监听

[oracle@db ~]$ $ORACLE_HOME/bin/netca /silent /responsefile /u01/app/oracle/database/response/netca.rsp

安装数据库实例

编辑数据库实例静默应答文件

[root@localhost tmp]# vi /u01/app/oracle/database/response/dbca.rsp

GDBNAME = "orcl"

SID = "orcl"

SYSPASSWORD = "Ahss_0987"

SYSTEMPASSWORD = "Ahss_0987"

SYSMANPASSWORD = "Ahss_0987"

DBSNMPPASSWORD = "Ahss_0987"

DATAFILEDESTINATION =/home/oracledb/oradata

RECOVERYAREADESTINATION=/home/oracledb/fast_recovery_area

CHARACTERSET = "AL32UTF8"

NATIONALCHARACTERSET= "AL32UTF8"

TOTALMEMORY = "1638"---根据实际内存大小比例计算得到，比如2G的80%

[root@localhost tmp]# su - oracle

[oracle@db ~]$ dbca -silent -responseFile /u01/app/oracle/database/response/dbca.rsp

查询数据库状态

[oracle@db ~]$ lsnrctl status

[oracle@db ~]$ sqlplus / as sysdba

SQL>

select instance_name,status from v$instance;

show parameter service_name;

select * from v$version;

col name for a70

select name,status from v$datafile;

set linesize 150

col member for a50

select a.member,b.group#,b.thread#,b.members,b.status,b.bytes/1024/1024 from v$logfile a,v$log b where a.group#=b.group#;

set wrap off

col filename for a60

select

b.file_name filename,

b.bytes/1024/1024 sizeM,

(b.bytes-sum(nvl(a.bytes,0)))/1024/1024 usedM,

substr((b.bytes-sum(nvl(a.bytes,0)))/(b.bytes)*100,1,5) preuse

from dba_free_space a,dba_data_files b

where a.file_id=b.file_id

group by b.tablespace_name,b.file_name,b.bytes

order by b.tablespace_name;