{"id":4757,"date":"2015-05-11T10:35:59","date_gmt":"2015-05-11T02:35:59","guid":{"rendered":"http:\/\/rmohan.com\/?p=4757"},"modified":"2015-05-11T10:35:59","modified_gmt":"2015-05-11T02:35:59","slug":"oracle-12c-database-on-rhel-7-centos-7-fedora","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=4757","title":{"rendered":"Oracle 12C database on Rhel 7 Centos 7 Fedora"},"content":{"rendered":"

Install Oracle Database 12c On CentOS7<\/p>\n

Add a host file entry<\/p>\n

[root@oracledb ~]# cat \/etc\/hosts
\n127.0.0.1\u00a0\u00a0 localhost localhost.localdomain localhost4 localhost4.localdomain4
\n::1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 localhost localhost.localdomain localhost6 localhost6.localdomain6
\n192.168.1.60 oracledb.rmohan.com oracledb<\/p>\n

[root@oracledb ~]# hostnamectl
\nStatic hostname: oracledb.rmohan.com
\nIcon name: computer-vm
\nChassis: vm
\nMachine ID: 4145c21ef6ec4ca3a6a4ea34087a5552
\nBoot ID: a0d067b346df44f98ba7248578bfde3b
\nVirtualization: vmware
\nOperating System: CentOS Linux 7 (Core)
\nCPE OS Name: cpe:\/o:centos:centos:7
\nKernel: Linux 3.10.0-229.1.2.el7.x86_64
\nArchitecture: x86_64<\/p>\n

[root@oracledb ~]# cat\u00a0\u00a0 \/etc\/centos-release
\nCentOS Linux release 7.1.1503 (Core)
\n[root@oracledb ~]#<\/p>\n

[root@oracledb ~]# ip a\u00a0\u00a0 | grep inet
\ninet 127.0.0.1\/8 scope host lo
\ninet6 ::1\/128 scope host
\ninet 192.168.1.60\/24 brd 192.168.1.255 scope global eno16777736
\ninet6 fe80::20c:29ff:feac:4a80\/64 scope link tentative dadfailed
\n[root@oracledb ~]#<\/p>\n

Login as root and add required groups:<\/p>\n

\/usr\/sbin\/groupadd -g 501 oinstall
\n\/usr\/sbin\/groupadd -g 502 dba
\n\/usr\/sbin\/groupadd-g 503 oper
\n\/usr\/sbin\/groupadd-g 504 asmadmin
\n\/usr\/sbin\/groupadd-g 506 asmdba
\n\/usr\/sbin\/groupadd -g 505 asmoper
\nuseradd -u 502 -g oinstall -G dba,asmdba,oper oracle
\npasswd oracle<\/p>\n

Upload the oracle software on to the server<\/p>\n

I downloaded the following database packages.<\/p>\n

cd \/root\/software<\/p>\n

wget http:\/\/dl.fedoraproject.org\/pub\/epel\/7\/x86_64\/e\/epel-release-7-5.noarch.rpm
\nrpm -ivh epel-release-7-5.noarch.rpm<\/p>\n

yum groupinstall “GNOME Desktop” -y
\nyum groupinstall “Development Tools” -y<\/p>\n

Oracle Installation Prerequisites<\/p>\n

yum install binutils -y
\nyum install compat-libstdc++-33 -y
\nyum install compat-libstdc++-33.i686 -y
\nyum install gcc -y
\nyum install gcc-c++ -y
\nyum install glibc -y
\nyum install glibc.i686 -y
\nyum install glibc-devel -y
\nyum install glibc-devel.i686 -y
\nyum install ksh -y
\nyum install libgcc -y
\nyum install libgcc.i686 -y
\nyum install libstdc++ -y
\nyum install libstdc++.i686 -y
\nyum install libstdc++-devel -y
\nyum install libstdc++-devel.i686 -y
\nyum install libaio -y
\nyum install libaio.i686 -y
\nyum install libaio-devel -y
\nyum install libaio-devel.i686 -y
\nyum install libXext -y
\nyum install libXext.i686 -y
\nyum install libXtst -y
\nyum install libXtst.i686 -y
\nyum install libX11 -y
\nyum install libX11.i686 -y
\nyum install libXau -y
\nyum install libXau.i686 -y
\nyum install libxcb -y
\nyum install libxcb.i686 -y
\nyum install libXi -y
\nyum install libXi.i686 -y
\nyum install make -y
\nyum install sysstat -y
\nyum install unixODBC -y
\nyum install unixODBC-devel -y
\nyum install zlib-devel -y
\nyum install compat-libcap1 -y<\/p>\n

[root@oracledb ~]#sysctl -p
\nnet.ipv4.ip_forward = 0
\nnet.ipv4.conf.default.rp_filter = 1
\nnet.ipv4.conf.default.accept_source_route = 0
\nkernel.sysrq = 0
\nkernel.core_uses_pid = 1
\nnet.ipv4.tcp_syncookies = 1
\nkernel.msgmnb = 65536
\nkernel.msgmax = 65536
\nkernel.shmall = 4294967296
\nfs.file-max = 6815744
\nkernel.sem = 250 32000 100 128
\nkernel.shmmni = 4096
\nkernel.shmmax = 4398046511104
\nnet.core.rmem_default = 262144
\nnet.core.rmem_max = 4194304
\nnet.core.wmem_default = 262144
\nnet.core.wmem_max = 1048576
\nfs.aio-max-nr = 1048576
\nnet.ipv4.ip_local_port_range = 9000 65500<\/p>\n

[root@oracledb ~]#
\nAdd following lines to set shell limits for user oracle in file \/etc\/security\/limits.conf<\/p>\n

oracle\u00a0\u00a0 soft\u00a0\u00a0 nproc\u00a0\u00a0\u00a0 131072
\noracle\u00a0\u00a0 hard\u00a0\u00a0 nproc\u00a0\u00a0\u00a0 131072
\noracle\u00a0\u00a0 soft\u00a0\u00a0 nofile\u00a0\u00a0 131072
\noracle\u00a0\u00a0 hard\u00a0\u00a0 nofile\u00a0\u00a0 131072
\noracle\u00a0\u00a0 soft\u00a0\u00a0 core\u00a0\u00a0\u00a0\u00a0 unlimited
\noracle\u00a0\u00a0 hard\u00a0\u00a0 core\u00a0\u00a0\u00a0\u00a0 unlimited
\noracle\u00a0\u00a0 soft\u00a0\u00a0 memlock\u00a0 50000000
\noracle\u00a0\u00a0 hard\u00a0\u00a0 memlock\u00a0 50000000<\/p>\n

[root@clusterserver2 yum.repos.d]# systemctl stop firewalld.service
\n[root@clusterserver2 yum.repos.d]# systemctl disable firewalld.service
\nrm ‘\/etc\/systemd\/system\/dbus-org.fedoraproject.FirewallD1.service’
\nrm ‘\/etc\/systemd\/system\/basic.target.wants\/firewalld.service’
\n[root@clusterserver2 yum.repos.d]#<\/p>\n

su\u00a0 – oracle
\ncd \/software
\nunzip linuxamd64_12102_database_1of2.zip
\nunzip linuxamd64_12102_database_2of2.zip<\/p>\n

 <\/p>\n

\"Oracle12cdb<\/a> \"Oracle12cdb<\/a> \"Oracle12cdb<\/a> \"Oracle12cdb<\/a> \"Oracle12cdb<\/a> \"Oracle12cdb<\/a> \"Oracle12cdb<\/a> \"Oracle12cdb<\/a> \"Oracle12cdb<\/a> \"Oracle12cdb<\/a><\/p>\n

 
\nDuring the linking phase, you will see the following error.<\/p>\n

Error in invoking target ‘links proc gen_pcscfg procob’ of makefile
\n‘\/home\/oracle\/app\/oracle\/product\/12.1.0\/precomp\/lib\/ins_precomp.mk’.
\nSee
\n‘\/u01\/app\/oraInventory\/logs\/installActions2014-10-29_09-07-03PM.log’
\nfor details.<\/p>\n

To fix it, do the following:<\/p>\n

rm -rf $ORACLE_HOME\/lib\/stubs\/*
\ncp $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk.orig<\/p>\n

Perform the following modifications:<\/p>\n

vi $ORACLE_HOME\/rdbms\/lib\/env_rdbms.mk<\/p>\n

# Line 176
\n# FROM:
\nLINKTTLIBS=$(LLIBCLNTSH) $(ORACLETTLIBS) $(LINKLDLIBS)
\n# TO\u00a0 :
\nLINKTTLIBS=$(LLIBCLNTSH) $(ORACLETTLIBS) $(LINKLDLIBS) -lons<\/p>\n

# Line 279-280
\n# FROM:
\nLINK=$(FORT_CMD) $(PURECMDS) $(ORALD) $(LDFLAGS) $(COMPSOBJS)
\nLINK32=$(FORT_CMD) $(PURECMDS) $(ORALD) $(LDFLAGS32) $(COMPSOBJS)
\n# TO\u00a0 :
\nLINK=$(FORT_CMD) $(PURECMDS) $(ORALD) $(LDFLAGS) $(COMPSOBJS) -Wl,–no-as-needed
\nLINK32=$(FORT_CMD) $(PURECMDS) $(ORALD) $(LDFLAGS32) $(COMPSOBJS) -Wl,–no-as-needed<\/p>\n

# Line 3041-3042
\n# FROM:
\nTG4PWD_LINKLINE= $(LINK) $(OPT) $(TG4PWDMAI) \\
\n$(LLIBTHREAD) $(LLIBCLNTSH) $(LINKLDLIBS)
\n# TO\u00a0 :
\nTG4PWD_LINKLINE= $(LINK) $(OPT) $(TG4PWDMAI) \\
\n$(LLIBTHREAD) $(LLIBCLNTSH) $(LINKLDLIBS) -lnnz12<\/p>\n

Click the \u201cRetry\u201d button.<\/p>\n

Now, the installation should continue.
\n[root@oracledb oracle]# \/home\/oracle\/app\/oraInventory\/orainstRoot.sh
\nChanging permissions of \/home\/oracle\/app\/oraInventory.
\nAdding read,write permissions for group.
\nRemoving read,write,execute permissions for world.<\/p>\n

Changing groupname of \/home\/oracle\/app\/oraInventory to oinstall.
\nThe execution of the script is complete.
\n[root@oracledb oracle]# chmod 775 \/home\/oracle\/app\/oracle\/product\/12.1.0\/dbhome_1\/r
\nracg\/\u00a0\u00a0\u00a0\u00a0 rdbms\/\u00a0\u00a0\u00a0 relnotes\/ rest\/\u00a0\u00a0\u00a0\u00a0 root.sh
\n[root@oracledb oracle]# chmod 775 \/home\/oracle\/app\/oracle\/product\/12.1.0\/dbhome_1\/r
\nracg\/\u00a0\u00a0\u00a0\u00a0 rdbms\/\u00a0\u00a0\u00a0 relnotes\/ rest\/\u00a0\u00a0\u00a0\u00a0 root.sh
\n[root@oracledb oracle]# chmod 775 \/home\/oracle\/app\/oracle\/product\/12.1.0\/dbhome_1\/root.sh
\n[root@oracledb oracle]# sh \/home\/oracle\/app\/oracle\/product\/12.1.0\/dbhome_1\/root.sh
\nPerforming root user operation.<\/p>\n

The following environment variables are set as:
\nORACLE_OWNER= oracle
\nORACLE_HOME=\u00a0 \/home\/oracle\/app\/oracle\/product\/12.1.0\/dbhome_1<\/p>\n

Enter the full pathname of the local bin directory: [\/usr\/local\/bin]:
\nCopying dbhome to \/usr\/local\/bin …
\nCopying oraenv to \/usr\/local\/bin …
\nCopying coraenv to \/usr\/local\/bin …<\/p>\n

Creating \/etc\/oratab file…
\nEntries will be added to the \/etc\/oratab file as needed by
\nDatabase Configuration Assistant when a database is created
\nFinished running generic part of root script.
\nNow product-specific root actions will be performed.<\/p>\n

 <\/p>\n

 <\/p>\n

\"Oracle12cdb<\/a> \"Oracle12cdb<\/a><\/p>\n

\"Oracle13\"<\/a> \"Oracle12cdb<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Install Oracle Database 12c On CentOS7<\/p>\n

Add a host file entry<\/p>\n

[root@oracledb ~]# cat \/etc\/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.1.60 oracledb.rmohan.com oracledb<\/p>\n

[root@oracledb ~]# hostnamectl Static hostname: oracledb.rmohan.com Icon name: computer-vm Chassis: vm Machine ID: 4145c21ef6ec4ca3a6a4ea34087a5552 Boot ID: a0d067b346df44f98ba7248578bfde3b Virtualization: vmware Operating System: CentOS Linux 7 (Core) CPE OS […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4757"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4757"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4757\/revisions"}],"predecessor-version":[{"id":4772,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/4757\/revisions\/4772"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}