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

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

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.

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

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

2008 - 2011

Newports Institute Of Communication & Economics

Pakistan

Newports Institute Of Communication & Economics offers a B.S. in Computer Science.

Certificate

2013

Oracle University

USA

Oracle E-Business Suite R12 Financials Certified Expert Consultant, PAYABLES

Certificate

2013

Oracle University

USA

Oracle E-Business Suite R12 Financials Certified Expert Consultant, PAYABLES

Certificate

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

Works

Projects

Oracle Cloud Infrastructure Projects

Content

Oracle E-Business Suite Upgrade Project

Blog

May 31, 2017 How to restart ADOP from FAILED session – R12.2 Online Patching

APPS DBAInstallations/Configurations-Applications

How to restart ADOP from FAILED session – R12.2 Online Patching

Sometimes during prepare or apply phase of ADOP, some error occurs and you wants to Restart the ADOP session.

Perform following steps.:

$adop phase=abort
Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:

Please wait. Validating credentials…

.
.
.
.
.
.
.
.
adop phase=abort – Completed Successfully

Log file: /u01/appltest/fs_ne/EBSapps/log/adop/40/adop_20141257_01987.log
adop exiting with status = 0 (Success)
$

May 31, 2017 Oracle APPLICATION R12 Log File Locations

APPS DBAInstallations/Configurations-Applications

APPS R12 LOG FILE LOCATIONS

Log files are useful in troubleshooting issues in Oracle Applications. Below is the given list of Log file location in Oracle Applications for Startup/Shutdown, Cloning, Patching, DataBase & Apps Listener and various components in ORACLE Apps R12/11i:

1.Startup/Shutdown Log files for Application Tier in R12

Instance Top is new TOP added in R12

Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt…

$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web)

$INST_TOP/apps/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3)
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp]
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/opmn/ (OC4J~…,oa*,opmn.log)
$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.2/network/ (listener log)
$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log (CM log files)

2. Cloning Log files in R12

Preclone log files in source instance

Database Tier

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log)

Application Tier

$INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log)

Clone log files in target instance

Database Tier

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log

Apps Tier

$INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log

3. Patch related log files in R12

Application Tier adpatch log

$APPL_TOP/admin/$SID/log/

Developer (Developer/Forms & Reports 10.1.2) Patch

$ORACLE_HOME/.patch_storage

Web Server (Apache) patch

$IAS_ORACLE_HOME/.patch_storage

Database Tier opatch log

$ORACLE_HOME/.patch_storage

4. Autoconfig related log files in R12

Database Tier Autoconfig log :

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/adconfig.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/MMDDHHMM/NetServiceHandler.log

Application Tier Autoconfig log –

$INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log

Autoconfig context file location in R12 –

$INST_TOP/apps/$CONTEXT_NAME/appl/admin/$CONTEXT_NAME.xml

5. Other log files in R12

1.Database Tier

Relink Log files :
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME /MMDDHHMM/ make_$MMDDHHMM.log
Alert Log Files
$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
Network Logs :
$ORACLE_HOME/network/admin/$SID.log
OUI Inventory Logs :
$ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs

2.Application Tier

$ORACLE_HOME/j2ee/DevSuite/log
$ORACLE_HOME/opmn/logs
$ORACLE_HOME/network/logs
Tech Stack Patch 10.1.3 (Web/HTTP Server)
$IAS_ORACLE_HOME/j2ee/forms/logs
$IAS_ORACLE_HOME/j2ee/oafm/logs
$IAS_ORACLE_HOME/j2ee/oacore/logs
$IAS_ORACLE_HOME/opmn/logs$IAS_ORACLE_HOME/network/log
$INST_TOP/logs/ora/10.1.2
$INST_TOP/logs/ora/10.1.3
$INST_TOP/logs/appl/conc/log
$INST_TOP/logs/appl/admin/log

May 31, 2017 object ‘/lib/libcwait.so’ from /etc/ld.so.preload cannot be preloaded

APPS DBAErrors/Workarounds-Applications

ERROR

ld.so: object ‘/lib/libcwait.so’ from /etc/ld.so.preload cannot be preloaded: ignored.
Changes
Check compat-libcwait-2.1-1.i386.rpm was installed if yes

SOLUTION

1- Move the “libcwait.so” library from “/usr/lib” to “/lib”.

2. Modify the path given in the file “/etc/ld.so.preload” to point to the new location.

3- Download and Install compat-libcwait-2.1-2 of 64 bit with Root user.

# rpm -e compat-libcwait-2.1-1.i386
# rpm -ivh compat-libcwait-2.1-2.x86_64.rpm

NOTE: Download from compat-libcwait-2.1-2

May 31, 2017 Unable to locate ‘linkxlC’ utility in path

APPS DBAErrors/Workarounds-Applications

ERROR

$ adcfgclone.pl dbTechStack
                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                        Oracle Applications Rapid Clone
                                 Version 12.0.0
                      adcfgclone Version 120.31.12010000.8
Enter the APPS password :
no linkxlC in /u01/ebs/db/11.2.0/appsutil/clone/bin/../jre/bin /usr/bin /etc /usr/sbin /usr/ucb /home/oradev/bin /usr/bin/X11 /sbin /u01/ebs/db/11.2.0/bin .
Checking for make…    found – /usr/bin/make
Checking for ld…     found – /usr/bin/ld
Checking for linkxlC…
Unable to locate ‘linkxlC’ utility in path
Checking for ar…     found – /usr/bin/ar
Unable to locate all utilities with system path.
PATH = /u01/ebs/db/11.2.0/appsutil/clone/bin/../jre/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oradev/bin:/usr/bin/X11:/sbin:/u01/ebs/db/11.2.0/bin:.

WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above
$

SOLUTION

1. Check the linkxlC path in Linux by typing below command.

$ which linkxlC

/usr/oracle/bin/linkxlC

2.Export Path for linkxlC

$ export PATH=/usr/oracle/bin:$PATH

3. Run adcfgclone again:

$ adcfgclone.pl dbTechStack

May 31, 2017 Unable to authenticate session in Oracle apps R12 (12.0.4): Login Issue

APPS DBAErrors/Workarounds-Applications

ERROR

Unable to authenticate session in Oracle apps R12 (12.0.4): Login Issue

It is in the following log file:

$INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log

15/09/19 05:45:20.601 10.1.3.0.0 Started

15/09/19 05:45:30.769 html: 10.1.3.0.0 Started

15/09/19 05:45:35 .132 html: oracle.apps.fnd.security.LeakDetectionFilter.initialized:1219349853132

15/09/19 05:45:38.132 html: LeakSetting:

global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false

ignoring:null

15/09/19 05:45:45.859 html: chain failed

javax.servlet.ServletException: java.lang.RuntimeException: Unable to create user session. Please contact your System Administrator.

at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:780)

SOLUTION

1.Enable FND debug

The FND debug log would have below error:

Oracle error -1654: ORA-01654: unable to extend index APPLSYS.FND_LOGINS_N2 by 16 in tablespace APPS_TS_ARCHIVE has been detected in FND_SIGNON.AUDIT_USER.

2.Check if the APPS_TS_ARCHIVE Tablespace is full.

3.Increase the size of tablespace APPS_TS_ARCHIVE by adding a datafile to the tablespace.

May 27, 2017 Recommended Database Parameters Updated for EBS 12.2

NEWS AND UPDATES

Recommended Database Parameters Updated for EBS 12.2

By: Steven Chan | Senior Director

We publish a definitive list of Oracle Database initialization parameter settings for the optimal performance of Oracle E-Business Suite 12.2, 12.1, and 12.0:

Database Initialization Parameters for Oracle E-Business Suite Release 12 (Note 396009.1)

This document covers all Oracle Database releases that are certified with EBS 12.x, including:

Oracle Database 12c Release 1 (12cR1)
Oracle Database 11g Release 2 (11gR2)
Oracle Database 11g Release 1 (11gR1)
Oracle Database 10g Release 2 (10gR1)

This document has just been updated with new information about the service_names parameter introduced in the April 2017 updates to the AD and TXK utilities.

Source: https://blogs.oracle.com/stevenchan/recommended-database-parameters-updated-for-ebs-122

Contact

Get in Touch

Address: Karachi, PAKISTAN
Email: askme@SyedSaadAli.com
Phone: +92-300-026-5668
Freelance: Available

Contact Form