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: 37
  • 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
2024-
Senior Apps DBA
Private Contractor
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
Senior Apps DBA
2022- 2024
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
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
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
September 1, 2017 RAC Useful Views And Tables
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

RAC Useful Views And Tables

GCS and Cache Fusion Diagnostics
v$cache contains information about every cached block in the buffer cache
v$cache_transfer contains information from the block headers in SGA that have been pinged at least once
v$instance_cache_transfer contains information about the transfer of cache blocks through the interconnect
v$cr_block_server contains statistics about CR block transfer across the instances
v$current_block_server contains statistics about current block transfer across the instances
v$gc_element contains one-to-one information for each global cache resource used by the buffer cache

GES diagnostics
v$lock contains information about locks held within a database and outstanding requests for locks and latches
v$ges_blocking_enqueue contains information about locks that are being blocked or blocking others and locks that are known to the lock manager
v$enqueue_statistics contains details about enqueue statistics in the instance
v$resource_limits display enqueue statistics
v$locked_object contains information about DML locks acquired by different transactions in databases with their mode held
v$ges_statistics contains miscellaneous statistics for GES
v$ges_enqueue contains information about all locks known to the lock manager
v$ges_convert_local contains information about all local GES operations
v$ges_convert_remote contains information about all remote GES operations
v$ges_resource contains information about all resources known to the lock manager
v$ges_misc contains information about messaging traffic information
v$ges_traffic_controller contains information about the message ticket usage

Dynamic Resource Remastering
v$hvmaster_info contains information about current and previous master instances of GES resources in relation to hash value ID of resource
v$gcshvmaster_info the same as above but globally
v$gcspfmaster_info conatins information about current and previous masters about GCS resources belonging to files mapped to a particular master, including the number of times the resource has remastered

Cluster Interconnect
v$cluster_interconnects contains information about interconnects that are being used for cluster communication
v$configured_interconnects same as above but also contains interconnects that AC is aware off that are not being used

Miscellanous
v$service services running on an instance
x$kjmsdp display LMS daemon statistics
x$kjmddp display LMD daemon statistics

 

 

 
September 1, 2017 RAC Files and Directories
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

RAC Files and Directories

 

$ORA_CRS_HOME/cdata/<cluster_name>

 OCR backups (default location)

$ORA_HOME/log/<hostname>/client/ocrconfig_<pid>.log

 OCR command log file

$ORA_CRS_HOME/crs/log

 contains trace files for the CRS resources

$ORA_CRS_HOME/crs/init

 contains trace files for the CRS daemon during startup, a good place to start

$ORA_CRS_HOME/css/log

 contains cluster reconfigurations, missed check-ins, connects and disconnects from the client CSS listener. Look here to obtain when reboots occur

$ORA_CRS_HOME/css/init

 contains core dumps from the cluster synchronization service daemon (OCSd)

$ORA_CRS_HOME/evm/log

 logfiles for the event volume manager and eventlogger daemon

$ORA_CRS_HOME/evm/init

 pid and lock files for EVM

$ORA_CRS_HOME/srvm/log

 logfiles for Oracle Cluster Registry (OCR)

$ORA_CRS_HOME/log

 log fles for Oracle clusterware which contains diagnostic messages at the Oracle cluster level

 

 
September 1, 2017 APP-FND-01542 : This Application Server is not authorized to access this system
APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your system administrator.

(more…)
September 1, 2017 RAC Acronyms in Used
APPS DBAInstallation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Real Application Cluster Acronyms

GCS

 Global Cache Services in memory database containing current locks and awaiting locks, also known as PCM

GES

 Global Enqueue Services coordinates the requests of all global enqueues uses the GCS, also known as non-PCM

GRD

 Global Resource Directory all resources available to the cluster (formed and managed by GCS and GES), see GRDfor more details

GRM

 Global Resource Manager helps to coordinate and communicate the locks requests between Oracle processes

GSD

 Global Services Daemon runs on each node with one GSD process per node. The GSD coordinates with the cluster manager to receive requests from clients such as the DBCA, EM, and the SRVCTL utility to execute administrative job tasks such as instance startup or shutdown. The GSD is not an Oracle instance background process and is therefore not started with the Oracle instance

PCM (IDLM)

 Parallel Cache Management formly know as (integrated) Distributed Lock Manager, its another name for GCS

Resource

 n/a it is a identifiable entity it basically has a name or a reference, it can be a area in memory, a disk file or an abstract entity

Resource (Global)

 n/a a resource that can be accessed by all the nodes within the cluster examples would be the following

Data Buffer Cache Block

Transaction Enqueue

Database Data Structures

LVB

 Lock Value Block contains a small amount of data regarding the lock

TRFC

 Traffic Controller controls the DLM traffic between instances (messaging tickets)

 

 
August 30, 2017 August 2017 Update to E-Business Suite Technology Codelevel Checker (ETCC)
NEWS AND UPDATES

August 2017 Update to E-Business Suite Technology Codelevel Checker (ETCC)

By: Steven Chan| Senior Director

The E-Business Suite Technology Codelevel Checker (ETCC) tool helps you identify application or database tier overlay patches that need to be applied to your Oracle E-Business Suite Release 12.2 system. ETCC maps missing overlay patches to the default corresponding Database Patch Set Update (PSU) patches, and displays them in a patch recommendation summary.

What’s New

ETCC has been updated to include bug fixes and patching combinations for the following recommended versions of the following updates:

  • July 2017 Database 12.1.0.2 PSU and Proactive Bundle Patch
  • July 2017 Database 11.2.0.4 PSU and Engineered Systems Patch

Obtaining ETCC

We recommend always using the latest version of ETCC, as new bugfixes will not be checked by older versions of the utility. The latest version of the ETCC tool can be downloaded via Patch 17537119 from My Oracle Support.

References

Source:https://blogs.oracle.com/stevenchan/august-2017-update-to-e-business-suite-technology-codelevel-checker-etcc

 

 

 
August 27, 2017 Can Oracle Label Security be Used with EBS 12.2?
Oracle APPS DBA

Can Oracle Label Security be Used with EBS 12.2?

By: Steven Chan | Senior Director

Yes, Oracle Label Security (OLS) can be used with EBS 12.2.  It can also be used for earlier EBS releases such as EBS 12.1 and 12.0.

Oracle Label Security is an optional database-level technology for developing customized security schemes. It is possible to use this technology to customize EBS 12.2.

There is no documentation for using this technology with EBS 12.2. The principles described in the following note for EBS 11i are generally-applicable to customizing later EBS releases such as EBS 12.1 and 12.2:

What are the support implications of using OLS with EBS?

This is a technology used for customizing EBS.  The standard support implications for customizations apply to customizations created with OLS:

Related Articles

Source: https://blogs.oracle.com/stevenchan/can-oracle-label-security-be-used-with-ebs-122

Contact

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

    All Rights Reserved