Disruptive technology

Disruptive technology = > Order of magnitude cheaper , order of magnitude lower quality, order of magnitude lower margin captured by the vendor

How to increase the number of processes allowed in oracle database.

Log in as sys

$ sqlplus sys as sysdba;

Enter the passed for sys when prompted.

If your application makes many connections and the number of processes allowed to be created by the oracle db is smaller than that, you will get the error

ORA-12519: TNS:no appropriate service handler found

To solve this issue, first view the number of processes allowed by oracle.

SQL> select * from v$resource_limit where resource_name = 'processes';

If you are using oracle express edition, this value would be 40.

Now increase number of allowed the processes

SQL>alter system set processes=300 scope=spfile;
SQL>shutdown immediate;
SQL>startup

How to log from within a BPEL process

There are multiple ways to log information from a BPEL process to the server logfile.

One options is to write your own extension activity and use it to log information to the log where necessary. However, there is a simple and easy way to write logs without writing your own extension. That is to use the E4X extension activity.

In order to use E4X extension within your bpel process, follow the following steps.

1. Add xpath 2.0 namespaces to the process definition.

queryLanguage="urn:oasis:names:tc:wsbpel:2.0:sublang:xpath2.0"
expressionLanguage="urn:oasis:names:tc:wsbpel:2.0:sublang:xpath2.0"

2. Define e4x as an extension.

<bpel:extensions>
  <bpel:extension namespace="http://ode.apache.org/extensions/e4x" mustUnderstand="yes"/>
</bpel:extensions>

3. Include the e4x extension operation where you want to log information.

   <bpel:assign validate="no" name="AssignE4X">
      <bpel:extensionAssignOperation>
         <js:snippet xmlns:js="http://ode.apache.org/extensions/e4x">
           <![CDATA[ print(“My Log message from bpel process");  ]]>
         </js:snippet>
       </bpel:extensionAssignOperation>
   </bpel:assign>