install Oracle 11G on Oracle Enterprise Linux 7 OEL7.docx

1、install Oracle 11G on Oracle Enterprise Linux 7 OEL7This 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 w

2、ith Oracle software installation).Installation software is available on OTN version 11.2.0.1 or metalink 11.2.0.4. In this installation Im presenting installation for 11.2.0.4 but for previous version 11.2.0.X it shouldnt be different.Oracle software which I verifiedrelease 11.2.0.4p13390677_112040_

3、Linux-x86-64_1of7.zip p13390677_112040_Linux-x86-64_2of7.zipOS configuration and preparationOS configuration is executed as root. To login as root just execute following command in terminal.su - rootAdd groups-required groups/usr/sbin/groupadd -g 501 oinstall/usr/sbin/groupadd -g 502 dba/usr/sbin/gr

4、oupadd -g 503 operAdd user Oracle/usr/sbin/useradd -u 502 -g oinstall -G dba,oper oracleChange password for userpasswd oracleAdd kernel parameters to /etc/sysctl.confkernel.shmmni = 4096 kernel.shmmax = 4398046511104kernel.shmall = 1073741824kernel.sem = 250 32000 100 128fs.aio-max-nr = 1048576fs.fi

5、le-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586Apply kernel parameters/sbin/sysctl -pAdd following lines to set shell limits for user oracle in file /etc/security/limits.confor

6、acle soft nproc 131072oracle hard nproc 131072oracle soft nofile 131072oracle hard nofile 131072oracle soft core unlimitedoracle hard core unlimitedoracle soft memlock 50000000oracle hard memlock 50000000The “/etc/hosts” file must contain a fully qualified name for the server. For example.127.0.0.1

7、oel7 localhost localhost.localdomainModify .bash_profile for user oracle in his home directory# Oracle Settingsexport TMP=/tmpexport ORACLE_HOSTNAME=export ORACLE_UNQNAME=ORA11Gexport ORACLE_BASE=/ora01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=ORA11GPATH=/usr/sb

8、in:$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_BASEalias cdoh=cd $ORACLE_HOMEalias tns=cd $ORACLE_HOME/network/adminalias envo=env | grep ORACLEumask 022Check which packages are installed

9、 and which are missingrpm -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-develIn my case it returns followingbinutils-2

10、.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 insta

11、lledlibaio-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 installedThere are two optio

12、ns to install missing packages You need to install missing from dvd. Just mount it and install missing packages using rpm -Uvh command from directory /Packages.NOTE Im using x86_64 version of packagesrpm -Uvh elfutils-libelf-devel*.x86_64.rpmrpm -Uvh libaio-devel*.x86_64.rpmrpm -Uvh unixODBC*.x86_64

13、.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_1mkd

14、ir -p /ora01/app/oracle/product/11.2.0/db_1chown oracle:oinstall -R /ora01Disable 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=permissiveIn Oracle Enterprise Linux 7 /tmp data is stored on tmpfs wh

15、ich 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.mountInstall database softwareLets start with database software installation as oracle user.su - oracle-unzip software 11.2.0.4unzip p13390677_112040_Li

16、nux-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 :)oracleoel7 $ alias envo cdob cdoh tnsalias envo=env | grep ORACLEalias cdob=cd $ORACLE_BASEalias cdoh=cd $ORACLE_HOMEalias tns=cd $ORACLE_HOME/network/

17、admin-run alias command envo to display environment settingsenvoORACLE_UNQNAME=ORA11GORACLE_SID=ORA11GORACLE_BASE=/ora01/app/oracleORACLE_HOSTNAME=ORACLE_HOME=/ora01/app/oracle/product/11.2.0/db_1-run alias command cdob and cdoh to check ORACLE_BASE, ORACLE_HOME oracleoel7 $ cdoboracleoel7 oracle$ p

18、wd/ora01/app/oracleoracleoel7 db_1$ cdohoracleoel7 db_1$ pwd/ora01/app/oracle/product/11.2.0/db_1-run installation./runInstall1. 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

19、 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 dat

20、abase 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” butto

21、n.13. Boring installation 14. I received following error during linking binariesTo 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) -lnnz11then click “Retry” button15. Database Configuration will start a

22、nd 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.sh18. Installation completed. Just click “Close” button.Post installation stepsEdit the “/etc/oratab” file to set restart flag for ORA11G to Y.ORA11G:/u01/app/oracle/product/11.2.0/db_1:YHave a fun