Skip to main content

STEPS TO INSTALL ORACLE DATABASE 12C ON ORACLE LINUX 7.x

Installing Oracle Database 12c

After the Installation of Oracle Linux follow the following steps:-

STEP ONE : Install the following packages

  • ·        Login as root
  • ·        Create a new file on the terminal using the command: #  vi rpm_packages.txt
  • ·        Copy the packages below, paste and save the file.
binutils-2.23.52.0.1-12.el7.x86_64
compat-libcap1-1.10-3.el7.x86_64
compat-libstdc++-33-3.2.3-71.el7.i686
compat-libstdc++-33-3.2.3-71.el7.x86_64
gcc-4.8.2-3.el7.x86_64
gcc-c++-4.8.2-3.el7.x86_64
glibc-2.17-36.el7.i686
glibc-2.17-36.el7.x86_64
glibc-devel-2.17-36.el7.i686
glibc-devel-2.17-36.el7.x86_64
ksh
libaio-0.3.109-9.el7.i686
libaio-0.3.109-9.el7.x86_64
libaio-devel-0.3.109-9.el7.i686
libaio-devel-0.3.109-9.el7.x86_64
libgcc-4.8.2-3.el7.i686
libgcc-4.8.2-3.el7.x86_64
libstdc++-4.8.2-3.el7.i686
libstdc++-4.8.2-3.el7.x86_64
libstdc++-devel-4.8.2-3.el7.i686
libstdc++-devel-4.8.2-3.el7.x86_64
libXi-1.7.2-1.el7.i686
libXi-1.7.2-1.el7.x86_64
libXtst-1.2.2-1.el7.i686
libXtst-1.2.2-1.el7.x86_64
make-3.82-19.el7.x86_64
sysstat-10.1.5-1.el7.x86_64 

  • ·        To install the packages use the command: # yum install $(cat rpm_packages.txt)

STEP TWO: Update the host file - /etc/hosts

Enter the command: # vi /etc/hosts

Enter the command: # vi /etc/hosts Copy the line below and paste in the file
192.168.8.144 randydba.com randydba

STEP THREE: Create group and user oracle

  • Login as root
  • Enter the following commands:
    • # groupadd oinstall
    • # groupadd dba
    • # groupadd oper
    • # useradd -g oinstall -G dba,oper oracle
    • # passwd oracle

STEP FOUR: Set parameter

  • # vi /etc/sysctl.conf
  • Add the following lines
            fs.file-max = 6815744
            kernel.sem = 250 32000 100 128
            kernel.shmmni = 4096
            kernel.shmall = 1073741824
            kernel.shmmax = 4398046511104
            net.core.rmem_default = 262144
            net.core.rmem_max = 4194304
            net.core.wmem_default = 262144
            net.core.wmem_max = 1048576
            fs.aio-max-nr = 1048576
            net.ipv4.ip_local_port_range = 9000 65500
  • Enter the command: # /sbin/sysctl -p

STEP FIVE: Modify security limits

  • # vi /etc/security/limits
  • Add the following lines at the end of the file
            oracle soft nofile 1024
            oracle hard nofile 65536
            oracle soft nproc 16384
            oracle hard nproc 16384
            oracle soft stack 10240
            oracle hard stack 32768

NB!! :-
  • As root run the command # yum install xorg-x11-apps.x86_64
  • Logout and login as the oracle user
  • Go to system tools - settings - display to change the resolution to 1024 x 768 (4:3)
  • In the terminal window do this:
    • export DISPLAY=:0.0
    • xclock
You should see a little GUI window appear (if not try to install the xorg-x11-apps.x86_64 again as root.) Make sure it works before proceeding!!!!

STEP SIX: Create folder to install oracle

  • # mkdir -p /u01/app/
  • # chown -R oracle:oinstall /u01/app/
  • # chmod -R 775 /u01/app/

STEP SEVEN: Set environment variable for user oracle

Enter the following commands:-
  • # su - oracle
  • $ cd ~
  • $ vi .bash_profile
  • Add the following lines 
            # Oracle Settings
            export TMP=/tmp
            export TMPDIR=$TMP

            export ORACLE_HOSTNAME=randydba.com
            export ORACLE_UNQNAME=cdb1
            export ORACLE_BASE=/u01/app/oracle
            export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
            export ORACLE_SID=cdb1

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

            export PATH=$ORACLE_HOME/bin:$PATH
            export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

            export NLS_DATE_FORMAT="mm/dd/yyyy hh24:mi:ss"

STEP EIGHT: Unzip database files

  • $ unzip linuxamd64_12c_database_1of2.zip.zip
  • $ unzip linuxamd64_12c_database_2of2.zip.zip

STEP NINE: Install oracle DB

  • $ cd database
  • $ ./runInstaller
Now, install oracle database

Follow the GUI steps below:- 














Location: Boulevard de la Liberté, Douala, Cameroon

Comments

Post a Comment

Popular posts from this blog

Oracle Database 19c Step by Step Installation On Oracle Linux 7.6

This post describes the installation of Oracle Database 19c 64-bit on Oracle Linux 7.6  x86-64 bit. The Linux server needs a minimum of 3G swap and secure Linux set to permissive. An example of this type of Linux installation can be seen here . Download Software Download the Oracle software from oracle edelivery . Oracle Installation Prerequisites Automatic Setup Use the "oracle-database-preinstall-19c" package to perform all your prerequisite setup. # yum install -y oracle-database-preinstall-19c If you are using RHEL7 or CentOS7, you can pick up the PRM from the OL7 repository and install it. It will pull the dependencies from your normal repositories. # yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm Hosts File Set a fully qualified name for the server in the "/etc/hosts" file. < IP-address > < fully-qualified-machine-name > < machin...
9 comments
Read more

How to Delete Old Trace & Dump files with ADRCI

The ADRCI command interpreter has multiple features:- Create a package with incident or problem information for Oracle Support Analyze diagnostic data within the Automatic Diagnostic Repository (ADR) Run health checks In this post, we'll be concentrating on deleting the old diagnostic files with ADRCI. Set your environment and run the ADRCI utility: $ adrci Use the following command to list the ADR homes: adrci> show home ADR Homes: diag/rdbms/db11g/DB11G diag/tnslsnr/sol10/listener Choose the ADR home from the list above: adrci> set home diag/rdbms/db11g/DB11G Check the current retention policy: adrci> show control Check the following columns in the output: LONGP_POLICY:- It is set to 365 days by default. It is responsible for Incidents and Health Monitor warnings. SHORTP_POLICY:- It is set to 30 days by default. It manages the trace and core dump files. Use the following commands to change the retention policy: Specify the time in hours: 10 Days = 240 ...
1 comment
Read more

Oracle Database 12C Error Codes, Solutions and Suggestions from ORA-19700 to ORA-20000

Oracle 12C Error Codes, Solutions and Suggestions from ORA 19700 to ORA 20000 ORA-19700: device type exceeds maximum length of string Cause:  The device type indicated is invalid. Action:  Supply a correct device type and retry the allocation. ORA-19701: device name exceeds maximum length of  string Cause:  The device name indicated is invalid. Action:  Supply a correct device name and retry the allocation. ORA-19702: device parameter exceeds maximum length of  string ORA-19703: device command string exceeds maximum length of  string Cause:  The device command string exceeds maximum length. Action:  Correct the command and retry the operation. ORA-19704: file name exceeds maximum length of  string Cause:  The specified file name, which was a parameter to a copy, backup, or restore operation, exceeds the maximum file name length for this operating system. Action:  Retry the operation with a s...
Post a Comment
Read more