- Maintaining Oracle Application File System and Database using AD Utilities.
- Starting, stopping and troubleshooting issues related to Application server components.
- Using adadmin to relink executables, generate forms/reports,generate jar files, compile/validate APPS schema.
- Analyzing patch pre-requisites and Applying the Patches using AD Patch Utility on Application file System and Technology Stack.
- Applying Mini Packs, Family Packs, Maintenance Pack and Rollup patches.
- Applying database patches using opatch utility and troubleshooting issues related to OPatch.
- System administration activities like creating users, assigning Responsibilities, defining custom managers.
- Changing configuration files as per the requirement.
- Changing APPS password and Application database users’ password for security.
- Performing Healthchecks.
- Splicing off-cycle products using adsplice utility.
- Cloning of Oracle Applications 11i from Production to Test Instance.
- Taking backups- physical, logical, RMAN and performing Restore, Recovery.
- Troubleshooting issues related to concurrent managers.
- Managing System Configuration using Autoconfig.
- Modifying initialization parameters as per the requirement-PFILE AND SPFILE.
- Reorganization of tables that are fragmented.
- Creating users and assigning appropriate roles, privileges.
- Managing tablespaces and data files.
- Monitoring alert log file.
- Troubleshooting ORA- errors.
- Analyzing AWR reports.
This blog offers expert insights on Oracle E-Business Suite (EBS), Database Administration, and Oracle Cloud Infrastructure (OCI). Explore in-depth tutorials, best practices, and solutions for Oracle EBS management, Oracle Database performance tuning, and OCI cloud administration. Whether you're optimizing Oracle databases, migrating to the cloud, or managing enterprise applications, our blog provides the latest tips and strategies to enhance your Oracle environment and ensure peak performance.
10 Apr 2016
What are the daily activities of Oracle Applications DBA?
Subscribe to:
Post Comments (Atom)
-
When trying to add a datafile to a tablespace , got the error – ORA-32771: cannot add file to bigfile tablespace. SQL> ALTER TABLESPAC...
-
Below Query is Used to verify if MRP process is running fine on Standby Database, after any maintenance activity that requires disconnect ...
-
Issue: FS_CLONE is failing with error :Could not find patch context file from database Error details: $adop phase=fs_clone ============== C...
No comments:
Post a Comment
Was this Post Helpful?
Feel free to suggest your opinions in the comments section!