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

December 1, 2017 How to Enable/Disable Maintenance Mode without using ADADMIN

APPS DBAInstallations/Configurations-Applications

Enable/Disable Maintenance Mode without using ADADMIN

We can Enable or Disable Maintenance mode without using ADADMIN through following given procedure:

Enable Maintenance Mode:

$sqlplus apps/appspassword

SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

Disable Maintenance Mode:

$sqlplus apps/appspassword

SQL>$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

December 1, 2017 How to Add Responsibility to User from Back End

APPS DBAInstallations/Configurations-Applications

How to Add Responsibility to User from Back End

SYNTAX

fnd_user_pkg.addresp(username => Application User Name
,resp_app => Responsiblity_Application_Short_Name
,resp_key => Responsibility_Key
,security_group => Security_Group ‘Mostly it is ‘STANDARD’ so it can be hard coded it’
,description => Any comments you want
,start_date => Sysdate From Today
,end_date => Sysdate + any number of days which is required);

EXAMPLE

BEGIN
fnd_user_pkg.addresp (‘SYEDSAADALI‘,’SYSADMIN‘,’SYSTEM_ADMINISTRATOR‘,’STANDARD‘,
‘Add Sysadmin Responsibility to SYEDSAADALI‘, SYSDATE, SYSDATE + 100);
COMMIT;
DBMS_OUTPUT.put_line (‘Responsibility Added Successfully’);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ( ‘ Responsibility is not added due to ‘ || SQLCODE || SUBSTR (SQLERRM, 1, 100));
ROLLBACK;
END;

December 1, 2017 ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE

APPS DBAErrors/Workarounds-Applications

ERROR

Routine AFPGCP cannot create a process ID for your concurrent manager process ORACLE error 8004 in FDUUID
Cause: FDUUID failed due to ORA-08004: sequence FND_CONCURRENT_PROCESSES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated.
TheCall to establish_icm failed
The Internal Concurrent Manager has encountered an error.

(more…)

November 9, 2017 How to Find Request Group associated for a Program

AppsDBA ScriptsScripts

How to Find Request Group associated for a Program

SELECT rg.application_id
       “Request Group Application ID”,
       rg.request_group_id
       “Request Group – Group ID”,
       rg.request_group_name,
       rg.description,
       rgu.unit_application_id,
       rgu.request_group_id
       “Request Group Unit – Group ID”,
       rgu.request_unit_id,
       cp.concurrent_program_id,
       cp.concurrent_program_name,
       cpt.user_concurrent_program_name,
       Decode(rgu.request_unit_type, ‘P’, ‘Program’,
                                     ‘S’, ‘Set’,
                                     rgu.request_unit_type) “Unit Type”
FROM   fnd_request_groups rg,
       fnd_request_group_units rgu,
       fnd_concurrent_programs cp,
       fnd_concurrent_programs_tl cpt
WHERE  rg.request_group_id = rgu.request_group_id
       AND rgu.request_unit_id = cp.concurrent_program_id
       AND cp.concurrent_program_id = cpt.concurrent_program_id
       AND cpt.user_concurrent_program_name = ‘Program Name’;

November 9, 2017 How to Find Scheduled Concurrent Program

AppsDBA ScriptsScripts

How to Find Scheduled Concurrent Program

Below Query will Fetch all the details for a scheduled concurrent program.

SELECT a.requested_by,
       a.status_code,
       a.phase_code,
       a.request_id,
       b.user_concurrent_program_name,
       c.concurrent_program_name,
       a.requested_start_date,
       c.execution_method_code,
       d.execution_file_name,
       d.execution_file_path
FROM   apps.fnd_concurrent_requests a,
       apps.fnd_concurrent_programs_tl b,
       apps.fnd_concurrent_programs c,
       apps.fnd_executables d
WHERE  a.status_code IN ( ‘Q’, ‘I’ )
       AND a.concurrent_program_id = b.concurrent_program_id
       AND b.concurrent_program_id = c.concurrent_program_id
       AND c.application_id = d.application_id
       AND c.executable_id = d.executable_id
       AND a.requested_start_date > SYSDATE
       AND a.hold_flag = ‘N’
ORDER  BY 1;

Query For Finding schedules for a particular program

SELECT a.requested_by,
       a.status_code,
       a.phase_code,
       a.request_id,
       b.user_concurrent_program_name,
       c.concurrent_program_name,
       a.requested_start_date,
       c.execution_method_code,
       d.execution_file_name,
       d.execution_file_path
FROM   apps.fnd_concurrent_requests a,
       apps.fnd_concurrent_programs_tl b,
       apps.fnd_concurrent_programs c,
       apps.fnd_executables d
WHERE  a.status_code IN ( ‘Q’, ‘I’ )
       AND a.concurrent_program_id = b.concurrent_program_id
       AND b.concurrent_program_id = c.concurrent_program_id
       AND c.application_id = d.application_id
       AND c.executable_id = d.executable_id
       AND a.requested_start_date > SYSDATE
       AND a.hold_flag = ‘N’
       AND b.user_concurrent_program_name = ‘&Program_Full_Name’
ORDER  BY 1;

November 8, 2017 Different Statuses of Concurrent Manager

APPS DBAInstallations/Configurations-Applications

Different Statuses of Concurrent Manager

PENDING STATUS

Normal – Request is waiting for the next available manager. Currently all manager are running other requests.

Standby – Program to run request is incompatible with other program(s) currently running. The requests will be in the Conflict Resolution Manager’s queue. Once the other request with which the request is incompatible gets completed then the request will be executed.

Scheduled – Request is scheduled to start at a future time or date.

Waiting – A child request is waiting for its Parent request to mark it ready to run Request which runs sequentially will wait for a prior request to complete.

RUNNING STATUS

Normal – Request is running normally.

Paused – Parent request pauses for all its child requests to finish.

Resuming – All requests submitted by the same parent request (i.e. child requests) have completed running. The Parent request resumes running.

Terminating – Request is terminated forcefully by choosing the Cancel Request button in Concurrent Request window from front end.

COMPLETED STATUS

Normal – Request completed successfully.

Error – Request failed to complete successfully.

Warning – Request completed with warnings.

Cancelled – Pending or Inactive request is cancelled by choosing the Cancel Request button in the Concurrent Requests window from front end.

Terminated – Request is terminated by choosing the Cancel Request button in the Concurrent Requests window from front end. This states comes after Running-Terminating state.

INACTIVE STATUS

Disabled – Program to run request is not enabled. We need to Contact System Administrator.

On Hold – Pending request is placed on hold forcefully by choosing the Hold Request button in the Concurrent Requests window.

No Manager – No manager is defined to run the request or the manager needed to run the request is down. We need to Contact System Administrator. A status of No Manager is also given when all managers are locked by run-alone requests.

Contact

Get in Touch

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

Contact Form