Установка базы данных oracle linux

Установка базы данных oracle linux

In this tutorial, you learn how to install Oracle Database 11g on Linux.

Note: This OBE was tested on production software however some of the screenshots may still refer to the beta software.

Topics

This tutorial covers the following topics:

	Overview
	Installing Oracle Database 11g on Linux
	Testing Your Installation
	Summary

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Overview

Using the Oracle Universal Installer, you install the Oracle Database 11g software and create a database.

Installing Oracle Database 11g on Linux

To install the Oracle software, you must use the Oracle Universal installer.

For this installation, you need either the DVDs or a downloaded version of the DVDs. In this tutorial, you install from the downloaded version. From the directory where the DVD files were unzipped, open a terminal window and enter the following:

The product you want to install is Oracle Database 11g. Make sure the product is selected and click Next.

You will perform a basic installation with a starter database. Enter orcl for the Global Database Name and oracle for Database Password and Confirm Password. Then, click Next.

You need to specify your Inventory directory. The location should be set to /u01/app/oracle/oraInventory. Accept the default Operating System group name, oinstall. Then, click Next.

The installer now verifies that the system meets all the minimum requirements for installing and configuring the chosen product. Please correct any reported errors before continuing. When the check successfully completes, click Next.

Oracle Configuration Manager allows you to associate your configuration information with your Metalink account. You can choose to enable it on this window. Then, click Next.

Review the Summary window to verify what is to be installed. Then, click Install.

The progress window appears.

The Configuration Assistants window appears.

Your database is now being created.

When the database has been created, you can unlock the users you want to use. Click OK.

You need to execute orainstRoot.sh and root.sh as the root user.

Open a terminal window and enter the following commands. Follow the prompts as instructed.

Switch back to the Universal Installer and click OK.

Click Exit. Click Yes to confirm exit.

Testing Your Installation

To test that your installation completed successfully, perform the following steps:

Open a browser and enter the following URL:

https:// :1158/em

where hostname > should be changed to your machine name, IP address, or localhost.

Because Enterprise Manager Database Control is a secure site, you need a certificate. Select the Accept this certificate permanently option, and then click OK.

Enter system as the User Name and oracle as the Password, and then click Login.

The Database Control Home Page appears. Your installation was successful.

Summary

In this tutorial, you learned how to install and test the Oracle Database 11g installation on Linux.

Источник

Установка базы данных oracle linux

Database Installation Guide

Oracle Database Database Installation Guide, 19c for Linux

Copyright © 2015, 2021, Oracle and/or its affiliates.

Primary Authors: Prakash Jashnani, Subhash Chandra

Contributing Author: Douglas Williams

Contributors: Jean-Francois Verrier, Richard Roddy, Neha Avasthy, Sampath Ravindhran, Prasad Bagal, Subhranshu Banerjee, Gerald Venzl, Tammy Bednar, Avi Miller, Gavin Bowe, Gia-Khanh Nguyen, Darcy Christensen, Kiran Chamala, Jonathan Creighton, Benoit Dageville, Logeshwaran Rajan, Rajesh Dasari, Angad Gokakkar , Anu Natarajan, Girdhari Ghantiyala, Bernard Clouse, Chandrasekharan Iyer, Anil Nair, Sivaram Soma, Lisa Vaz, Ranjit Noronha, Vasu Venkatasubramanian, Sumanta Chatterjee, Margaret Susairaj, Malai Stalin, Markus Michalewicz, Subrahmanyam Kodavaluru, Sudip Datta, Madhu Hunasigi, Jim Erickson, Marcus Fallen, Joseph Francis, Allan Graves, Barbara Glover, Asad Hasan, Thirumaleshwara Hasandka, Putta Ramesh, Sergio Leunissen, Aneesh Khandelwal, Joel Kallman, Eugene Karichkin, Jai Krishnani, Prasad K Kulkarni, Ranjith Kundapur, Balaji Pagadala, Christopher Jones, Tak Wang, Bryn Llewellyn, Saar Maoz, Chao Liang, Gopal Mulagund, Pushkar Punit, Sivaselvam Narayanasamy, Ankur Kemkar, Sue Lee, Rich Long, Ricardo Alonso Gonzalez Acuna, Barb Lundhild, Sangeeth Jose, Rudregowda Mallegowda, Prasad Kuruvadi Nagaraj, Mughees Minhas, Krishna Mohan, Matthew McKerley, John McHugh, Gurudas Pai, Satish Panchumarthy , Rajesh Prasad, Rajendra Pingte, Ramesh Chakravarthula, Srinivas Poovala, David Price, Hanlin Qian, Michael Coulter, Hema Ramamurthy, Sunil Ravindrachar, Mark Richwine, Dipak Saggi, Alan Tam, Ian Cookson, David Schreiner, Ara Shakian, Naveen Ramamurthy, Mohit Singhal, Dharma Sirnapalli, Akshay Shah, James Spiller, Roy Swonger, Binoy Sukumaran, Jagvir Yadav, Ravi Thammaiah, Shekhar Vaggu, Pablo Sainz Albanez, Hector Vieyra, Peter Wahl, John Haxby, Sergiusz Wolicki, Sivakumar Yarlagadda, Nagendra Kumar Ym

Источник

Oracle Database 19c Installation On Oracle Linux 8 (OL8)

Oracle database 19c is supported on Oracle Linux 8, but you must be running on UEK6 and database version 19.7. The installation will work without the patches, but it will not be supported without them.

This article describes the installation of Oracle Database 19c 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 here.

Download Software

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

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-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 DNF commands listed in the manual setup section. Depending on the OS package groups you have selected, some additional packages might also be needed.

If you are using RHEL8 or CentOS8, you can pick up the RPM from the OL8 repository and install it. It will pull the dependencies from your normal repositories.

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-database-preinstall-19c.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. Don’t worry if some don’t install. It won’t prevent the installation.

Create the new groups and users.

Uncomment the extra groups you require.

Additional 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.

If you are not using Oracle Linux and UEK, you will need to manually disable transparent huge pages.

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 ORACLE_HOME directory, unzip the software directly into this path and start the Oracle Universal Installer (OUI) by issuing one of the following commands in the ORACLE_HOME directory. 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.

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.

Patch Installation (Optional)

The installation of 19.3 will work without applying the patches. If you don’t have access to the patches and are just doing the installation for a test system, you can proceed without this step.

For the installation to be supported you need to be on patch level 19.7 (April 2020) or later. To get the patches you need to have a valid Oracle Support CSI so you can download them from Oracle Support. This is an example of applying the 19.7 patch to a clean standalone installation without ASM and before a database is created.

For patches on real systems, always read the patch notes.

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’.

Enable Oracle Managed Files (OMF) and make sure the PDB starts when the instance starts.

Источник