Activities Performed, as Oracle-Applications DBA on Oracle-Ebusiness Suite 11i.

=======================================================

• Installations, Configuration of Oracle Ebusiness Suite11i, 11.5.9.
• Upgradation of - Applications from 11.5.9 to 11.5.10 on test servers successfully.

---> Developer 6i with oracle applications 11i (forms, reports)

• Jinitiator with oracle applications 11i.
• Cloning the Oracle 11i Production instance for dev, test environment.
• Adding a node by using Rapid Clone.
• Applying latest releases of the RDBMS patches using Opatch utility from Oracle on Production and test instance to resolve few technical challenges & issues.

• Patching 11i instance and used defaults file to reduce patch timelines. ---->Patches like - Mini pack for the products AD, FND, ADX, TXK.

• Generating forms, reports, jar files using adadmin.
• Installed new products using adsplice and licensing new application modules.
• Resolved few apps issues by Compiling invalid objects and relinking the apps executables.
• Enhancing the oracle application performance.
• Making changes for components configuration like port numbers and made them functional.
• Involved in SYSADMIN actions like creation of users and assigning responsibilities.
• Resolved the Apache, Conc. manager’s and other application tier startup issues.
• Troubleshooting, support, monitoring Concurrent managers & programs and applications.
• Resolved the view log/out files issues of concurrent requests.
• Performing FNDLOAD, WFLOAD and FNDCPASS for managing passwords.
• Gathering statistics of tables/schemas using fnd_stats.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Monitoring table space size, resizing table space, alert log, trace files.
• Troubleshooting several performance issues related to fragmentation of tables.