Install oracle database 12c on oracle linux

Install oracle database 12c on oracle linux

Oracle Database Installation Guide, 12c Release 2 (12.2) for Linux

Copyright © 2015, 2019, Oracle and/or its affiliates. All rights reserved.

Primary Author: Prakash Jashnani

Contributing Authors: Douglas Williams, Sunil Surabhi

Contributors: David Austin, Mark Bauer, Neha Avasthy, Sampath Ravindhran, Prasad Bagal, Subhranshu Banerjee, Aparna Kamath, Tammy Bednar, Eric Belden, Gavin Bowe, Robert Chang, Darcy Christensen, Kiran Chamala, Jonathan Creighton, Benoit Dageville, Logeshwaran Rajan, Rajesh Dasari, Angad Gokakkar , Anu Natarajan, Girdhari Ghantiyala, Bernard Clouse, Chandrasekharan Iyer, David Jimenez, Sivaram Soma, Janet Stern, Vishal Saxena, Vasu Venkatasubramanian, Suman Palavalli, Sameer Joshi, Malai Stalin, Markus Michalewicz, Subrahmanyam Kodavaluru, Khethavath Singh, Sudip Datta, Madhu Hunasigi, Jim Erickson, Marcus Fallen, Joseph Francis, Mark Fuller, Allan Graves, Barbara Glover, Asad Hasan, Thirumaleshwara Hasandka, Sagar Jadhav, Clara Jaeckel, Aneesh Khandelwal, Joel Kallman, Eugene Karichkin, Jai Krishnani, Sangeeth Kumar, Ranjith Kundapur, Kevin Jernigan, Christopher Jones, Simon Law, Bryn Llewellyn, Saar Maoz, Sreejith Minnanghat, Gopal Mulagund, Ankur Kemkar, Sue Lee, Rich Long, Raunak Rungta, Barb Lundhild, Rolly Lv, Rudregowda Mallegowda, Padmanabhan Manavazhi, Mughees Minhas, Krishna Mohan, Matthew McKerley, John McHugh, Gurudas Pai, Satish Panchumarthy , Rajesh Prasad, Rajendra Pingte, Richard Roddy, Srinivas Poovala, Mohammed Shahnawaz Quadri, Hanlin Qian, Gurumurthy Ramamurthy, Hema Ramamurthy, Sunil Ravindrachar, Mark Richwine, Dipak Saggi, Trivikrama Samudrala, Shachi Sanklecha, David Schreiner, Ara Shakian, Janelle Simmons, Mohit Singhal, Dharma Sirnapalli, Akshay Shah, James Spiller, Roy Swonger, Binoy Sukumaran, Kamal Tbeileh, Ravi Thammaiah, Shekhar Vaggu, Preethi Vallam, Ajesh Viswambharan, Peter Wahl, Terri Winters, John Haxby, Sergiusz Wolicki, Sivakumar Yarlagadda, Zakia Zerhouni

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are «commercial computer software» pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Источник

Oracle Database 12c Release 1 (12.1) Installation On Oracle Linux 8 (OL8)

This article describes the installation of Oracle Database 12c Release 1 (12.1) 64-bit on Oracle Linux 8 (OL8) 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 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.

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

At the time of writing there isn’t a preinstall package from 12.1, but we can use the 19c preinstall package.

If you plan to use the «oracle-database-preinstall-19c» package to perform all your prerequisite setup, issue the following command.

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

It’s worth running the all the YUM commands listed in the manual setup section. Depending on the OS package groups you have selected, some additional packages might also be needed.

Manual Setup

If you have not used the «oracle-database-preinstall-19c» package to perform all prerequisites, you will need to manually perform the following setup tasks.

Add the following lines to the «/etc/sysctl.conf» file, or in a file called «/etc/sysctl.d/98-oracle.conf».

Run one of the following commands to change the current kernel parameters, depending on which file you edited.

Add the following lines to a file called «/etc/security/limits.d/oracle-rdbms-server-12cR1-preinstall.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.

Uncomment the extra groups you require.

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. To disable it, do the following.

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

Putting mount points directly under root without mounting separate disks to them is typically a bad idea. It’s done here for simplicity, but for a real installation «/» storage 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.

The scripts are created using the cat command, with all the «$» characters escaped. If you want to manually create these files, rather than using the cat command, remember to remove the «\» characters before the «$» characters.

Create a «scripts» directory.

Create an environment file called «setEnv.sh». The «$» characters are escaped using «\». If you are not creating the file with the cat command, you will need to remove the escape characters.

Add a reference to the «setEnv.sh» file at the end of the «/home/oracle/.bash_profile» file.

Create a «start_all.sh» and «stop_all.sh» script that can be called from a startup/shutdown service. Make sure the ownership and permissions are correct.

Once the installation is complete and you’ve edited the «/etc/oratab», you should be able to start/stop the database with the following scripts run from the «oracle» user.

You can see how to create a Linux service to automatically start/stop the database here.

Installation

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

Switch to the directoy with the installation media, unzip it and start the Oracle Universal Installer (OUI) by issuing one of the following commands. The interactive mode will display GUI installer screens to allow user input, while the silent mode will install the software without displaying any screens, as all required options are already specified on the command line. We need to use the CV_ASSUME_DISTID environment variable to fake the OS for the installer.

Run the root scripts when prompted.

You can read more about silent installations here.

You are now ready to create a database, but it’s better to patch the installation first if you have access to Oracle Support.

Database Creation

You create a database using the Database Configuration Assistant (DBCA). The interactive mode will display GUI screens to allow user input, while the silent mode will create the database without displaying any screens, as all required options are already specified on the command line.

You can read more about silent database creation here.

Post Installation

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

Источник

Oracle Database 12c Release 1 (12.1) Installation On Oracle Linux 7 (OL7)

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

This article describes the installation of Oracle Database 12c Release 1 (12.1) 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 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.

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-12cR1-preinstall» package to perform all your prerequisite setup, issue the following command.

Earlier versions of Oracle Linux required manual setup of the Yum repository by following the instructions at http://public-yum.oracle.com.

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

It’s worth running the all the YUM commands listed in the manual setup section. Depending on the OS package groups you have selected, some additional packages might also be needed.

Manual Setup

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

Add the following lines to the «/etc/sysctl.conf» file, or in a file called «/etc/sysctl.d/98-oracle.conf».

Run one of the following commands to change the current kernel parameters, depending on which file you edited.

Add the following lines to a file called «/etc/security/limits.d/oracle-rdbms-server-12cR1-preinstall.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.

Uncomment the extra groups you require.

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. To disable it, do the following.

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

Putting mount points directly under root without mounting separate disks to them is typically a bad idea. It’s done here for simplicity, but for a real installation «/» storage 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.

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.

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

Check out the notes below for how to deal with potential errors that may arise during the installation.

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

The «Database Configuration Assistant Complete» screen displays the Database Express 12c URL, which will be something like «https://ol7.localdomain:5500/em».

Post Installation

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

12.1.0.1 Notes

Only follow these notes if you are attempting the install using 12.1.0.1, there are a number of things that will need to be fixed along the way. These are not necessary for a 12.1.0.2 installation, as it completes cleanly.

The following steps need to be considered during the installation.

When clicking «Next» on the «Download Software Updates» screen you will get the following message. Click the «Yes» button.

During the linking phase, you will see the following error.

To fix it, do the following:

Perform the following modifications to the «$ORACLE_HOME/rdbms/lib/env_rdbms.mk» file.

Click the «Retry» button.

Later, you might see the following error.

To fix it, do the following:

Perform the following modifications to the «$ORACLE_HOME/ctx/lib/env_ctx.mk» file.

Click the «Retry» button.

Due to the issues during the linking phase, it probably makes sense to do a relink once the installation is complete.

12.1.0.2 Notes

During the linking phase, you may see the following error.

To fix it, run the following command as the «oracle» user, then click the «Retry» button.

During the database creation as part of the installation, or after when using the DBCA, you may get the following error.

To fix it, follow the instructions to rebuild Perl as described towards the end of this post by Laurent Leturgez. You will have to redo the database creation.

Источник