Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Home

About Me

Technically-sophisticated professional with extensive experience in updating server security, executing routine back-ups, and designing and implementing tests of the system to address issues with accessing data

  • Adept at leading the planning, designing, developing, testing, and deploying efficient solutions within Oracle EBS system, in order to satisfy strategic, financial, and operations needs of the organization.
  • Skilled in planning and managing successful projects, mitigating risks, controlling costs, and directing project teams. Instrumental in monitoring routine maintenance of system, implementing the ERP systems, and approving budget.
  • Proven success in analyzing business processes/process re-engineering and recommending solutions. Deft at establishing IT service continuity management strategies, disaster recovery plans and associated test procedures of each critical functional area of the organization.
  • Age: 36
  • Residence: Pakistan
  • Freelance: Available
  • Address: Karachi, PAKISTAN
My Services
Oracle E-Business Suite Upgrade
Oracle E-Business Suite Migration
Oracle Database Upgrade or Migrate
Oracle Maximum Availability Architecture
Performance Evaluation
Pricing
Hire Me On Upwork
$ 35 Hour
  • Database Administration
  • Oracle E-Business Suite Administration
  • Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management
Hire Me on Fiverr
$ 35 Hour
  • Database Administration
  • Oracle E-Business Suite Administration
  • Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management
Hire Team
$ 40 Hour
  • Database Administration
  • Oracle E-Business Suite Administration
  • Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management

Resume

Resume
Experience
Senior Apps DBA
2022- Present
Senior Apps DBA
Computer & Systems Engineering Company
My role includes infrastructure support, capacity planning, installation, configuration, database design, and migration, up gradation, performance monitoring, security,  database backups, data recovery plan, and procedures including application server administration
Lead Infrastructure Consultant
2020-2021
Lead Infrastructure Consultant
ITANZ Group
Managed Oracle cloud infrastructure, compute, storage, networking, connectivity, and edge service, database management, analytics, integration, and Oracle weblogic clustering environment over Oracle Cloud IAAS.  Collaborated with the Oracle corporation staff for offering technical support to diagnose and troubleshoot common problems.
Professional Freelancer
2020 - 2022
Professional Freelancer
Upwork Inc.
Collaborated with Clients for the Task Related to Oracle Database, Oracle E-Business Suite, Oracle Cloud Infrastructure, Oracle Weblogic
Assistant Director (Databases)
2015-2020
Assistant Director (Databases)
Pakistan Civil Aviation Authority
Managed ERP for implementing the structures effectively, while limiting the resources consumed in the planning process. Improved IT/business processes and investigations to resolve the user’s issues as well as offered user’s training to help the user in operating the system in efficient way.
Education
Newports Institute Of Communication & Economics
2008 - 2011
Newports Institute Of Communication & Economics
Pakistan

Newports Institute Of Communication & Economics offers a B.S. in Computer Science.

Certificate
Oracle University
2013
Oracle University
USA

Oracle E-Business Suite R12 Financials Certified Expert  Consultant, PAYABLES 

Certificate
Oracle University
2014
Oracle University
USA

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional 

Certificate
Oracle University
2011
Oracle University
USA

Oracle Database 11g Administrator Certified Professional 

Certificate
Skills
Oracle Expertise
  • Oracle Databases
  • Oracle E-Business Suite
  • Oracle Weblogic
  • Oracle Cloud Infrastructure
  • Oracle Database Appliances
Languages
  • English
System
  • Linux
    90%
  • Microsoft
    75%
  • SOLARIS
    65%
  • AIX
    60%
Knowledge
  • Installation/Configuration
  • Capacity Planning
  • Data Recovery Plan
  • Oracle Database Migration and Upgrade
  • Oracle ERP Migration and Upgrade
  • Linux and Windows management
  • Performance Evaluation

Blog

April 10, 2017 adapcctl.sh exiting with status 204
APPS DBAErrors/Workarounds-Applications

While cloning Oracle Applications

You might encounter an issue:

adapcctl.sh exiting with status 204

(more…)

April 9, 2017 Database Interview Questions Part 2
Database Interview QuestionsInterview Questions

1.Which Table spaces are created automatically when you create a database?

(more…)

April 9, 2017 Database Interview Questions Part 1
Database Interview QuestionsInterview Questions

1.What is BLOB datatype?

(more…)

April 8, 2017 Output Post Processor is Down
APPS DBAErrors/Workarounds-Applications

Output Post Processor is Down with Actual Process is 0 And Target Process is 1  

(more…)

April 8, 2017 Apps DBA Interview Questions Part 5
Apps DBA Interview QuestionsInterview Questions

1.What is Online Patching?

Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while the system is up and running, and the users are working as normal.

 

2.Which Oracle E-Business Suite releases Online Patching feature is available?

Online patching is used with Oracle E-Business Suite 12.2 and higher.

3.What types of patch are applied online?

All Oracle E-Business Suite Release 12.2 patches are applied online. This includes one-off patches, patch rollups, consolidated updates and security patches.

 

4.What is the Online Patching cycle?

The Online Patching Cycle is a sequence of inter-related steps (phases) used to apply patches to an Oracle E-Business Suite system.

 

5.What tool is used to apply online patches?

The AD Online Patching (adop) command-line utility is used to manage the Online Patching cycle.adop invokes adpatch is the background only.

 

6.Is there any downtime in Online Patching?

There is a short period of downtime when the application tier services are shut down and restarted. The database remains open all the time.

 

7.Once I upgrade to Release 12.2, can I still apply patches in the traditional way?

No. All patches for Release 12.2 will be online patches. The traditional, pre-12.2 method of applying patches will not work.There are option like downtime and hotpatch which works more like traditional way but they are used for patches directed by Oracle

 

8.What is the Online Patching infrastructure?

This infrastructure includes database objects edition and patch/run file system components.

 

9.Does Online Patching require the 11gR2 Oracle Database feature?

Yes. Online patching depends on the Edition Based Redefinition (EBR) feature that was introduced in the Oracle 11gR2 Database. Most notably, EBR allows edition of code objects in the database. To do this, it provides new object types such as editions, edition views, and cross-edition triggers, all of which are part of the Online Patching infrastructure.

10.What are the phases that make up the Online Patching cycle?

The Online Patching cycle consists of the following phases:
a) Prepare a virtual copy (patch edition) of the running application (run edition).
b) Apply patches to the patch edition of the application.
c) Finalize the system in readiness for the cutover phase.
d) Cutover to the patch edition and make it the new run edition.
e) Cleanup obsolete definitions or data to recover space.

 

11.What downtime is required during an Online Patching cycle? or as the name spells online,there is no downtime in the whole process?

The cutover phase requires a short period of downtime (typically a few minutes) for transition tasks such as a restart of the application tier services.

 

12.Is any downtime required for the database tier?

No. In fact, the database needs to be up and running during each phase of the Online Patching cycle.

 

13.How does Online Patching work on the application tier?

During Release 12.2 installation, Rapid Install will lay down two copies of the application tier file system. One of the copies will be labeled as the run file system, and the other as the patch file system. Subsequently, when a patch is applied, adop will:

1.Synchronize the contents of the run file system to the patch file system. This happens during the prepare phase.
2.Perform patching actions on the patch file system. This happens during the apply phase.
3.Finally, during the cutover phase, the adop utility restarts the application tier services. The patch file system is then promoted to be the new run file system, and the old run file system becomes the patch file system for the next patching cycle.

[edsanimate_start entry_animation_type= “bounceIn” entry_delay= “0” entry_duration= “1.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]

Note that a third file system, the non-editioned file system (fs_ne), is created to store files containing data that is needed across all file systems,such as log files.

[edsanimate_end]

 

14.How do I apply Oracle Fusion Middle-ware patches in Oracle E-Business Suite Release 12.2?

During the apply phase of an Online Patching cycle, you apply Oracle Fusion Middle-ware patches to the Oracle homes of the patch edition file system. Then, after the cut over phase is complete, you synchronize the file systems by performing an fs_clone operation.

 

15.Can I use the patch edition for testing and development purposes?

As a specialized component of the Online Patching infrastructure, the patch edition is not supported for use as a test environment. You should continue to employ a separate, dedicated test environment.

 

16.Can Online Patching be used with database technologies such as Active Dataguard and Flashback?

Yes. Online patching can be used alongside Active Dataguard and Flashback. Infact we can use flashback to rollback the changes after the final cutover.

 

17.Does Online Patching increase the network port requirements on an Oracle E-Business Suite instance?

Yes. Online patching requires an additional set of network ports for the Oracle WebLogic Server managed servers on the second file system. During the cutover phase, the managed servers run simultaneously on the patch file system and run file system for a brief period, in a rolling transition process.

 

18.Is it possible to abort an Online Patching session?

Yes. Up to cutover, you can run the abort phase to undo the changes made so far in the patching cycle. It is not possible to back out patches once cutover is complete.

 

19.Is the shared APPL_TOP configuration supported with Online Patching?

Yes. A shared APPL_TOP configuration is supported and recommended for multi-node application tier implementations in Release 12.2.

20.How does adop work in a multi-node environment?

The adop Online Patching tool uses remote APIs and ssh login to execute patching operations on remote nodes in a multi-node environment. The node that launches adop becomes the ‘master’ node, and the remote nodes are referred to as ‘slaves’.

 

21.How do I determine the status of my Online Patching session?

You can run the adop -status command. This will display information that includes phases completed and the time taken. If you want additional details of operations performed, you can run the adop -status -detail command.

 

 

April 7, 2017 RW-50004: An Error Has Occurred
APPS DBAErrors/Workarounds-Applications

While Installing Oracle E-Business Suite we might get the following error:

RW-50004: An Error Has Occurred, Check the log file for details:

(more…)

Contact

Get in Touch
  • Address: Karachi, PAKISTAN
  • Email: askme@SyedSaadAli.com
  • Phone: +92-300-026-5668
  • Freelance: Available
Contact Form