Oracle 26 AI Silent Installation on Linux: Complete Step-by-Step Guide (2026)
If you're an Oracle DBA, system administrator, or someone preparing…
Oracle 26 AI installation on Linux
In this article, we are going to learn Oracle 26…
How to Apply Oracle 19c Patch 19.30 on Linux – Step-by-Step Guide
Keeping your Oracle Database 19c up to date is critical…
oracle rac
oracle .bash_profile Grid user:
Oracle RAC Useful Commands
Oracle RAC useful commands: these commands help DBAs to maintain…
Switchover steps in oracle data guard
In this tutorial, we will learn the switchover steps in…
Switchover steps in Oracle RAC Environment
Here are the switchover steps in Oracle RAC environment, which…
scripts
blwt ap ev ex kill event kill sid longops sql…
Oracle 23c installation on Linux
Here we will learn Oracle 23c installation on Linux step…
Export from 11g and import to 19c
In this article, we are going to learn how to…
how to Activate Standby Database as Primary after Failover
When it comes to database management, the ability to failover…
Manual Reinstate old Primary Using Flashback
In this article, we will learn how to reinstate old…
How to reinstate the old Primary as a Standby after Failover in Oracle
In this practice, we reinstate the old primary as a…
Oracle Dataguard Switchover with broker
To perform an Oracle Data Guard switchover with broker, you…
How to setup Data Guard Broker Configuration
Setting up Data Guard Broker Configuration involves the following steps.…
Oracle 19c Dataguard setup with PDB
Oracle 19c Dataguard setup with PDB, Dataguard is a disaster…
Patching 19.3 to 19.16 step by step
In this article, we are going to learn how to…
ORA-16019: Cannot Use Db_recovery_file_dest With LOG_ARCHIVE_DEST Or LOG_ARCHIVE_DUPLEX_DEST
SQL> alter system set log_archive_dest_2='service=ocp_dr noaffirm async valid_for=(online_logfiles,primary_role) db_unique_name=ocp_dr';alter system…
oracle installation on susi
load 3 4 -RPMs stop firewall
AUTOMATICALLY KILL INACTIVE SESSIONS
Hi, today we are going to create script which automatically…
Upgrade Oracle 11g to 19c using AutoUpgrade utility
Hi, in this article we are going to learn how…
Check the Patch Applied to the Oracle Database
In Oracle Database we have multiple ways to find Patch…
Tablespace Utilization In Oracle Multitenant Database
In this article, we will check tablespace utilization in CDB…
Delete RMAN Backups
In this article, we are going to learn how to…
How to Configure Recovery Catalog
In this article, we will learn how to configure the…
HOW TO DOWN HIGH WATER MARK
This article will learn how to reset the High Water…
Why do we use FAL_SERVER and FAL_CLIENT parameters in Oracle dataguard
In this article, we are going to understand why we…
How to upgrade ORACLE 11G to 19C
In this article, we are going to learn how to…
How to Identify OS PID from SID in Oracle Database
We want to find out OS PID against sid in…
Change Archivelog mode and Destination In Oracle 19c
In this article, we are going to learn how to…
ORA-02019: connection description for remote database not found
Hi, I'm facing this error "ORA-02019: connection description for remote…
How to Recover lost datafile with no backup
In this article, we are going to learn how to…
Backup Oracle Database using RMAN
In our previous post, we already discussed about the RMAN…
Oracle RMAN Backup Types
In this article, we are going to discuss oracle rman…
How to access Ubuntu server using putty from windows?
In this article, we are going to learn how to…
How to Generate Execution Plan in Oracle
Knowing how to generate an execution plan optimizer of the…
ORA-12954: The request exceeds the maximum allowed database size of 12 GB
In this article, we are going to solve ORA 12954…
How to Change Archivelog Destination in Oracle
In this article, we are going to learn how to…
Rman full database backup script
In this article, we are going to learn how to…
crosscheck archivelog all
In this article, we are going to learn, why we…
How to find the long running queries in oracle
Here we are going to learn how to find the…
Oracle DataPump Performance Tuning
In this article, we are going to learn datapump performance…
ORA-19913 unable to decrypt backup
Today we facing the ORA-19913 unable to decrypt backup error…
How to Get DB Link DDL in oracle
how to get ddl for db_link in oracle with password,…
Data Pump Export Import Over the Network using network_link
In this article, we going to learn how to use…
Check Oracle Database Growth per Month
In this article, we are going to check oracle database…
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
Sometimes, we face ORA-14452 during drop or alter. SO, in…
Streams AQ: enqueue blocked on low memory Oracle wait event
In this article, we are going to discuss the oracle…
Global Temporary Tables
Applications regularly utilize some type of impermanent information store for…
Export Backup Automation in Oracle On Linux
Hello, friends in this article we are going to learn…
RMAN BACKUP SCRIPT
How to automate Oracle RMAN Backup with shell script In…
Oracle TDE implementation
Oracle TDE implementation In this article, we are going to…
Crosscheck archive in rman
Crosscheck Archivelog all Validation failed for archived log In this…
Oracle Instant Client Installation
How do I install Oracle Client Installer? The Oracle Instant…
Oracle Database 21c Installation On Oracle Linux 7 | Oracle 21c Download
Install Oracle 21c Linux In this article, we are going…
Rename an Oracle Database schema?
How do you Rename Oracle Database Schema? This is a…
How to Check Last Password Change History?
In this article, we are going to learn how to…
What are the control file and datafile in Oracle?
What is control file and datafile in Oracle? In this…
Managing the Oracle Database Flash Recovery Area
How do I check flash recovery area? The flash recovery…
Useful Linux commands for DBA
Linux/UNIX Commands For DBAs Here we learn some useful Linux…
Queries to Monitor Expdp Datapump Jobs Status
How do you monitor Expdp Impdp process? This article is…
How to kill Inactive sessions in ORACLE?
Hi, In this article we are going to learn how…
How to check Database size and tablespace Utilization?
Checking the database size and tablespace utilization is an important…
How to Delete old archives using ASMCMD?
How do I delete old archive logs? Hi, in this…
How to Relocate Datafiles in Oracle?
In this article, we are going to learn how to…
Oracle 11g R2 Dataguard configuration step by step
Oracle 11g R2 Dataguard configuration step by step, before starting…
ORA-00054 resource busy and acquire with nowait
The error ORA-00054 occurs if DDL or DML currently running…
How to load data from CSV file into oracle using SQL Loader
Load data from CSV file into oracle Hi Friends, in…
Set newname RMAN script
In this article, we are going to learn how to…
Find redo log members, redo log file size and redo log status
In this article, we will show you how to find…
How to Reconfigure Oracle Restart
Oracle Restart Configuration In this article, we are going to…
ORA-19502 Solutions
What is ora 19502? Today I'm just performing the database…
How to Configure OEM DBconsole Manually
OEM DBconsole Manually This tutorial is from oracle 11g, and…
How to drop oracle database manually
How do I manually drop a database? In this article,…
TNS-00583: Valid Node Checking: Unable To Parse Configuration
TNS-00583 Actually, in today's session I am facing the error…
ORA-00031: session marked for kill Solution
In this tutorial, we will learn how to solve the…
Oracle 19c Installation on OEL 7 step by step
Hello Friends, in this article we are going to learn…
How to install, configure, and use Statspack in Oracle
Oracle Statspack Hello guys, in this article we are going…
How to Rename Database Using Controlfile
How do I change a database name in Controlfile? Hi…
Creating Non CDB database in silent mode – ORACLE 19C
In this example, we are using oracle 19c and going…
How to Create Pluggable Database Oracle
In this article, we are going to learn how to…
How to set Oracle Pluggable Database Automatic startup
As you know the pluggable database concept introduce in oracle…
How to create ASM diskgroup
In this article, we are going to learn how to…
How to Export Tables using PARFILE STEP BY STEP
Export Tables using PARFILE, Table export also known as the…
ORA-01244: unnamed datafile(s) added to control file by media recovery
Hi friends, in this article we are going to solve…
Load oracleasm module
In this article we are going to learn how to…
Estimate Required Disk Space for Export Using Estimate_only
In Data Pump EXPDP command use estimate only, to check…
ORA-01654: unable to extend index solution
Hi guys, I'm getting an "ora-01654 unable to extend index"…
How to Rename Oracle Database using NID
How do I change my NID database name? Hello friends,…
How to add SWAP Space in Linux
Sometimes we need to add extra swaps to our Linux…
ORA-12919: Can not drop the default permanent tablespace
Hi, Today I am getting the “ORA-12919: Can not drop…
How To Export Tablespace Using Expdp Data Pump Utility?
Export Tablespace Using Expdp Hi, In this article we are…
SQL Character Function
What is Character Functions Hello, friends in this article we…
Single Row Functions
Single row functions operate on a single row only then…
How to create a SEQUENCE step by step
In this article, we are going to learn how to…
Alter table drop column Oracle
Hello friends, In this article, we are going to discuss,…
How To Find CPU And Memory Information Of Oracle Database Server
Hello friends, In this article, we are going to find…
How To Find Execution History Of An sql_id
Hello friends, in this article I'm going to show you…
ORA 25153 Temporary Tablespace is Empty
Here is the solution of ORA 25153. If you faced…
How To Get Tablespace Quota Details Of An User In Oracle
In this article, we are going to show you how…
Scroll to Top