OCP TECHNOLOGY
Home
Contact
About
Blog
Cart
checkout
Search for:
scripts
8
Mar, 24
blwtapevexkill eventkill sidlongopssql text
Read More
Oracle 23c installation on Linux
3
Dec, 23
Here we will learn Oracle 23c installation on Linux step
Read More
Export from 11g and import to 19c
2
Sep, 23
In this article, we are going to learn how to
Read More
how to Activate Standby Database as Primary after Failover
14
Mar, 23
When it comes to database management, the ability to failover
Read More
Manual Reinstate old Primary Using Flashback
11
Mar, 23
In this article, we will learn how to reinstate old
Read More
How to reinstate the old Primary as a Standby after Failover in Oracle
5
Mar, 23
In this practice, we reinstate the old primary as a
Read More
Oracle Dataguard Switchover with broker
26
Feb, 23
To perform an Oracle Data Guard switchover with broker, you
Read More
How to setup Data Guard Broker Configuration
21
Feb, 23
Setting up Data Guard Broker Configuration involves the following steps.
Read More
Oracle 19c Dataguard setup with PDB
9
Feb, 23
Oracle 19c Dataguard setup with PDB, Dataguard is a disaster
Read More
Patching 19.3 to 19.16 step by step
15
Jan, 23
In this article, we are going to learn how to
Read More
ORA-16019: Cannot Use Db_recovery_file_dest With LOG_ARCHIVE_DEST Or LOG_ARCHIVE_DUPLEX_DEST
10
Jan, 23
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
Read More
oracle installation on susi
5
Jan, 23
load34 -RPMsstop firewall
Read More
AUTOMATICALLY KILL INACTIVE SESSIONS
19
Aug, 22
Hi, today we are going to create script which automatically
Read More
Upgrade Oracle 11g to 19c using AutoUpgrade utility
6
Aug, 22
Hi, in this article we are going to learn how
Read More
Check the Patch Applied to the Oracle Database
3
Aug, 22
In Oracle Database we have multiple ways to find Patch
Read More
Tablespace Utilization In Oracle Multitenant Database
17
Jun, 22
In this article, we will check tablespace utilization in CDB
Read More
Delete RMAN Backups
11
Jun, 22
In this article, we are going to learn how to
Read More
How to Configure Recovery Catalog
3
Jun, 22
In this article, we will learn how to configure the
Read More
HOW TO DOWN HIGH WATER MARK
20
May, 22
This article will learn how to reset the High Water
Read More
Why do we use FAL_SERVER and FAL_CLIENT parameters in Oracle dataguard
28
Apr, 22
In this article, we are going to understand why we
Read More
How to upgrade ORACLE 11G to 19C
23
Apr, 22
In this article, we are going to learn how to
Read More
How to Identify OS PID from SID in Oracle Database
6
Apr, 22
We want to find out OS PID against sid in
Read More
Change Archivelog mode and Destination In Oracle 19c
3
Apr, 22
In this article, we are going to learn how to
Read More
ORA-02019: connection description for remote database not found
1
Apr, 22
Hi, I'm facing this error "ORA-02019: connection description for remote
Read More
How to Recover lost datafile with no backup
1
Apr, 22
In this article, we are going to learn how to
Read More
Backup Oracle Database using RMAN
24
Mar, 22
In our previous post, we already discussed about the RMAN
Read More
Oracle RMAN Backup Types
24
Mar, 22
In this article, we are going to discuss oracle rman
Read More
How to Generate Execution Plan in Oracle
7
Mar, 22
Knowing how to generate an execution plan optimizer of the
Read More
ORA-12954: The request exceeds the maximum allowed database size of 12 GB
3
Mar, 22
In this article, we are going to solve ORA 12954
Read More
How to Change Archivelog Destination in Oracle
1
Mar, 22
In this article, we are going to learn how to
Read More
Rman full database backup script
24
Feb, 22
In this article, we are going to learn how to
Read More
crosscheck archivelog all
4
Feb, 22
In this article, we are going to learn, why we
Read More
How to find the long running queries in oracle
29
Jan, 22
Here we are going to learn how to find the
Read More
Oracle DataPump Performance Tuning
4
Jan, 22
In this article, we are going to learn datapump performance
Read More
ORA-19913 unable to decrypt backup
4
Jan, 22
Today we facing the ORA-19913 unable to decrypt backup error
Read More
How to Get DB Link DDL in oracle
26
Dec, 21
how to get ddl for db_link in oracle with password,
Read More
Check Oracle Database Growth per Month
26
Dec, 21
In this article, we are going to check oracle database
Read More
Data Pump Export Import Over the Network using network_link
26
Dec, 21
In this article, we going to learn how to use
Read More
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
25
Dec, 21
Sometimes, we face ORA-14452 during drop or alter. SO, in
Read More
Streams AQ: enqueue blocked on low memory Oracle wait event
23
Dec, 21
In this article, we are going to discuss the oracle
Read More
Global Temporary Tables
19
Dec, 21
Applications regularly utilize some type of impermanent information store for
Read More
Export Backup Automation in Oracle On Linux
16
Dec, 21
Hello, friends in this article we are going to learn
Read More
RMAN BACKUP SCRIPT
10
Dec, 21
How to automate Oracle RMAN Backup with shell script In
Read More
Oracle TDE implementation
4
Dec, 21
Oracle TDE implementationIn this article, we are going to learn
Read More
Crosscheck archive in rman
17
Nov, 21
Crosscheck Archivelog all Validation failed for archived logIn this article,
Read More
Oracle Instant Client Installation
2
Nov, 21
How do I install Oracle Client Installer? The Oracle Instant
Read More
Oracle Database 21c Installation On Oracle Linux 7 | Oracle 21c Download
18
Oct, 21
Install Oracle 21c LinuxIn this article, we are going to
Read More
Rename an Oracle Database schema?
15
Oct, 21
How do you Rename Oracle Database Schema?This is a very
Read More
How to Check Last Password Change History?
3
Oct, 21
In this article, we are going to learn how to
Read More
What are the control file and datafile in Oracle?
28
Sep, 21
What is control file and datafile in Oracle?In this article,
Read More
Managing the Oracle Database Flash Recovery Area
22
Sep, 21
How do I check flash recovery area?The flash recovery area
Read More
Useful Linux commands for DBA
22
Sep, 21
Linux/UNIX Commands For DBAsHere we learn some useful Linux commands
Read More
Queries to Monitor Expdp Datapump Jobs Status
16
Sep, 21
How do you monitor Expdp Impdp process?This article is all
Read More
How to kill Inactive sessions in ORACLE?
16
Sep, 21
Hi, In this article we are going to learn how
Read More
How to check Database size and tablespace Utilization?
14
Sep, 21
Checking the database size and tablespace utilization is an important
Read More
How to Delete old archives using ASMCMD?
14
Sep, 21
How do I delete old archive logs?Hi, in this article
Read More
How to Relocate Datafiles in Oracle?
12
Sep, 21
In this article, we are going to learn how to
Read More
Oracle 11g R2 Dataguard configuration step by step
12
Sep, 21
Oracle 11g R2 Dataguard configuration step by step, before starting
Read More
ORA-00054 resource busy and acquire with nowait
24
Aug, 21
The error ORA-00054 occurs if DDL or DML currently running
Read More
How to load data from CSV file into oracle using SQL Loader
21
Aug, 21
Load data from CSV file into oracleHi Friends, in this
Read More
Set newname RMAN script
25
Jul, 21
In this article, we are going to learn how to
Read More
Find redo log members, redo log file size and redo log status
21
Jun, 21
In this article, we will show you how to find
Read More
How to Reconfigure Oracle Restart
15
Jun, 21
Oracle Restart ConfigurationIn this article, we are going to reconfigure
Read More
ORA-19502 Solutions
12
Jun, 21
What is ora 19502?Today I'm just performing the database full
Read More
How to Configure OEM DBconsole Manually
29
May, 21
OEM DBconsole ManuallyThis tutorial is from oracle 11g, and we
Read More
How to drop oracle database manually
28
May, 21
How do I manually drop a database?In this article, we
Read More
TNS-00583: Valid Node Checking: Unable To Parse Configuration
26
May, 21
TNS-00583Actually, in today's session I am facing the error TNS-00583
Read More
ORA-00031: session marked for kill Solution
25
May, 21
In this tutorial, we will learn how to solve the
Read More
Oracle 19c Installation on OEL 7 step by step
3
May, 21
Hello Friends, in this article we are going to learn
Read More
How to install, configure, and use Statspack in Oracle
30
Apr, 21
Oracle StatspackHello guys, in this article we are going to
Read More
How to Rename Database Using Controlfile
29
Apr, 21
How do I change a database name in Controlfile?Hi Guys,
Read More
Creating Non CDB database in silent mode – ORACLE 19C
24
Apr, 21
In this example, we are using oracle 19c and going
Read More
How to Create Pluggable Database Oracle
22
Apr, 21
In this article, we are going to learn how to
Read More
How to set Oracle Pluggable Database Automatic startup
20
Apr, 21
As you know the pluggable database concept introduce in oracle
Read More
How to create ASM diskgroup
2
Apr, 21
In this article, we are going to learn how to
Read More
How to Export Tables using PARFILE STEP BY STEP
29
Mar, 21
Export Tables using PARFILE, Table export also known as the
Read More
ORA-01244: unnamed datafile(s) added to control file by media recovery
29
Mar, 21
Hi friends, in this article we are going to solve
Read More
Load oracleasm module
26
Mar, 21
In this article we are going to learn how to
Read More
Estimate Required Disk Space for Export Using Estimate_only
24
Mar, 21
In Data Pump EXPDP command use estimate only, to check
Read More
ORA-01654: unable to extend index solution
6
Mar, 21
Hi guys, I'm getting an "ora-01654 unable to extend index"
Read More
How to Rename Oracle Database using NID
5
Mar, 21
How do I change my NID database name?Hello friends, in
Read More
ORA-12919: Can not drop the default permanent tablespace
17
Jan, 21
Hi, Today I am getting the “ORA-12919: Can not drop
Read More
How To Export Tablespace Using Expdp Data Pump Utility?
16
Jan, 21
Export Tablespace Using ExpdpHi, In this article we are going
Read More
SQL Character Function
6
Jan, 21
What is Character FunctionsHello, friends in this article we are
Read More
Single Row Functions
4
Jan, 21
Single row functions operate on a single row only then
Read More
How to create a SEQUENCE step by step
4
Jan, 21
In this article, we are going to learn how to
Read More
Alter table drop column Oracle
4
Jan, 21
Hello friends, In this article, we are going to discuss,
Read More
How To Find CPU And Memory Information Of Oracle Database Server
2
Jan, 21
Hello friends, In this article, we are going to find
Read More
How To Find Execution History Of An sql_id
2
Jan, 21
Hello friends, in this article I'm going to show you
Read More
ORA 25153 Temporary Tablespace is Empty
2
Jan, 21
Here is the solution of ORA 25153.If you faced the
Read More
How To Get Tablespace Quota Details Of An User In Oracle
2
Jan, 21
In this article, we are going to show you how
Read More
How To Get Ddl Of All Tablespaces In Oracle
1
Jan, 21
Hello Friends, In this article we are going to show
Read More
How to Recover Controlfile without Backup?
28
Dec, 20
Recover Controlfile without BackupHello Friends, In this article we are
Read More
How to create DB Link?
18
Dec, 20
In this article, I’m going to show you how to
Read More
What is SQL, DBMS, and RDBMS
17
Dec, 20
What is SQL, DBMS and RDBMSHello friends, in this article
Read More
Using SQL Select Statements
17
Dec, 20
How to use SQL select statement?In this article, we are
Read More
How to Install ORACLE 12c R1 on ORACLE Linux 7 step by step
10
Dec, 20
In this post, I’m going to demonstrate to you how
Read More
How to Restore RMAN Backup with a Different Database Name
10
Dec, 20
Hello friends, in this article I’m going to demonstrate to
Read More
How to Partitioning in existing table using EXCHANGE PARTITION
10
Dec, 20
Partitioning in existing tableHello, friends in this article we are
Read More
Transport Tablespace from Linux to Windows in ORACLE 11g & 10g
10
Dec, 20
Transport tablespace from Linux to windows platform step by stepIn
Read More
1
2
Next
Scroll to Top