Author: Syed Saad Ali

September 6, 2017 Oracle’s Booming Cloud Business Could Rip And Replace SAP As #1 In Apps

NEWS AND UPDATES

Oracle’s Booming Cloud Business Could Rip And Replace SAP As #1 In Apps

Opinions expressed by Forbes Contributors are their own.

Oracle founder and chairman Larry Ellison believes cloud computing gives Oracle the chance to overtake archrival SAP in enterprise apps. (Photo by Ezra Shaw/Getty Images)

(Note: After an award-winning career in the media business covering the tech industry, Bob Evans was VP of Strategic Communications at SAP in 2011, and Chief Communications Officer at Oracle from 2012 to 2016. He now runs his own firm, Evans Strategic Communications LLC.)

CLOUD WARS – Cloud computing, which has already triggered massive disruptions across industries in business models and traditional pecking-orders, is giving Oracle Corp. a once-in-a-generation chance to displace arch-enemy SAP as the world leader in enterprise applications.

For decades, SAP has been the world leader in enterprise applications and Oracle has been the frontrunner in enterprise databases, with both companies retaining their leadership positions in spite of the seismic shifts in the industry caused by the moves from mainframes to minicomputers to client-server to the Internet.

Oracle’s recent surge in cloud-applications revenue—it sold $1 billion in SaaS apps during the quarter ended May 31 and $3.4 billion for the year—give it a legitimate chance to overtake SAP as the world’s #1 provider of enterprise applications, particularly in the massive cloud ERP market.

In the combined category of on-premise apps plus cloud apps, it’s still not very close as SAP’s revenue for that category doubles that of Oracle for the corresponding set of products and services:

Oracle: For the 3 months ending May 31, it reported combined applications revenue of $2.86 billion: $964 million for SaaS apps and $1.9 billion for on-premise (see full details on page 10 of the Oracle press release).
SAP: For the 3 months ending June 30, it reported combined applications revenue for cloud plus on-premise of $5.61 billion (see full details on page 7 of the SAP press release).

But in that same Q4, Oracle’s SaaS revenue (non-GAAP) of $1.0 billion was up 76% over the year-earlier period—and during its June 21 earnings call with analysts, Oracle executives emphasized that every financial KPI they monitor for SaaS points to even bigger and better numbers for the coming quarter, which will end Aug. 31.

And standing out prominently among all that growth was Oracle’s Cloud ERP business, which CEO Mark Hurd said is now on an annualized run rate of $1.2 billion after Q4 revenue soared 156% over the year-earlier period.

Triggering that steep growth, said Hurd, were 868 new Cloud ERP customers in Q4, plus 200 more “expansions” from customers that were added more of the Oracle Cloud ERP services to ones they’d purchased previously.

As businesses jump to the cloud to accelerate innovation and engage more intimately with customers, my Cloud Wars series analyze the major cloud vendors from the perspective of business customers.

Source: https://www.forbes.com/sites/bobevans1/2017/08/02/oracles-booming-cloud-business-could-rip-and-replace-sap-as-1-in-apps/#577f898c546c

September 1, 2017 How To Trace Concurrent Programs

APPS DBAErrors/Workarounds-ApplicationsInstallations/Configurations-Applications

How To Trace Concurrent Programs

CASE 1 : Concurrent Program Tracing without bind variables

1) Follow the following navigation to enable logging for Concurrent Program

Goto Sysadmin > Concurrent > Program > Define
Query the concurrent program
Check the trace box to enable trace

2) Execute the concurrent program and note down the request id

CASE 2: Concurrent Program Tracing with bind variables and waits

1) Note down the following values

SQL>SELECT value FROM v$parameter WHERE name = “max_dump_file_size”;
SQL>SELECT value FROM v$parameter WHERE name = “timed_statistics”;

2) Execute the following commands as sysdba

SQL>ALTER SYSTEM SET max_dump_file_size = unlimited;
SQL>ALTER SYSTEM SET timed_statistics = true;
SQL>ALTER SYSTEM SET EVENTS ‘10046 trace name context forever, level 12’;

3) Execute the concurrent program and note down the request id

4)Turn off tracing the reset the values.

SQL>ALTER SYSTEM SET EVENTS ‘10046 trace name context off’;
SQL>ALTER SYSTEM SET max_dump_file_size = <value from step 1>;
SQL>ALTER SYSTEM SET timed_statistics = <value from step 1>;

CASE 3: Enabling the trace for a concurrent request for which you donot have privileges to run the concurrent Request.

1) Now, Run the concurrent program and get the request id .

2) Get the oracle_process_id for that concurrent request.

SELECT request_id,
oracle_process_id
FROM fnd_concurrent_requests
WHERE request_id IN (“xxxxxxx”);

3) Now get the session details ( SID and Serial ) using value obtained from step 2

col “SID/SERIAL” format a10 col username format a15
col osuser format a15 col program format a40
SELECT s.sid
|| “,”
|| s.serial# “SID/SERIAL”,
s.username,
s.osuser,
s.status,
p.spid       “OS PID”,
s.inst_id,
s.MODULE
FROM   sys.gv_$session s,
sys.gv_$process p
WHERE  s.paddr = p.addr
AND s.inst_id = p.inst_id
AND p.spid = &value_from_step2
ORDER  BY To_number(p.spid);

4) Execute the following command to enable the trace :

EXECUTE dbms_support.start_trace_in_session (&sid, &serial, binds=>true, waits=>
true);

5) Collect the trace from udump location and investigate the issue.

Reference Metalink Note: 296559.1 to know more about tracing.

September 1, 2017 Troubleshooting AD Controller

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

Fixing a “Failed” worker

Whenever a job fails for the 1st time, the job is deferred at the end of the phase and another job is assigned to that worker.

What If the Job Fails 2nd Time?

If the run time of the job was < 10 min => the job is deferred at the end of the phase and another job is assigned to that Worker.
if the run time of the job was >= 10 min => then the job status will be shown as “Failed”.

What If the job fails 3nd time?

If the Job fail third time the job status will be shown as “Failed”.

Review the Worker log information into

$APPL_TOP/admin/<SID>/log/adworkNNN.log

Example: adwork001.log name for the worker number 1.

After fixing error, start (if is not already started) AD Controller and to use the option 2 “Tell worker to restart a failed job”.

When prompted we have to specify the worker which must be restarted.

If all the workers are failed, we can type all to restart all Workers.

Restarting a Failed Patch Process

During a patch process (or adadmin process) if a job fails and cannot be restarted, then the patch must be restarted.

Here are the steps for doing this:

Tell worker to quit (for all workers) => to manually shutdown/ quit the workers
Tell manager that a worker failed its job
Tell manager that a worker acknowledges quit => the manager will stop, the AutoPatch will restart the patch

PLEASE NOTE: When the patch will restart all the information in the database about this session must be accurate.

How to determine if a process is Hanging or not

We can check the log file to see if some information is added or not to the log
We can determine if the worker process is consuming CPU by issuing below

$ ps -eo pcpu,pid,user,args | grep workerid

3.We check if there are any child processes, which are consuming CPU by issuing following command:

$ ps -eo pcpu,pid,ppid,user,args | grep <Parent Process> | grep -v grep

Restarting a Hanging Worker Process

1. kill at the OS level the processes associated with the Hanging Worker

$ kill -9 ProcesssNumber

2. fix the problem

3. Restart the worker (or the job)

Restart an AD utility after a Node Crash

a. Start AD Controller

b. Choose “4. Tell manager that a worker failed its job“

c. Choose “2. Tell worker to restart a failed job“

d. Restart the AD utility that was running when the node

Shutting down the Manager

1. Start AD Controller

2. Choose “3. Tell worker to quit“

3. Verify that no worker processes are running

September 1, 2017 RapidWiz log files for Oracle Applications Release 12

APPS DBAErrors/Workarounds-ApplicationsInstallations/Configurations-ApplicationsOracle APPS DBA

RapidWiz log files for Oracle Applications Release 12

During installation of Release 12 using RapidWiz, the following log files are created.

In case of any errors during the installation, we can use these log file locations for troubleshooting.

Before the installation starts:
The Rapidwiz Configuration File is saved in three locations,these are follows.

$TMP//conf_.txt
$INST_TOP/conf_.txt
/appsutil/conf_.txt

Database Tier log files are located as follows:

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/.logRDBMS
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_.log
ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log$ORACLE_HOME/appsutil/log/
$CONTEXT_NAME/adcrdb_.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log

Applications Tier(s) log files are located as follows:

$INST_TOP/logs/.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log
$INST_TOP/logs/ora/10.1.2/install/make_.log
$INST_TOP/logs/ora/10.1.3/install/make_.log
$INST_TOP/admin/log/ApplyAppsTechStack.log
$INST_TOP/admin/log/ohclone.log
$APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log
$APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_.log
$APPL_TOP/admin/$CONTEXT_NAME/log/adconfig.log
$APPL_TOP/admin/$CONTEXT_NAME/log/NetServiceHandler.log

Inventory Registration log files are as follows:

/logs/cloneActions.log
/logs/oraInstall.log
/logs/silentInstall.log