Every Oracle system has an “/etc/oratab” file, which is created after Oracle installation by the Root.sh script. This file contains entries for every database on the system. “Setup Oracle to Startup Automatically if the System is Restarted” To complete this process, you need to log in with the root user. Setup Oracle to Startup Automatically … Read more
In this article, we will explore how to check the last analyzed date of tables and indexes in Oracle, or in other words, how to determine when the statistics were last gathered. “check last gather stats in oracle”. Check last gather stats in oracle Here are the complete steps to retrieve the latest statistics gathering … Read more
In this document, we will learn what is RMAN and how to take Oracle Database Backup – “Oracle RMAN tutorial”. What is Oracle RMAN used for? RMAN, or Recovery Manager, is a tool created by Oracle to handle backup and recovery tasks within Oracle databases. It simplifies processes such as data file backups, control file … Read more
In this article, we will learn how to install Linux in Oracle VirtualBox step by step. We are demonstrating Oracle Linux 8.4 installation here, the steps are almost the same for Redhat Linux/Centos, etc. Required Softwares Step 1: Create a Virtual Machine Open VirtualBox software and create a new virtual machine first. Name: Enter your … Read more
During Oracle 11.2.0.4 installation we facing the following message “error in invoking target agent nmhs of makefile“. Don’t worry about it just follow the below steps and you will resolve it succesfully. How to solve error in invoking target agent nmhs of makefile Don’t click on Abort or Continue, to solve error in invoking target … Read more
In Oracle, the RECYCLEBIN feature by default is enabled. To protect eccidentally dropped tables. “purge recyclebin in oracle”. Oracle scripts. Other commands to purge recyclebin in oracle Here are the more commands to check RECYCLEBIN, Check recycle-bin from SYSDBA account Check Current session RECYCLEBIN Purges recyclebin from current session Using the below commands we can … Read more
To get the tablespace DDL (Data Definition Language) in Oracle, you can use the DBMS_METADATA package. “tablespace DDL in oracle” Get DDL for specific tablespace Step 1: To get tablespace ddl in oracle first connect to your Oracle database using a tool such as SQL*Plus or SQL Developer. Step 2: Execute the following SQL statement … Read more
In Oracle, a tablespace is a logical storage container that can hold one or more database objects, such as tables, indexes, and other schema objects. The following is an example of a Data Definition Language (DDL) create tablespace in Oracle. Statement to create tablespace in Oracle Let’s go through each component of this create a … Read more
In this article we are going to learn how to performe switchover steps in Oracle Data Guard environment. Here we performing manual switchover activity. So, follow me carefully. “Switchover steps in Oracle 12c”,”Oracle database switchover steps 19c”, “Oracle Active Data Guard switchover”, “Switchover and switchback in Oracle 12c”, “Switchover steps in oracle 11g”, “Failover steps … Read more
In this article we are going to learn how to run expdp jobs in background (nohup) step by step. Keywords “nohup expdp / as sysdba”, “expdp parfile userid=/ as sysdba”, “How to run expdp in nohup”. Steps to run export in background Follow the below steps to run expdp/impdp in nohup. Step 1: Create parfile … Read more
Hello guys, the Oracle uptime and startup history is recorded in alert log files. But you also check these details using SQL Queries. “Oracle UPTIME AND STARTUP history”. Connect with us on Social Network Oracle UPTIME AND STARTUP history Heres is the steps to check oracle database uptime and startup history step by step. 1. … Read more
In this article we are going to learn how to create spool file with timestamp oracle database. “oracle spool date format”. Connect with us on Social Network spool file with timestamp oracle Login into database and follow the below steps. Step 1: Create a dummy column with noprint option. Step 2: Select sysdate with reference … Read more
Hi, in this practice we are going to learn how to generate table DDL, view DDL, Materialized View DDL and user DDL. You also read below articles: DB LINK DDL GET TABLESPACE DDL GET ROLE DDL Get more oracle scritps How do you get DDL of a table in Oracle? In real time environment some … Read more
In this post, we will learn how to take rman backup with archivelog step-by-step guide. What is backup database plus Archivelog? The backup database plus archivelog command will create a database backup with archivelogs using the RMAN utility. RMAN Backup with Archivelog Or you can use the below script for the same task. Output from … Read more
In this tutorial, I’ll be describing the RMAN (Recovery Manager), which we frequently use to backup and restore Oracle Databases. Backup and Restore are essential tasks for Oracle database administrators. “Introduction to Oracle RMAN” Introduction to Oracle RMAN Oracle RMAN Tool is available to help you manage the Backup & Restore operations. It comes with the … Read more
I recently encountered a situation where the RMAN backup job was stuck. I ended the hung session as the database size was only four GB and it had been running for the last four hours. We made some changes to the RMAN command and ran the jobs again. It was completed in under an hour. … Read more
The Oracle schema owner is the Oracle user who owns all of your database objects. To check the schema’s size, you will need to obtain all database objects owned or controlled by the user. “Find Schema Size in Oracle“. Script to Find Schema Size in Oracle Use the below script to find the schema size. Check … Read more
Toad makes it easy to export the output of executed sqlplus queries to excel -xls using toad. Here’s how to do this on the sql prompt. To save the output, you will need to use text formatting options as well as a spool file name. “save SQL query output in excel format”. Save SQL query output … Read more
Oracle includes built-in features that allow you to convert scn into timestamp or timestamp to SCN. SCN_TO_TIMESTAMP accepts as an argument a number which evaluates to a system number (SCN) and returns the approximate timestamp associated. This function can be used to find the approximate timestamp associated an SCN. Oracle provides two packages, TIMESTAMP_TO_SCN and SCN_TO_TIMESTAMP. convert scn … Read more
Fragmentation leads to slowdowns in-database processing and excessive storage space wastage. This article will explain how to determine if a table has been fragmented in Oracle. Remove Table Fragmentation. Gather Table Stats Gather table stats which has slowness issue, if you recently gathered the table stats then skip this option. OR use the below query: … Read more
We have two configurations to configure Oracle Instance Size, listed below. One instance size Separate Instance size Oracle Instance Size 1. One Instance Size: The Oracle MEMORY _TARGET parameter defines the total size of the instance. Example: If MEMORY _TARGET is set to 10 GB, Oracle will manage PGA + SGA within 10 GB. Note: … Read more
Today I’m trying to restore the RAC database backup in another RAC environment and after successful restoration, we tried to rename the database then we faced ORA-12720 Operation Requires Database Is In EXCLUSIVE Mode. Ora Errors ORA-12720: Operation Requires Database Is In EXCLUSIVE Mode During rename database activity when we re-creating the controlfile it gives the … Read more
ORA-00392 log 1 of thread 1 is being cleared, operation not allowed, this ora error comes after restoration when we trying to open the database in resetlogs mode. Cause: ORA-00392 The first command “alter database open resetlogs” is abnormally abrupted leaving the redo log status as CLEARING/CLEARING_CURRENT in controlfile : ORA-00392 SOLUTION: First you try … Read more
Hi, in this practice, we will restore database until a specific time in the past, or restore database until time. Restore Database until time RMAN restoration until time script. Step 1: Set environment For Windows: set ORACLE_SID=orcl For Linux/AIX: export ORACLE_SID=orcl Step 2. Start Database nomount Start your database till the nomount stage using pfile. … Read more
In this article, we are going to learn how to schedule cron job in the Linux platform step by step. Before scheduling a corn job you must know how it works. A cron job is the same as a task scheduler in windows which executes a specific task at the scheduled time. This tutorial will … Read more
In this article, we are going to learn how to upgrade 12c to 19c using rman. Read: Upgrade Oracle 11g to 19c Database Action on 12c Database Follow all the below steps carefully on Oracle 12c to upgrade oracle database from 12c to 19c using RMAN backup. Step 1: Check Database registry Before start the … Read more
In this article, we are going to learn to upgrade oracle 11g to 19c database. Here we are going to use a manual upgrade using SQL scripts. Read: How to Add New Disk in ASM DiskGroup A list of that releases supports a direct upgrade Here is the list which supports a direct upgrade to … Read more
In this article, we are going to learn the oracle 11g R2 two node RAC dataguard setup in RHEL 6.8 OS. Here we going to configure the data guard (primary and standby) and RAC with physical standby. Environment Details We have already set up two RAC databases on 11gR2 nodes in prodrac101 and prodrac102, with … Read more
Today one of my client was facing ora-12528 TNS:listener: all appropriate instances are blocking new connections. ORA-12528 We checked the listener status and found the instance is also blocked in the listener which means the normal user cannot be able to establish a connection from the application side. Solve ORA-12528: TNS:listener: all appropriate instances are … Read more
Here we are going to discussed oracle RAC interview questions, which are commonly asked by interviewers. Best Oracle rac interview questions Below you will find the best oracle RAC interview questions, I hope you will enjoy these questions. Q1. What is Oracle RAC? RAC stands for Real Application cluster. Oracle Real Application Clusters (RAC) allow … Read more
Sometimes we need to drop the unusable oracle database from the server to free up the resources. So in this article, we are going to learn step by step how to drop database manually in oracle. Pre-requisites: Before the drop, must be sure about the database which you want to drop, then find below details … Read more
In the Oracle database, we face an “ORA-00020: maximum number of processes exceeded” error while making a connection with the oracle database via sqlplus and the Application may encounter TNS errors. This practice we performing on Linux platform. Read how to solve ORA-12954 ORA-00020: maximum number of processes exceeded If you face ORA-00020 maximum number of … Read more
In this article, we are going to learn how to convert physical standby to snapshot standby database step by step on linux platform. What is snapshot standby database? Snapshots allow for a read-write operation on the standby database. We can use snapshots for testing or for developing databases, which are exact replicas of production databases. … Read more
Generating EXECUTION PLAN is discussed in detail with the help of clear and comprehensive screenshots, along with a comparison of times saved. These include getting EXPLAIN PLAN and using V$SQL_PLAN to find out execution plan in Oracle Database. Read: How to Add New Disk in ASM DiskGroup Environment for this practice Generate EXECUTION PLAN from … Read more
Add New Disk in ASM DiskGroup, As per the business growth the database also growing so sometimes we need to add space in the existing diskgroup. The oracle rider will help to resolve your query also on PATCHING. Steps to add Add New Disk in ASM DiskGroup Follow the below step to add a new … Read more
Description:- In this article, we are going to see the Patching Oracle Enterprise Manager 13c Release 4 Update 12 For OMS And Weblogic Part-1 OMS, Part-2 Weblogic Oracle Reference Doc:- Enterprise Manager 13.4 Main Release Update List (Includes Plug-ins) ( Doc ID 2647078.2 )For Weblogic please check: Critical Patch Update (CPU) Program Jul 2020 Patch … Read more