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

November 7, 2017 opmnctl start: failed. Can not resolve test.oracle.com for interface any
APPS DBAErrors/Workarounds-Applications

ERROR

OPMN ERROR:
———-
Can not resolve test.oracle.com for interface any 
opmnctl start: failed.

(more…)

November 7, 2017 ELFCLASS64 at /usr/lib64/perl5/XSLoader.pm line 70
APPS DBAErrors/Workarounds-Applications

ERROR

=============================================
*** Latest formsapp.ear has been deployed ***
=============================================

Program : /u01/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Tue Sep 4 05:45:23 2015
Perl script txkChkFormsDeployment.pl got executed successfully
(more…)

November 7, 2017 How To Setup Printers on Oracle Apps
APPS DBAInstallations/Configurations-Applications

How To Setup Printers on Oracle Apps

Defined Printer at Unix OS level

First check the status of printer at unix level by issuing the following command:

$lpstat –a

Step To Configure Printer in Oracle Applications

  1. Define Driver

  2. Define Style

  3. Define Printer Type

  4. Register the Printer

1. Define Driver

  • Login to application using System Administrator or Application Administrator

Navigation : Install > Printer > Driver

Please provide the below values (depending upon your configuration) to set up.

Enter the Driver Name: ERW2PAPER

Enter the User Driver Name: HPLJ4- For Employers Paper W2

Description: Potrait printing for Employer’s Paper W2

SRW Driver: LW2

SRW drivers are read by Oracle reports when a report is run and insert control characters which tell the destination printer on where to insert the page breaks and font to be used. SRW driver is used when output file is sent to the printer

SRW driver files on  unix are  located  in $FND_TOP/reports.

2. Define Printer Style

Navigation : Install > Printer > Style

Login to application using System Administrator or Application Administrator Responsibility.

Please provide the below values (depending upon your configuration) to set up.

Style Name : HPW

Seq: Enter unique sequence number

User Style: LANDWIDE – HPLJ4

SRW Driver: HPW , this should match with driver define page

Layout: Columns,Rows 

Orientation: Columns  and  Rows  inserted  here override the height and width defined in SRW driver file

3. Define Printer Type

Navigation: Install > Printer > Type

Please provide the below values (depending upon our configuration) to set up.

Type: HPLJ4SI

Style: Style name

Driver Name: Driver name

4. Register New Printer

Navigation : Install > Printer > Register

Login to application using System Administrator or Application Administrator Responsibility.

Please provide the below values (depending upon your configuration) to set up.

Printer: Printer Name

Type: Type defined earlier

Description: Useful description

November 3, 2017 An Introduction to Financial Statement Generator (FSG)
Configurations-GLGeneral LedgerOracle Functional

An Introduction to Financial Statement Generator (FSG)

Financial Statement Generator

The Financial Statement Generator (FSG) is a powerful reporting engine that supports interchangeable report objects, server-based processing for high performance, and report scheduling for efficient use of system resources. You can define reports on-line with complete control over the rows, columns and contents of your report.

Features

  • Standard reports are generally more detailed than FSG.s and many focus on transaction level detail.
  • FSG report shows off account balances in General Ledger only.
  • Oracle Financial Statement Generator builds reports using re-useable components.
  • In order to create a report you must first define each of the component parts, which may include:
    • Row Set
    • Column Set
    • Content Set
    • Row Order
    • Display Set
  •  You must combine at least a row set and a column set to produce the reports you need.
  • You may group reports into report sets.

Row Set

A report component you build within Oracle by defining all of the rows in your report. For each row, you control the format and content, including line descriptions, indentations, spacing, page breaks, calculations, units of measure, precision and so on. For example, you might define a standard balance sheet row set.

Column Set

A column set defines the format and content of the columns in an FSG report. In FSG, the commonly assumed attribute for a column definition is a time period (amount type), whereas the attribute for a row definition is an account assignment. Therefore, typical column sets include headings and subheadings, amount types, format masks, currency assignments, and calculation columns for totals.

Content Set

A report component that you build within Oracle that defines the information in each report and the printing sequence of your reports. For example, you can define a departmental content set which prints one report for each department.

Row Order

A report component that you use to modify the current order of rows and Accounting Flexfield segments in your report. You can rank your rows in ascending or descending order based on a selected column and rearrange the sequence of segments in your Accounting Flexfield. For example, if you want to review Total Expenditures in descending order by project, you can rank your rows in descending order by the Total Expenditures column and rearrange your segments so that project appears first on your report.

Display Set

A Financial Statement Generator report component that you build within Oracle to control the display of ranges of rows and/or columns in a report, without reformatting the report or losing header information. You can define a display set which works for reports that use specific row and column sets. Or, you can define a generic display set which works for any report, regardless of its row and column set.

Extensible Business Reporting Language XBRL

eXtensible Business Reporting Language (XBRL) is an open specification for software that uses Extensible Markup Language (XML) data tags, together with a taxonomy, to describe business reporting, including financial information. An XBRL taxonomy is a standard description and classification system for the contents of accounting reports.

November 1, 2017 unable to spawn jobq slave process, slot 0, error 1089
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

ERROR

kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089

(more…)

November 1, 2017 Temporary Tablespace and Datafile Management in Oracle database
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Temporary Tablespace and Datafile Management in Oracle database

1.  For Finding temp file and temp tablespace with size

SELECT file#, 
       status, 
       bytes / 1024 / 1024 “Size_MB”, 
       name 
FROM   v$tempfile; 

SELECT file_name, 
       tablespace_name, 
       bytes / 1024 / 1024 / 1024, 
       status 
FROM   dba_temp_files; 

2. Add tempfile to existing temp tablespace

SQL>ALTER TABLESPACE temp ADD tempfile ‘/u02/apps/oracle/temp01_01.dbf’ SIZE 
2048m; 

3. Add new temp tablespace and make as default

SQL>CREATE TEMPORARY TABLESPACE temp2 tempfile ‘/u02/apps/oracle/temp01.dbf’ SIZE 2g autoextend ON;

SQL>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2; 

Note: use “reuse” if datafile physically exists.

4. Making old Temporary Tablespace Offline

SQL>ALTER DATABASE tempfile ‘/u02/apps/oradata/temp01.dbf’ OFFLINE; 

5. Drop Temporary Tablespace 

SQL>DROP TABLESPACE temp INCLUDING CONTENTS AND datafiles;

NOTE: Don’t drop immediatly, Check user is using TEMP tablespace by the Below Given Query, then you can drop

SELECT a.username, 
       a.osuser, 
       a.sid 
       ||‘,’ 
       ||a.serial#                  SID_SERIAL, 
       c.spid                       Process, 
       b.tablespace                 tablespace, 
       a.status, 
       SUM(b.extents) * 1024 * 1024 SPACE 
FROM   v$session a, 
       v$sort_usage b, 
       v$process c, 
       dba_tablespaces d 
WHERE  a.saddr = b.session_addr 
       AND a.paddr = c.addr 
       AND b.tablespace = d.tablespace_name 
GROUP  BY a.username, 
          a.osuser, 
          a.sid 
          ||‘,’ 
          ||a.serial#, 
          c.spid, 
          b.tablespace, 
          a.status; 

6. Shrink Temporary Tablespace

SQL>ALTER TABLESPACE temp shrink tempfile ‘/u02/apps/oradata/temp01.dbf’ keep 10g;

Contact

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