Install Oracle 11G Release 2 (11.2) on Oracle Linux 7 (OEL7),备忘
来源:互联网 发布:手机声音美化软件 编辑:程序博客网 时间:2024/05/16 02:29
Install Oracle 11G Release 2 (11.2) on Oracle Linux 7 (OEL7)
This article presents how to install Oracle 11G on Oracle Enterprise Linux 7 (OEL7).
Read following article how to install Oracle Enterprise Linux 7: Install Oracle Linux 7 (OEL7) (for comfort set 2G memory for your virtual machine before proceeding with Oracle software installation).
Installation software is available on OTN version 11.2.0.1 or metalink 11.2.0.4. In this installation I’m presenting installation for 11.2.0.4 but for previous version 11.2.0.X it shouldn’t be different.
Oracle software which I verified
release 11.2.0.4
p13390677_112040_Linux-x86-64_1of7.zip p13390677_112040_Linux-x86-64_2of7.zip
OS configuration and preparation
OS configuration is executed as root. To login as root just execute following command in terminal.
su - root
Add groups
--required groups/usr/sbin/groupadd -g 501 oinstall/usr/sbin/groupadd -g 502 dba/usr/sbin/groupadd -g 503 oper
Add user Oracle
/usr/sbin/useradd -u 502 -g oinstall -G dba,oper oracle
Change password for user
passwd oracle
Add kernel parameters to /etc/sysctl.conf
kernel.shmmni = 4096 kernel.shmmax = 4398046511104kernel.shmall = 1073741824kernel.sem = 250 32000 100 128fs.aio-max-nr = 1048576fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586
Apply kernel parameters
/sbin/sysctl -p
Add following lines to set shell limits for user oracle in file /etc/security/limits.conf
oracle soft nproc 131072oracle hard nproc 131072oracle soft nofile 131072oracle hard nofile 131072oracle soft core unlimitedoracle hard core unlimitedoracle soft memlock 50000000oracle hard memlock 50000000
The “/etc/hosts” file must contain a fully qualified name for the server.
<IP-address> <fully-qualified-machine-name> <machine-name>
For example.
127.0.0.1 oel7 oel7.dbaora.com localhost localhost.localdomain
Modify .bash_profile for user oracle in his home directory
# Oracle Settingsexport TMP=/tmpexport ORACLE_HOSTNAME=oel7.dbaora.comexport ORACLE_UNQNAME=ORA11Gexport ORACLE_BASE=/ora01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=ORA11GPATH=/usr/sbin:$PATH:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;alias cdob='cd $ORACLE_BASE'alias cdoh='cd $ORACLE_HOME'alias tns='cd $ORACLE_HOME/network/admin'alias envo='env | grep ORACLE'umask 022
Check which packages are installed and which are missing
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' binutils \elfutils-libelf \elfutils-libelf-devel \gcc \gcc-c++ \glibc \glibc-common \glibc-devel \glibc-headers \ksh \libaio \libaio-devel \libgcc \libstdc++ \libstdc++-devel \make \sysstat \unixODBC \unixODBC-devel
In my case it returns following
binutils-2.23.52.0.1-12.el7(x86_64)elfutils-libelf-0.157-2.el7(x86_64)package elfutils-libelf-devel is not installedgcc-4.8.2-3.el7(x86_64)gcc-c++-4.8.2-3.el7(x86_64)glibc-2.17-36.el7(x86_64)glibc-common-2.17-36.el7(x86_64)glibc-devel-2.17-36.el7(x86_64)glibc-headers-2.17-36.el7(x86_64)package ksh is not installedlibaio-0.3.109-9.el7(x86_64)package libaio-devel is not installedlibgcc-4.8.2-3.el7(x86_64)libstdc++-4.8.2-3.el7(x86_64)libstdc++-devel-4.8.2-3.el7(x86_64)make-3.82-19.el7(x86_64)sysstat-10.1.5-1.el7(x86_64)package unixODBC is not installedpackage unixODBC-devel is not installed
There are two options to install missing packages
- You need to install missing from dvd. Just mount it and install missing packages using rpm -Uvh command from directory <mount dvd>/Packages.
NOTE – I’m using x86_64 version of packages
rpm -Uvh elfutils-libelf-devel*.x86_64.rpmrpm -Uvh libaio-devel*.x86_64.rpmrpm -Uvh unixODBC*.x86_64.rpmrpm -Uvh ksh*.x86_64.rpm
- Run yum install command for missing packages
--example howto install many packagesyum install elfutils-libelf-devel \ksh \libaio-devel \unixODBC*
Create directory structure for database software
- ORACLE_BASE – /ora01/app/oracle
- ORACLE_HOME – /ora01/app/oracle/product/11.2.0/db_1
mkdir -p /ora01/app/oracle/product/11.2.0/db_1chown oracle:oinstall -R /ora01
Disable secure linux by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows. It requires REBOOT to be effective !!!
SELINUX=permissive
In Oracle Enterprise Linux 7 /tmp data is stored on tmpfs which consumes memory and is too small. To revert it back to storage just run following command and REBOOT machine to be effective.
systemctl mask tmp.mount
Install database software
Let’s start with database software installation as oracle user.
su - oracle--unzip software 11.2.0.4unzip p13390677_112040_Linux-x86-64_1of7.zipunzip p13390677_112040_Linux-x86-64_2of7.zip--I defined 4 aliases in .bash_profile of user oracle to make --administration heaven :)[oracle@oel7 ~]$ alias envo cdob cdoh tnsalias envo='env | grep ORACLE'alias cdob='cd $ORACLE_BASE'alias cdoh='cd $ORACLE_HOME'alias tns='cd $ORACLE_HOME/network/admin'--run alias command envo to display environment settingsenvoORACLE_UNQNAME=ORA11GORACLE_SID=ORA11GORACLE_BASE=/ora01/app/oracleORACLE_HOSTNAME=oel7.dbaora.comORACLE_HOME=/ora01/app/oracle/product/11.2.0/db_1--run alias command cdob and cdoh to check ORACLE_BASE, ORACLE_HOME [oracle@oel7 ~]$ cdob[oracle@oel7 oracle]$ pwd/ora01/app/oracle[oracle@oel7 db_1]$ cdoh[oracle@oel7 db_1]$ pwd/ora01/app/oracle/product/11.2.0/db_1--run installation./runInstall
1. Uncheck checkbox “I wish to receive security updates via My Oracle Support” and then click “Next” button.
2. Ignore following message and click “Yes” button.
3. Select “Skip software updates” and click “Next” button.
4. Select “Create and configure a database” then click “Next” button.
5. Select “Server Class” then click “Next” button.
6. Select “Single instance database installation” and click “Next” button.
7. Select “Typical Install” and click “Next” button.
8. Enter database name, administration password for user and click “Next” button.
9. Just click “Next” button.
10. Check checkbox “Ignore All” to ignore this error. Then click “Next” button.
11. Just click “Yes” button to continue with installation.
12. Summary screen just before installation. Click “Install” button.
13. Boring installation …
14. I received following error during linking binaries
To fix this error edit $ORACLE_HOME/sysman/lib/ins_emagent.mk, search for the line
$(MK_EMAGENT_NMECTL)
and replace the line with
$(MK_EMAGENT_NMECTL) -lnnz11
then click “Retry” button
15. Database Configuration will start and create database for you.
16. You should see summary screen for your new database. Click “OK” button to continue with installation.
17. In the “middle” of installation you will be asked to run 2 scripts as user root. when scripts are executed just click “OK” button. Installation will proceed.
--execute scripts/ora01/app/oraInventory/orainstRoot.sh/ora01/app/oracle/product/11.2.0/db_1/root.sh
18. Installation completed. Just click “Close” button.
Post installation steps
Edit the “/etc/oratab” file to set restart flag for ORA11G to ‘Y’.
ORA11G:/u01/app/oracle/product/11.2.0/db_1:Y
Have a fun 0 0
- Install Oracle 11G Release 2 (11.2) on Oracle Linux 7 (OEL7),备忘
- Install and configure Oracle 11g Release 2 on Redhat 6.3 Enterprise Linux 64 step by step
- Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 5
- Oracle Database 11g Release 2 RAC On Oracle Linux 5.8 Using VirtualBox
- Oracle Database 11g Release 2 RAC On Oracle Linux 5.8 Using VirtualBox
- Oracle Database 11g Release 2 RAC On Oracle Linux 5.8 Using VirtualBox
- Oracle Database 11g Release 2 RAC On Oracle Linux 5.8 Using VirtualBox
- Oracle Database 11g Release 2 RAC On Oracle Linux 5.8 Using VirtualBox
- Installation of Oracle 11g Release 2 (11.2.0.1.0) on RedHat EL 5, (Oracle) Enteprise Linux 5 and Cen
- Install Oracle 10g On Linux
- Oracle Database 11g Release 2 on Ubuntu 12.04 HOWTO
- Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2
- Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2
- Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2
- Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2
- Oracle Database 11g Release 2 RAC On Linux Using VMware Server 2
- Oracle Database 11g Release 2 RAC On Linux Using VirtualBox
- Oracle Database 11g Release 2 RAC On Linux Using NFS
- XML映射配置
- jpa 的多对多的属性时查询的两种方式
- 导入新项目后 出现红叉 红叹号
- 几何画板如何生成三角函数图像
- iBET Live Casinos Rebate 0.75% Bonus
- Install Oracle 11G Release 2 (11.2) on Oracle Linux 7 (OEL7),备忘
- 编译脚本linux shell脚本写法和一般使用方法
- oracle中查询多情况并存的情况
- Spark学习笔记(五)
- Android建立远程动态库,提交到Jcenter
- 【嵌入式Linux学习七步曲之第五篇 Linux内核及驱动编程】揭开Linux Proc文件系统的神秘面纱
- 为什么匿名内部类参数必须为final类型
- Java反射机制详解
- Python习题:Python 判断是不是等差数列,要求算法时间复杂度为O(NlogN)