Batch Script in Windows to take export EXPDP of Oracle Database To automate the process of running Oracle Data Pump (expdp) on a daily basis, and including the date in the filenames for both dump and log files, you can write a Windows batch script. Below is an example script for automating the expdp process with date-based file names. Batch Script for Oracle expdp Backup with Date in Dump and Log Files @echo off SET ORACLE_HOME=C:\app\oracle\product\12.1.0\dbhome_1 SET ORACLE_SID=ORCL REM Directory where dumps and logs will be stored SET BACKUP_DIR=C:\backup\oracle\expdp REM Get the cur ..read more

Step by Step Guide to Install Oracle Database 19c on Windows In this post I am going to share step by step for installing the Oracle 19c Standard Database on Windows Operating System. 1) Download the 19c Windows Database Software Oracle 19c software for Windows from the official Oracle download page. I have downloaded Oracle Database 19c (19.3) for Microsoft Windows x64 (64-bit) as per my need. 2) Unzip and Launch Installation Wizard 3) Kick off the installer Right click and setup and run as administrator. 4) Follow the below screen to proceed with installation. W ..read more

Setup Linux 8 Repository in for Oracle Linux We can setup a OL8 repository manually as below vi /etc/yum.repos.d/oracle-linux-ol8.repo Add below [ol8_baseos_latest] name=Oracle Linux 8 BaseOS Latest ($basearch) baseurl=https://yum.oracle.com/repo/OracleLinux/OL8/baseos/latest/$basearch/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle gpgcheck=1 enabled=1 [ol8_appstrem] name=Oracle Linux 8 Appsstream Repository baseurl=https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/ enabled=1 gpgcheck=1 gpgkey=https://yum.oracle.com/RPM-GPG-KEY-oracle-ol8 Please do like and subs ..read more

Query To Check DB_RECOVERY_FILE_DEST_SIZE Utilization in Oracle Script: set linesize 999 SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE; or col name for a32 col size_m for 999,999,999 col reclaimable_m for 999,999,999 col used_m for 999,999,999 col pct_used for 999 SELECT name , ceil( space_limit / 1024 / 1024) SIZE_M , ceil( space_used / 1024 / 1024) USED_M , ceil( space_reclaimable / 1024 / 1024) RECLAIMABLE_M , decode( nvl( space_used, 0),  0, 0  , ceil ( ( ( space_used - space_reclaimable ) / space_limit) * 100) ) PCT_USED  FROM v$recovery_file_dest ORDER BY name / Pl ..read more

Users Receiving Larger Number of Emails For Already Closed Notifications An EBS user received over 900 emails from the Workflow Mailer, all seemingly related to just two or three notifications that had already been closed. This issue arose because the Workflow Mailer was processing invalid responses for notifications marked as closed. The user’s SMTP server responded with "UNDELIVERABLE" or "Message Delayed" replies, including the original email as part of the response. Each reply contained a "NID line" (Notification ID) such as: NID[579620/150876511398750957310222682961425070341@AOLDEV ..read more

How to reconfigure patch file system in EBS R12.2 We had a scenarios where I need to re-create or again configure the patch file system in ebs. Steps 1. Run adpreclone.pl on run file system Source run file system. $ perl adpreclone.pl appsTier   2. Detach PATCH homes: Below Oracle Homes are registered in the inventory which needs to be deregistered: /u01/app/fs2/FMW_Home/Oracle_EBS-app1 /u01/app/fs2/FMW_Home/webtier /u01/app/fs2/FMW_Home/oracle_common   cd $FMW_HOME/oracle_common/oui/bin ./runInstaller -removeHome ORACLE_HOME=/u01/app/fs2/FMW_Home/Oracle_EBS-app1 -silen ..read more

Expdp of  Table Returns ORA-39166 or ORA-31655 in Oracle Database Certain system-generated schemas, such as SYS, MDSYS, and ORDSYS, cannot be exported using exp or expdp because they hold Oracle-managed data and metadata. These schemas are essential for the internal functioning of the database and are excluded from export operations. Additionally, some tables owned by users like SYS or APEX_040200 are automatically skipped during export. These tables are also not eligible for export, even if explicitly specified, as they contain Oracle's internal data. For example, certain tables owne ..read more

ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set Error: [oracle@fundb ~]$ dgmgrl DGMGRL for Linux: Release 12.2.0.1.0 - Production on Sat Jul 19 18:03:42 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> connect / Connected to "PRIM_CL" Connected as SYSDG. DGMGRL> DGMGRL> create configuration 'PRIM_CL' as primary database is 'PRIM_CL' connect identifier is PRIM_CL; Configuration "PRIM_CL" created with primary database "PRIM_CL" DGMGRL> DGMGRL> add data ..read more

Step-by-Step Guide to Set Up Data Guard Broker in Oracle Oracle Data Guard Broker is a distributed management framework that automates and centralizes the creation, configuration, and monitoring of a Data Guard configuration. It simplifies many of the tasks related to managing Data Guard. This guide outlines the step-by-step process for setting up the Data Guard Broker in Oracle. Pre-Requisites Before setting up Data Guard Broker, ensure that: You have an Oracle Database environment configured with a primary and standby database. Data Guard is already configured and running between the prim ..read more

RMAN Active Duplicate Fails with ORA-19837 ORA-19849 ORA-19850 Error: RMAN active duplicate fails with error: RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-19849: error while reading backup piece from service <service_name> ORA-19850: backup piece constructed from service <service_name> is corrupt ORA-19837: invalid blocksize 0 in backup piece header ORA-19660: some files in the backup set could not be verified ORA-19661: datafile 0 could not be verified ORA-19849: error while reading backup piece from service ..read more