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

December 16, 2022 ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called:
“APPS.AP_ACCTG_DATA_FIX_PKG”
ORA-06512: at line 38
(more…)

December 9, 2022 The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException
APPS DBAErrors/Workarounds-Applications

ERROR

<Error> <Store> <BEA-280061><The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException:
[Store:280105]The persistent file store “_WLS_AdminServer” cannot open file _WLS_ADMINSERVER000000.DAT.

(more…)

December 2, 2022 How to Get Apps Password From Backend
APPS DBAAppsDBA ScriptsInstallations/Configurations-ApplicationsOracle APPS DBAScripts

How to Get Apps Password From Backend

 

STEP 1.  First login to Database through Command Prompt

sqlplus / as sysdba

 

STEP 2 : Create Function From Below Script to decrypt the encrypted password

create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,
in_chr_encrypted_pin IN VARCHAR2)  
RETURN VARCHAR2 AS
LANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;

 

STEP 3 : Run the Below Query for Retrieving AppsPassword

SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;

ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873
AB2FFFA3B302AEE6EBD1

 

 

STEP 4:  Run the Below Query to get the Password

SELECT apps.decrypt_pin_func(‘GUEST/ORACLE123′,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1’) from dual;

APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1′)
——————————————————————————–
APPS

 

STEP 5:  Now Login With the Password Retrieved.

SQL> conn apps/APPS;
Connected.

 

November 17, 2022 Oracle E-Business Suite on Autonomous Database on Dedicated Exadata Infrastructure
APPS DBA

 

 Oracle E-Business Suite (EBS) Release 12.2 is now certified for Autonomous Database on Dedicated Exadata Infrastructure. Oracle runs best on Oracle. So, running Oracle applications on the Autonomous Database Dedicated is the obvious choice because it uses groundbreaking machine learning (ML)-backed automation to accelerate innovation, reduce costs, and reduce risks.

Autonomous Database on Dedicated Exadata Infrastructure

Before we dive into why you should run EBS on Autonomous Database Dedicated, let’s provide an overview of the Autonomous Database and its deployment on Dedicated Exadata Infrastructure. The Autonomous Database service takes a 19c converged database and runs it on Exadata, the world’s most optimized platform for running an Oracle database. Then we use artificial intelligence (AI), which allows Oracle to make decisions on how to optimize performance, security, resource efficiency, availability, and other aspects of the database.

These processes happen without the need for human intervention so all those routine tasks traditionally performed by database administrators (DBAs), like creating, running and maintaining backup scripts, installing updates, managing security, and optimizing performance are done by the Autonomous Database. Autonomous Database Dedicated is a specific type of deployment on Autonomous Database where you get an entire Exadata Cloud Infrastructure dedicated to you so only your workloads run on this infrastructure.

Benefits of running EBS on an Autonomous Database Dedicated

Now that we have a better understanding of Autonomous Database Dedicated, let’s get into why it’s the best way to run EBS. EBS is an enterprise application that runs your business and helps you meet financial reporting and regulatory requirements. It is business critical and, depending on your application architecture and which modules you’re using, it can be mission critical. So you want to be on dedicated Exadata infrastructure because it provides isolation and security that comes from being on single-tenant infrastructure. With this isolation, you also get predictable performance because you’re the only one using these resources. Plus, you get flexible maintenance where you can choose your own window for maintenance operations, although Oracle is responsible for performing the successful applications of the patches.

You get all these features and the benefits that come with being an autonomous database. You get improved personal efficiency with all those tasks like provisioning, patching, monitoring, tuning automated, which frees up developers and DBAs to innovate more. Automated tasks are quarterly database and other security patching, including operating system patching, which minimizes security vulnerabilities and reduces risk. The self-recovery, rolling self-updates, and scheduled maintenance features help maximize system availability. These features allow us to guarantee a service level agreement (SLA) of 99.995% for both planned and unplanned downtime.

The benefits of running EBS on Autonomous Database Dedicated aren’t limited to operational or technical but include business benefits too. You can close the books faster each month because with Autonomous Database Dedicated on Oracle Exadata Cloud Infrastructure X9M, you can complete those jobs in 33–50% less time. By closing the books faster, you get superior business insights that let you make timely and informed decisions to help give your company that competitive advantage. You can be better equipped to solve those complex, challenging problems to support the business. All your analytics queries (more efficient with Autonomous Database Dedicated’s self-tuning capabilities), database cloning, and much more can improve speed too.

So, with EBS on Autonomous Database Dedicated, you get more information faster, enabling your business to act more rapidly at significantly lower costs. Aside from staying in compliance with SOX, GDPR, and any other regulatory compliance framework, you also eliminate internal audit findings. You can rest assured that you’re up to date since patches are applied on time every quarter.

What’s covered

This initial certification announcement is for limited availability and includes specialized procedures to migrate existing EBS environments to Autonomous Database Dedicated. With EBS environments that have been migrated, you can back up, restore, clone, and patch Autonomous Database and integrate with Oracle Identity and Access Management (IAM) service.

As we continue to add more EBS support for Autonomous Database Dedicated, we plan to include the following features:

  • Support for larger capacity Exadata systems

  • Support for alternative file systems to provide optimal environment-specific performance

  • Ability to opt for a specific EBS Autonomous Database release update

  • Capability to perform EBS Autonomous Database upgrades

  • Higher system availability during scheduled maintenance

  • Support for disaster recovery procedures

Get started today

After learning about the benefits of running EBS on Autonomous Database Dedicated, you must want to how you can get started. We’re in the limited availability program, where we cater to early adopters to ensure that they have the best experience.

To join this program, you must meet the following requirements:

  • Be on or willing to move to the latest (specified) EBS code levels and to Oracle Database 19c
  • Be willing to deploy on Autonomous Database on Dedicated Exadata Infrastructure
  • Be an Oracle customer with an “early adopter” personality and don’t have a fixed or urgent deadline
  • Complete the qualification questionnaire available through the EBS on Autonomous Database program office

 

Source: https://blogs.oracle.com/cloud-infrastructure/post/ebs-adb-dedicated-exadata-infrastructure?_escaped_fragment_=

 

November 11, 2022 Oracle ACE Associate Award To Syed Saad Ali
APPS DBA

ORACLE ACE ASSOCIATE AWARD

 

Syed SaadAli ACE Associate

 

 

October 11, 2022 How to FIND Oracle EBS R12 Component Versions
APPS DBA

How to FIND Oracle EBS R12 Component Versions

 

 1.  How to Find Oracle EBS Application Version Release?

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
12.2.8

2 : How to Find Oracle Database Version Release?

SQL>  SELECT * FROM V$VERSION;

BANNER  CON_ID
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production         0
PL/SQL Release 12.1.0.2.0 – Production         0
CORE    12.1.0.2.0      Production         0
TNS for Linux: Version 12.1.0.2.0 – Production         0
NLSRTL Version 12.1.0.2.0 – Production         0

 

3: How to FIND Operating System Version?

 

OPERATING SYSTEM COMMANDS
SOLARIS cat /etc/release
RED HAT ENTERPRISE LINUX cat /etc/redhat-release
ORACLE LINUX cat /etc/oracle-release

 

4:  How to FIND Apache, Forms, Java, Reports, Perl, and Weblogic Version?

COMPONENTS COMMANDS
APACHE

$IAS_ORACLE_HOME/ohs/bin/httpd -v

$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

FORMS

frmcmp_batch | grep Version | grep Forms

$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

REPORTS

$ORACLE_HOME/bin/rwrun | grep Release

JAVA

#sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print$2}’ $ADMIN_SCRIPTS_HOME/java.sh` -version;”

#java -version

cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35

PERL

$IAS_ORACLE_HOME/perl/bin/perl -v | grep built

WEBLOGIC

cd $FMW_HOME/wlserver_10.3/server/lib

#java -cp weblogic.jar weblogic.version

 

 

Contact

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