BLOG CONTENT

Introduction -Oracle Apps DBA History of Database and Applications:                 Oracle History and ERP Versions their Release Date              Oracle Database Version History & Oracle Release Versions                                            Deadline Dates for Current Oracle Database Versions             Oracle E-Business Suite Release 12.2 Technology Stack Documentation Roadmap Architectures:              Oracle Database Architecture ​             Oracle E-Business Suite R12.2 Architecture              How update statement works in oracle              Oracle EBS File system              Oracle EBS Application Objects and Tablespaces.              Adpreclone and Adcfgclone in EBS              Local Inventory and Global Inventory in Oracle EBS .              What is new  ​Ad utilities:    autoconfig adadmin adpatch admrgpch adsplice fndcpass adworkers adcrtl adrelink adclone adlicmgr adident WFLOAD  User Management:             Adding new user in Oracle Apps from back end Concurrent Managers:                      Concurrent Request Status Codes and Phase Codes ​Tablespace Management:            How to create, add, drop, reuse Tempfile            Undo Management & Undo Tablespace Invalid Objects:          Invalid Objects Scripts:          How to Terminate a Concurrent Requests from backend          Scrip to take backup of Package specification and Package Body          Scrip to take backup of View and Trigger          Query to get list of Custom Form List in oracle application          Script to Put Concurrent Requests on Hold          How to Decrypt Sysadmin Password in EBS R12          Pre - Clone Backup Script on Database Node          Script to find profile option value from Back-end          Query to Find RMAN backup details          How to identify whether the Downtime required or not to change Oracle database parameter          Scripts to find Locks on Package in Oracle Database Refresh&Clones:           Schema Refresh Using Data pump           Oracle Database 12c/19c Hot Cloning Of Pluggable Databases           How to setup UTL_FILE_DIR values in the 19c database. Upgrades:              Oracle EBS Upgrade Steps from 12.2.0 to R12.2.10               RMAN:              RMAN Block Change Tracking Overview   Disaster Recovery:​              Oracle Data Guard Types​                         SNAPSHOT DATABASE CONVERSION From PHYSICAL STANDBY DATABASE:          Errors And Solutions:            ​             Cleanup in STANDARD mode is failing              ORA-28000: the account is locked:Exception occurred: java.sql.SQLException:              Invalid APPS database user credentials. No updates Performed              How to create .dbc file in Oracle Apps R12 EBS ?              Unable to Start Admin Server on EBS 12.2              FNDCPASS Error: Oracle error -29548: ORA-29548: Java system class reported ​             ORA-28007: the password cannot be reused              Function not available to this responsibility. Change responsibilities or ​             contact your System Administrator Error in EBS ​