Installing OracleDB on CentOS7

Note: I already have MariaDB and Apache Tomcat installed on CentOS7 server. Now I’ll be adding the free version of OracleDB.
Note: I followed these instructions: http://www.tecmint.com/oracle-database-11g-release-2-installation-in-linux/

cd /etc/yum.repos.d (Change directory)
wget http://public-yum.oracle.com/public-yum-ol6.repo (Get the file)
yum install oracle-rdbms-server-11gR2-preinstall (Install the file I downloaded)

Note: I saw for most part success with the install, except for:
–> Finished Dependency Resolution
Error: Package: kernel-uek-2.6.39-400.264.13.el6uek.x86_64 (ol6_UEK_latest)
Requires: ql23xx-firmware
Available: ql23xx-firmware-3.03.27-3.1.el6.noarch (ol6_latest)
ql23xx-firmware = 3.03.27-3.1.el6
You could try using –skip-broken to work around the problem
You could try running: rpm -Va –nofiles –nodigest

Q: How to create a FQDN for the server?
A: Within /etc/hosts Went into VI and added this:
10.0.0.50 centos.pg.com

Q: How to set the hostname?
A: Within /etc/sysconfig/network I went into VI and added:
HOSTNAME=centos.pg.com

Q: How to set the hosts files
Note: I already added in 10.0.0.50 for centos.pg.com, but then went back in and added oracle
Note: It now looks like:
10.0.0.50 centos.pg.com oracle

Q: How to restart the network?
A: /etc/init.d/network restart

Q: How to add a user account for Oracle?
A: adduser oracle

Q: How to change password for the new account Oracle?
A: passwd oracle – made it redwood123

Q: How to add for 90-nproc.conf?
A: Add the entry to file “/etc/security/limits.d/90-nproc.conf” as described below.
A: With this entry:
# Default limit for number of user’s processes to prevent
# accidental fork bombs.
# See rhbz #432903 for reasoning.

* soft nproc 1024
# To this
* – nproc 16384

Q: How to change for SELinux
Note: It was originally set for “enforcing” and I changed to “permissive”
A: /etc/selinux/config
A: Changed from enforcing to permissive

Note: After rebooting, log-in as oracle (this is the new account I just created)

When I do PWD is returns /home/oracle

Q: How to modify the .bash_profile file?
A: vi .bash_profile
A: Add this in and modify the FQDN to centos.pg.com
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=centos.pg.com; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH export PATH

About Paul

CERT Coordinator, Ham Radio Operator, GTD Fan; Photographer; Domino/Notes Administrator
This entry was posted in SQL. Bookmark the permalink.