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

Order Now

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

Order Now

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

Order Now

Resume

Experience

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

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.

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

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

2008 - 2011

Newports Institute Of Communication & Economics

Pakistan

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

Certificate

2013

Oracle University

USA

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

Certificate

2014

Oracle University

USA

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional

Certificate

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

Works

Projects

Oracle Cloud Infrastructure Projects

Content

Oracle E-Business Suite Upgrade Project

Blog

May 9, 2017 R12: Rapid Cloning Issue : ouicli.pl INSTE8_APPLY 255

APPS DBAErrors/Workarounds-Applications

ERROR

R12: Rapid Cloning Issue : ouicli.pl INSTE8_APPLY 255

(more…)

May 7, 2017 Receipt Workbench Error: Applying Receipt Generates Workflow Notification With Error – Local Event Error: oracle.apps.ar.applications.cashapp.apply

Accounts ReceivablesErrors/Workarounds-AR

ERROR

Receipt Workbench Error: Applying Receipt Generates Workflow Notification With Error – Local Event Error: oracle.apps.ar.applications.cashapp.apply

On : 12.1.1 version, Receipts Related

When attempting to apply a receipt, a notification is generated with the following error:

Local Event ERROR : oracle.apps.ar.applications.CashApp.apply
Event Error Message: No Event Subscriptions exist for this Event

The issue can be reproduced at will with the following steps:

Responsibility: Receivables Manager
Navigation: Receipts > Receipts
Apply a receipt to an invoice

Due to this issue, SYSADMIN mailbox is getting hundreds of notifications daily and you are not sure whether the error requires an action from you to fix, or can be ignored.

CHANGES

Upgraded to 12.1.1

CAUSE

FND Debug log generated via Note:433199.1 How to enable and retrieve debug log messages shows the following:

Start executing rule function – PA_PWP_NOTIFICATION.Receive_BE [Start time 1301086012]
End executing rule function – PA_PWP_NOTIFICATION.Receive_BE [End time 1301086014] [Time taken – .02 secs]
Executed Rule Function PA_PWP_NOTIFICATION.Receive_BE and returned ERROR
saving event to WF_ERROR on TST.LAKECO.ORG

This is worked in unpublished Bug 8869818 and Bug 8993957 GSI R12.1.1 WFERROR GENERATED FOR “PA AR NOTIFICATION” (PAPWPAR). In the bug it says:

WFERROR is generated for “PA AR Notification”(PAPWPAR) even when the functionality is not in use( “AR Receipt Notification” is disabled
Automatic receipt creation program in AR triggers the Business event oracle.apps.ar.applications.CashApp.apply, this in turn triggers the subscription API PA_PWP_NOTIFICATION.Receive_BE in synchronous mode. In API PA_PWP_NOTIFICATION.Receive_BE
apps_inititalize was called which was resetting the context already set by AR program. This resetting of context was clearing out the request_id from the global variables and was causing performance impact in AR process.

SOLUTION

If you Don’t the PA AR Notification subscription then you can disable it as follows:

First login as SYSADMIN (you must have SYSADMIN privileges in order to update)

Responsibility: Workflow Administrator Web Applications
Navigation: Administrator Workflow > Business Events

– In Name field for search criteria enter ‘oracle.apps.ar.applications.CashApp.apply’
– (B) Click Go
– It will show you one even under Results
– Under Subscription column, click on Subscription icon
– Go to update subscription “PA_PWP_NOTIFICATION.Receive_BE”
– Select Disable
– Apply
– This will disable the notifications to PA manager and will also bypass the call made to this particular API.

May 7, 2017 There is already an ACTIVE ADOP CYCLE with session id : SP2-0640: Not connected

APPS DBAErrors/Workarounds-Applications

ERROR

The below failure while executing :

Running perl /u01/apps/oracle/fs2/prodapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/apps/oracle/inst/fs2/inst/apps/PROD_U01ORACLEapp01/appl/admin/PROD_U01ORACLEapp01.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

There is already an ACTIVE ADOP CYCLE with session id : SP2-0640: Not connected
adpreclone cannot be run with pending ADOP session.

SOLUTION

While An active ADOP session , If any cloning activity is performed, both file-systems could be in trouble. Hence we need to clear all ADOP sessions before executing adpreclone. However if adop -status -detail has no active sessions. Then Apply

Patch 22271970: ADPRECLONE.PL FAILS ON DELTA 7

$adop phase=apply patches=22271970

May 6, 2017 ORA-04030: out of process memory when trying to allocate 4088 bytes while ADOP in 12.2.3

APPS DBAErrors/Workarounds-Applications

ERROR

ORA-04030: out of process memory when trying to allocate 4088 bytes while ADOP in 12.2.3

SOLUTION

Restart of the adworker fixed the issue.

OR

Change the page count to 200000 at the OS level:

$ more /proc/sys/vm/max_map_count
$ sysctl -w vm.max_map_count=200000

OR

Adjust the realfree heap pagesize within the database by setting the following parameters in the init/spfile and restart the database.

_use_realfree_heap=TRUE
_realfree_heap_pagesize_hint = 262144

Then try restarting the worker

May 5, 2017 Autoconfig fails with IO Error: The Network Adapter could not establish the connection

APPS DBAErrors/Workarounds-Applications

ERROR

—————————————————————
ADX Database Utility
—————————————————————

(more…)

May 4, 2017 libXtst.so.6: cannot open shared object file: No such file or directory

APPS DBAErrors/Workarounds-Applications

ERROR

While executing rapidwiz for E-Business Suite for Release 12.2.0 installation,

facing an error related to jre file:

libXtst.so.6: cannot open shared object file: No such file or directory

SOLUTION

Installed the below packages:

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
binutils-2.17.50.0.6-6.0.1.el5.i386.rpm

Recreate the Link below by ROOT user:

# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

Contact

Get in Touch

Address: Karachi, PAKISTAN
Email: askme@SyedSaadAli.com
Phone: +92-300-026-5668
Freelance: Available

Contact Form