linux7系统怎么安装oracle12C R2

64次阅读
没有评论

共计 7644 个字符,预计需要花费 20 分钟才能阅读完成。

这篇文章主要介绍“linux7 系统怎么安装 oracle12C R2”,在日常操作中,相信很多人在 linux7 系统怎么安装 oracle12C R2 问题上存在疑惑,丸趣 TV 小编查阅了各式资料,整理出简单好用的操作方法,希望对大家解答”linux7 系统怎么安装 oracle12C R2”的疑惑有所帮助!接下来,请跟着丸趣 TV 小编一起来学习吧!

## 内存检查
#Minimum: 1 GB of RAM
#Recommended: 2 GB of RAM or more

grep MemTotal /proc/meminfo | awk {print $2/1024 MB}

##swap 的检查
#Available RAM,Swap Space Required
#Between 1 GB and 2 GB,1.5 times the size of the RAM
#Between 2 GB and 16 GB,Equal to the size of the RAM
#More than 16 GB,16 GB

grep SwapTotal /proc/meminfo | awk {print $2/1024 MB}

##packages for linux6
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)

yum -y install binutils compat-libcap1 compat-libstdc++ compat-libstdc++*.i686 gcc gcc-c++ glibc-2*.i686 glibc glibc-devel*.i686 glibc-devel ksh libgcc libgcc-*.i686 libstdc++*.i686 libstdc++ libstdc++-devel libstdc++devel*.i686 libaio-*.i686 libaio libaio-*.i686 libaio-devel libaio-devel*.i686 make sysstat unixODBC-devel unixODBC*.i686 

##packages for linux 7
rpm -qa | grep binutils-2.23.52.0.1-12.el7.x86_64 
rpm -qa | grep compat-libcap1-1.10-3.el7.x86_64 
rpm -qa | grep compat-libstdc++-33-3.2.3-71.el7.i686
rpm -qa | grep compat-libstdc++-33-3.2.3-71.el7.x86_64
rpm -qa | grep gcc-4.8.2-3.el7.x86_64 
rpm -qa | grep gcc-c++-4.8.2-3.el7.x86_64 
rpm -qa | grep glibc-2.17-36.el7.i686 
rpm -qa | grep glibc-2.17-36.el7.x86_64 
rpm -qa | grep glibc-devel-2.17-36.el7.i686 
rpm -qa | grep glibc-devel-2.17-36.el7.x86_64 
rpm -qa | grep ksh
rpm -qa | grep libaio-0.3.109-9.el7.i686 
rpm -qa | grep libaio-0.3.109-9.el7.x86_64 
rpm -qa | grep libaio-devel-0.3.109-9.el7.i686 
rpm -qa | grep libaio-devel-0.3.109-9.el7.x86_64 
rpm -qa | grep libgcc-4.8.2-3.el7.i686 
rpm -qa | grep libgcc-4.8.2-3.el7.x86_64 
rpm -qa | grep libstdc++-4.8.2-3.el7.i686 
rpm -qa | grep libstdc++-4.8.2-3.el7.x86_64 
rpm -qa | grep libstdc++-devel-4.8.2-3.el7.i686 
rpm -qa | grep libstdc++-devel-4.8.2-3.el7.x86_64 
rpm -qa | grep libXi-1.7.2-1.el7.i686 
rpm -qa | grep libXi-1.7.2-1.el7.x86_64 
rpm -qa | grep libXtst-1.2.2-1.el7.i686 
rpm -qa | grep libXtst-1.2.2-1.el7.x86_64 
rpm -qa | grep make-3.82-19.el7.x86_64 
rpm -qa | grep sysstat-10.1.5-1.el7.x86_64

yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*.i686 gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio-*.i686 libaio-devel libaio-devel*.i686 libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++devel*.i686 libXi libXi*.i686 libXtst libXtst*.i686 make sysstat unixODBC unixODBC-devel unixODBC*.i686
yum -y localinstall compat-libstdc++-33-3.2.3-72.el7.*   #单独下载

##create user and group 
groupadd -g 1000 oinstall
groupadd -g 1001 dba
groupadd -g 1002 oper
useradd -g oinstall -G dba,oper oracle 

##vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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

/sbin/sysctl -p 

## 官方文档对 shmmax 的设置解释,(文档 ID 567506.1),我一般直接使用当前设置 /sbin/sysctl -a | grep shm
#Oracle Global Customer Support officially recommends a maximum for SHMMAX of 1/2 of physical RAM . 
#The maximum size of a shared memory segment is limited by the size of the available user address space. On 64-bit systems, this is a theoretical 2^64bytes. So the theoretical limit for SHMMAX is the amount of physical RAM that you have.  However, to actually attempt to use such a value could potentially lead to a situation where no system memory is available for anything else.  Therefore a more realistic physical limit for SHMMAX would probably be physical RAM – 2Gb . 
#In an Oracle RDBMS application, this physical limit still leaves inadequate system memory for other necessary functions. Therefore, the common Oracle maximum for SHMMAX that you will often see is 1/2 of physical RAM . Many Oracle customers chose a higher fraction, at their discretion. 
#Occasionally, Customers may erroneously think that that setting the SHMMAX as recommended in this NOTE limits the total SGA.   That is not true.  Setting the SHMMAX as recommended only causes a few more shared memory segments to be used for whatever total SGA that you subsequently configure in Oracle. For additional detail, please see

##
?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
oracle hard stack 10240

## 创建软件安装目录
mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app/oracle

## 添加本地参数
su – oracle
vi .bash_profile
umask 0022
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1
ORACLE_SID=orcl
export ORACLE_BASE ORACLE_HOME ORACLE_SID
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin:/usr/bin:/sbin
LD_LIBRARY_PATH=$ORACLE_HOME/lib

## 修改 hosts 文件
ip add | grep enp0s8 | grep inet | awk {print $2} | awk -F / {printf $1}{cmd= hostname system(cmd)} /etc/hosts
cat /etc/hosts

## 开机启动图形化
[root@localhost ~]# systemctl get-default 
multi-user.target
[root@localhost ~]# cat /etc/inittab 
# inittab is no longer used when using systemd.
#
# ADDING CONFIGURATION HERE WILL HAVE NO EFFECT ON YOUR SYSTEM.
#
# Ctrl-Alt-Delete is handled by /usr/lib/systemd/system/ctrl-alt-del.target
#
# systemd uses targets instead of runlevels. By default, there are two main targets:
#
# multi-user.target: analogous to runlevel 3    # 多用户模式
# graphical.target: analogous to runlevel 5     #图形化模式
#
# To view current default target, run:
# systemctl get-default
#
# To set a default target, run:
# systemctl set-default TARGET.target
#
[root@localhost ~]# systemctl set-default graphical.target  
Removed symlink /etc/systemd/system/default.target.
Created symlink from /etc/systemd/system/default.target to /usr/lib/systemd/system/graphical.target.
[root@localhost ~]# systemctl get-default 
graphical.target

?
## 关闭防火墙和 selinux
[root@localhost ~]# systemctl stop firewalld
[root@localhost ~]# systemctl disable firewalld  
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
Removed symlink /etc/systemd/system/basic.target.wants/firewalld.service.
[root@rhel7ora11 ~]# getenforce 
Enforcing
[root@rhel7ora11 ~]# setenforce 0
[root@rhel7ora11 ~]# getenforce 
Permissive
[root@rhel7ora11 ~]# vi /etc/selinux/config 
SELINUX=disabled

sed -i s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config

## 安装
./runInstaller
# 执行脚本
[root@rhel7-ora12c-ip156 ~]# /u01/app/oraInventory/orainstRoot.sh 
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.

[root@rhel7-ora12c-ip156 ~]# /u01/app/oracle/product/12.2.0/db_1/root.sh 
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/12.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
   Copying dbhome to /usr/local/bin …
   Copying oraenv to /usr/local/bin …
   Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] : 
no
Oracle Trace File Analyzer (TFA – User Mode) is available at :
    /u01/app/oracle/product/12.2.0/db_1/suptools/tfa/release/tfa_home/bin/tfactl

OR

Oracle Trace File Analyzer (TFA – Daemon Mode) can be installed by running this script :
    /u01/app/oracle/product/12.2.0/db_1/suptools/tfa/release/tfa_home/install/roottfa.sh
   
#dbca 创建数据库,assm 管理最少需要 1460M 内存分配

到此,关于“linux7 系统怎么安装 oracle12C R2”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注丸趣 TV 网站,丸趣 TV 小编会继续努力为大家带来更多实用的文章!

正文完
 
丸趣
版权声明:本站原创文章,由 丸趣 2023-08-01发表,共计7644字。
转载说明:除特殊说明外本站除技术相关以外文章皆由网络搜集发布,转载请注明出处。
评论(没有评论)