Thursday, May 28, 2015

Oracle 12 c Enterprise installation on CentOS 6.6

I didn't think it would be a breeze either, but if you have the right steps.....

1) Download Oracle from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index-092322.html

2) There are two files, download both of them depending on the architecture, I chose 64 bit.

3) Unzip them from the command window

  • unzip linuxamd64_12102_database_1of2.zip
  • unzip linuxamd64_12102_database_2of2.zip


4) The files should get created in the database folder.

5) create an oracle user and the appropriate groups

  • sudo groupadd oinstall
  • sudo groupadd dba
  • sudo useradd -g oinstall -G dba -s /bin/bash oracle
  • sudo passwd oracle
6) Edit the /etc/security/limits.conf and add the following lines

  • oracle          hard    nproc           16384
  • oracle          soft    nproc           16384
  • oracle          hard    nofile          65536
  • oracle          soft    nofile          65536
7) Edit the /etc/pam.d/login and add the following line
  • session required /lib64/security/pam_limits.so
8) Edit the /etc/sysctl.conf and add the following line
  • fs.filemax = 65535
9) I like all my software in /opt, so skip this if you are not like me.
  • sudo mkdir -p /opt/oracle
  • sudo chown -R oracle:oinstall /opt/oracle
10) Now run the oracle installer, ./database/runInstaller
  • Skip the first screen and click next
  • Choose "Install database software only"  and click next
  • Choose "Single Instance database installation"  and click next
  • Choose "English"  and click next
  • Choose "Enterprise Edition"  and click next
  • Set base as /opt/oracle/app/oracle  and click next
  • Set Inventory directory as /opt/oracle/app/oraInventory
  • Set oraInventory groupname as oinstall  and click next
  • Set all OS groups to DBA  and click next

11)The installer will check pre requisites and comee back with a list. Choose Fix & check again. You should be prompted to run a script file as root user. Run the script and come back and click ok.

12) Click on Check again and you should see a list of warnings. I dont like warnings so I am going to fix them all.
  • Install compat-libcap-1.10  - sudo yum install compat-libcap1.x86_64
  • Install compat-libstdc++-33 - sudo yum install compat-libstdc++-33.x86_64
  • Install gcc-c 4.4.4 - sudo yum install gcc-c++.x86_64
  • Install ksh - sudo yum install ksh.x86_64
  • Install libaio-devel - sudo yum install libaio-devel.x86_64
13) Click on Check agian, ensure there are no more warnings and click next.

This should complete the installation of the database. You will get a prompt to run some scripts as root before the installation completes.

14) Run your oraenv scripts from the /usr/local/bin folder, then login as an oracle user, and run dbca to create your database.

Have fun!