How to Check Oracle UPTIME AND STARTUP history?

Oracle UPTIME AND STARTUP history

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

Create spool file with timestamp in oracle

spool file with timestamp

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

RMAN Backup with Archivelog

RMAN Backup with Archivelog

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

Oracle RMAN

introduction to rman

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

Kill Hung RMAN Session

Kill Hung RMAN Session

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

How to Find Schema Size in Oracle

Find Schema Size in Oracle

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

How to save SQL query output in excel format?

How to save SQL query output in excel

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

How to convert scn to a timestamp in Oracle

convert scn to a timestamp

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

How to Remove Table Fragmentation in Oracle

Remove Table Fragmentation

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

How to Check Oracle Instance Size

Oracle Instance Size

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

ORA-12720 Operation Requires Database Is In EXCLUSIVE Mode

ORA-12720 Operation Requires Database

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 Solution

ora-00392

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

How to Restore Database until time

Restore Database until time

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

Upgrade Oracle Database from 12c to 19c using the RMAN backup

upgrade 12c to 19c using rman

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

Upgrade Oracle 11g to 19c Database

Upgrade Oracle 11g to 19c Database

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

Solve ORA-12528

ORA-12528

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

Drop Database Manually in Oracle

Drop Database Manually

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

ORA-00020: maximum number of processes exceeded

ORA-00020: maximum number of processes exceeded

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

Convert Physical Standby To Snapshot Standby Database

Physical Standby To Snapshot Standby Database

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

How to Add New Disk in ASM DiskGroup

Add New Disk in ASM DiskGroup

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

Patching Oracle Enterprise Manager 13c Release 4 Update 12 For OMS And Weblogic

Patching Oracle Enterprise Manager 13c

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