Oracle 11g download linux

Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 7 (OL7)

Oracle Linux 7 is a production release, but the Oracle Database is only supported on it from Oracle Database 11g (11.2.0.4) onward. This installation should not be used for a real system when using database versions prior to 11.2.0.4.

This article describes the installation of Oracle Database 11g Release 2 (11.2.0.4) 64-bit on Oracle Linux 7 (OL7) 64-bit. The article is based on a server installation with a minimum of 2G 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 using one of the two link below. If you have access to My Oracle Support (MOS), then it is better to download the 11.2.0.4 version, since this is the first release of 11.2 that is supported on Oracle Linux 7.

Unpack Files

Unzip the files.

You should now have a single directory called «database» containing installation files.

Hosts File

The «/etc/hosts» file must contain a fully qualified name for the server.

Set the correct hostname in the «/etc/hostname» file.

Oracle Installation Prerequisites

Perform either the Automatic Setup or the Manual Setup to complete the basic prerequisites. The Additional Setup is required for all installations.

Automatic Setup

If you plan to use the «oracle-rdbms-server-11gR2-preinstall» package to perform all your prerequisite setup, follow the instructions at http://public-yum.oracle.com to setup the yum repository for OL, then perform the following command.

All necessary prerequisites will be performed automatically.

It is probably worth doing a full update as well, but this is not strictly speaking necessary.

Manual Setup

If you have not used the «oracle-rdbms-server-11gR2-preinstall» package to perform all prerequisites, you will need to manually perform the following setup tasks.

Add or amend the following lines in the «/etc/sysctl.conf» file.

Run the following command to change the current kernel parameters.

Add the following lines to the «/etc/security/limits.conf» file.

Add the following line to the «/etc/pam.d/login» file, if it does not already exist.

The following packages are listed as required, including the 32-bit version of some of the packages. Many of the packages should be installed already.

Create the new groups and users.

We are not going to use the extra groups, but include them if you do plan on using them.

Additional Setup

The following steps must be performed, whether you did the manual or automatic setup.

Set the password for the «oracle» user.

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

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

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.

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

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

Add the following lines at the end of the «/home/oracle/.bash_profile» file.

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.

Proceed with the installation of your choice. You can see type of installation I performed by clicking on the links below to see screen shots of each stage. The «pdksh» package will be listed as missing, which can be ignored because we installed the «ksh» package instead.

If you are doing an installation for an Enterprise Manager repository, remember to do an advanced installation and pick the ALT32UTF8 character set.

During the link phase you will encounter an error invoking the «ins_emagent.mk» file. To fix this, edit the «$ORACLE_HOME/sysman/lib/ins_emagent.mk», doing a search and replace for the line shown below.

Click the «Retry» button.

Post Installation

Edit the «/etc/oratab» file setting the restart flag for each instance to ‘Y’.

Источник

Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6

This article describes the installation of Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with SELinux set to permissive and the firewall disabled. The following package groups were included for this installation.

• Base System > Base
• Base System > Client management tools
• Base System > Compatibility libraries
• Base System > Hardware monitoring utilities
• Base System > Large Systems Performance
• Base System > Network file system client
• Base System > Performance Tools
• Base System > Perl Support
• Servers > Server Platform
• Servers > System administration tools
• Desktops > Desktop
• Desktops > Desktop Platform
• Desktops > Fonts
• Desktops > General Purpose Desktop
• Desktops > Graphical Administration Tools
• Desktops > Input Methods
• Desktops > X Window System
• Development > Additional Development
• Development > Development Tools
• Applications > Internet Browser

An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below.

Download Software

Download the Oracle software from OTN or MOS depending on your support status.

Unpack Files

Unzip the files.

You should now have a single directory called «database» containing installation files.

Hosts File

The «/etc/hosts» file must contain a fully qualified name for the server.

Oracle Installation Prerequisites

Perform either the Automatic Setup or the Manual Setup to complete the basic prerequisites. The Additional Setup is required for all installations.

Automatic Setup

If you plan to use the «oracle-rdbms-server-11gR2-preinstall» package to perform all your prerequisite setup, follow the instructions at http://public-yum.oracle.com to setup the yum repository for OL, then perform the following command.

All necessary prerequisites will be performed automatically.

It is probably worth doing a full update as well, but this is not strictly speaking necessary.

Manual Setup

If you have not used the «oracle-rdbms-server-11gR2-preinstall» package to perform all prerequisites, you will need to manually perform the following setup tasks.

Oracle recommend the following minimum parameter settings.

The current values can be tested using the following command.

Add or amend the following lines in the «/etc/sysctl.conf» file.

Run the following command to change the current kernel parameters.

Add the following lines to the «/etc/security/limits.conf» file.

Install the following packages if they are not already present.

This will install all the necessary 32-bit packages for 11.2.0.1. From 11.2.0.2 onwards many of these are unnecessary, but having them present does not cause a problem.

Create the new groups and users.

We are not going to use the «asm» groups, since this installation will not use ASM.

Additional Setup

Set the password for the «oracle» user.

Amend the «/etc/security/limits.d/90-nproc.conf» file as described below. See MOS Note [ID 1487773.1]

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

Once the change is complete, restart the server.

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

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

Login as root and issue the following command.

Login as the oracle user and add the following lines at the end of the «.bash_profile» file.

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.

Proceed with the installation of your choice. The prerequisites checks will fail for the following version-dependent reasons:

• 11.2.0.1: The installer shows multiple «missing package» failures because it does not recognize several of the newer version packages that were installed. These «missing package» failures can be ignored as the packages are present. The failure for the «pdksh» package can be ignored because we installed the «ksh» package in its place.
• 11.2.0.2: The installer should only show a single «missing package» failure for the «pdksh» package. It can be ignored because we installed the «ksh» package in its place.
• 11.2.0.3: The installer shows no failures and continues normally.

You can see the type of installation I performed by clicking on the links below to see screen shots of each stage.

If you are doing an installation for an Enterprise Manager repository, remember to do an advanced installation and pick the ALT32UTF8 character set.

Post Installation

Edit the «/etc/oratab» file setting the restart flag for each instance to ‘Y’.

Common Errors

«error code 35» : The machine name in the «/etc/hosts» file is not correct. It needs an entry for the loopback adapter (localhost) and the machine name. If you are using DNS for name resolution, you still need the loopback adapter reference in this file.

«error code 37» : The DNS not working properly. You may also get this error is the «/etc/hosts» file is not configured correctly.

«sqlplus: error while loading shared libraries: libclntsh.so.11.1» : The prerequisites have not been met. Work through them again. Specifically, make sure the «gcc» package has been installed.

Listener fails to start — Typically this is due to incorrect name resolution. Make sure the «/etc/hosts» and/or DNS is configured correctly.

Linking errors — Almost always due to missing prerequisites. Review the setup sections.

Источник

Oracle Database 11g Release 2 Installation on RHEL/CentOS 6.x/5.x/4.x

As we all know Oracle database is the most popular and widely used Relational Database Management System (RDBMS) in the world. This post describes step by step installation of Oracle Database 11g Release 2 32bit on CentOS 6.4 32bit. The installation steps should not be vary on most of the Red Hat based Linux distributions.

Installing Oracle Database 11g Release 2

Step 1: Install Oracle Dependencies

We use “oracle-rdbms-server-11gR2-preinstall” package offered by “Oracle Public Yum” repository. The Oracle public yum repository provides a free and easiest way to install all the latest Oracle Linux dependencies automatically. To setup yum repository, follow the instructions provided below.

Use “wget” command to Download appropriate yum configuration file under /etc/yum.repos.d/ directory as root user.

RHEL/CentOs 6.x

RHEL/CentOs 5.x

RHEL/CentOs 4.x

Now perform the following “yum” command to install all the necessary prerequisites automatically.

While importing GPG key, you might get “GPG key retrieval failed” error as shown below. Here, you need to import proper GPG key for your OS release.

Download and verify the appropriate Oracle Linux GPG Key that best matches your RHEL/CentOS compatible OS release.

RHEL/CentOs 6.x

RHEL/CentOs 5.x

RHEL/CentOs 4.x

Step 2: Setting Hostname

Open the “/etc/sysconfig/network” file and modify the HOSTNAME to match your FQDN (Fully Qualified Domain Name) host name.

Open “/etc/hosts” file and add fully qualified hostname for the server.

Now you need to restart networking on the server to make sure that changes will be persistent on reboot.

Step 3: Oracle User Settings

Set the password for the “oracle” user.

Add the entry to file “/etc/security/limits.d/90-nproc.conf” as described below.

Set SELinux to “permissive” mode by editing the file “/etc/selinux/config“.

Once you’ve made change, don’t forger to restart the server to reflect new changes.

Login as Oracle user and open file “.bash_profile“, which is available on oracle user’s home directory, make an entries as described below. Make sure you set correct hostname to “ORACLE_HOSTNAME=oracle.tecmint.com“.

Switch to root user and issue the following command to allow Oracle user to access X Server.

Create the directories and set the appropriate permissions in which the Oracle software will be installed.

Step 4: Downloading Oracle Software

Sign-up and Download the Oracle software using the following link.

1. Oracle Database 11g Release 2

Download Oracle 11g Release 2

The Oracle package contains 2 zip files which you must first accept the license agreement before downloading. I’ve given the files names for you reference, please download these files for your system architecture somewhere under “/home/oracle/“.

For Linux x86 Systems

For Linux x86-64 Systems

Step 5: Oracle Installation

Now let’s start Oracle installation. First of all need to switch as ‘oracle’ user to install database.

Extract compressed Oracle database source files to the same directory “/home/oracle/“.

Post unzip source file, directory called database will be created, go to inside the directory and execute below script to start Oracle database installation process.

1. RunInstaller will call Oracle Universal Installer (OUI), wherein look and feel & steps are the same across all the operating system.

Oracle Universal Installer

2. Provide your email address to be informed of security issues and receive security updates.

Configure Oracle Security Updates

3. Create and Configure a Database

Create Oracle Database

4. Choose the system class, either Desktop or Server.

Select Oracle System Class

5. Select the type of database installation you want to perform.

Select Database Installation Type

6. Select “Typical install” option to install full oracle installation with basic configuration.

Select Typical Install

7. Set Administrative password and perform full Database installation with basic configuration.

Set Oracle Administrative Password

8. Please click on “Yes” to continue with installation.

Typical Install Configuration Confirm

9. Create Inventory

Create Inventory

10. If you faced prerequisites warning during installation. Click on “Fix & Check Again“. Oracle fixes Prerequisites by itself. This is the new feature of Oracle Database 11g.

Perform Prerequisite Checks

The pdksh package is not available in Oracle repository due to which you need to download and install it manually.

During pdksh package installation you may encountered conflict error of ksh package. Remove ksh package forcefully and install the pdksh package with given below command:-

11. Performing Prerequisite checks: It’s test whether sufficient total SWAP space is available on the system.

Performing Prerequisite SWAP Check

12. Installation Summary: Click on Save Response File. This file is useful for Oracle Silent Mode Installation

Oracle Installation Summary

13. Save Response File somewhere in your system.

Save Response File

14. Product Installation Progress

Product Install

15. Copying database files

Copying Database Files

16. Click on “Password Management“.

Oracle Password Management

17. Set password for user “SYS” and click on OK to continue.

Set SYS User Password

18. Configuration scripts need to be executed as the “root” user. Go to the path given in the screen and execute the scripts one by one. Click on ‘OK‘ once scripts is executed.

Execute Configuration Scripts

19. The installation of Oracle Database is successful.

Oracle Installation Finish

20. To test your Oracle installation navigate to web based management interface for your system at “localhost” with the user name “SYS” connecting as “SYSDBA” and using the password you set during the install of Oracle. Remember to open port 1158 on your firewall and restart the iptables service.

Oracle Enterprise Manager Login

21. Oracle Enterprise Database Control Manager

Oracle Database Control Manager

Now you can start using Oracle. I highly recommend you to follow the Oracle Documentation for more help. There are number of client applications out there which can help you, like the command line tool called Oracle Instant Client and the Oracle SQL Developer UI program.

This is end of the Oracle Database Software Installation. In our upcoming article we will be covering how to create database using DBCA and how to Start-up and Shutdown Oracle Database. Please stay tuned….

If You Appreciate What We Do Here On TecMint, You Should Consider:

TecMint is the fastest growing and most trusted community site for any kind of Linux Articles, Guides and Books on the web. Millions of people visit TecMint! to search or browse the thousands of published articles available FREELY to all.

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

We are thankful for your never ending support.

Источник