Установка oracle 19 линукс

Database Installation Guide

Oracle Database Database Installation Guide, 19c for Linux

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.

Источник

Oracle Database 19c Installation On Oracle Linux 7 (OL7)

This article describes the installation of Oracle Database 19c 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 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 YUM 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 RHEL7 or CentOS7, you can pick up the PRM from the OL7 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.

Someone in the comments suggested you might need to add the previous lines into the «/etc/security/limits.conf» file also for CentOS7. This is definitely not needed for OL7, but worth considering if the installer gives prerequisite failures for these settings.

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

The following packages are listed as required. 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.

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.

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

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.

Run the root scripts when prompted.

You can read more about silent installations here.

You are now ready to create a database.

Database Creation

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.

Источник

Step by Step Oracle 19c Installation On Linux

In this article we are going to see Oracle Database 19c (19.3) for Linux 7.6

Download the 19c software from Oracle Support.

Unzip the 19c software and execute runInstaller :

]$ unzip -d /u01/app/oracle/product/19.0.0/ LINUX.X64_193000_db_home.zip

Let’s start the oracle binaries installation and oracle 18c database creation.

Step1 : Click create and configure a single instance database

Step2 : Click Server class

Step3 : Select Enterprise Edition

Step 4:Choose location for ORACLE_BASE

Step 5: Select configuration type as General Purpose / Transaction Processing.

Step 6: Enter Database name

Step 7: Enter database file location

Step 8: Enable Archivelog mode option for database

Step 9: Enter SYS and SYSTEM user password

Step 10: Check OS groups for installation

Step 11: Check Prerequisite checks for 19c database installation

Step 12: Check Summary

Step 13: Run root.sh and Orainventory scripts :

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.

] # sh /u01/app/oracle/product/19.0.0/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19.0.0

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.
Oracle Trace File Analyzer (TFA – Standalone Mode) is available at :
/u01/app/oracle/product/19.0.0/bin/tfactl

tfactl will use TFA Service if that service is running and user has been granted access
tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed

Step 14: Check database status

] # sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 – Production on Thu May 2 20:45:55 2019
Version 19.3.0.0.0

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0

SQL> select instance_name,status from v$instance;

Oracle database 19c installation is completed successfully.

Источник