网站建设资讯

NEWS

网站建设资讯

linux7系统怎么安装oracle12CR2

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

成都创新互联专注于华容企业网站建设,成都响应式网站建设,购物商城网站建设。华容网站建设公司,为华容等地区提供建站服务。全流程按需策划,专业设计,全程项目跟踪,成都创新互联专业和态度为您提供的服务

##内存检查
#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”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注创新互联网站,小编会继续努力为大家带来更多实用的文章!


标题名称:linux7系统怎么安装oracle12CR2
网页网址:http://cdweb.net/article/jjhios.html