Tag install database on linux

Hello everyone today I am going to install oracle 19c on Linux RedHat 8.6. also in this video, I will talk about x11 forwarding and its problem, and install oracle 19c on the new version of RedHat

Prerequisites:

1. Hardware and Software Requirements: Verify that your system meets the hardware and software requirements specified in Oracle’s documentation.
2. Linux User and Groups:

• Create a dba group:

bash

sudo groupadd dba

• Create the oracle user and add them to the dba group:

bash

sudo useradd -g dba oracle

• Set a password for the oracle user:

bash

sudo passwd oracle

3. Kernel Parameters and Resource Limits: Modify the kernel parameters and resource limits as recommended by Oracle. Edit the /etc/sysctl.conf file and add or update these lines:

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

Then, apply the changes:

sudo sysctl -p

Edit the /etc/security/limits.conf file and add the following lines at the end of the file:

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

Installation:

1. Download Oracle Database 19c: Visit Oracle’s website to download the Oracle Database 19c installation files for Linux.
2. Extract Installation Files:
   • Unzip the downloaded files:

unzip oracle-database-19c-*.zip

Installation:

1. Download Oracle Database 19c: Visit Oracle’s website to download the Oracle Database 19c installation files for Linux.
2. Extract Installation Files:
   • Unzip the downloaded files:

codeunzip oracle-database-19c-*.zip

3. Run Oracle Universal Installer (OUI):

• Navigate to the database directory where you extracted the files.
• Run the Oracle Universal Installer as the oracle user:

bash

./runInstaller

4. Oracle Installation Steps:

• Follow the graphical prompts in the Oracle Universal Installer:
  • Choose “Install database software only.”
  • Specify the Oracle Base and Software Location.
  • Select the edition and options you want to install.
  • Provide the Oracle Inventory Directory (usually /u01/app/oraInventory).
  • Follow the rest of the installation wizard, including setting the Oracle Home user password.

5. Execute Root Scripts:

• After the installation is complete, the installer will prompt you to run root scripts. Open a new terminal as the root user and execute the scripts as instructed.

6. Create and Configure a Database:

• You can use the Database Configuration Assistant (DBCA) or command-line tools like SQL*Plus to create and configure an Oracle Database instance.

7. Start and Stop the Database:

• Start the Oracle Database with SQL*Plus or by using the provided scripts like dbstart:

sqlplus / as sysdba
SQL> startup

• Stop the database with SQL*Plus or dbshut.

8. Testing:

• Verify that the Oracle Database is running correctly by connecting to it, creating tables, and executing queries.

Remember that this is a simplified overview, and you should always refer to Oracle’s official documentation and installation guides for the most accurate and up-to-date instructions. Oracle installations can be complex, and it’s important to ensure that your system meets all prerequisites and requirements. Consider involving an experienced Oracle DBA if you are unfamiliar with the process.