we are going to create an environment to study ORACLE from scratch. It is a bit hard because you DO NEED to have some skills with Unix and maybe in SQL. Anyway don’t give up. This is a good way to start.

 

  • First you go to https://edelivery.oracle.com and create an account. ORACLE provides all the software to study and stay up to date.
  • Download ORACLE VM Virtual Box
  • Install it just next, next and finish.
  • Download ORACLE Linux 7
  • Install it in your VM.
  • Create an HD of 100GB
  • Before start the installation go to virtual box settings and change your network card to “bridge”.
  • Point the CD drive of virtual machine to the OS image. Start the installation.
  • Set an easy password during the installation.
User Password
root Root
  • After installed, log on the machine and type the command “hostnamectl set-hostname oralinux”. oralinix will be the name of the machine. You’ll be able to connect through “Putty”
  • Type the command “yum update” to update your system
  • You need to copy the oracle files to the server. Open your ftp
  • Connect with user and pass root and move the DB files to inside the /etc folder

 

Automatic Setup

To perform all its prerequisite setup, issue the following command.

  • # yum install oracle-rdbms-server-12cR1-preinstall -y

 

Additional Setup

Set the password for the “oracle” user.

  • passwd oralinux
  • Amend the “/etc/security/limits.d/90-nproc.conf” file as described below. See MOS Note [ID 1487773.1]

 

# Change this

*          soft    nproc    1024

 

# To this

* – nproc 16384

 

 

 

Set secure Linux to permissive by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows.

 

SELINUX=permissive

Once the change is complete, restart the server or run the following command.

 

# setenforce Permissive

If you have the Linux firewall enabled, you will need to disable or configure it, as shown here or here. To disable it, do the following.

 

# service iptables stop

# chkconfig iptables off

Create the directories in which the Oracle software will be installed.

 

mkdir -p /u01/app/oracle/product/12.1.0.2/db_1

chown -R oracle:oinstall /u01

chmod -R 775 /u01

Putting mount points directly under root is typically a bad idea. It’s done here for simplicity, but for a real installation “/” should be reserved for the OS.

Unless you are working from the console, or using SSH tunnelling, login as root and issue the following command.

 

xhost +<machine-name>

Add the following lines at the end of the “/home/oracle/.bash_profile” file.

 

# Oracle Settings

export TMP=/tmp

export TMPDIR=$TMP

 

export ORACLE_HOSTNAME=ol6-121.localdomain

export ORACLE_UNQNAME=cdb1

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/db_1

export ORACLE_SID=cdb1

 

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

 

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

 

 

 

Your OS is ready to receive the installation of the ORACLE database. In the other post I’ll describe how to download and install.

Leave a Reply

Your email address will not be published. Required fields are marked *