Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : June-2018


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Saturday, April 16, 2016

Install 12c Grid Infrastructure on OEL-6

12c Install series -Part I

In this series we will install 12c Grid infrastructure on Oracle Enterprise Linux-6 using Virtual Box on a MAC.

Install Virtual Box and Create two node RAC cluster on Mac

Virtual Box Binaries can be downloaded here:

Step-by-Step doc to install Virtual Box and spin off two node RAC clutser:

Wednesday, April 6, 2016

To start Workflow components from back end.

SQL> select component_id,component_name, component_status FROM apps.fnd_svc_components WHERE component_type like '%WF%';

COMPONENT_ID COMPONENT_NAME                                                                   COMPONENT_STATUS
------------ -------------------------------------------------------------------------------- ------------------------------
      10000 ECX Inbound Agent Listener                                                       STOPPED
      10001 ECX Transaction Agent Listener                                                   STOPPED
      10002 Workflow Deferred Agent Listener                                                 STOPPED
      10003 Workflow Deferred Notification Agent Listener                                    STOPPED
      10004 Workflow Error Agent Listener                                                    STOPPED
      10005 Workflow Inbound Notifications Agent Listener                                    STOPPED
      10006 Workflow Notification Mailer                                                     STOPPED
      10020 Workflow Java Deferred Agent Listener                                            STOPPED
      10021 Workflow Java Error Agent Listener                                               STOPPED
      10041 Workflow Inbound JMS Agent Listener                                              STOPPED
      10040 Web Services IN Agent                                                            STOPPED
      10042 Web Services OUT Agent                                                           STOPPED
      10043 WF_JMS_IN Listener(M4U)                                                          STOPPED

To start the WF components from back end:

SQL> declare
    retcode number(10);
    errbug varchar2(50);
    fnd_svc_component.start_component (10006,retcode,errbug);

PL/SQL procedure successfully completed.