Pipelined Function for String Separation
We might face some scenarios for convert string data into rows. Here you can separate a string into rows by giving the string separator as input. Users can give any…
Read MoreEXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER
EXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER In this blog, we are going to learn about how to do export/import data pump backup by using the tablespace parameter [oracle@oracle Desktop]$ cd [oracle@oracle ~]$ export ORACLE_SID=Trainee [oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu Feb 4 10:42:03 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started.…
Read MoreSCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING CURRENTLY
SCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING In this tutorial, we going to learn about to find which database instance is running now. Mostly we use “/etc/oratab” to view…
Read MoreEasy way to find SID in database using basic information
There are many scenarios, DBA struggling to identify the sessions running in database on sudden adhoc request. To capture the session quickly with the information what we get is really…
Read MoreCommVault Backup failed due to connectivity issues in RAC
Issue: The Commvault issue is reporting saying that first node connection is fine and rest all the 2 nodes is not connecting. Solution: The following are the key points that…
Read MoreKey points to look about TDE Wallet on Bare metel during backup failure.
Database backups fail if the TDE wallet is not in the proper state. The following scenarios can cause this problem If the database was started using SQL*Plus, and the ORACLE_UNIQUENAME environment…
Read MoreScript to check the Highest SQL Wait Time using Active Session History (ASH)
Below sql script to check the Highest SQL Wait Time using Active Session History (ASH) col session_id for a10 col session_serial# for a10 col session_state for a20 SELECT h.session_id, h.session_serial#,…
Read MoreScript to see if any Debug or Trace profile options have been set to Y in Oracle ERP application.
Below sql script to check if any Debug or Trace profile options have been set to Y in Oracle ERP application, select distinct a.application_short_name app_short, user_profile_option_name optname, decode(level_id, 10001,’SITE’, 10002,’APP…
Read MoreRemove Disk from ASM diskgroup in Oracle 19c.
Follow the below steps to remove a disk from ASM diskgroup in Oracle 19c. 1. Check the ASM disks in ASM DiskGroup. 2. Remove disk from ASM diskgroup. 3. Check…
Read MoreAdd Disk to ASM diskgroup in Oracle 19c.
Follow the below steps to add a disk to ASM diskgroup in Oracle 19c. 1. Create ASM disk. 2. Check the ASM disks. 3. Add disk to ASM diskgroup. 4.…
Read More