Syed Saad Ali
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
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

AppsDBA CV Download CV Contact Me

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

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
May 13, 2017 ORA-12720: operation requires database is in EXCLUSIVE mode
Errors/Workarounds10gErrors/Workarounds11gOracle Database Material

ERROR

CREATE CONTROLFILE .................................
   .................................................
CHARACTER SET AL32UTF8;

ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode

SOLUTION

SQL> alter system set cluster_database=FALSE scope=spfile sid='*';
SQL> shutdown immediate; 
SQL>startup nomount;

Now, re-run script for creating controlfile 

CREATE CONTROLFILE .................................
   .................................................
CHARACTER SET AL32UTF8;

Control file created.

Then, change parameter with its old value and restart database.

SQL>alter system set cluster_database=TRUE scope=spfile sid='*';
May 13, 2017 Friday Spotlight: Migrate Virtual Machines from VMware to Oracle VM
NEWS AND UPDATES

Friday Spotlight: Migrate Virtual Machines from VMware to Oracle VM

By: Simon Coter | Director of Product Management

We are very pleased to announce a new whitepaper and tool that help customers migrate virtual machines from VMware to Oracle VM.

More and more customers would like to move away from the high cost and proprietary virtualization solution to the open cloud infrastructure built on Oracle Linux and Oracle VM. In this white paper, we discuss 4 methods to approach what was a painful migration from VMware to Oracle VM; in fact, into this whitepaper you’ll find 4 different main chapters:

  • Migration using Open Virtualization Format (OVA)
  • Migration using data replication
  • Conversion using open-source utilities
  • Automated migration using CLI interfaces

And for each section above you’ll also have a Pros/Cons table that will help to address the migration with the best solution possible.

The “Automated migration tool” is a solution based on a very simple script that it’s able to interact with both VMware CLI and Oracle VM CLI interfaces with the target to automate the export/import job from VMware to Oracle VM.

This script has been released to help our customers to migrate their virtual machines to Oracle VM 3.4. Please feel free to write your ideas or possible improvements for the script on this blog post.

Source: https://blogs.oracle.com/virtualization/migrate-vms-from-vmware-to-ovm

 

 
May 12, 2017 Autoconfig Error after clone in 12.1.3 Instance
APPS DBAErrors/Workarounds-Applications

ERROR

Running autoconfig on a cloned instance , the below mentioned error occurred:

PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 32

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
adadmprf.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.

AutoConfig could not successfully execute the following scripts:
    Directory: /u01/ebs/oracle/inst/apps/test_mine/admin/install
      adadmprf.sh             INSTE8_PRF         1 

 

 

 

 

SOLUTION

1.RUN the Following given Query with APPS user and notedown the SID from Output:

  • select applications_system_name from applsys.fnd_product_groups; 

2.Update the entry with target instance name:

  •  update applsys.fnd_product_groups set applications_system_name = ‘<target instance>’; 

3.Run autoconfig again.

 

 
May 11, 2017 Quarterly EBS Upgrade Recommendations: May 2017 Edition
NEWS AND UPDATES

Quarterly EBS Upgrade Recommendations: May 2017 Edition

By: Steven Chan| Senior Director

We’ve previously provided advice on the general priorities for applying EBS updates and creating a comprehensive maintenance strategy.

Here are our latest upgrade recommendations for E-Business Suite updates and technology stack components.  These quarterly recommendations are based upon the latest updates to Oracle’s product strategies, latest support timelines, and newly-certified releases.

You can research these yourself using this Note:

Upgrade Recommendations for May 2017

EBS 12.2

 EBS 12.1

 EBS 12.0

 EBS 11.5.10
Check your EBS support status and patching baseline Apply the minimum 12.2 patching baseline
(EBS 12.2.3 + latest technology stack updates listed below)In Premier Support to September 30, 2023		 Apply the minimum 12.1 patching baseline
(12.1.3 Family Packs for products in use + latest technology stack updates listed below)In Premier Support to December 31, 2021		 In Sustaining Support. No new patches available.

Upgrade to 12.1.3 or 12.2

Before upgrading, 12.0 users should be on the minimum 12.0 patching baseline

 In Sustaining Support. No new patches available.

Upgrade to 12.1.3 or 12.2

Before upgrading, 11i users should be on the minimum 11i patching baseline
Apply the latest EBS suite-wide RPC or RUP 12.2.6
Sept. 2016		 12.1.3 RPC5
Aug. 2016		 12.0.6
11.5.10.2
Use the latest Rapid Install StartCD 51
Feb. 2016		 StartCD 13
Aug. 2011		 12.0.6 11.5.10.2
Apply the latest EBS technology stack, tools, and libraries AD/TXK Delta 9
Apr. 2017FND
Aug. 2016EBS 12.2.5 OAF Update 12
May 2017

EBS 12.2.4 OAF Update 15
Mar. 2017

ETCC
May 2017

Web Tier Utilities 11.1.1.9

Daylight Savings Time DSTv28
Nov. 2016

 12.1.3 RPC5

OAF Bundle 5
Jun. 2016

JTT Update 4
Oct. 2016

Daylight Savings Time DSTv28
Nov. 2016
Apply the latest security updates Apr. 2017 Critical Patch Update

SHA-2 PKI Certificates

SHA-2 Update for Web ADI & Report Manager

Migrate from SSL or TLS 1.0 to TLS 1.2

Sign JAR files

 Apr. 2017 Critical Patch Update

SHA-2 PKI Certificates

SHA-2 Update for Web ADI & Report Manager

Migrate from SSL or TLS 1.0 to TLS 1.2

Sign JAR files

 Oct. 2015 Critical Patch Update April 2016 Critical Patch Update
Use the latest certified desktop components Use the latest JRE 1.8, 1.7, or 1.6 release that meets your requirements.

Switch to Java Web Start

Upgrade to IE 11

Upgrade to Firefox ESR 52

Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016)

Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607)

 Use the latest JRE 1.8, 1.7, or 1.6 release that meets your requirements

Switch to Java Web Start

Upgrade to IE 11

Upgrade to Firefox ESR 52

Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016)

Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607)
Upgrade to the latest database Database 11.2.0.4 or 12.1.0.2 Database 11.2.0.4 or 12.1.0.2 Database 11.2.0.4 or 12.1.0.2 Database 11.2.0.4 or 12.1.0.2
If you’re using Oracle Identity Management Upgrade to Oracle Access Manager 11.1.2.3

Upgrade to Oracle Internet Directory 11.1.1.9

 Migrate from Oracle SSO to OAM 11.1.2.3

Upgrade to Oracle Internet Directory 11.1.1.9
If you’re using Oracle Discoverer Migrate to Oracle
Business Intelligence Enterprise Edition (OBIEE), Oracle Business
Intelligence Applications (OBIA).Discoverer 11.1.1.7 reaches End of Life June 2017		 Migrate to Oracle
Business Intelligence Enterprise Edition (OBIEE), Oracle Business
Intelligence Applications (OBIA).Discoverer 11.1.1.7 reaches End of Life June 2017
If you’re using Oracle Portal Migrate to Oracle WebCenter  11.1.1.9 Migrate to Oracle WebCenter 11.1.1.9 or upgrade to Portal 11.1.1.6 (End of Life Jun. 2017).

Source: https://blogs.oracle.com/stevenchan/quarterly-ebs-upgrade-recommendations%3a-may-2017-edition

 

 
May 11, 2017 ERROR While starting OACORE services in R12
APPS DBAErrors/Workarounds-Applications

 ERROR

ERROR While starting OACORE services in R12

(more…)
May 10, 2017 R12 : Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874
APPS DBAErrors/Workarounds-Applications

ERROR

R12 : Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874: warning in the execution of ODCIINDEXALTER routine

(more…)

Contact

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

    All Rights Reserved