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 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,
Check Oracle Database Growth per Month
In this article, we are going to check oracle database
Data Pump Export Import Over the Network using network_link
In this article, we going to learn how to use
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,
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
How To Get Ddl Of All Tablespaces In Oracle
Hello Friends, In this article we are going to show
How to Recover Controlfile without Backup?
Recover Controlfile without Backup Hello Friends, In this article we
How to create DB Link?
In this article, I’m going to show you how to
What is SQL, DBMS, and RDBMS
What is SQL, DBMS and RDBMS Hello friends, in this
Using SQL Select Statements
How to use SQL select statement? In this article, we
How to Install ORACLE 12c R1 on ORACLE Linux 7 step by step
In this post, I’m going to demonstrate to you how
How to Restore RMAN Backup with a Different Database Name
Hello friends, in this article I’m going to demonstrate to
How to Partitioning in existing table using EXCHANGE PARTITION
Partitioning in existing table Hello, friends in this article we
Transport Tablespace from Linux to Windows in ORACLE 11g & 10g
Transport tablespace from Linux to windows platform step by step
Scroll to Top