Step by Step Easy process to install Oracle 19c RAC 2Node Cluster

Two Node Oracle RAC 19c installation and configuration in oracle linux 7.8 High Level Steps:- Operating System Oracle Linux 7.8 Swap Size 16GB firewalld systemctl disable firewalld SELINUX vi /etc/selinux/config (selinux=permissive) IP Settings vi /etc/hosts & check ifconfig& DNS Entry Disable libvirtd.service systemctl disable libvirtd.service Hostname vi /etc/hostname Add Storage Create LUN in SAN stoage […]

Step by Step Easy process to install Oracle 19c RAC 2Node Cluster Read More »

Oracle Database 19c RAC Patching using Opatch Utility

Easy Step By Step Patching of Oracle 19c RAC using Opatch [root@node1 u04]# rpm -ivh psmisc-22.20-16.el7.x86_64.rpm –nodeps –force warning: psmisc-22.20-16.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Verifying… ################################# [100%] Preparing… ################################# [100%] Updating / installing… 1:psmisc-22.20-16.el7 ################################# [100%] [root@node1 u04]# ssh node2 NOKEY Verifying… ################################# [100%] Preparing… ################################# [100%] Updating / installing… 1:psmisc-22.20-16.el7

Oracle Database 19c RAC Patching using Opatch Utility Read More »

DR DATABASE STRUCK OR STOPED APPLYING ARCHIVELOG ORA-16086

provided steps outline the process of managing standby redo logs (SRLs) for a Data Guard setup, focusing on configuring and troubleshooting issues during the addition and removal of standby log groups. Here’s a summary of what you performed and some recommendations: Steps and Observations: Recommendations: Let me know if you need further assistance or troubleshooting!

DR DATABASE STRUCK OR STOPED APPLYING ARCHIVELOG ORA-16086 Read More »

STEPS TO RECOVER A STANDBY DR DATABASE IN CASE OF MISSING/CORRUPT ARCHIVE LOGS

When a standby database is not being updated, due to missing or corrupt archive logs, the following steps are to be followed:- TO RECOVER A STANDBY DATABASE IN CASE OF MISSING/CORRUPT ARCHIVE LOGS When a standby database is not being updated, due to missing or corrupt archive logs, the following steps are to be followed:-

STEPS TO RECOVER A STANDBY DR DATABASE IN CASE OF MISSING/CORRUPT ARCHIVE LOGS Read More »

ARCHIVE LOG NOT SHIPPED TO  DR DATABASE

ORA-16191: Primary log  shippingclient not logged onstandby ARCHIVE LOG NOT SHIPPED TO DR DATABASE Check the status of archive log shipping status to standby. Run the command in standby database . oraenv +ASM Asmcmd>cd fra/sbyweb/archivelog Asmcmd>ls ( It will show the archive log shipped) IN PRIMARY DATABASE Run the following command [oracle@caoweb1]$ !sql SQL> select

ARCHIVE LOG NOT SHIPPED TO  DR DATABASE Read More »

DATAGUARD NOT IN SYNC MISSING ARCHIVELOG IN RAC TO RAC ENVIRONMENT

When a standby database is not being updated, due to missing or corrupt archive logs DATAGUARD NOT IN SYSNC MISSING ARCHIVELOG IN RAC TO RAC ENVIRONMENT Error : archive log seq 39212 not shiiped from primary to standby database rac to rac Error details :FAL[client]: Failed to request gap sequence GAP – thread 2 sequence

DATAGUARD NOT IN SYNC MISSING ARCHIVELOG IN RAC TO RAC ENVIRONMENT Read More »

Normalization in MySQL Database

Dependency Example: Explain functional dependency and how it affects normalization.Normalization Task: Demonstrate how to normalize a sample table into 1NF, 2NF, and 3NF using MySQL. Introduction to Database ConceptsWhat is a Database?A database is an organized collection of data that allows for easy access, management, andupdating. It stores data in a structured format, usually as

Normalization in MySQL Database Read More »

“How I Configured a VPS to Host Multiple Applications (PHP, Python, Node.js) with Subdomains and SSL”

“Step-by-Step Guide: Setting Up a VPS to Host Multiple Applications with Subdomains” Description: “In this blog post, I’ll share my experience configuring a Hostinger VPS to host multiple applications running on PHP, Python, and Node.js, each with its own subdomain. Learn how to manage different versions of PHP, set up a reverse proxy with Nginx,

“How I Configured a VPS to Host Multiple Applications (PHP, Python, Node.js) with Subdomains and SSL” Read More »

APEX and ORDS 24.1 configuration in OracleLinux

Install Oracle APEX 24.1 on Oracle Linux 8.6 Configure ORDS 24.2 with Oracle Database 19c Enterprise Edition Deploying Oracle APEX and ORDS in Apache Tomca Jasper Integration with Oracle APEX Oracle APEX 24.1 Installation and configuration in Oracle Linux 8.6 Oracle APEX 24.1 ORDS 24.2 Oracle Database 19c Enterprise Edition Oracle Linux 8.6 Apache Tomcat

APEX and ORDS 24.1 configuration in OracleLinux Read More »