Why do we use FAL_SERVER and FAL_CLIENT parameters in Oracle dataguard

FAL_SERVER and FAL_CLIENT

In this article, we are going to understand why we use FAL_SERVER and FAL_CLIENT parameters in the Oracle dataguard environment. FAL full form is “fetch archive log“. The FAL is an oracle data guard environment parameter. With the name, you can clearly understand it fetched the archive logs for the standby database from the primary … Read more

How to upgrade ORACLE 11G to 19C

Upgrade oracle 11g to 19c

In this article, we are going to learn how to upgrade the oracle 11g to 19c database on the Linux platform step by step. My Environment for this practice Prerequisites: Before starting the upgrade make sure you have done the below checklist: Stop the Listener Take full database backup using RMAN Purge Recycblebin Gather Dictionary … Read more

How to Identify OS PID from SID in Oracle Database

Identify OS PID from SID

We want to find out OS PID against sid in the Oracle database to check the performance related to OS and Database. In the Linux platform, every process has its process ID (PID) and a user can easily get PID from SID (Identify OS PID from SID). Query to check PID from sid in Oracle … Read more

Change Archivelog mode and Destination In Oracle 19c

Change Archivelog mode and Destination

In this article, we are going to learn how to change archivelog mode and destination in oracle 19c. Start Change Archivelog mode and Destination Step 1: Check Archive log mode Status Check current archive log mode status in oracle 19c. As we checked our database running in no archive mode. Step 2: Create the Archive … Read more

ORA-02019: connection description for remote database not found

Hi, I’m facing this error “ORA-02019: connection description for remote database not found” during making a connection with the DB link. ORA-02019 This could be happening because of the wrong DB link name or a TNS entry missing of the remote database. In my case my DB link name is xdb_link. Find DB Link Using … Read more

How to Recover lost datafile with no backup

Recover lost datafile with no backup

In this article, we are going to learn how to recover lost datafile with no backup. Suppose expediently you lost a datafile at the OS level and there is no current backup available. But the best point is that you are in archivelog mode and you have all archive logs available since the datafile was … Read more

Backup Oracle Database using RMAN

Backup Oracle Database using RMAN

In our previous post, we already discussed about the RMAN utility and oracle database backup types. In this article, we are going to discuss RMAN utility configuration and create a backup oracle database using RMAN. RMAN backup configuration Before we can take the backup, we need to set up certain RMAN parameters. For instance, for the … Read more

Oracle RMAN Backup Types

rman backup type

In this article, we are going to discuss oracle rman backup types. As you know RMAN is a utility of oracle database which is used to take Database backup. The RMAN backup is two types: Full Backup Incremental Backup Full RMAN backup A complete backup differs from a full database backup. A full backup of the … Read more

How to access Ubuntu server using putty from windows?

access ubuntu server using putty

In this article, we are going to learn how to access Ubuntu Linux from Windows using putty step by step. To access ubuntu or any Linux server through putty we required the server IP address and ssh services must be enabled, also you must be able to ping the server from your windows server. Access … Read more

How to Generate Execution Plan in Oracle

Generate Execution Plan

Knowing how to generate an execution plan optimizer of the SQL statement is an important part of optimizing SQL performance. There are many methods for generating an execution plan. The best option that suits you should be your tuning tool. Execution plan with autotrace When you want to display the SQL execution plan and don’t … Read more

ORA-12954: The request exceeds the maximum allowed database size of 12 GB

ora 12954

In this article, we are going to solve ORA 12954 the request exceeds the maximum allowed database size of 12 GB. The above error comes because of oracle XE (Express Edition), we faced this error in the oracle 18c XE PDB database. Steps to solve ORA 12954 In that case, don’t have only two choices … Read more

How to Change Archivelog Destination in Oracle

Change Archive Log Destination

In this article, we are going to learn how to change archive log destination in the oracle database production (LIVE) environment step by step. Sometimes we face disk space issues in the production environment due to high archive generation. So, here we are going to discuss how to change the archive destination in a standalone … Read more

Rman full database backup script

rman full database backup script

In this article, we are going to learn how to create rman full database backup script step by step. RMAN (Recovery Manager) is a popular tool to create Oracle Database backups. Using RMAN we can create two types of backups listed below. Full Database Backup Incremental Database Backup So, here we are going to learn … Read more

crosscheck archivelog all

crosscheck archivelog all

In this article, we are going to learn, why we need to run crosscheck archivelog all commands. You must read this article carefully and follow all steps. Why we run crosscheck archivelog all? Rman utility is a very powerful utility that is used for creating Oracle Database backup. The crosscheck command only verifies the existence … Read more

How to find the long running queries in oracle

How to find the long running queries in oracle

Here we are going to learn how to find the long running queries in oracle, sometimes the query takes time to complete. Oracle has a view v$session_longops which is used to tracke these kinds of queries. The view shows the details about the work has donned in percentage, the pending percentage also and sofar completed, … Read more

Oracle DataPump Performance Tuning

DataPump-Performance-Tuning

In this article, we are going to learn datapump performance tuning. The Datapump is a tool that helps us to create a database backup. There are a few ways to increase export backup performance listed below: DIRECT=Y PARALLEL=n DIRECT=Y During export backup, if we use direct=y, it’s allowed to skip the SQL evaluation buffer. Though … Read more

ORA-19913 unable to decrypt backup

ORA-19913 unable to decrypt backup

Today we facing the ORA-19913 unable to decrypt backup error during RMAN backup restoration. After troubleshooting we found, this backup belonged to the encryption-enabled database and there is a wallet also configured. while backup restoration, open database in nomount state then check wallet status, it is showing closed. SQL> select status from v$encryption_wallet; STATUS ————– … Read more

Data Pump Export Import Over the Network using network_link

datapump network_link

In this article, we going to learn how to use the network_link parameter in oracle datapump export & import activity step by step. Case: Sometimes we need to move a table or schema from one database to another database but don’t have sufficient disk space on the production server. As you know the dump file … Read more

Check Oracle Database Growth per Month

Oracle Database Growth

In this article, we are going to check oracle database growth per month. Here we have to script one is for complete database growth and another one is to check growth as per tablespace level. Oracle Database Growth per month script Using the below query you can find out the per month database growth. SQL> … Read more

ORA-14452: attempt to create, alter or drop an index on temporary table already in use

ORA-14452

Sometimes, we face ORA-14452 during drop or alter. SO, in this article, we are going to learn how to solve “ORA-14452: attempt to create” this error. We face this issue if the table is currently used in any other session, and we trying to drop or alter the table. Find Session Details Let’s find in … Read more

Streams AQ: enqueue blocked on low memory Oracle wait event

Streams AQ: enqueue blocked

In this article, we are going to discuss the oracle wait event “Streams AQ: enqueue blocked on low memory” due to this wait event we are facing a performance issue in the export backup, today my export backup was in a hung state and it takes a very long time. ideally, the export backup was … Read more

Global Temporary Tables

Global Temporary Tables

Applications regularly utilize some type of impermanent information store for processes that are too convoluted to finish in a solitary pass. Regularly, these transitory stores are characterized as data set tables or PL/SQL tables. From Oracle 8i ahead, the upkeep and the board of transitory tables can be assigned to the waiter by utilizing Global … Read more

Export Backup Automation in Oracle On Linux

export backup automation

Hello, friends in this article we are going to learn how to schedule database export backup automatically. Yes, it is possible to export backup automation with a crontab scheduler. How to schedule Export Backup Using shell scripting, we can schedule the export backup as per our convenient time. Using the following steps we can schedule … Read more

RMAN BACKUP SCRIPT

RMAN BACKUP SCRIPT

How to automate Oracle RMAN Backup with shell script In a real environment, you obviously won’t manually trigger all of the Oracle database backups. An automated mechanism is required to enable RMAN backups. In this article, we’ll look at automating RMAN backup using a shell script. Create Backup Location On your database server, create a … Read more

Oracle TDE implementation

Oracle TDE implementation

Oracle TDE implementation In this article, we are going to learn about Oracle TDE implementation. The TDE full form is transparent data encryption. What is TDE implementation? Which is used to encrypt the sensitive data at table level and tablespace level also. Once TDE is configured on the data, only the authorized users can access … Read more

Crosscheck archive in rman

validation failed for archived

Crosscheck Archivelog all Validation failed for archived log In this article, we are going to learn how to perform crosscheck for archives in the oracle database step by step. Validation failed for archived solution. validation failed Sometimes we face the error validation failed message during rman backup. Actually, we face the error because someone deletes … Read more

Oracle Instant Client Installation

How do I install Oracle Client Installer? The Oracle Instant Client is lightweight software, Which is freely distributable implementation. The advantage of the Oracle Instant Client is it does not need a formal installation. Instead, just unzip the instant client software and used it without any fuss. How to install Oracle instant Client step-by-step guide. … Read more

Oracle Database 21c Installation On Oracle Linux 7 | Oracle 21c Download

21c installation

Install Oracle 21c Linux In this article, we are going to learn oracle 21c installation on the Linux platform step by step. What is Oracle Database 21c? Oracle 21c is the latest release of Oracle database software, if you want to read more about click here. Can I download Oracle for free? Yes, You can … Read more

Rename an Oracle Database schema?

rename a database schema

How do you Rename Oracle Database Schema? This is a very common question to every oracle dba person and sometimes we need to rename a database schema. So, in this article, we are going to learn how to change schema names in oracle step by step. Read: How to Rename Database Using Controlfile Can we … Read more

How to Check Last Password Change History?

Last Password Change in Oracle

In this article, we are going to learn how to check past password change history in the oracle database. Using the below commands you can check the password change history step by step. Read: What is control file and datafile in Oracle? When was my Oracle password last changed? The below query will show you … Read more

What are the control file and datafile in Oracle?

What is control file and datafile in Oracle?

What is control file and datafile in Oracle? In this article, we are going to learn what is control files and datafiles in Oracle. In the Oracle database environment, each and every database has its own separate control files. The control files also called binary files which record the physical structure of the oracle database. … Read more

Managing the Oracle Database Flash Recovery Area

Flash Recovery Area

How do I check flash recovery area? The flash recovery area or FRA in the oracle database is a location on the disk where the oracle database stores the backup files and archive files. Read: How to Add New Disk in ASM instance? How to configure FRA size Before starting configuration you must decide on … Read more

Useful Linux commands for DBA

Linux/UNIX Commands For DBAs Here we learn some useful Linux commands for dba. Read: How to add SWAP Space in Linux Useful Linux commands for an Oracle DBA 1. PWD: show the present working directory. 2. ls: list all files and directories from a given location, if the location is not given it shows the … Read more

Queries to Monitor Expdp Datapump Jobs Status

monitor expdp datapump jobs

How do you monitor Expdp Impdp process? This article is all about monitoring oracle DataPump jobs, checking expdp or impdp jobs status, killing running jobs,troubleshoot hang jobs, etc. Here you will get different queries, which you can use to start, stop, resume, kill and see the status of data pump jobs. So, let’s monitor the … Read more

How to kill Inactive sessions in ORACLE?

kill Inactive sessions

Hi, In this article we are going to learn how to kill inactive sessions. Sometimes there are so many inactive sessions available in the database. Due to these inactive sessions our database response a little slowly. So we need to kill them using the below steps. Read: How to create a database link Subscribe on YouTube … Read more

How to check Database size and tablespace Utilization?

Database size and tablespace Utilization

Database size and tablespace Utilization? In this article, we are going to check full database size, used size, and free space in the database as well as check the tablespace utilization details. Read: Find redo log members, redo log file size and redo log status Subscribe on YouTube Step 1. To check Database total space. … Read more

How to Delete old archives using ASMCMD?

Delete old archives using ASMCMD

How do I delete old archive logs? Hi, in this article we are going to learn how to delete old archives using asmcmd. ASMCMD will work only in the case of the ASM environment. Read: How to create ASM diskgroup Subscribe to us on YouTube So, before deleting the archives in the ASM environment we … Read more

How to Relocate Datafiles in Oracle?

Relocate Datafiles in Oracle

In this article, we are going to learn how to Relocate Datafiles in Oracle from one mount point to another mount point or disk. In other words, you can say that due to insufficient disk space we need to move data files to a different location. Read: How to drop oracle database manually Subscribe on … Read more

Oracle 11g R2 Dataguard configuration step by step

Oracle 11g R2 Dataguard configuration

data guard configuration steps in oracle 11gr2 Oracle 11g R2 Dataguard configuration step by step, before starting DG configuration you must read the below note. Subscribe on YouTube Oracle Database RDBMS software installed with one database on the PRIMARY server and on STANDBY server installed only RDBMS software without any Database. PRIMARY STANDBY IP Address: 192.168.1.10 IP Address: 192.168.1.20 … Read more

ORA-00054 resource busy and acquire with nowait

ORA-00054 resource busy and acquire with nowait

The error ORA-00054 occurs if DDL or DML currently running without commits on the target table. The ORA-00054 mostly occurs in sessions that try to change table data or the structure of a table. Read: ORA-00031: session marked for kill Solution You can get the information about the locks using the below lists views: DBA_BLOCKERS: … Read more

How to load data from CSV file into oracle using SQL Loader

load data from CSV file into oracle using sql loader

Load data from CSV file into oracle Hi Friends, in this article, we will load data from the CSV file into oracle using SQL loader. SQL Loader is a tool which is providing by oracle. Read: How to create a SEQUENCE step by step What is SQL Loader? SQL Loader helps us to load data … Read more

Set newname RMAN script

Set newname RMAN script

RMAN script In this article, we are going to learn how to create a rman restoration script with a set newname parameter. If you try to restore the database on another server using RMAN and the directory structure is different, you can use the below query for restoration. Step 1. Check datafile location on the … Read more

Find redo log members, redo log file size and redo log status

Find redo log

In this article, we will show you how to find redo log members, redo log file size, and redo log status using some simple commands. How do you find the redo log? You can subscribe to my YouTube Channel Click Here Step 1. Find redo log file members and group details. Output from the above … Read more

How to Reconfigure Oracle Restart

RECONFIGURE ORACLE RESTART

Oracle Restart Configuration In this article, we are going to reconfigure the oracle restart step by step. Why do we need to reconfigure the oracle restart? Actually, in my organization, they rename the server name, if the server is renamed and rebooted the ASM instance failed to show error ORA-29701 unable to connect to cluster … Read more

ORA-19502 Solutions

ORA-19502

What is ora 19502? Today I’m just performing the database full backup and suddenly I’m facing an ORA-19502 error message. I didn’t understand why this error came because I did not see any ora error in the alert file. I’m suffering on google but didn’t get any solution then I just checked my mount points … Read more

How to Configure OEM DBconsole Manually

OEM DBconsole Manually

OEM DBconsole Manually This tutorial is from oracle 11g, and we are going to learn how to configure OEM dbconsole manually on the Linux platform. If you have previously configured the OEM console but it is not working then we need to drop the existing configuration and recreate the OEM repository, start configuration using the … Read more

How to drop oracle database manually

DROP ORACLE DATABASE MANUALLY

How do I manually drop a database? In this article, we are going to learn how to drop the oracle database manually step by step. Perform these steps in UAT first don’t perform on the production database server. How to Create Pluggable Database Oracle How do I drop an entire database? Prerequisites Before taking any … Read more

TNS-00583: Valid Node Checking: Unable To Parse Configuration

ORA 00583

TNS-00583 Actually, in today’s session I am facing the error TNS-00583 Valid Node Checking first time in my career, and unable to find the proper solution. Then I’m suffering on Google and found one solution on oracle support which I am going to discuss with you. Doc-id 1680353.1 ORA-00031: session marked for kill Solution I … Read more

ORA-00031: session marked for kill Solution

ORA-00031

In this tutorial, we will learn how to solve the ORA-00031 session marked for kill error. How do you resolve ORA 00031? Step 1. Login in Database with administrator (sys) user and find spid to kill at os level. If you have the user details which find the details as per user name using the … Read more

Oracle 19c Installation on OEL 7 step by step

ORACLE 19C INSTALLATION ON LINUX

Hello Friends, in this article we are going to learn how to install oracle 19c on OEL 7) step by step. In this installation, we use the oracle-database-preinstall-19c package. Creating Non-CDB database in silent mode – ORACLE 19C OS Version OS version which we are going to use in this article. Prerequisite for Oracle 19c … Read more

How to install, configure, and use Statspack in Oracle

Statspack in Oracle

Oracle Statspack Hello guys, in this article we are going to learn how to install, configure and use statspack in oracle. In this activity, I’m going to use the Oracle 12c environment. Introduction to Statspack If the DB server running very slow, then we need to perform DB tuning and it is very important to … Read more

How to Rename Database Using Controlfile

How to Rename Database Using Controlfile

How do I change a database name in Controlfile? Hi Guys, in this article we are going to learn how to rename a database using controlfile. Actually, we have two ways to rename the oracle database listed below. Rename Database using controlfile. Rename Database using NID utility. So, here I’m going to us first one … Read more

Creating Non CDB database in silent mode – ORACLE 19C

Creating Non CDB database in silent mode

In this example, we are using oracle 19c and going to learn how to Creating Non-CDB database in silent mode. As you know, we can also create a database using the DBCA utility but in some cases, we don’t have access to the GUI. So here we will learn silent mode database creation step by … Read more

How to Create Pluggable Database Oracle

Create Pluggable Database Oracle

In this article, we are going to learn how to create pluggable database Oracle in oracle 12c or 19c. Here I’m going to create a pluggable database using PDB seed (PDB$SEED). How to set Oracle Pluggable Database Automatic startup Create Pluggable Database Step 1. Check current database details with existing pdbs. In my case the … Read more

How to set Oracle Pluggable Database Automatic startup

Pluggable Database Automatic startup

As you know the pluggable database concept introduce in oracle 12c and when we startup the CDB database the PDBs (Pluggable Database) will be mount stage. So that time we need to open PDBs manually using alter command. Here we are going to learn how to Oracle Pluggable Database Automatic startup step by step. To … Read more

How to create ASM diskgroup

create diskgroup asm

In this article, we are going to learn how to create an ASM diskgroup, so here I’m going to show you the complete steps to creating ASM devices and then the ASM disk group. To create ASM diskgroups you can use asmca (Oracle ASM Configuration Assistant) which is providing a GUI interface. But in this … Read more

How to Export Tables using PARFILE STEP BY STEP

Export Tables using PARFILE, Table export also known as the table level export in oracle data pump utility. DBA take table level export using expdp data pump command. Oracle DBA perform export import task as per there requirements. Export backup also called as logical backup. The export backup we can perform as table level, schema … Read more

ORA-01244: unnamed datafile(s) added to control file by media recovery

ORA-01244

Hi friends, in this article we are going to solve the ORA-01244 error, that you will be facing during manual database recovery. ORA-01244 unnamed datafiles added to control file by media recovery Cause: Actually that error most of the time you will face during the recovery, due to the datafile entry is not in the … Read more

Load oracleasm module

loading module oracleasm failed

In this article we are going to learn how to load oracleasm module or solve if oracleasm not mounted. Some time we face loading module oracleasm failed error. During creating the ASM disk we are facing the below error Read: Oracle Database Migration from Non-ASM to ASM oracleasm module not loaded or /dev/oracleasm not mounted. … Read more

Estimate Required Disk Space for Export Using Estimate_only

EXPDP Estimate only

In Data Pump EXPDP command use estimate only, to check the estimate the disk space required for the export backup job without performing real export backup. Before creating the export dump it’s better to check dump size using estimate_only. For example we are going to take demo of scott user. EXPDP Estimate only Step 1. … Read more

How to Rename Oracle Database using NID

RENAME DATABASE USING NID

How do I change my NID database name? Hello friends, in this article we are going to learn how to rename a database using the NID utility step by step. So in this demo, we are going to rename the db11g database name to ocptech. Before the NID utility, we can rename the database using … Read more

How to add SWAP Space in Linux

add swap space in linux

Sometimes we need to add extra swaps to our Linux machine, so in this article, I’m going to show you how to add swap space. We have two ways to add swap in the Linux environment. Create swap space using the file. Use Hard disk to adding swap space. Check existing swap details using the … Read more

ORA-12919: Can not drop the default permanent tablespace

ORA-12919 Can not drop the default permanent tablespace

Hi, Today I am getting the “ORA-12919: Can not drop the default permanent tablespace” error. Actually, I tried to drop users tablespace which is the default tablespace for the database user and I’m getting the above error. ORA-12919 Can not drop the default permanent tablespace Cause – We tried to drop default tablespace. Action – … Read more

How To Export Tablespace Using Expdp Data Pump Utility?

How To Export Tablespaces Using Expdp Data Pump Utility

Export Tablespace Using Expdp Hi, In this article we are going to learn how to export tablespaces using expdp data pump utility practically. What is tablespace? A tablespace is a logical unit of storage that is used by the database to store database objects like tables and PL/SQL codes. We can export tablespaces using the … Read more

SQL Character Function

Character Functions in SQL

What is Character Functions Hello, friends in this article we are going to discuss how to use Character Functions in SQL. The character functions accept only Character type values and return in character and number both. Type of Character Functions There are Eight types of Character Functions in SQL. CONCAT SUBSTR LENGTH INSTR LPAD RPAD … Read more

Single Row Functions

Single Row Functions

Single row functions operate on a single row only then return one result for each row, there are many types of single-row functions. Following are the types of Single Row Functions. Number Function. Date Function. Character Function. Conversion Function. General Function. Number Function Always accept only numeric values and also return always numeric values. Number Function … Read more

How to create a SEQUENCE step by step

How to create a SEQUENCE step by step

In this article, we are going to learn how to create and use SEQUENCE. What is SEQUENCE? SEQUENCE is an oracle shareable object which is generated numeric values and it can be unique. you can use this value as a primary key and unique value. Let see how to create SEQUENCE and how to use sequence step by step. How to … Read more

Alter table drop column Oracle

alter table modify column oracle example

Hello friends, In this article, we are going to discuss, how to use the ALTER TABLE ORACLE MODIFY column. Using this command we can modify table structure if required after table creation. Alter Table Oracle Modify In this practical, we are using the following table which has three columns. Modify Column Suppose, I want to … Read more

How To Find CPU And Memory Information Of Oracle Database Server

Hello friends, In this article, we are going to find CPU and memory information of the oracle database server. How do I find CPU and memory information in Linux? The below script will help us to get CPU, memory and core, socket information of an Oracle database server from SQL prompt. How do I check … Read more

How To Find Execution History Of An sql_id

Hello friends, in this article I’m going to show you how to find execution history of an sql_id. The below script will display the execution history of a sql_id from AWR. It will join the dba_hist_sqlstat and dba_hist_sqlsnapshot table to get the required information. Read: ORA 25153 Temporary Tablespace is Empty

ORA 25153 Temporary Tablespace is Empty

ORA 2515

Here is the solution of ORA 25153. If you faced the above error just add more space in the temporary tablespace or add a new tempfile in the temporary tablespace. How to check temporary tablespace in oracle Check the temporary tablespace size using the below query. Or you can use following query. Change the the … Read more

How To Get Tablespace Quota Details Of An User In Oracle

Get Tablespace Quota Details Of An User In Oracle

In this article, we are going to show you how to get tablespace quota details of a user in oracle. What is tablespace quota in Oracle? In the Oracle database when we set the quota for a user, that means we set the limit of data storage for particular schemas objects in the specified tablespace. … Read more

How To Get Ddl Of All Tablespaces In Oracle

How To Get Ddl Of All Tablespaces In Oracle

Hello Friends, In this article we are going to show you how to get ddl of all tablespaces in oracle. Get DDL of All Tablespaces Oracle Use below query to get ddl of all tablespaces in oracle. If you really like this article, please subscribe my YouTube channel. Read – How to Recover Controlfile without … Read more

How to Recover Controlfile without Backup?

recover controlfile without backup

Recover Controlfile without Backup Hello Friends, In this article we are going to discuss how to recover our controlfile without backup. Suppose if your controlfile is deleted accidentally and you don’t have any backup then what is the way to recover them. How do you recover a lost control file? So here you can find … Read more

Install JAVA on Linux

Install JAVA on Linux

How to Install JAVA 8 on Linux using the compiled source code? In this article, I’m going to show you how to install java 8 using the compiled source code on Redhat Linux, CentOS, and Fedora also the same steps. Step 1. Extract the zip file Extract downloaded source code inside the /opt/ directory using the following … Read more

What is MySQL?

What is MySQL

What is MySQL, My is the daughter’s name of MySQL’s co-founder, Monty Widenius. The name of My/SQL is the combination of My and SQL, MySQL. What is mysql database MySQL is a DBMS (database management system) that allows you to manage RDBMS (relational databases). My/SQL is open-source Database software backed by Oracle. It means you can use My/SQL without paying … Read more

How to install Mysql Database Server on Redhat Linux

install Mysql Database

How install MySQL server in Linux? In this article, I’m going to show you how to Install MySQL Database Server step by step on Redhat Linux. For the MySQL database installation, we have required MySQL rpm files. You can find out these rpm files from your OS CD or from your YUM repository. If the … Read more

How do I add a new hard drive to Linux?

How to add new hard drive in Linux

In this article, I’m going to show you how to add a new hard drive to a Linux environment. Start to Add New hard drive to the Linux platform. Environment In this tutorial, I’m using a VMware environment. And my machine has a 40 GB disk, as you can see below the screenshot. Add new Hard Disk Now … Read more

How to create DB Link?

create db link

In this article, I’m going to show you how to create a DB Link step by step. How to create a database link, A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access … Read more

What is SQL, DBMS, and RDBMS

What is SQL DBMS and RDBMS

What is SQL, DBMS and RDBMS Hello friends, in this article we going to discuss what is SQL ( Structured Query Language), DBMS (Database Management System), and RDBMS (Relational Database Management System), also understand what is the difference between DBMS and RDBMS. What is SQL? SQL (Structured Query Language) is used for Data Manipulation and … Read more

Using SQL Select Statements

use SQL select statement

How to use SQL select statement? In this article, we are going to learn how to use SQL select statement to retrieve data from tables or views. In the database, data stored in tables format and if you want to check that data then you should know how to use Oracle SQL statements. Important points for … Read more

How to Schedule automatic tasks to Shutdown or Restart PC?

Schedule automatic tasks

Schedule automatic task to Shutdown or Restart PC Hello Friends in this article I’m going to discuss with you how to schedule automatic tasks on your PC so let’s start. Click on the start button and search task scheduler or press window + r then type taskschd.msc then hit enter, then click on create a basic task in the … Read more

5 Major Interview Mistakes You Should Avoid

5 Major Interview Mistakes You Should Avoid

Do you have an upcoming interview to prepare for? If so, it is likely that you also suffer from the pre-interview jitters. The best way to counter interview-related anxiety is to prepare, prepare, prepare. Of course, it goes without saying that you should practice for your interview performance, but one area you need to pay … Read more

How to Install ORACLE 12c R1 on ORACLE Linux 7 step by step

How to Install ORACLE 12c R1 on ORACLE Linux 7 step by step

In this post, I’m going to demonstrate to you how to install ORACLE 12c Release 1 (12.1) on ORACLE LINUX-7 64 bit step by step. For ORACLE 12c  installation minimum 2GB swap is required. Download ORACLE 12c R1 software from www.oracle.com accept OTN License Agreement, it’s downloaded in two parts and it’s a zip file. Start Oracle … Read more

How to Restore RMAN Backup with a Different Database Name

How to Restore RMAN Backup with a Different Database Name

Hello friends, in this article I’m going to demonstrate to you Restore RMAN Backup with a Different Database Name on New Server step-by-step guide. Restore oracle database from rman backup to another server Steps to Clone database to different DB name use RMAN Full or Level 0 Database RMAN backup. Controlfile backup. spfile backup. Password … Read more

How to Partitioning in existing table using EXCHANGE PARTITION

How to Partitioning in existing table using EXCHANGE PARTITION

Partitioning in existing table Hello, friends in this article we are going to disuse how to partition the existing table using EXCHANGE PARTITION. If you want to learn more about partition click here. In this article, we are going to perform the below actions. Create a sample table and insert some records in this table. … Read more

Transport Tablespace from Linux to Windows in ORACLE 11g & 10g

Transport Tablespace from Linux to Windows in ORACLE 11g & 10

Transport tablespace from Linux to windows platform step by step In this tutorial, I’m going to show you how Transport tablespace from Linux to windows platform, in oracle Database we can transport tablespace and Database from one platform to another platform. In this topic, I’m using Redhat Linux 6 (64 bit) and Microsoft Windows 7 … Read more

How to Transport Database from Linux to windows?

How to Transport Database from Linux to windows

Transport Database from Linux to Windows Hello, friends in this article we are going to discuss How to Transport Database from Linux to windows. Transportable Database (TDB) requires all the datafiles format must be converted to the targeted platform format. How Migrate Database from Linux to windows? During TDB, the datafiles conversion can take place one … Read more

How to Convert the NON-CDB database to CDB

How to Convert the NON-CDB database to CDB

In this article, I’m going to show you how to convert a NON-CDB database into cdb database. Convert non-container database to multitenant pluggable database with Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit. Run the following commands on both machines. Output from Non-CDB database Output from CDB database Output from CDB database Run the … Read more

How to Uninstall Oracle 18c from Windows

How to Uninstall Oracle 18c from Windows

Uninstall Oracle 18c? Dear friends if you using the windows platform for the Oracle database so I think you know that very well this is not an easy task to uninstall oracle software like other software. In this tutorial, we are going to learn how to uninstall oracle 18c from windows manually. Steps to Remove … Read more

How to Install Oracle 18c on Windows?

How to Install Oracle 18c on Windows

How to Install Oracle 18c on Windows? Oracle Database 18c is available for Linux and Microsoft Windows and in this article we are going to discuss how to install oracle 18c on windows. Minimum hardware requirements for Oracle 18c These are the minimum hardware requirements for oracle 18c installation. 2GB RAM 10GB Free space on your … Read more

How to upgrade 11g to 19c manually?

How to upgrade 11g to 19c manually

In this article, we are going to discuss how to upgrade Oracle 11g (11.2.0.4) to 19c (19.2.0.0) manually. Follow me step by step carefully. Start to upgrade 11g to 19c manually Source Environment About Source Details OS Details Redhat Linux 7.6 (64 bit) Oracle Database version 11.2.0.4 Database Name OCP ORACLE_HOME path /u01/app/oracle/product/11.2.0.4/dbhome_1 Target Environment … Read more

How to Change password without showing the actual password on screen?

How to Change password without showing the actual password on screen

Hello friends, today we are going to discuss how to change the oracle user password without showing the actual PASSWORD on the screen. There is two way one is with ALTER command another one is PASSWORD keyword. But in the case of alter command, the password will show on screen, and in the case of PASSWORD, the keyword did not. In my case, … Read more

19c data guard new features

data guard new features

Hello friends, in this article I’m going to discuss here oracle Oracle 19c Data Guard concepts. The changes in Oracle 19c Data Guard concepts and administration are listed below The process of flashback a physical standby to a point-in-time that was captured on the production (primary) is simplified by automatically replicating restore points from production … Read more

Oracle 19c Active Data Guard-DML Redirection

Oracle 19c Active Data Guard-DML Redirection

DataGuard DML Redirection Hello friends, in this article we are going to discuss the oracle 19c DML Redirection feature with DataGuard. ACTIVE DATAGUARD DML REDIRECTION is a new feature in Oracle 19c which enables the Data Manipulation Language (DML) operations on the standby server to be redirected and run on the production (Primary) database. The updated data will … Read more

Display all the tables with foreign key

Display all the tables with foreign key

Hello, friends in this article we are going to discuss how to display all the tables in a schema with foreign key relations and the number of records for the parent and the child tables. How do I see all foreign keys to a table or column? The following query will solve our problem, execute … Read more

Oracle 19c Data Guard Configuration step by step

Oracle 19c Data Guard Configuration

Hello friends in this article, we going to discuss Oracle 19c Data Guard Configuration step by step. Oracle Data Guard is a high availability model which prevents downtime and data loss by using redundant systems and software to eliminate single points of failure. Our Environment for this practice Primary Environment DB_NAME OCP DB_UNIQUE_NAME OCP IP … Read more