Oracle Database is an object-relational database management system (RDBMS) developed by Oracle Corporation. The Oracle Database 12c is a high-performance, enterprise-class database. Oracle Database is the most popular, trusted database systems. Oracle Database support multiple operating systems like Redhat, SUSE, Oracle Linux, Microsoft Windows and IBM Linux.
In this article we will explain how to install Oracle Database 12c on Linux Server.
Step 1: Prerequisites
Packages: First we need to install the required packages. These packages we can easily get from OS officially repository.
Reload the configuration file to reflect the changes.
# sysctl -p # sysctl -a
Next, we need to configure some limits for the oracle user.
# vim /etc/security/limits.conf
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 32768
Step 4: Configure X11 Forwarding
X11 forwarding refers to executing such a program remotely through an SSH (Secure Shell) connection. With X11 you can easily install the Oracle Database. You can use mention link to configrure X11 on server.
Once you will download the Oracle database setup from Oracle official website. Extract the Oracle files on a Linux server.
# cd /software # unzip linuxx64_12201_Oracle_database.zip
Step 7: Install Oracle Database
Start the Oracle Database Installer issuing the following command in the database directory.
# cd /software/database # ./runInstaller
Provide your email address to be informed of security issues and click “Enter”
If you are using any proxy server then provide the details of proxy server and click “Continue”
Choose create and configure a database option and click “Next”
Under the ‘System Class’ section, choose system class and click “Next” again.
In this section, Select the type of installation you want to select and click “Next”
Select the installation type and click “Next”
Now specify full database installation with basic configuration and click “Next”
You are starting your first installation on the host. Specify a directory for Installation metadata files and click “Next”
Verify that the installation pre-checks are completed without errors. then it will show the summary of the information such as global settings, database information, etc. Review the information and click “install”.
Now installation of Oracle Database has been started. It will take a few minutes to complete.
During the installation you need to run a couple of scripts to set the required permissions.
Changing permissions of /u01/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall. The execution of the script is complete.
Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin … Copying oraenv to /usr/local/bin … Copying coraenv to /usr/local/bin … Creating /etc/oratab file… Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Do you want to setup Oracle Trace File Analyzer (TFA) now ? yes|[no] : Oracle Trace File Analyzer (TFA - User Mode) is available at : /u01/app/oracle/product/11.2.0/dbhome_1/suptools/tfa/release/tfa_home/bin/tfactl OR Oracle Trace File Analyzer (TFA - Daemon Mode) can be installed by running this script : /u01/app/oracle/product/11.2.0/dbhome_1/suptools/tfa/release/tfa_home/install/roottfa.sh
Oracle database configuration has been completed and click “Next”.
Step 8: Access Oracle Enterprise Manager
When it is finished, you will be presented with the message indicating the URL of the Oracle Enterprise Manager:
Step 10: Set Oracle Home Directory
Add the following lines in user home directory at .bash_profile file.