Introduction -Oracle Apps DBA
Content of Oracle Database
Oracle APPS DBA Content
LINUX / UNIX Basic Commands
History of Database and Applications
Oracle History & 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
Control File MaNagement
Password File
Start & Stop
Start and Stop EBS R12 Application Services
Startup and Shutdown Modes of Database
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
Workflow Loader
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
Database upgrade from 12c to 19c Pluggable Database
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
NADHAN'S SCRIPTS
Content of Oracle Database
Oracle APPS DBA Content
LINUX / UNIX Basic Commands
History of Database and Applications
Oracle History & 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
Control File MaNagement
Password File
Start & Stop
Start and Stop EBS R12 Application Services
Startup and Shutdown Modes of Database
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
Workflow Loader
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
Database upgrade from 12c to 19c Pluggable Database
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
NADHAN'S SCRIPTS