How to apply the technology patches to EBS R12.2

We already know the general practice to apply application patches to R12.2 through online patching Adop(Ad online patching utility) explained R12.2 R12.2 Online patching cycle Summary Let’s explore the steps on how to apply database patches , weblogic patches , 10.1.2 patches , web-tier patches  to the R12.2 tech stack. We can apply the same online patching cycle for the below technology patches a. Weblogic … Continue reading How to apply the technology patches to EBS R12.2 »

how to perform relink in Oracle

Last updated on August 18th, 2019 at 05:52 pmSometimes Oracle components may start giving strange issues like coredump  or the Operating system is patched, In these cases it is always recommended to try oracle relink to resolve the issues.A Oracle relink is also necessary whenever you install a new release or a patchset or when there is a patch or upgrade to the OS environment. Oracle … Continue reading how to perform relink in Oracle »

How Parallel execution works in Oracle database

Last updated on September 1st, 2019 at 05:44 pmWhat is Parallel Execution in Oracle database This allows a single SQL statement to be executed by a multiple processes executing concurrently on different CPU’s. It increases throughput by utilizing more resources (Memory, CPU & I/O).It uses a pool of instance background processes (query slaves) .Based on Parallel Execution you are able to use more system resources … Continue reading How Parallel execution works in Oracle database »

LEAD and LAG : Oracle Analytic Functions

Last updated on August 18th, 2019 at 05:47 pmLead Function LEAD has the ability to compute an expression on the next rows (rows which are going to come after the current row) and return the value to the current row. The general syntax of LEAD is shown below: LEAD (<expr>, <offset>, <default>) OVER (<analytic_clause>) <expr> is the expression to compute from the leading row. <offset> … Continue reading LEAD and LAG : Oracle Analytic Functions »

Single row functions in Oracle sql

Last updated on September 2nd, 2019 at 05:06 pmThis is part of SQL tutorial and has good examples,explanation on single row functions in Oracle Sql Functions are programs that take zero or more arguments and return a single value. Functions can be single row ,multiple row functions We will be discussing here Single row functions in SQL What is single row functions in Oracle SQL … Continue reading Single row functions in Oracle sql »

how to use XMLImporter and FndXdfCmp in Oracle EBS

Last updated on August 18th, 2019 at 05:53 pmXMLImporter and FndXdfCmp are the implement utilities in Oracle E business Suite for implementing new schema definition and changes Here are the steps on how to use XMLImporter and FndXdfCmp XMLImporter java -classpath “${CLASSPATH}” oracle.jrad.tools.xml.importer.XMLImporter $APPL_TOP/ahl/12.0.0/mds/prd/webui/WorkorderDetailsRN.xml -username apps -password apps -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=exam.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TEST)))” -userId “1” -rootPackage /oracle/apps/ahl -rootdir $APPL_TOP/ahl/12.0.0/mds java -classpath “${CLASSPATH}” oracle.jrad.tools.xml.importer.XMLImporter $APPL_TOP/ahl/12.0.0/mds/prd/webui/WorkorderDocumentsRN.xml -username apps -password apps -dbconnection … Continue reading how to use XMLImporter and FndXdfCmp in Oracle EBS »

FNDCPASS and AFPASSWD

Last updated on August 18th, 2019 at 05:51 pmFNDCPASS is an important utility in EBS application and it is located in $FND_TOP/bin.  It is used to change password for apps schema, oracle EBS schema password and application user password change. $FNDCPASS FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS FNDCPASS apps/apps 0 Y system/manager ORACLE FNDCPASS apps/apps 0 Y system/manager USER When you execute FNDCPASS, it … Continue reading FNDCPASS and AFPASSWD »

How to work with date Functions in Oracle sql

Last updated on September 2nd, 2019 at 05:22 pmThis post I am trying to explain many things  about date in oracle like oracle sql date functions,oracle sql date format, oracle sql date comparison, oracle date difference in  years,oracle date difference in  days, oracle date difference in  months Oracle has provided date and timestamp type for storing the date and time information in the database. Date … Continue reading How to work with date Functions in Oracle sql »

How to List All Tables in Oracle

All the table and column information are stored in SYS.TAB$ and SYS.COL$ tables.  Oracle has provided data dictionary views  to get the information about table and columns There are three categories of  views To list all tables owned by the current user, select tablespace_name, table_name from user_tables; To list all tables in a Oracle database select owner,table_name,tablespace_name, from dba_tables; To list all tables accessible to … Continue reading How to List All Tables in Oracle »

Oracle DBA: Hanganalyze ,system state dump,v$wait_chains

Many times Oracle database get hangs due to locks or latching issue and Nobody can login to the system. It becomes critical and  And Usually we do shutdown abort to immediately resolve the issue. But  it is good to take system state dump/hanganalyze  at 1 min interval to analyze the locking or latching  issue afterwards before doing shutdown abort so that we can find the … Continue reading Oracle DBA: Hanganalyze ,system state dump,v$wait_chains »

How to find EBS R12 components Version

Last updated on August 31st, 2019 at 06:04 pmWe are often asked How to find EBS R12 components Version. This is includes all R12.0/R12.1 and R12.2. I will try to explain how to find out that with various EBS R12 version with command and reports. Apache Version $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Perl Version $IAS_ORACLE_HOME/perl/bin/perl -v|grep built Java Version/JDK Version sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print … Continue reading How to find EBS R12 components Version »

What is RAID(Redundant Array of Inexpensive Disks)

Last updated on September 24th, 2019 at 05:52 pmRAID stands for Redundant Array of Inexpensive Disks.Managing a large number of individual disk drives can be very difficult, since you must balance the database files across all of these disk drives in order to spread out the I/O load. In order to simplify this task, provide for optimal performance and to provide a fault tolerant system, … Continue reading What is RAID(Redundant Array of Inexpensive Disks) »