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
October 10, 2017 Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE
Errors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Oracle error – 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE
(USERNAME=SYSADMIN)
(ROLENAME=FND_RESP|FND|FND_FUNC_ADMINI|STANDARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has
been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

SOLUTION

This Issue exists in default R12 installation

Step 1. Run the concurrent program “Workflow Directory Services User/Role Validation” with parameters : 100000, Yes, Yes, No

Step 2. Bounce all services under oacore or bounce opmnctl .

Reference Oracle Note id : 454988.1

 

 
October 6, 2017 Data Guard Vs SAN To SAN Replication
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Data Guard Vs SAN to SAN Replication
 

Oracle Data Guard

SAN-to-SAN

Implementation Cost

 Low High

Database Aware

 Yes No

Granularity of Replication

 Transaction level Disk Block Level

Distance Limitations

 No Limitations Limitations Exist

Recovery from human error or corruption

 Easy to detect and can be recovered by replaying logs Replicates block as it is and possible that corrupt blocks gets replicated.
October 6, 2017 Comparison Between Oracle GoldenGate and DataGuard
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Comparison Between Oracle GoldenGate and DataGuard

Technical Points

Oracle Dataguard / Active Dataguard

Oracle Golden Gate
Operating System Primary Database and Standby Database Should be same. (But 11g Onwards it supports Heteregenous Data Guard Configurations.                       Example : We can imeplement Oracle Data Guard between Oracle Linux server 6.2 (x86_64)  and Microsoft Windows 2008 Server R2 (x64) Primary Database and Standby Database need not be same.
Database Should be Oracle Database in both Source and Target. Database can be different in Source and Target. Example :Source database can be Oracle and Target database can be MY SQL/MS SQL server.
Database Version Primary Database and Standby Database Should be same. Primary Database and Standby Database need not be same. (Including Database Software).
Replication method Data movement will be in-form of Log Files. It moves Data Transaction wise through Extract and Replicat process from Source to Target, when commits.
Database mode Source: Read write mode
Target:  Recovery Mode / Open Read Only.		 Source: Read write mode
Target:  Read write mode
Replication Type Unidirectional. (Data movement will happen in single direction). Multi-Directional.
Integrated Feature No additional software to install. Oracle Data Guard /Active Data Guard includes in Enterprise Edition. Oracle GoldenGate software to install in Source as well as Target.
License Cost No additional license required for Oracle Data Guard to install. Oracle Active Data Guard is an enterprise option with Oracle Enterprise Edition. Oracle GoldenGate Software Licence required in Source and Target Databases.
Database Edition Source: Oracle Enterprise Edition
Target: Oracle Enterprise Edition.		 Source: Can be Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One
Target:  Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One
October 6, 2017 Generating AWR Reports
Database ScriptsOracle Database Material

Generating AWR Reports

You can generate AWR reports by running SQL scripts, as described below :-

# Generating an AWR Report

@$ORACLE_HOME/rdbms/admin/awrrpt.sql

 

# To generate an AWR report on a specific database instance:

@$ORACLE_HOME/rdbms/admin/awrrpti.sql

 

# To generate an AWR report in an Oracle RAC environment: 

@$ORACLE_HOME/rdbms/admin/awrgrpt.sql

 

#To generate an AWR report on a specific database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgrpti.sql

 

# To generate an AWR report for a particular SQL statement:

@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql

 

# To generate an AWR report for a particular SQL statement on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrsqrpi.sql

 

#To generate an AWR Compare Periods report:

@$ORACLE_HOME/rdbms/admin/awrddrpt.sql

 

# To generate an AWR Compare Periods report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpt.sql

 

# To generate an AWR Compare Periods report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/awrddrpi.sql

 

# To generate an AWR Compare Periods report on a specified database instance in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/awrgdrpi.sql

 

# To generate an ASH report:

@$ORACLE_HOME/rdbms/admin/ashrpt.sql

 

# To generate an ASH report on a specified database instance:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

 

# To generate an ASH report in an Oracle RAC environment:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

 

 
October 6, 2017 RMAN Backup Script for Windows
Uncategorized

RMAN Backup Script for Windows

Create Batch file named as rmanbackup.cmd and copy the below given script in that batch file.

set oracle_sid=orcl
rman target sys/passwd nocatalog cmdfile=’c:\app\rman\rmanbkp.cmd’ log=’c:\app\rman\bkp_log.log’

—————

–rmanbackup.cmd

run
{
allocate channel d1 type disk;
backup
tag whole_database_open
format ‘c:\app\archive\db_%t_%s_p%p’
database;
sql ‘alter system archive log current’;
sql ‘alter system archive log current’;
backup archivelog all
format ‘c:\app\archive\al_%t_%s_p%p’
delete all input;
delete noprompt obsolete;
backup current controlfile
tag =cf1
format ‘c:\app\archive\cf_%t_%s_p%p’;
}

 

 
October 6, 2017 Find and Delete Older Files in Linux
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Delete Older Files in Linux

 

Files older than 1 day

find /rman/arch/*.dbf -mtime +1 -exec mv {} /rman/archbkp/ \;

 

Move files older than 25 hours

find /rman/arch/*.dbf -mmin +1500 -exec mv {} /rman/archbkp/ \;

 

List files older than 2hours

find /rman/arch/*.dbf -mmin +120 -exec ls -ltr {} \;

 

Delete files older than 1 day

find /rman/arch/*.dbf -mtime +1 -exec rm {} \;

 

Delete files older than 1 hours

find /rman/arch/*.dbf -mmin +60 -exec rm {} \;

 

 

Contact

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

    All Rights Reserved