- How to Enable Clients Using SID to Connect to Oracle PDB in a Oracle Home and Oracle Grid Infrastructure Installation
- Base64 Encode "string" - command-line in Windows
- How to run Oracle SQL tuning advisor for a sql_id in Oracle Database
- Delete the inactive patches to improve performance of oracle Database patching
- Finding Out Patches Applied to WebLogic Server in EBS 12.2
- Configuring Oracle E-Business Suite REST API Services - Issue: Unable To Authenticate ASADMIN User-
- When Attempting To register A New Supplier in Oracle EBS Error Occurs: "ORA-20001: Oracle Internet Directory is not registered correctly"
- How to create JDBC data source connection from WebLogic to Oracle Cloud Autonomous Database ATP or ADW
- Migrate Oracle database to Oracle Cloud Autonomous Database using Data Pump Conventional Export/Import
- Oracle EBS R12 how to know port pool and ports of apps Tier services
- Retrieve Apps password or Forgot Apps Password in Oracle EBS R12
- Prerequisite to install the Oracle EBS with Rapid wiz and Clone EBS with Rapid Clone
- How to Automate the restart of Oracle EBS WebLogic Managed OAcore & OAfm servers using Shell Script
- Best practice for configuring Data Guard Switchover / Failover HA service between primary and DR sites.
- Reclaim the unused space in data file in oracle database if file system or ASM file system is full
- oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException (No such file or directory)
- How to un-link a FND_USER from from SSO in EBS R12
- How to remove/mask the Workflow email address to avoid mails being sent to user from TEST/DEV Oracle Apps Instance
- Oracle EBS 12.2 cloning with version 19c Database
- Finding the Weblogic URL and Port from Oracle EBS R12.2 Context File
- Migrate on-premises Oracle database to Oracle Cloud Architecture(OCI) Database service database using Data Pump Conventional Export/Import
- adop phase prepare failed-[UNEXPECTED]Data dictionary corruption - timestamp mismatch
- Methods for Migrating the On premise Oracle Databases to the Oracle Cloud Infrastructure(OCI)
- Find OOP log file for concurrent program - SQL Query to Find OOP log file for concurrent program
- Oracle ASM disk space check utilization script
- [INS-07009] Unable to load bean store- oracle.xml.parser.v2.XMLParseException: Invalid char in text- - Invalid char in text-gridSetup.sh Oracle Grid Upgrade or Installation error
- srvctl config database -d DBNAME DB PRCT-1011 : Failed to run "osdbagrp". Detailed error:
- ERROR: Some old configuration footprints still exists-Run ebs-delete-node before re-running add node
- perl adcfgclone.pl appsTier dualfs BEGIN failed--compilation aborted at adcfgclone.pl line 27
- Kill inactive session in oracle database using shell script automatically
- Open Workflow Notifications list is very slow in Oracle EBS
- adop phase=cutover FAILED: file ADZDWRKR.sql on worker 1 ORA-00600: internal error code, arguments: [kqllod:no stub for dependency
- [UNEXPECTED]Nodes are listed in the ADOP_VALID_NODES table but not in the FND_NODES table
- oracle.apps.fnd.formsClient.jnlp.Fnd .. ExitException: Your security settings have blocked a self-singned application from running
- Step by Step Transparent data encryption TDE with Oracle EBS
- Steps by Step APEX and ORDS Installation and Configuration in Oracle EBS R12
- How to open Discoverer Viewer or Discoverer plus in Microsoft Edge Browser
- Adding node in oracle apps R12.2 having shared file system
- Oracle Data Masking using TRANSLATE function
- Oracle ASM Disk Migration to Different ASM Disk Storage
- Unable to call fnd_ldap_wrapper . create_user / update_user ORA-20001 Internal Error: Webgate allowed access to protected page GUID=null EBS blank login page issue How to autopopulate user_guid in fnd_user table - While creating user in Oracle Apps it's showing error that AppsDN password has been expired
- Find Oracle Application Profiles Change in N Day
- Arabic character does not appear or chunk characters or ??? characters in XML PDF report on Oracle EBS 12.2.6
- adpreclone.pl take long time and failed with 'Script timed out' during creating FMW home
- Oracle Step by Step Manual Data Guard Switchover and SwitchBack
- Are Artificial Intelligence and Data Science Related? If So How?
- SQL Query to Get Oracle Database Alertlog File Name with full directory folder path
- What is Data Science what are the tasks involved and why so much confusion
- RMAN-04006: ERROR FROM AUXILIARY DATABASE: ORA-12528: TNS:LISTENER: ALL APPROPRIATE INSTANCES ARE BLOCKING NEW CONNECTIONS
- LGWR: Primary database is in MAXIMUM AVAILABILITY mode | ORA-16072: a minimum of one standby database destination is required
- Oracle Passwordless Connectivity Issue in ORACLE RAC setup even after Successful the Passwordless connectivity between RAC Node
- Oracle RAC SSH Passwordless Setup issue - com.jcraft.jsch.JSchException: Algorithm negotiation fail
- ERROR: RPC Port 1634 is not free ERROR: Some of the ports which are common across RUN and PATCH fs are not yet free.Waiting for 1 minute before rechecking
- How To Allow ADOP To Continue As If It Were Successful After Hitting An Error While Applying Patch(es)
- adop phase=prepare fails with: Error Message : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
- ORA-04021: timeout occurred while waiting to lock object
- How to increase java heap size in EBS R12.2
- [WARNING] [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’
- sql planner check
- sql text from username
- AD delta 11 upgrade Patch 26834480 or AD delta 12 upgrade Patch 30628681 is failing failed: file ademusr.sql on worker 1 with ORA-01031: insufficient privileges
- Oracle Discoverer Installation and Configuration
- Discoverer SSL Certificate Import and Configuration
- FS_CLONE or PREPARE FAILED:At least one Oracle inventory check has failed
- Post Clone Steps on EBS Environment
- Checking the Conflicts DB patches with a given DB patch
- Find Latest CPU/PSU Oracle Database Check
- How to install Oracle Trace File Analyzer (TFA)
- Instance number '2' is used by host 'hostname' perl adclonectx.pl \
- ERROR: Invalid java version found while running adcfgclone.pl command
- Step By Step Integrating Oracle e-Business Suite 12.2.6 with Oracle Access Manager 12.2.1.3 and Oracle Internet Directory 12.2.1.3 using Windows Native Authentication
- Java Web Start Configuration in Oracle EBS 12.2.6
- cmclean.sql script
- FS_CLONE Error: Received disconnect from IP Address Timeout, your session not responding. :failed
- IMP-00028: partial import of previous table rolled back:
- Script for generate the Tablespace and Alter Tablespace Useful for Export and Import(Exdp and impdp) and DB Migration using expdp and impdp
- Step by Steps Oracle EBS DMZ setup and Configuration
- Extracting Private Key and Certificate from Oracle Wallet
- How to find EBS R12 components Version
- Determining your Oracle EBS Code Level and Family Pack
- Cloning Oracle Database Home From One Server To Another Server
- Oracle E-Business Suite Cloud Manager Hands-On Lab for Provision the Oracle EBS Environment and then Lift & Shift
- Oracle Cloud Infrastructure Architect Associate - Sample Questions
- Oracle Cloud Terminology and Concepts
- Oracle OCI Api Keys Creation and Integration(import and add the key to OCI user)
- Upgrade java 1.8 for Oracle EBS 12.2.6
- Adding Screen in SSH session to retrieve back screen in case your session timeout or lost due to power failure
- Get the Process ID from Port Number - Solaris
- adop prepare, apply and fs_clone failed exiting with status = 1 and 255
- adop failing - adop is not able to detect any valid application tier nodes in ADOP_VALID_NODES table - Ensure autoconfig is run on all nodes.- adop exiting with status = 255 (Fail)
- adop session time out on DMZ nodes
- Oracle EBS Suite Weblogic Server connection filtering
- Create Materialized Views in Oracle EBS 12.2 version
- SSL/TLS Certificate import on Oracle EBS DMZ iSupplier and iRecruitment web portal
- Change the datasource password in Oracle EBS 12.2
- FNDCPASS error in R12 - Error in password verification for APPS
- Duplicate the database from Rman Backup Location
- oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.wf.worklist.server.NotificationsAM'.
- ASM Queries
- Query for responsibility list attached to user in Oracle EBS 12 Apps
- Query to get details for Vacation Rule and Delegation in Oracle EBS R12 Apps
- How to Check Oracle EBS R12 Workflow Mailer sending email or not at Unix server level
- How to Recreate a Corrupted Workflow Background Queue WF_Deferred_Table_M
- Oracle RAC database is not coming up and error is RAC is not configured
- SRVCTL add database fails with osdbagrp error - PRCT-1011 : Failed to run "osdbagrp". Detailed error: null
- DG Broker Configuration in Oracle Database and Examples
- Oracle EBS XML Publisher Report Completed With Error: java.lang.NullPointerException
- Accounts Payable Trial Balance Report Completed With Error: java.lang.NullPointerException
- ORA-01516: nonexistent log file, data file, or temporary file "+DATA"
- How to find password of Application User in Oracle EBS Apps R12
- Daily Essential SQL Queries For Oracle Apps DBA
- Troubleshooting Oracle E Business Suite Workflow Mailer and Notification issues
- UNIX Useful Commands
- Compile Oracle Forms in Oracle EBS R12
- Create New Application user from existing user in Oracle EBS R12
- Compile jsp pages in Oracle EBS
- Trace a Concurrent Request in Oracle EBS And Generate TKPROF File
- Kill OS Processes with corresponding OS user
- Find inode utilization for a file system in Unix Servers
- Avoid time out in UNIX server SSH session for long running scripts or shell scripts
- How to fix block corruption in Oracle Database
- Create Rman Backup scripts from SQL Query
- FNDCPASS Examples
- Reset Oracle EBS Application User Password through Oracle EBS API
- ADOP (Ad online patching utility) in R12.2
- Delete files more than 9 days old in UNIX
- Oracle EBS 12.1.3 Apps Form crash after calling discoverer workbooks through EBS Application
- Internal 500 Error frequently in Oracle EBS 12.1.3 due to Long running JVM
- Forms are not opening after cloning in oracle ebs 12.1.3
- EBS DB startup through svrctl is getting failed with ORA-00119: invalid specification for system parameter REMOTE_LISTENER
- Error CRS-5017 and ORA-12547 when using srvctl command to start/stop a database
- Rebuild Workflow Queue table if the workflow Queue table corrupted or email not sent
- How To Purge E-Mail Notifications From The Workflow Queue So The E-Mail Is Not Sent
- Steps to Recreate Oracle Central Inventory in Real Applications Clusters(RAC)
- Data Guard Standby Commads
- RSYNC Commads
- Oracle EBS Concurrent Reports Failing With Errors REP-0004,REP-0082 and REP-0104
- Import the Jar Signing Certificate for Oracle E-Business Suite
- Extracting private key from Oracle Wallet
- Oracle EBS Database RAC to RAC database cloning
- Rman database Restore Command running in background using nohup
- Duplicate the database using Rman from active database
- Create Standby database using Rman Duplicate Database from active database
- Autoconfig failed - ORA-01422: exact fetch returns more than requested number of rows
- AutoConfig could not successfully execute - ouicli.pl INSTE8_APPLY 1
- Oracle EBS 12.2 Accessgate SSO CONFIGURATION - Removing and adding
- Step by Step procedure to Clone Oracle EBS R12.2 instance database and application
- AutoConfig could not successfully execute - ouicli.pl INSTE8_APPLY 255
- Rman Useful commands
- Create synonym in edition based objects in Oracle EBS database with Oracle EBS 12.2 version
- Home
- _All Posts
- Oracle Apps DBA
- __Oracle EBS Cloning
- __Oracle EBS Patching
- __SSL/TLS Export&Import
- __Oracle Apps DBA Troubleshooting
- __SQL Queries For Apps DBA
- __SQL Queries For Oracle Apps Techno-Functional
- __Oracle Apps
- Oracle Core DBA
- _Oracle Dataguard
- _Oracle RAC
- _RMAN
- Oracle Cloud
- Unix/Linux
- Data Science
- About Me