{"id":2901,"date":"2025-03-22T08:56:23","date_gmt":"2025-03-22T08:56:23","guid":{"rendered":"https:\/\/w3buddy.com\/?p=2901"},"modified":"2026-01-15T13:10:31","modified_gmt":"2026-01-15T07:40:31","slug":"how-to-install-oracle-19c-on-amazon-linux-2-2025-step-by-step-guide","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/how-to-install-oracle-19c-on-amazon-linux-2-2025-step-by-step-guide\/","title":{"rendered":"How to Install Oracle 19c on Amazon Linux 2 (2025) | Step-by-Step Guide"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In this guide, we provide a step-by-step process to install <strong><a href=\"https:\/\/www.oracle.com\/in\/database\/technologies\/oracle19c-linux-downloads.html\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle 19c<\/a><\/strong> on <strong><a href=\"https:\/\/aws.amazon.com\/amazon-linux-2\/?amazon-linux-whats-new.sort-by=item.additionalFields.postDateTime&amp;amazon-linux-whats-new.sort-order=desc\" target=\"_blank\" rel=\"noreferrer noopener\">Amazon Linux 2<\/a><\/strong> using the <strong>GUI-based installer<\/strong>. You&#8217;ll learn how to configure system requirements, set up necessary users and groups, adjust kernel parameters, and perform the installation with an optional patch application. This tutorial ensures a smooth setup with detailed instructions and GUI screenshots. By the end, you&#8217;ll have a fully functional Oracle 19c database running on Amazon Linux 2.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>Watch this step-by-step tutorial on how to install Oracle 19c on Amazon Linux 2 (2025) before following the written guide.<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to Install Oracle 19c on Amazon Linux 2 (2025) | Step-by-Step Guide | W3Buddy\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/qJqbvGNymaQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 1: Check System Kernel Version<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Run the following command to check the system&#8217;s kernel version and architecture:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">uname -a<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command displays detailed system information, including the kernel version, system architecture, and hostname. It helps verify that you are running Amazon Linux 2 and confirm compatibility with Oracle 19c.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2: Install Required Packages<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Run the following command to install the necessary dependencies for Oracle 19c using <strong>root <\/strong>user:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">sudo yum install -y binutils compat-libcap1 compat-libstdc++-33 \\\ngcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel \\\nlibX11 libXau libXi libXtst libXrender libXrender-devel \\\nlibgcc libstdc++ libstdc++-devel libxcb make smartmontools \\\nsysstat<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle 19c requires specific system libraries and tools to function properly. This command installs essential development tools, runtime libraries, and system utilities, ensuring that all dependencies are met before proceeding with the installation. The <code>-y<\/code> flag automatically confirms the installation, making the process smoother.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 3: Configure System Kernel Parameters<\/h2>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">fs.file-max = 6815744\nkernel.sem = 250 32000 100 128\nkernel.shmmni = 4096\nkernel.shmall = 1073741824\nkernel.shmmax = 4398046511104\nnet.ipv4.ip_local_port_range = 9000 65500\nnet.core.rmem_default = 262144\nnet.core.rmem_max = 4194304\nnet.core.wmem_default = 262144\nnet.core.wmem_max = 1048576<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">These kernel parameters are required to ensure stable performance and resource allocation for the Oracle Database.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>fs.file-max<\/strong>: Sets the maximum number of open file descriptors.<\/li>\n\n\n\n<li><strong>kernel.sem<\/strong>: Configures semaphore settings for interprocess communication.<\/li>\n\n\n\n<li><strong>kernel.shmmax &amp; kernel.shmall<\/strong>: Define shared memory limits for Oracle processes.<\/li>\n\n\n\n<li><strong>net.ipv4.ip_local_port_range<\/strong>: Expands the available port range for network connections.<\/li>\n\n\n\n<li><strong>net.core.rmem_* &amp; net.core.wmem_*<\/strong>: Adjust TCP buffer sizes for better network performance.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Step 4: Verify and Apply Kernel Parameter Changes<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After updating the <strong>\/etc\/sysctl.conf<\/strong> file with the required kernel parameters, verify and apply the changes using the following commands:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">cat \/etc\/sysctl.conf<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command displays the contents of the \/etc\/sysctl.conf file, allowing you to verify that all required parameters have been correctly added.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">sudo sysctl -p<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command applies the new kernel parameters without requiring a system reboot. It ensures that the changes take effect immediately.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">sysctl -a | grep oracle<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command checks if any kernel parameters specifically related to Oracle are already set. It helps confirm that the system is properly configured for Oracle Database installation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 5: Disable SELinux<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle 19c requires SELinux to be set to <strong>Permissive<\/strong> mode to avoid security restrictions. Run the following commands to disable SELinux temporarily and permanently:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">setenforce 0<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command sets SELinux to <strong>Permissive<\/strong> mode temporarily (until the next reboot), allowing Oracle to function without SELinux restrictions.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">sed -i 's\/^SELINUX=enforcing\/SELINUX=permissive\/g' \/etc\/selinux\/config<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command modifies the SELinux configuration file (<strong>\/etc\/selinux\/config<\/strong>) to ensure that SELinux remains in <strong>Permissive<\/strong> mode even after a system reboot. It replaces <strong>SELINUX=enforcing<\/strong> with <strong>SELINUX=permissive<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To verify the SELinux status, run:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">getenforce<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If SELinux is in <strong>Permissive<\/strong> mode, the output should be:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">Permissive<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Step 6: Set Resource Limits for the Oracle User<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle requires specific resource limits to be set for the <strong>oracle <\/strong>user to ensure smooth database operation. Run the following commands as the <strong>root<\/strong> user to define these limits in<strong> \/etc\/security\/limits.conf<\/strong> file.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">echo \"oracle   soft   nofile   1024\" >> \/etc\/security\/limits.d\/oracle.conf\necho \"oracle   hard   nofile   65536\" >> \/etc\/security\/limits.d\/oracle.conf\necho \"oracle   soft   nproc    16384\" >> \/etc\/security\/limits.d\/oracle.conf\necho \"oracle   hard   nproc    16384\" >> \/etc\/security\/limits.d\/oracle.conf\necho \"oracle   soft   stack    10240\" >> \/etc\/security\/limits.d\/oracle.conf\necho \"oracle   hard   stack    32768\" >> \/etc\/security\/limits.d\/oracle.conf\necho \"oracle   hard   memlock  134217728\" >> \/etc\/security\/limits.d\/oracle.conf\necho \"oracle   soft   memlock  134217728\" >> \/etc\/security\/limits.d\/oracle.conf<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>nofile (Number of open files):<\/strong> Limits the maximum number of open files per process.<\/li>\n\n\n\n<li><strong>nproc (Number of processes):<\/strong> Limits the number of user processes allowed.<\/li>\n\n\n\n<li><strong>stack (Stack size):<\/strong> Defines the maximum stack size for Oracle processes.<\/li>\n\n\n\n<li><strong>memlock (Memory locking):<\/strong> Ensures Oracle can lock memory pages to prevent them from being swapped out.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">To check if the limits are correctly applied, switch to the oracle user and run:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">ulimit -a<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This will display the configured limits, confirming they have been set correctly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 7: Disable Swap<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle 19c requires swap to be disabled for optimal performance. Run the following commands as the <strong>root<\/strong> user:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">swapoff -a<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command disables swap temporarily (until the next reboot). This is necessary because Oracle Real Application Clusters (RAC) and certain Oracle features perform better without swap.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">sed -i '\/swap\/d' \/etc\/fstab<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command permanently disables swap by removing any swap-related entries from the <code>\/etc\/fstab<\/code> file. This ensures that swap does not get re-enabled after a system reboot.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To confirm that swap has been disabled, run:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">free -m<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>Swap<\/strong> row in the output should show <code>0<\/code> allocated swap space, indicating that swap is successfully disabled.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 8: Disable Firewall<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle 19c requires certain network ports to be open, and disabling the firewall ensures smooth communication between components. Run the following commands as <strong>root<\/strong> to stop and disable the firewall:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">systemctl stop firewalld<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command immediately stops the firewall service, preventing it from blocking any required ports during the installation process.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">systemctl disable firewalld<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command ensures that the firewall does not start automatically after a system reboot.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To check the firewall status, run:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">systemctl status firewalld<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If the firewall is disabled, you should see output indicating that the service is <strong>inactive (dead)<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 9: Create Oracle User and Groups<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle requires specific user groups for managing installation, database administration, and operations. Run the following commands as <strong>root<\/strong> to create the necessary groups and user:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Create Groups<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">groupadd -g 54321 oinstall\ngroupadd -g 54322 dba\ngroupadd -g 54323 oper<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>oinstall<\/strong>: Primary group for Oracle installation and software management.<\/li>\n\n\n\n<li><strong>dba<\/strong>: Grants database administrator privileges.<\/li>\n\n\n\n<li><strong>oper<\/strong>: Used for database operator tasks like starting\/stopping the database.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Create the Oracle User and Assign Groups<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">useradd -u 54321 -g oinstall -G dba,oper oracle<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creates a user named <strong>oracle<\/strong> with UID <strong>54321<\/strong>.<\/li>\n\n\n\n<li>Assigns <strong>oinstall<\/strong> as the primary group.<\/li>\n\n\n\n<li>Adds the user to the <strong>dba<\/strong> and <strong>oper<\/strong> groups, granting necessary privileges.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">To check the newly created user and group associations, run:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">id oracle<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should display the correct UID, primary group (oinstall), and additional groups (dba, oper).<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">uid=54321(oracle) gid=54321(oinstall) groups=54322(dba),54323(oper)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The <strong>oracle<\/strong> user has the correct <strong>UID (54321)<\/strong>.<\/li>\n\n\n\n<li>The <strong>primary group<\/strong> is <strong>oinstall (GID 54321)<\/strong>.<\/li>\n\n\n\n<li>The user is successfully added to the <strong>dba (GID 54322)<\/strong> and <strong>oper (GID 54323)<\/strong> groups.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This setup ensures that the Oracle user has the required permissions for installation and database management. \u2705<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 10: Set a Password for the Oracle User<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To secure the <strong>oracle<\/strong> user account, set a password using the following command:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">passwd oracle<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command prompts you to enter a new password for the <strong>oracle<\/strong> user. After typing the password, you\u2019ll need to confirm it by re-entering the same password.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To check if the password has been set, try switching to the <strong>oracle<\/strong> user:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">su - oracle<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If the password is correctly set, you should be able to log in as the <strong>oracle<\/strong> user without any issues. \u2705<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 11: Create Required Directories and Set Permissions<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle 19c requires specific directories for software installation, database storage, and backups. Run the following commands as <strong>root<\/strong> to create these directories and set the correct ownership and permissions.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Create Required Directories<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">mkdir -p \/u01\/app\/oracle\/product\/19c\/db_1\nmkdir -p \/u02\/oracle\/oradata\nmkdir -p \/u02\/oracle\/FRA\nmkdir -p \/backup\/patch<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\/u01\/app\/oracle\/product\/19c\/db_1<\/strong>: Directory for Oracle Database binaries.<\/li>\n\n\n\n<li><strong>\/u02\/oracle\/oradata<\/strong>: Location for Oracle database data files.<\/li>\n\n\n\n<li><strong>\/u02\/oracle\/FRA<\/strong>: Fast Recovery Area (FRA) for backups and logs.<\/li>\n\n\n\n<li>\/<strong>backup\/patch<\/strong>: Directory for storing Oracle patches.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Set Ownership for the Oracle User<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">chown -R oracle:oinstall \/u01\nchown -R oracle:oinstall \/u02\nchown -R oracle:oinstall \/backup<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Assigns <strong>oracle<\/strong> user and <strong>oinstall<\/strong> group as the owners of the directories.<\/li>\n\n\n\n<li>Ensures the <strong>oracle<\/strong> user has proper access to manage Oracle files.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Set Permissions<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">chmod -R 750 \/u01\/\nchmod -R 750 \/u02\/\nchmod -R 750 \/backup\/<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>750 permissions<\/strong>:\n<ul class=\"wp-block-list\">\n<li><strong>Owner (oracle)<\/strong>: Full read, write, and execute permissions (<code>7<\/code>).<\/li>\n\n\n\n<li><strong>Group (oinstall)<\/strong>: Read and execute permissions (<code>5<\/code>).<\/li>\n\n\n\n<li><strong>Others<\/strong>: No access (0).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>This ensures that only the <strong>oracle user and oinstall group<\/strong> have access to these directories, improving security.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">To check if the directories are created and permissions are correctly set, run:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">ls -ld \/u01 \/u02 \/backup<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should show the correct ownership (oracle:oinstall) and permissions (drwxr-x&#8212;). \u2705<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 12: Configure Oracle Environment Variables<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">Switch to the Oracle User<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Run the following command as <strong>root<\/strong> to switch to the <strong>oracle<\/strong> user:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">su - oracle<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Create and Edit <strong>.bash_profile<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Run the following command to open the <strong>.bash_profile<\/strong> file for editing:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">vi ~\/.bash_profile<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Press <strong>i<\/strong> to enter insert mode, then add the following environment variables:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">export TMP=\/tmp\nexport TMPDIR=$TMP\n\nexport ORACLE_HOSTNAME=ip-172-31-47-65.ap-south-1.compute.internal\nexport ORACLE_UNQNAME=cdb1\nexport ORACLE_BASE=\/u01\/app\/oracle\nexport ORACLE_HOME=\/u01\/app\/oracle\/product\/19c\/db_1\nexport ORACLE_SID=orcl\nexport ORACLE_TERM=xterm\nexport BASE_PATH=\/usr\/sbin:$PATH\nexport PATH=$ORACLE_HOME\/bin:$BASE_PATH\nexport PATH=$ORACLE_HOME\/OPatch:$PATH\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib\nexport CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Press <strong>ESC<\/strong>, then type: <strong>:wq!<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This writes the changes and exits the file.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Reload the .bash_profile<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">To apply the changes immediately, run:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">. ~\/.bash_profile\n\nor\n\nsource ~\/.bash_profile<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check if the Oracle environment variables are set correctly:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">env | grep ORA<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">It should display values for <strong>ORACLE_HOME<\/strong>, <strong>ORACLE_SID<\/strong>, <strong>ORACLE_BASE<\/strong>, etc., confirming that the environment is properly configured.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 13: Download, Rename, and Unzip Oracle 19c Installation Files<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After setting up the Oracle environment, download and extract the Oracle 19c database software from using <strong>Oracle <\/strong>user.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Navigate to the Installation Directory<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">cd $ORACLE_HOME\npwd<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Expected Output:<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">\/u01\/app\/oracle\/product\/19c\/db_1<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This confirms you are in the correct installation directory.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Download Oracle 19c Software<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">wget -O LINUX.X64_193000_db_home.zip \"https:\/\/download.oracle.com\/otn\/linux\/oracle19c\/190000\/LINUX.X64_193000_db_home.zip?AuthParam=1742599078_bde80d998bfe6bff32f3cf05a195e82a\"<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>wget<\/strong> downloads the Oracle 19c ZIP file.<\/li>\n\n\n\n<li><strong>-O<\/strong> renames the file directly to <strong>LINUX.X64_193000_db_home.zip<\/strong>, avoiding long filenames with AuthParam tokens.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Unzip the Installation File<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Extracts the installation files into the <strong>$ORACLE_HOME<\/strong> directory.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Verify the Extraction<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">ls -lrt<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You should see the extracted installation files inside <strong><code>$ORACLE_HOME<\/code><\/strong>, confirming a successful download and unzip.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 14: Install Required X11 Packages for GUI Installation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle 19c requires an <strong>X11 (X Window System) environment<\/strong> for running the GUI-based installer. Install the necessary X11 packages based on your <strong>OS<\/strong>.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\"># For Amazon Linux 2\n# In this video, we will only install these two as our OS is Amazon Linux 2.\nsudo yum install -y xorg-x11-xauth\nsudo yum install -y xclock xterm\n\n# For Red Hat Enterprise Linux 8 (RHEL 8)\nsudo yum install -y xorg-x11-xauth\nsudo yum install -y xterm\n\n# Note: The xorg-x11-apps package (which includes xclock) is in the \n# CodeReady Linux Builder Repository for RHEL 8, so it's skipped.\n\n# For SUSE Linux Enterprise Server 15 SP1\nsudo zypper install -y xauth\nsudo zypper install -y xclock\n\n# For Ubuntu Server 18\nsudo apt install -y x11-apps<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Step 15: Export a False Image for Oracle Installation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle\u2019s installer checks the OS version, and sometimes, it may not recognize newer versions. To <strong>bypass compatibility issues<\/strong>, set the CV_ASSUME_DISTID environment variable based on your OS.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\"># Oracle Linux\nexport CV_ASSUME_DISTID=OL8  # For Oracle Linux 8\nexport CV_ASSUME_DISTID=OL7  # For Oracle Linux 7\n\n# Red Hat Enterprise Linux (RHEL)\nexport CV_ASSUME_DISTID=RHEL8  # For RHEL 8\nexport CV_ASSUME_DISTID=RHEL7  # For RHEL 7\n\n# Amazon Linux\nexport CV_ASSUME_DISTID=OL8  # Assume compatibility with Oracle Linux 8\n\n# Ubuntu (Debian-based)\nexport CV_ASSUME_DISTID=OL8  # Mimic Oracle Linux 8\n\n# SUSE Linux Enterprise Server (SLES)\nexport CV_ASSUME_DISTID=SLES12  # For SLES 12\nexport CV_ASSUME_DISTID=SLES15  # For SLES 15\n\n# Sun Solaris (SPARC or x86)\nexport CV_ASSUME_DISTID=SOLARIS\n\n# CentOS (Now Stream)\nexport CV_ASSUME_DISTID=RHEL8  # Since CentOS is RHEL-based\n\n# Rocky Linux \/ AlmaLinux\nexport CV_ASSUME_DISTID=RHEL8<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Persist the Setting for Oracle User<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To apply the setting permanently for the <strong>oracle<\/strong> user:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">vi ~\/.bash_profile  # Open profile<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Add the export command for your OS, then save and exit (<strong>:wq!<\/strong>).<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">. ~\/.bash_profile  # Reload profile\necho $CV_ASSUME_DISTID  # Verify setting<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Expected Output:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">OL8  # or your set value<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Step 16: Start Oracle 19c Installer<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Now, switch to the <strong>oracle<\/strong> user and start the Oracle 19c GUI installer.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Switch to the oracle User<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Run the following command from the <strong>ec2-user<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">su - oracle<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Enter the <strong>oracle user password<\/strong> when prompted.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Verify the Current Directory<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Ensure you are in the <strong>oracle home directory<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">pwd\n# Expected Output: \/home\/oracle<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Set the Compatibility Variable<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Export the CV_ASSUME_DISTID variable to ensure compatibility:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">export CV_ASSUME_DISTID=OEL7.6<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Start Oracle 19c Installer<\/h4>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">cd $ORACLE_HOME\n.\/runInstaller<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>Oracle Universal Installer (OUI)<\/strong> GUI will launch. Follow the on-screen steps to complete the installation. \u2705<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><mark style=\"background-color:#f1ff00\" class=\"has-inline-color\">If you want to apply a <strong>patch<\/strong> while installing Oracle 19c, use the following command instead of just <strong>.\/runInstaller<\/strong>:<\/mark><\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">.\/runInstaller -applyRU \/backup\/patch\/35943157<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>-applyRU<\/strong> applies the <strong>Release Update (RU)<\/strong> patch <strong>before<\/strong> installation completes.<\/li>\n\n\n\n<li>Replace <strong>35943157<\/strong> with the correct patch number if using a different patch.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">This ensures your Oracle database is installed with the latest updates right from the start!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Complete GUI Instructions (Step-by-Step with Screenshots)<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"594\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-12-1024x594.png\" alt=\"\" class=\"wp-image-2903\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-12-1024x594.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-12-300x174.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-12-768x445.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-12-1536x891.png 1536w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-12-2048x1187.png 2048w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-12-150x87.png 150w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"808\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-13-1024x808.png\" alt=\"\" class=\"wp-image-2904\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-13-1024x808.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-13-300x237.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-13-768x606.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-13-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-13.png 1181w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"804\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-14-1024x804.png\" alt=\"\" class=\"wp-image-2905\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-14-1024x804.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-14-300x236.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-14-768x603.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-14-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-14.png 1183w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"806\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-15-1024x806.png\" alt=\"\" class=\"wp-image-2906\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-15-1024x806.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-15-300x236.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-15-768x605.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-15-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-15.png 1177w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"813\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-16-1024x813.png\" alt=\"\" class=\"wp-image-2907\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-16-1024x813.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-16-300x238.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-16-768x610.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-16-150x119.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-16.png 1174w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"809\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-17-1024x809.png\" alt=\"\" class=\"wp-image-2908\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-17-1024x809.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-17-300x237.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-17-768x606.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-17-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-17.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"809\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-18-1024x809.png\" alt=\"\" class=\"wp-image-2909\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-18-1024x809.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-18-300x237.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-18-768x607.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-18-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-18.png 1176w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"813\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-19-1024x813.png\" alt=\"\" class=\"wp-image-2910\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-19-1024x813.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-19-300x238.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-19-768x609.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-19-150x119.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-19.png 1177w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"807\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-20-1024x807.png\" alt=\"\" class=\"wp-image-2911\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-20-1024x807.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-20-300x236.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-20-768x605.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-20-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-20.png 1181w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"806\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-21-1024x806.png\" alt=\"\" class=\"wp-image-2912\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-21-1024x806.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-21-300x236.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-21-768x605.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-21-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-21.png 1177w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"809\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-22-1024x809.png\" alt=\"\" class=\"wp-image-2913\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-22-1024x809.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-22-300x237.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-22-768x606.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-22-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-22.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"808\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-23-1024x808.png\" alt=\"\" class=\"wp-image-2914\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-23-1024x808.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-23-300x237.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-23-768x606.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-23-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-23.png 1186w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"805\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-24-1024x805.png\" alt=\"\" class=\"wp-image-2915\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-24-1024x805.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-24-300x236.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-24-768x604.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-24-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-24.png 1184w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"808\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-25-1024x808.png\" alt=\"\" class=\"wp-image-2916\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-25-1024x808.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-25-300x237.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-25-768x606.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-25-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-25.png 1177w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"807\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-26-1024x807.png\" alt=\"\" class=\"wp-image-2917\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-26-1024x807.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-26-300x236.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-26-768x605.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-26-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-26.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"803\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-27-1024x803.png\" alt=\"\" class=\"wp-image-2918\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-27-1024x803.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-27-300x235.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-27-768x603.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-27-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-27.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"799\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-28-1024x799.png\" alt=\"\" class=\"wp-image-2919\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-28-1024x799.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-28-300x234.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-28-768x599.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-28-150x117.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-28.png 1193w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"806\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-29-1024x806.png\" alt=\"\" class=\"wp-image-2920\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-29-1024x806.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-29-300x236.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-29-768x605.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-29-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-29.png 1177w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"807\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-30-1024x807.png\" alt=\"\" class=\"wp-image-2921\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-30-1024x807.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-30-300x236.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-30-768x605.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-30-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-30.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-31-1024x683.png\" alt=\"\" class=\"wp-image-2922\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-31-1024x683.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-31-300x200.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-31-768x512.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-31-150x100.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-31.png 1461w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"809\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-32-1024x809.png\" alt=\"\" class=\"wp-image-2923\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-32-1024x809.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-32-300x237.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-32-768x606.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-32-150x118.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-32.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"690\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-33-1024x690.png\" alt=\"\" class=\"wp-image-2924\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-33-1024x690.png 1024w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-33-300x202.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-33-768x518.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-33-150x101.png 150w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-33.png 1046w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Script to Check Database Details<\/h2>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">SET PAGESIZE 50\nSET LINESIZE 200 \nSET VERIFY OFF\nBREAK ON REPORT SKIP 1\nCOLUMN section_heading FORMAT A35\nCOLUMN section_data FORMAT A35\n-- Database Information Section\nSELECT 'DATABASE INFORMATION' AS section_heading, NULL AS section_data FROM dual\nUNION ALL\nSELECT NULL, NULL FROM dual  -- Blank line after heading\nUNION ALL\nSELECT 'Database Name:', db.name FROM v$database db\nUNION ALL\nSELECT 'Unique Name:', db.db_unique_name FROM v$database db\nUNION ALL\nSELECT 'Creation Date:', TO_CHAR(db.created, 'DD-MON-YYYY HH24:MI:SS') FROM v$database db\nUNION ALL\nSELECT 'Open Mode:', db.open_mode FROM v$database db\nUNION ALL\nSELECT 'Log Mode:', db.log_mode FROM v$database db\nUNION ALL\nSELECT 'Database Role:', db.database_role FROM v$database db\nUNION ALL\nSELECT 'Character Set:', \n       (SELECT value FROM v$parameter WHERE name = 'nls_character_set') FROM dual\nUNION ALL\nSELECT 'NCHAR Character Set:', \n       (SELECT value FROM v$parameter WHERE name = 'nls_nchar_character_set') FROM dual\nUNION ALL\nSELECT NULL, NULL FROM dual  -- Blank line after section\n-- Instance Information Section\nUNION ALL\nSELECT 'INSTANCE INFORMATION' AS section_heading, NULL AS section_data FROM dual\nUNION ALL\nSELECT NULL, NULL FROM dual  -- Blank line after heading\nUNION ALL\nSELECT 'Instance Name:', inst.instance_name FROM v$instance inst\nUNION ALL\nSELECT 'Host Name:', inst.host_name FROM v$instance inst\nUNION ALL\nSELECT 'Startup Time:', TO_CHAR(inst.startup_time, 'DD-MON-YYYY HH24:MI:SS') FROM v$instance inst\nUNION ALL\nSELECT 'Instance Status:', inst.status FROM v$instance inst\nUNION ALL\nSELECT 'Database Status:', inst.database_status FROM v$instance inst\nUNION ALL\nSELECT 'Logins Allowed:', inst.logins FROM v$instance inst\nUNION ALL\nSELECT 'Version:', inst.version FROM v$instance inst\nUNION ALL\nSELECT NULL, NULL FROM dual  -- Blank line after section\n;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"908\" height=\"607\" src=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-34.png\" alt=\"\" class=\"wp-image-2925\" srcset=\"https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-34.png 908w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-34-300x201.png 300w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-34-768x513.png 768w, https:\/\/w3buddy.com\/blog\/wp-content\/uploads\/2025\/03\/image-34-150x100.png 150w\" sizes=\"auto, (max-width: 908px) 100vw, 908px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In this guide, we provide a step-by-step process to install Oracle 19c on Amazon Linux 2 using the GUI-based installer. You&#8217;ll learn how to configure system requirements, set up necessary users and groups, adjust kernel parameters, and perform the installation with an optional patch application. This tutorial ensures a smooth setup with detailed instructions and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2943,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225],"tags":[],"class_list":["post-2901","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/2901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=2901"}],"version-history":[{"count":7,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/2901\/revisions"}],"predecessor-version":[{"id":2949,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/2901\/revisions\/2949"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media\/2943"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=2901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=2901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=2901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}